-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Ok so for a beginner, why not use MySQL? I've seen plenty o' books in Borders that cover PHP+MySQL. While that wouldn't be my choice for an actual application it's certainly a place to start and if the book covers both explicitly in concert with each other so much the better. If you have time I'd recommend perl, mod_perl, and PostgreSQL together. But then I'm not a database geek so all I have to go on is the 'it scales better' sort of comments. This year I did web databases of ~33,000 records. Next year it will be ~6,000,000. Joshua b. Jore Minneapolis Ward 3, precinct 10 http://www.greentechnologist.org On Wed, 7 Nov 2001, Hvidsten, Leif wrote: > So for someone who wants to learn relational database concepts (with no background other than M$ Access) and wants to learn PHP as well, would you recommend PostgreSQL over MySQL? I was planning to focus on using MySQL with PHP and Apache, would PostgreSQL be a better way to start? I'm very unfamiliar with these database technologies at the moment and would welcome any feedback. > > > > > > > > On Wed, Nov 07, 2001 at 11:03:16AM -0600, Florin Iucha wrote: > > > Now, what's [better-than-row-level locking] supposed to mean? > > > Attribute-level-locking? > > > > Exerpt from http://www3.us.postgresql.org/features.html > > > > Multi-Version Concurrency Control (MVCC) for highly scalable > > concurrent applications: > > * Readers do not block writers and writers do not > > block readers. > > * "Better than row-level locking." > > * Various row and table level locks are available as well. > > > > Detail found at > > http://www3.us.postgresql.org/users-lounge/docs/7.1/user/mvcc.html > > > > > Ignore the trolls and use what suits you best. A flatfile > > if that does > > > the job. > > > > Agreed, use what does the job. I'm a huge proponent of text files. I > > wouldn't like the Debian system as much if I wasn't. Given a large > > dataset, with records numbering in the tens of thousands, a more > > scalable solution may be required. Thus, RDBMS's come into > > the picture. > > If you require an RDBMS, MySQL may fit the bill. After having worked > > with Informix, Sybase, and MSSQL, I'm used to features standard in > > commercial SQL Standards compliant databases. MySQL falls far short > > when compared to these. The developers of MySQL say as much. > > > > > Mysql doesn't offer those but it doesn't have the overhead either. > > > > I'm not sure what you're getting at. PostgreSQL doesn't have any > > greater overhead than MySQL. They're both "bloated" compared to flat > > files. ;-) There are many myths out there about PostgreSQL's speed, > > especially when you factor in the improvements to the 7.1 version over > > the 6.5. Regardless, the point is moot. > > > > -- > > Chad Walstrom <chewie at wookimus.net> | a.k.a. ^chewie > > http://www.wookimus.net/ | s.k.a. gunnarr > > Key fingerprint = B4AB D627 9CBD 687E 7A31 1950 0CC7 0B18 206C 5AFD > > > > > > PRIVACY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain business confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If this e-mail was not intended for you, please notify the sender by reply e-mail that you received this in error. Destroy all copies of the original message and attachments. > > _______________________________________________ > Twin Cities Linux Users Group Mailing List - Minneapolis/St. Paul, Minnesota > http://www.mn-linux.org > tclug-list at mn-linux.org > https://mailman.mn-linux.org/mailman/listinfo/tclug-list > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (OpenBSD) Comment: For info see http://www.gnupg.org iD8DBQE76cqufexLsowstzcRAp84AJ0WEAYYkyYMsbvxEC+SI+LQj7zRsgCgnPYj Ps//CFHqIbYrDE1601+F1KA= =XykJ -----END PGP SIGNATURE-----