SitePoint Sponsor |
|
User Tag List
Results 1 to 8 of 8
Thread: PostgresQL
-
Feb 7, 2002, 06:04 #1
- Join Date
- Aug 2000
- Location
- Thailand
- Posts
- 4,810
- Mentioned
- 1 Post(s)
- Tagged
- 0 Thread(s)
PostgresQL
I have been asked to do a pretty big site outside of my usual day job. The companies language of choice is php (suits me
), but their db of choice is PostGreSQL.
Is is significantly different to mySQL? Does anyone have any good toots for working with php and PostGres?
Cheers,
H~The Artist Latterly Known as Crazy Hamster~
922ee590a26bd62eb9b33cf2877a00df
Currently delving into Django, GIT & CentOS
-
Feb 7, 2002, 06:23 #2
- Join Date
- Jan 2002
- Posts
- 8
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Yes it is significantly different to MYsql.
The main differences are that you can use stored procedures(functions in postgresql) and triggers and use subselects.
I don't really like GUI's and Postgresql's command line interface is execllent.
But for a php web based interface - http://phppgadmin.sourceforge.net
and for a non web GUI interface (not out yet but soon) see http://www.commandprompt.com/entry.lxp?lxpe=126
Postgresql 7.2 has just been released.
-
Feb 8, 2002, 05:31 #3
- Join Date
- Aug 2000
- Location
- Thailand
- Posts
- 4,810
- Mentioned
- 1 Post(s)
- Tagged
- 0 Thread(s)
Bugger. Thanks for that though - guess I'll have to get my learning hat back on! Any good toots?
~The Artist Latterly Known as Crazy Hamster~
922ee590a26bd62eb9b33cf2877a00df
Currently delving into Django, GIT & CentOS
-
Feb 8, 2002, 16:08 #4
This article might give you some help H
http://www.webmasterbase.com/article/542/
SeanHarry Potter
-- You lived inside my world so softly
-- Protected only by the kindness of your nature
-
Feb 8, 2002, 17:38 #5
I would take a look at PEAR DB library, which is distributed with PHP. By using PEAR DB it is simple to code an application for a number of different db backends. Write once, use many so to speak. To get you up to speed, look at these tutorials:
PEAR DB Primer
Introduction to PEAR
Quick Start Guide to Pear DB
Cheers.
-
Feb 11, 2002, 08:20 #6
- Join Date
- Aug 2000
- Location
- Thailand
- Posts
- 4,810
- Mentioned
- 1 Post(s)
- Tagged
- 0 Thread(s)
Nice one Sean and filmfoto, thanks!
H~The Artist Latterly Known as Crazy Hamster~
922ee590a26bd62eb9b33cf2877a00df
Currently delving into Django, GIT & CentOS
-
Feb 12, 2002, 01:11 #7
- Join Date
- Jun 2000
- Location
- Sydney, Australia
- Posts
- 3,798
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
There was a huge stouch on slashdot a few months ago around some reported benchmarks between MySQL and PostreSQL.
PostegreSQL (originally deveped at UC Berkely) is more of a real RDMS than MySQL. I have been looking for an excuse to use PostgreSQL for ages now - but it is always too easy to just do a job in MySQL rather than get familiar with PostgreSQL. I believe Tim Purdeo (sp?) original owner of phpBuilder.com and creator of sourceforge.com is a PostgreSQL advocate.
Another good place to have look around for postgreSQL stuff might be http://openacs.org/ (there are probably more helpful resources around, I just don't know them).
If MySQL hadn't become the default open source database for web development a few years ago, then we would all be using PostgreSQL instead. The vibe I have picked up from the geek literature is that MySQL was in the right place at the right time a few years back, whereas PostgreSQL went through a period a few years back of rather sporadic and disorganised development so kind of missed the boat.
Best of luck. Tell us how it goes.
-
Feb 12, 2002, 08:02 #8
- Join Date
- Jan 2001
- Location
- Lawrence, Kansas
- Posts
- 2,066
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Yup, www.phpbuilder.com has some good Postgres articles including one on how to move to it from mySQL (I think). I'm currently trying to resurrect a second hand 486 and turn it into a FreeBSD server so I can play around with things like Postgres properly
Bookmarks