By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,559 Members | 1,180 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,559 IT Pros & Developers. It's quick & easy.

RAD with postgreSQL

P: n/a
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

Nov 23 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #2

P: n/a
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

Nov 23 '05 #3

P: n/a
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

Nov 23 '05 #4

P: n/a
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

Nov 23 '05 #5

P: n/a
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

Nov 23 '05 #6

P: n/a
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

Nov 23 '05 #7

P: n/a
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

Nov 23 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.