IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New Agreed
Much better than MySQL.
Syntax is much closer to Oracle, the industry standard, so it is a great place to learn. On the other hand, all kinds of goodies if you don't care about porting your code later on.
New Postgresql also has much better (err damn my brain!)
function support to "emulate" Column triggers.

Needless to say, LAMP should LAPP. ( Linux, Apache, PostgresQL, [ Perl | Python | PHP ] )
--
[link|mailto:greg@gregfolkert.net|greg],
[link|http://www.iwethey.org/ed_curry|REMEMBER ED CURRY!] @ iwethey
Freedom is not FREE.
Yeah, but 10s of Trillions of US Dollars?
SELECT * FROM scog WHERE ethics > 0;

0 rows returned.
Expand Edited by folkert Oct. 27, 2005, 11:36:42 AM EDT
New Anyone looked at MySQL 5 yet?
Just saw the announcement about it. Looks like they just added a lot of the big stuff. Wonder how it's going to compare to Postgres now.
===

Purveyor of Doc Hope's [link|http://DocHope.com|fresh-baked dog biscuits and pet treats].
[link|http://DocHope.com|http://DocHope.com]
New I have done the "build it and they will die"
Routine with MySQL5. It's not ready, still.

I couldn't connect to it properly with older tools. Though I wasn't really trying that hard.

I guess I come from "the existing working implementations, should still work after an upgrade" camp. But then, I also like to break things.
--
[link|mailto:greg@gregfolkert.net|greg],
[link|http://www.iwethey.org/ed_curry|REMEMBER ED CURRY!] @ iwethey
Freedom is not FREE.
Yeah, but 10s of Trillions of US Dollars?
SELECT * FROM scog WHERE ethics > 0;

0 rows returned.
New I think MySQL has the same attiude that MS has on software
Whip something up.
Seems to work.
Get it out there.
Hype the speed.
Get users to try stuff.
Get users who don't know any better to be wowed.
Get complaints from knowledgeable users who are familier with other systems.
Try to steal features from other systems.
Realize that the new features are incompatible with the old features, and decide to partially implement the new features in an attempt not to break the old features.
Fuck it up.
Break the old while not providing the new.
Scramble.
Pull out the new, attempt to put the old back in.
Declare the old baseline as the standard, and ignore the rest as long as possible.

Repeat the cycle.

Remember, MySQL is a commercial entity 1st, and is market driven.

Postgres is more of a well designed academic exercise that has spawned several commercial spin-offs. Things get put in because they are good to have, not because that satisfy a marketing need. So it is developed in a steady non-rushed fashion. Features "feel" right. It always has very high-end capabilities (log based hot-backup, moment in time queries satisfied against the log, not the changing data, etc) that blew away MySQL, and the SQL dialect done not end up surprising Oracle users, since they seems to have developed almost in tandem.

And now there is a vendor that took that Oracle aspect a bit further, and is attempting an almost complete emulation, ie: [link|http://www.enterprisedb.com/|http://www.enterprisedb.com/].

I'd suggest taking a look at it if you are an Oracle/Postgres fan.
New Biggest thing I wanted from Postrgres that it didn't have
Replication. MySQL has had master/slave replication working for several years at least. People kept posting white papers and proof-of-concept demos of multi-master replication for Postgres, but I've never seen anyone say it works for real.
===

Purveyor of Doc Hope's [link|http://DocHope.com|fresh-baked dog biscuits and pet treats].
[link|http://DocHope.com|http://DocHope.com]
New We have something working here
Might be very specific to the users / tables involved.
Not my project though, so I'm clueless.
New They claim it is in there, but no idea if it is correct
for your usage.

[link|http://www.enterprisedb.com/edb-db.do|http://www.enterprisedb.com/edb-db.do]
New Among other things, mysql isn't free
as in beer.

Also, 2 phase commit/mvcc support is recent and thus unproven IMO.



"Whenever you find you are on the side of the majority, it is time to pause and reflect"   --Mark Twain

"The significant problems we face cannot be solved at the same level of thinking we were at when we created them."   --Albert Einstein

"This is still a dangerous world. It's a world of madmen and uncertainty and potential mental losses."   --George W. Bush
     Need suggestions - (jbrabeck) - (15)
         something like this? - (boxley) - (3)
             Good start - (jbrabeck) - (2)
                 hmm, ok another link - (boxley) - (1)
                     I'll have to send the 2d link to client. He'd like it. -NT - (jbrabeck)
         LAMP - (Steve Lowe)
         PostgreSQL - (tuberculosis) - (9)
             Agreed - (broomberg) - (8)
                 Postgresql also has much better (err damn my brain!) - (folkert) - (7)
                     Anyone looked at MySQL 5 yet? - (drewk) - (6)
                         I have done the "build it and they will die" - (folkert)
                         I think MySQL has the same attiude that MS has on software - (broomberg) - (3)
                             Biggest thing I wanted from Postrgres that it didn't have - (drewk) - (2)
                                 We have something working here - (broomberg)
                                 They claim it is in there, but no idea if it is correct - (broomberg)
                         Among other things, mysql isn't free - (tuberculosis)

The key; The whole key; And nothing but the key. So help me Codd.
106 ms