| WIKI | FAQ | Tech FAQ | |
 http://csua.com/feed/ | |
| ||||||
| 4/4 |
| 2003/3/12-13 [Computer/SW/Database] UID:27673 Activity:very high |
3/12 mySQL vs. postgreSQL: Thoughts? Likes? Dislikes? Horror stories?
Success stories? Thanks.
\_ I have found mySQL to be surprisingly good. I built a network
and system management product using mySQL for the db backend.
This system has been deployed in several dozen sites worldwide
with between 100-500 nodes managed per site. Most of the sites
have been running for about 1 1/2 to 2 yrs and during this time
with between 100-500 nodes managed per site. The amount of data
I originally wanted to use postgres or sysbase (the cheap one,
store per node varies, on ave its about 25-30 MB. Most of the
sites have been up for about 1 1/2 to 2 yrs and during this time
mySQL has been quite reliable (no data loss to date).
Originally I wanted to use postgres or sysbase (the cheap one,
SQLAnywhere iirc) but one of the people in my group told me
about mySQL so we tried it out for a bit and really liked it
because it was easy to install and maintain.
\_ PostgreSQL used to have edge over MySQL because MySQL by design
sacraficed features for performance. Some of the features
MySQL at the time didn't have includes: Transaction, Nested
Queries, and things like foreign key constraint support.
Later version of MySQL uses either innoDB or BerkeleyDB, which
effectively allow transaction (table locking, oppose to row-locking
but personally i can live with table locking for now) and
enforcing foreign key constraint.
I think in 5.2, MySQL started to support nest queries. it used
to be clear on when to use PostgreSQL (i.e. you need transaction)
now, the answer is less clear. You can ask other guys about the
performance aspect. Personaly, I perfer MySQL because 1. I don't
do anything real. 2. better on-line documentation, 3. more
on-line communities support, and 4. easy to use.
Then again, true hacker may have different opinions.
\_ I've never heard of a reason NOT to use PostgreSQL over MySQL
other than "I've never heard of it and can't pronounce it".
\_ MySQL is much easier to install and maintain.
\_ PostgreSQL is a "real" database: ACID compliant, supports
transactions, etc. MySQL is just a small lightweight
DB that is fine for small jobs but can't (shouldn't) be
trusted for any serious application
\_ That's what I've heard. The benchmarks I've found have
been pretty crappy all around, but the mySQL users in
general tend to be pretty unclear on standard DB concepts.
Not that benchmarks are particularly useful anyway, in the
computer industry there are lies, damn lies and then
there are benchmarks.
\_ You are so kewl! Can I use that clever quote?!
\_ Um, no. #f. Try again. What you said was true six months
ago before mysql stable natively supported the innoDB table
format. The innoDB table format supports (among other things)
transactions and gives mysql ACID compliance. mysql has a
larger, more active support community, is backed by mysql AB,
which is a successful and growing company, and, at this point
appears to be developed faster than postgres. Success story:
http://Kuro5hin.org. They've been using mysql + innodb support since
innodb was WAY beta. Success story: Slashdot.
\_ I'm not sure I'd use kuro5hin and slashdot as examples of
success.
\_ me neither. mysql is a hobby database and the only
reason to use it is if you can't get oracle.
\_ Um, wow. You ARE an idiot. Oracle is good for one
thing only: putting money in Larry Ellison's pockets.
\_ Don't be stupid.
\_ Hi Mr. Clueless Mindlessly Anti-Establishment Lad!
\_ Hmmm, hammers on database, both sites have impressive
uptimes. How do YOU define success?
\_ Slashdot is slow as shit and has a mediocre uptime.
Kuro5hin doesn't have that much traffic and frankly
in the real world where neither does slashdot. It's
all heavily cached which won't work for anything
important.
\_ Please continue doing that thing where you make
your ass talk. It's almost as funny as when
Jim Carrey does it in Ace Venture: Pet Detective.
Let me know when you have some *gasp* examples
from your 'real world'. Go away troll.
\_ Thank you for adding nothing to this thread but
mindless personal attack. When you can explain
why I'm wrong without using 3 and 4 letter
childish 'insults' then maybe you'll be able to
discuss databases with the rest of us. Troll,
indeed! Your 'reply' is laughable.
\_ Thank you for admitting that you are wrong.
What does it matter if I use 3 and 4 letter
insults while explaining that you are wrong.
This does not change the fact that you are,
as per your admission, wrong. Please let
me know when you have real world examples.
Until then, I repeat, go away troll.
\_ Uhm, no one admitted to being wrong or you
being right about anything. You're just
being silly now. I've no idea how you came
to believe that you're right or anyone
else is wrong about anything.
\_ Google, Slashdot and Yahoo use mySQL, some w/ innoDB.
Also, Google and Slashdot gzip their content, which is
another sign of a savvy site.
\_ who have you been talking to? you don't want to go
citing us as a testimonial; mysql has given us more
headaches than you can imagine. --aaron
\_ Don't confuse the issue with facts! |
| 4/4 |
|
| Kuro5hin.org -> www.kuro5hin.org/ Movies The Writers Guild of America registers approximately 30,000 screenplays every year, most of which never make it anywhere near the silver screen. Some of these are by "big name" writers like James Cameron and The Wachowski Brothers. Presented for your reading pleasure are four of my personal favourites. CEPEC recommended that all existing earthquake preparedness plans be reviewed. Since the announcement of his "major breakthrough" in earthquake prediction, Keilis-Borok has received a lot of attention in the press, with all of the sensationalism and doomsaying that you might expect, but not much detail. I guess it's an inevitable consequence of the Postal Service being spun off as an independent business unit that sooner or later, the spaces inside it would be sold off for marketing dollar. It's just the last place I expect to be inundated with 'see-our-movie' marketing but as time goes by, no space is kept sacred from advertising. Science Somewhere in the royal forests of Jaktorw, 1627 AD. Hidden deep in the primeval forest of what will become modern-day Poland, a poacher notches an arrow to the string of his bow. In an open glade, preserved for the exclusive hunting of the king, an animal that exists nowhere else in the world grazes. Her ancestors are preserved in ochre paints on the cave walls of Lascaux. Relatives to her bloodline will become the black fighting bulls of Spain, but they will be pale shadows compared to her. Standing more than six feet high at the shoulder, the aurochs' horns are massive scimitars of bone, spreading more than an arms span from her broad triangular head. She is ten feet from nose to tail, tons of muscle and flesh that are impossible to stop once she has begun her terrifying charge. The wood of the bow creaks as the poacher draws the arrow. The aurochs bellows with pain and range as the shaft sinks into her body, spearing her heart. Bloody froth drips from her mouth as her head rears back - and then the massive animal falls, the collapse of her body echoing through the forest. The aurochs chest falls as she draws a shuddering breath. In his first book, Code and Other Laws of Cyberspace, dark forces were gathering, conspiring to use code as a form of privatized law to hem in the Internet and the potential of the digital revolution. Readers learned that the Net, far from impervious, could be tamed by rewiring its architecture. The premise seems obvious now, but only because Lessig's 1999 ground-breaker connected the dots for us and set the scene for the struggles to follow. The only rock and roll was played on the AM pop station, and sparingly, at that. FM was relatively new, and the FM stations only played easy listening, Jazz, etc. My dad listened to FM 95, which played Herb Alpert and the like; There were two pop stations in town, one of which lost its license around 1963 for a fraudulent on-air contest that had people digging holes all over St. Louis, trespassing, etc, and it turned out that the prize didn't exist. The station went dark, and came back with new ownership and a country western format. This left one bad pop station in the entire large metropolitan area. One evening my dad wasn't home, so I turned on the stereo, a large furniture-like thing, and was amazed that there was rock and roll playing. Real rock and roll, unlike the schmaltz they played on the pop station. |