Well then, I suppose I'll learn PostgreSQL. It only took about 9 minutes to download too! I even found a tutorial for thcersion I apt-geted (7.2.1). Unfortunately I ran into problems immediately (1). The tutorial said that it meant I didn't have permissions right but I don't know how to fix those. I then figured I should try to create a user. That resulted in a new error (2). So my question is: how do I create a user? 1- bmike1@1[bmike1]$ createdb mydb psql: FATAL 1: user "bmike1" does not exist createdb: database creation failed bmike1@1[bmike1]$ sudo createdb mydb psql: FATAL 1: user "root" does not exist createdb: database creation failed bmike1@1[bmike1]$ bmike1@1[bmike1]$ 2- bmike1@1[bmike1]$ sudo createuser bmike1 Shall the new user be allowed to create databases? (y/n) y Shall the new user be allowed to create more new users? (y/n) y psql: FATAL 1: user "root" does not exist createuser: creation of user "bmike1" failed bmike1@1[bmike1]$ On Thursday 15 April 2004 21:07, Earl, Alex C wrote: > I would have to agree with Jerry. It would depend on what you are > looking for. I personally like PostgreSQL because its SQL is more > compliant with the ISO standard, it also has the feature like Jerry > mentioned of writing Perl (and you can add other languages) functions > right in the database. PostgreSQL does have a smaller user base right > now, I think it is because MySQL _looks_ so much easier to use. I used > both for extended periods of time and personally felt that PostgreSQL > suited my needs better. > > Alex > > > -----Original Message----- > > From: plug-discuss-admin@lists.plug.phoenix.az.us > > [mailto:plug-discuss- > > > admin@lists.plug.phoenix.az.us] On Behalf Of Jerry Davis > > Sent: Thursday, April 15, 2004 6:29 PM > > To: plug-discuss@lists.plug.phoenix.az.us > > Subject: Re: database > > > > On Thursday 15 April 2004 08:10 pm, Michael Havens wrote: > > > A couple of people have recommended I do that. Something I need to > > know is > > > > why you recommend PostgreSQL over MySQL. I mean how is it better; > > does it > > > > have more of a future; is it easier to learn or is it just differant > > to > > > > learn? > > > > Mike, > > > > When I fooled around with MySQL and PostgreSQL, I was equally > > impressed with > > > both of them. > > > > 1) MySQL seemed faster for selects > > 2) I liked PostgreSQL's ability to write perl functions right in the > > database. > > > So, I guess it depends upon what you want to do with it. > > > > I would go to both sites, and look at the features, to make a real > > determination. > > > > I have a both O'Reilly books. Alas ... I am currently pretty far away > > from > > > Phoenix now. > > > > Jerry > > > > > I was advised not to go with it previously because I could get help > > from > > > > more people if I went with MySQL. > > > > > > > > > > > > Then again > > > > > > On Thursday 15 April 2004 17:19, Earl, Alex C wrote: > > > > > > am I correct in assuming that you need Apache to be running to > > work > > > > > with > > > > > > > > > > MySQL? > > > > > > > > > > No. MySQL is completely independent. > > > > > > > > > > There is a very large and still fast growing field of > > development, > > > > > LAMP: > > > > > Linux, Apache, MySQL, PHP. http://www.onlamp.com/ The tools > > work > > > > > very > > > > > > > > > well together, and will for a very long time since development > > of all > > > > > > these is geared toward working together AND working with as many > > other > > > > > > protocols as possible. For instance, I worked on a project that > > > > > > > > included > > > > > > > > > a DB2 database, which PHP could interface through an ODBC driver > > > > > > > > provided > > > > > > > > > by IBM. So it was a part LAMP and part LA[db2]P website. Since > > this > > > > > is > > > > > > > > > Linux goodness, you can also write cron jobs that run php on the > > > > > > > > command > > > > > > > > > line, e-mail users, automatically submit e-mails into a MySQL > > table, > > > > > > whatever. > > > > > > > > > > I also highly recommend http://safari.oreilly.com/ . > > > > > > > > > > --Alexander > > > > > > > > I personally recommend PostgreSQL over MySQL as well, I failed to > > > > mention this earlier. I would also recommend using something like > > PEAR > > > > > to abstract the accesses to the database so that you can plug > > different > > > > > database servers into the back of your scripts. > > > > > > > > Alex > > > > > > > > --------------------------------------------------- > > > > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > > > > To subscribe, unsubscribe, or to change you mail settings: > > > > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss > > > > > > This message has been scanned for viruses by the VEI Internet > > > Automatic Email Spam and Virus Scanner, and is believed to be free > > of spam > > > > or viruses. Please report spam to spamtrap@vei.net. If you would > > like 98.9 > > > > % spam blocked from your E-mail then go to VEI Internet for details. > > > Anti-spam/Anti-virus is FREE with every account. > > > > > > > > > http://www.vei.net/ > > > mailtospamtrap@vei.net > > > --------------------------------------------------- > > > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > > > To subscribe, unsubscribe, or to change you mail settings: > > > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss > > > > -- > > Registered Linux User: 275424 > > Today's Fortune: Traveling through hyperspace isn't like > > dusting crops, boy. > > -- Han Solo > > --------------------------------------------------- > > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > > To subscribe, unsubscribe, or to change you mail settings: > > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss > > --------------------------------------------------- > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > To subscribe, unsubscribe, or to change you mail settings: > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss This message has been scanned for viruses by the VEI Internet Automatic Email Spam and Virus Scanner, and is believed to be free of spam or viruses. Please report spam to spamtrap@vei.net. If you would like 98.9 % spam blocked from your E-mail then go to VEI Internet for details. Anti-spam/Anti-virus is FREE with every account. http://www.vei.net/ mailtospamtrap@vei.net --------------------------------------------------- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change you mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss