Thread: RAD with postgreSQL
Hi, Any suggestion to Rapid Application Dev with postgreSQL ? I have a small app to make. I would prefer open-source solution if possible. I also would like to developp on my linux box but the result will be used on a windows 2000 and XP machine. But If I have no choice, I will developp on winXP. Any suggestion? P.S.: I never developp on linux at this time, so I don't know the name of the good tools available. (Except I developp in PHP for the web on Linux.) Thanks for your suggestions.
>I would prefer open-source solution if possible. I also would like to >developp on my linux box but the result will be used on a windows 2000 >and XP machine. But If I have no choice, I will developp on winXP. > >Any suggestion? > > Python with WxWindows or Borland with Delphi/Kylix >P.S.: I never developp on linux at this time, so I don't know the name >of the good tools available. (Except I developp in PHP for the web on >Linux.) > >Thanks for your suggestions. > > > >---------------------------(end of broadcast)--------------------------- >TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > > -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL
>I would prefer open-source solution if possible. I also would like to >developp on my linux box but the result will be used on a windows 2000 >and XP machine. But If I have no choice, I will developp on winXP. > >Any suggestion? > > It has nothing to do with open-source, but I suggest you have a look at MS Access. The ODBC driver for Postgresql gives me very good results. Development is really quick, and performance is great if you push your code to the server, in plpgsql functions. This is what we call "client-server thin client" and is opposed to "client-server fat client". Philippe Lang
You have also RealBasic, with cross-platform to Windows, Mac and linux... Luc ----- Original Message ----- From: "Eric" <ericg@conceptid.ca> To: <pgsql-general@postgresql.org> Sent: Sunday, September 05, 2004 8:48 PM Subject: [GENERAL] RAD with postgreSQL > Hi, > > Any suggestion to Rapid Application Dev with postgreSQL ? > > I have a small app to make. > > I would prefer open-source solution if possible. I also would like to > developp on my linux box but the result will be used on a windows 2000 > and XP machine. But If I have no choice, I will developp on winXP. > > Any suggestion? > > P.S.: I never developp on linux at this time, so I don't know the name > of the good tools available. (Except I developp in PHP for the web on > Linux.) > > Thanks for your suggestions. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match >
Hi, I have a running PHPBB mySQL dump that I would like to load/import in postgreSQL... I didn't try yet but I wonder if it's straightforward and just import the mySQL dump into postgreSQL ? (Of course, I want to migrate PHPBB running on a server with mySQL to another server running with postgreSQL). Yes PHPBB has postgreSQL support. Thanks.
On Wed, 2004-09-08 at 10:07, Eric wrote: > Hi, > > I have a running PHPBB mySQL dump that I would like to load/import in > postgreSQL... I didn't try yet but I wonder if it's straightforward and > just import the mySQL dump into postgreSQL ? > > (Of course, I want to migrate PHPBB running on a server with mySQL to > another server running with postgreSQL). Yes PHPBB has postgreSQL > support. I found this utility very helpful in a similar situation: http://freshmeat.net/projects/my2pg/ -- Greg Donald
Hi, You may find something here: http://www.rot13.org/~dpavlin/sql.html. In addition, I always thought that Postgres came with a MySQL to Postgres converter, but I might be wrong. Bye, Arthur On Wed, 08 Sep 2004 11:07:46 -0400, Eric <ericg@conceptid.ca> wrote: > Hi, > > I have a running PHPBB mySQL dump that I would like to load/import in > postgreSQL... I didn't try yet but I wonder if it's straightforward and > just import the mySQL dump into postgreSQL ? > > (Of course, I want to migrate PHPBB running on a server with mySQL to > another server running with postgreSQL). Yes PHPBB has postgreSQL > support. > > Thanks. > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html >
Eric wrote: > Hi, > > I have a running PHPBB mySQL dump that I would like to load/import in > postgreSQL... I didn't try yet but I wonder if it's straightforward and > just import the mySQL dump into postgreSQL ? > > (Of course, I want to migrate PHPBB running on a server with mySQL to > another server running with postgreSQL). Yes PHPBB has postgreSQL > support. I do this semi-regularly. You usually end up doing some minor corrections, not much though. You might want to check http://techdocs.postgresql.org/ -- Richard Huxton Archonet Ltd
On Wed, 2004-09-08 at 09:07, Eric wrote: > Hi, > > I have a running PHPBB mySQL dump that I would like to load/import in > postgreSQL... I didn't try yet but I wonder if it's straightforward and > just import the mySQL dump into postgreSQL ? > > (Of course, I want to migrate PHPBB running on a server with mySQL to > another server running with postgreSQL). Yes PHPBB has postgreSQL > support. Is this the dump from mysqldump or the one from PHPBB? I think the dump from phpbb directly could be imported to another instance of phpbb running on top of postgresql. I haven't ever tried it, I'm just guessing.