Pretty empty forum, time to populate it a little bit http://www.devshed.com/Talk/Forums/smile.gif
My question: Does anybody know of a beginners tutorial on PostgreSQL/PHP? I am learning MySQL right now, but my host only offers PostgreSQL.
Any help greatly appreciatet!
Johannes
No, but there outta be. How is it that PHP, an open-sourced language, rallies around a non-open MySQL?
-Ben
What exactly do you need help for? PostgreSQL or PHP/PostgreSQL interaction?
Try giving an example of something that you can't get to work.
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by tarvin:
What exactly do you need help for? PostgreSQL or PHP/PostgreSQL interaction?
Try giving an example of something that you can't get to work.[/quote]
Since we need to populate this forum, how about the basics? My server has RedHat whch supposedly comes with PostgreSQL, but I can't figure out how to get it going!
If I log in as root, and then [su postgres], it asks for a username and password. I don't know what the default is. I tried username as [Postgres] and password as [<RETURN>] but that isn't right. Any insight from the PostgreSQL gurus out there? Thanks in advance!!
http://www.devshed.com/Talk/Forums/confused.gif
Susan,
If you log in as root, why do you try to do a su command?? Try running postgre without that, just postgre (or whatever command is used to start the server) and see what happens.
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>
What exactly do you need help for? PostgreSQL or PHP/PostgreSQL interaction?
[/quote]
The thing is, I am currently learning PHP/MySQL, as there is much more help available on that. In theory there shouldn't be too much of a difference between MySQL and PostgreSQL, as you interact with both of them with SQL, right? But in reality there are quite a few differences between them (Like there is no AUTO_INCREMENT in PostgreSQL etc). I also read, that PostgreSQL is more powerful, sticks closer to the SQL standard and has more features than MySQL.
I guess what I am looking for is sort of a comparison of the two databases. That way I should be able to get working with PostgreSQL while reading stuff on MySQL...
Again, I am happy about everything regarding PostgreSQL: tips, URLs, tutorials etc.
Thanks a lot
Johannes
------------------
Well, yes, there is much more help on MySQL and PHP interaction. Also, I think that it is way a lot easier to work with these two in a combo, than PHP/PostgreSQL. But on the other hand, POstgreSQL supports many advanced features that most serious RDBMS' support (like atomicity).
Well, I finally dug it up. Here is a link to some begginer tutorials about PHP and PostgreSQL: http://www.elite2000.f2s.com/
I hope you find it useful.
Also, there is no explicit auto_increment function in PostgreSQL, but there is something called a sequence. You create one for each table you make. Reffer to the Postgre docs for more info.
There is a sequence "thing" in postgre and you an make it like this:
CREATE SEQUENCE id (this effects all tables in your database)
and you can use this query when you add data:
INSERT into table_name VALUES(nextval('id'),more,more)
---
wizactive
wizactive@jimportal.com http://www.jimportal.com/
You can find a tutorial on SQL using Postgres with instructions on installation of Postgres at http://linuxfocus.org/English/May1998/article13.html
This is a three part tutorial and the link above should get you to part I. Linux Focus is a Spanish online Magazine available in numerous languages.
Hope this helps.
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by jbb:
Pretty empty forum, time to populate it a little bit http://www.devshed.com/Talk/Forums/smile.gif
My question: Does anybody know of a beginners tutorial on PostgreSQL/PHP? I am learning MySQL right now, but my host only offers PostgreSQL.
Any help greatly appreciatet!
Johannes[/quote]
There is a PHP+PostgreSQL tutorial at http://designmagick.50megs.com/postgresql-tutorial/
Thanks guys!
Johannes
------------------
And its best that they do host only PostgreSQL...besides the OpenSource issue MySQL is not a database for anything where you need rock stable reliablity and security.
Goto the PostgreSQL website at www.postgresql.org (http://www.postgresql.org) and they have a wealth of documentaion including a tutorial in HTML and a PDF document of a book that the author tells me will be out this fall most likely.
Also a huge help to me is phpPgAdmin from www.phpwizard.net (http://www.phpwizard.net) This is a port of the MySQL version. It allows you to admin the database very easily and is a good example if you check out the PHP code.
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by jbb:
Pretty empty forum, time to populate it a little bit http://www.devshed.com/Talk/Forums/smile.gif
My question: Does anybody know of a beginners tutorial on PostgreSQL/PHP? I am learning MySQL right now, but my host only offers PostgreSQL.
Any help greatly appreciatet!
Johannes[/quote]
[This message has been edited by zonezero (edited July 08, 2000).]
Actually there is an auto increment. It is called "Serial". I learned Posgresql by using mySQL and using trial and error. The Posgresql.org site gives you all the information you need on syntax to switch to posgresql from there.
http://www.phpbuilder.com/getit/databases.php3
did anyone knows the best site for beginners on PHP/postreSQL...windows NT/XP as a platform..not LINUX..plzz tell me