Re: [AOLSERVER] Retrieving oid from INSERT

2006-04-06 Thread Mark Aufflick
Most of the web world runs on MySQL and does ok - just like CDBaby who You can't possibly liken Sybase to MySQL! I know that they are not even in the same league technically, but they do show disturbingly similar philosophies - like making NULL = NULL by default because many clients with

Re: [AOLSERVER] Retrieving oid from INSERT

2006-04-06 Thread Mark Aufflick
That's great - I'm a bit of a Sybase newby and this tip makes life a lot easier. Given that this is so easy and reasonable I don't understand why so many Sybase developers employ other unreliable methods to emulate triggers. On 4/5/06, Bas Scheffers [EMAIL PROTECTED] wrote: select @@identity

Re: [AOLSERVER] Retrieving oid from INSERT

2006-04-06 Thread Bas Scheffers
Mark Aufflick said: do show disturbingly similar philosophies - like making NULL = NULL by default because many clients with poorly trained developers asked for I recon that's the only one! (and I still don't see why this is such a bad thing) My problem with MySQL isn't this simplification, it's

Re: [AOLSERVER] Retrieving oid from INSERT

2006-04-06 Thread Dossy Shiobara
On 2006.04.06, Mark Aufflick [EMAIL PROTECTED] wrote: That's great - I'm a bit of a Sybase newby and this tip makes life a lot easier. Given that this is so easy and reasonable I don't understand why so many Sybase developers employ other unreliable methods to emulate triggers. For the

Re: [AOLSERVER] Retrieving oid from INSERT

2006-04-06 Thread Bas Scheffers
Dossy Shiobara said: You're right; MySQL is orders of magnitude better than Sybase. I'm dead Yeah, when it doesn't blow up in weird and wonderul ways... And you don't mind not being able to do online backups And if you think '-00-00' or '2006-02-30' is a date... (oh no, just tested mysql

Re: [AOLSERVER] Retrieving oid from INSERT

2006-04-06 Thread Dossy Shiobara
On 2006.04.06, Bas Scheffers [EMAIL PROTECTED] wrote: Dossy Shiobara said: You're right; MySQL is orders of magnitude better than Sybase. I'm dead Yeah, when it doesn't blow up in weird and wonderul ways... [...] I'll bet a nickel it's user error (whether that user is a developer or the

Re: [AOLSERVER] Retrieving oid from INSERT

2006-04-06 Thread Tom Jackson
It sounds like you guys are comparing rotten oranges and rotten apples. tom jackson On Thursday 06 April 2006 05:37, Bas Scheffers wrote: Dossy Shiobara said: You're right; MySQL is orders of magnitude better than Sybase. I'm dead Yeah, when it doesn't blow up in weird and wonderul ways...

Re: [AOLSERVER] Retrieving oid from INSERT

2006-04-06 Thread Bas Scheffers
Tom Jackson said: It sounds like you guys are comparing rotten oranges and rotten apples. Are there any apples that aren't considered rotten by someone, somewhere? Like I said before, every RDBMS has it's issues... ...MySQL just takes them to a whole new level and gets even otherwise sensible

Re: [AOLSERVER] Retrieving oid from INSERT

2006-04-06 Thread Bas Scheffers
Dossy Shiobara said: Oh man, who is feeding you this pack of lies? I mean, MySQL has been able to do hot online backups since May 2002! Well, you've been able to How? All I can find is this mysqldump and mysqlhotcopy, which lock tables while they are being dumped. Hardly online backup if you

Re: [AOLSERVER] Retrieving oid from INSERT

2006-04-06 Thread Dossy Shiobara
On 2006.04.06, Bas Scheffers [EMAIL PROTECTED] wrote: The difference? If I *had* to, I could extend MySQL to do exactly what I need. (Beware: Tcl as a supported UDF language for MySQL stored procs! Muwahaha.) Why waste your time, Postgres already has that! :) (and loads of other

Re: [AOLSERVER] Retrieving oid from INSERT

2006-04-06 Thread Bas Scheffers
On 6 Apr 2006, at 17:42, Dossy Shiobara wrote: Can you embed Postgres? Before I got turned on to SQLite, MySQL served I don't see that as a downside, it's not what I use it for. Like you say, there's SQLite for that. Try embedding MySQL into a non-GPL project and see how free it is then!

Re: [AOLSERVER] Retrieving oid from INSERT

2006-04-06 Thread dhogaza
On 2006.04.06, Bas Scheffers [EMAIL PROTECTED] wrote: As much as people criticize MySQL's replication and clustering, where's Postgres's? I don't see any mention of it in Postgres 8.1 docs: http://www.postgresql.org/docs/8.1/interactive/index.html That's because replication isn't part

Re: [AOLSERVER] Retrieving oid from INSERT

2006-04-06 Thread Bas Scheffers
On 6 Apr 2006, at 19:13, dhogaza@PACIFIER.COM wrote: The people who wrote MySQL have the ethical standards of the George W. Bush administration. What, it's made by the same folks as those behind JBoss!? ;-) Bas. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list,

Re: [AOLSERVER] Retrieving oid from INSERT

2006-04-06 Thread Mark Aufflick
On 4/6/06, Dossy Shiobara [EMAIL PROTECTED] wrote: Did you know that Sybase silently promotes an empty string to a string of 1 character? You can't actually store an empty string in a Sybase database. That is absolutely ridiculous. I'd expect that kind of behavior from some college-level

Re: [AOLSERVER] Retrieving oid from INSERT

2006-04-06 Thread Mark Aufflick
On 4/6/06, Bas Scheffers [EMAIL PROTECTED] wrote: Mark Aufflick said: do show disturbingly similar philosophies - like making NULL = NULL by default because many clients with poorly trained developers asked for I recon that's the only one! (and I still don't see why this is such a bad

Re: [AOLSERVER] Retrieving oid from INSERT

2006-04-06 Thread Mark Aufflick
On 4/7/06, Mark Aufflick [EMAIL PROTECTED] wrote: On 4/6/06, Dossy Shiobara [EMAIL PROTECTED] wrote: Did you know that Sybase silently promotes an empty string to a string of 1 character? You can't actually store an empty string in a Sybase database. That is absolutely ridiculous. I'd