RAD with 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?

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,

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

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.