RAD with postgreSQL

[Eric]

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

[Joshua D. Drake]

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.
[phone] - [e-mail] - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Secrétariat]

You have also RealBasic, with cross-platform to Windows, Mac and linux...

Luc
----- Original Message -----
From: "Eric" <er***@conceptid.ca>
To: <pg***********@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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Eric]

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

[Greg Donald]

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

[Arthur Hoogervorst]

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 <er***@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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Richard Huxton]

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Scott Marlowe]

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.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html