Re: [nlug] MySQL Letter to the EC
If you look through the archives, and in fact the internet, you'll find countless "why is postgres better than mysql" essays. You'll even find a few clueless "why mysql is better than everything" essays, which can be safely ignored. For me, the bottom line is that postgres was developed from the beginning to be an acid-compliant world-class rdbms. Mysql, on the other hand, was designed originally as a simple data store that could be queried with a subset of sql. Basically, if postgres is unix, mysql is ms-dos. Version 1. Because of its popularity, people have duct-taped reasonable functionality onto the side of mysql, including transactional capabilities, procedural languages, etc. The problem is that there is no reason to bother doing this to mysql when postgres had those capabilities all along. And, yes, I know that people are constantly improving mysql. But it'll never catch postgres because, not surprisingly, people didn't quit developing it 10 years ago. Watching mysql is like watching microsoft promise that the next version of internet explorer is going to really be good, as if catching up to firefox, safari, chrome, konqueror, etc. is even possible for them. Postgres is no more difficult to install, learn, or use than mysql. In terms of capability, there is no comparison. Critch details some of the differences, but he's just scratching the surface. I'm not being specific simply because I don't know where to begin. Others have done a better job of it, anyway, so google it and see. Michael -- Michael Darrin Chaney, Sr. mdcha...@michaelchaney.com http://www.michaelchaney.com/ -- You received this message because you are subscribed to the Google Groups "NLUG" group. To post to this group, send email to nlug-t...@googlegroups.com. To unsubscribe from this group, send email to nlug-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/nlug-talk?hl=en.
Re: [nlug] MySQL Letter to the EC
On Mon, Dec 14, 2009 at 9:06 AM, Michael Chaney wrote: > Because of the GPL, Oracle may own the copyrights but they'll have no > control. It doesn't matter. As others have said below, MySQL users > are better served with Postgres, anyway, maybe this is another good > reason to change. Yeah, who knows where MySQL is going to end up. -- Greg Donald http://destiney.com/ -- You received this message because you are subscribed to the Google Groups "NLUG" group. To post to this group, send email to nlug-t...@googlegroups.com. To unsubscribe from this group, send email to nlug-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/nlug-talk?hl=en.
Re: [nlug] MySQL Letter to the EC
On Sun, Dec 13, 2009 at 6:57 PM, John R. Dennison wrote: > I normally do not forward material to this list, but this is important > enough to do so. > >> I thought I post this link >> http://monty-says.blogspot.com/2009/12/help-saving-mysql.html >> in case anyone isn't aware of this yet and wants to email the EC. > > I urge users of MySQL to read this link and if they feel inclined (which > I hope most of you would) to mail the EC by the listed deadline > (tomorrow). > > Oracle owning MySQL is a horrible thing to contemplate, if for no other > reason than their track record with InnoDB. Because of the GPL, Oracle may own the copyrights but they'll have no control. It doesn't matter. As others have said below, MySQL users are better served with Postgres, anyway, maybe this is another good reason to change. Michael -- Michael Darrin Chaney, Sr. mdcha...@michaelchaney.com http://www.michaelchaney.com/ -- You received this message because you are subscribed to the Google Groups "NLUG" group. To post to this group, send email to nlug-t...@googlegroups.com. To unsubscribe from this group, send email to nlug-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/nlug-talk?hl=en.
Re: [nlug] MySQL Letter to the EC
>From my latest return to mysql. here are grievances I am annoyed with. date or time types can't be manipulated with simple math like functions. example, in postgres, you can subtract two dates with the expected - and get what you expect. mysql requires you use specific functions. Column defaults have to be constants in mysql. Postgres lets you do function calls for default values. This is how postgres implements autoincrement. mysql lacks rich data types. Mysql has numeric, date/time, and strings. Postgres supports those and shorthands to similar functionality that you have to specify in mysql, like boolean being a smallint(1). Postgres goes on to offer, geometric types, network address, composite(think struct from C). Here lately we have been finding more and more ways to make the baby mysql cry when it comes to large amounts of join tables. Due to the permissions model we are using, we make calls to the permissions module to create a temp table with a list of ids for a primary table that we have a specific permission over. So, we have some queries with 20 or more temp tables we are joining with the primary table, and then we have how ever many other tables we need to join with to get the rest of the important data. When we started hitting 40+ tables on a result set of about 100 or so rows taking over a minute to run. We had to start changing the way we used the DB. So there the tool is getting in the way. Can't say for certain that Postgres would do better as we do not have the luxury of porting and running our software on a different DB. Use of specific to mysql instructions for data manipulation so as to lure developers in and make them unable to change platforms. Start with the date manip stuff and go to the continence function of reporting back found rows for use in pagination when you limited the result set. Yes I have anger over being forced to use mysql, but I figure with enough time, maybe I can show how it can be better and faster. - "Don Delp" wrote: > On Sun, Dec 13, 2009 at 8:07 PM, Tim Jackson > wrote: > > More reasons to use Postgres. > > > > -- > > Tim > > > > Care to list some of the other reasons? > > > On Sun, Dec 13, 2009 at 6:57 PM, John R. Dennison > wrote: > >> I normally do not forward material to this list, but this is > important > >> enough to do so. > >> > >>> I thought I post this link > >>> http://monty-says.blogspot.com/2009/12/help-saving-mysql.html > >>> in case anyone isn't aware of this yet and wants to email the EC. > >> > >> I urge users of MySQL to read this link and if they feel inclined > (which > >> I hope most of you would) to mail the EC by the listed deadline > >> (tomorrow). > >> > >> Oracle owning MySQL is a horrible thing to contemplate, if for no > other > >> reason than their track record with InnoDB. > >> > >> > >> > >> > >> John > >> > >> -- > >> Without deviation from the norm, progress is not possible. > >> > >> -- Frank Zappa (1940-1993), composer, musician, film director > >> > > > > -- > > > > You received this message because you are subscribed to the Google > Groups "NLUG" group. > > To post to this group, send email to nlug-t...@googlegroups.com. > > To unsubscribe from this group, send email to > nlug-talk+unsubscr...@googlegroups.com. > > For more options, visit this group at > http://groups.google.com/group/nlug-talk?hl=en. > > > > > > > > -- > > You received this message because you are subscribed to the Google > Groups "NLUG" group. > To post to this group, send email to nlug-t...@googlegroups.com. > To unsubscribe from this group, send email to > nlug-talk+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/nlug-talk?hl=en. -- Steven Critchfield cri...@basesys.com -- You received this message because you are subscribed to the Google Groups "NLUG" group. To post to this group, send email to nlug-t...@googlegroups.com. To unsubscribe from this group, send email to nlug-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/nlug-talk?hl=en.
Re: [nlug] MySQL Letter to the EC
On Sun, Dec 13, 2009 at 8:07 PM, Tim Jackson wrote: > More reasons to use Postgres. > > -- > Tim > Care to list some of the other reasons? > On Sun, Dec 13, 2009 at 6:57 PM, John R. Dennison wrote: >> I normally do not forward material to this list, but this is important >> enough to do so. >> >>> I thought I post this link >>> http://monty-says.blogspot.com/2009/12/help-saving-mysql.html >>> in case anyone isn't aware of this yet and wants to email the EC. >> >> I urge users of MySQL to read this link and if they feel inclined (which >> I hope most of you would) to mail the EC by the listed deadline >> (tomorrow). >> >> Oracle owning MySQL is a horrible thing to contemplate, if for no other >> reason than their track record with InnoDB. >> >> >> >> >> John >> >> -- >> Without deviation from the norm, progress is not possible. >> >> -- Frank Zappa (1940-1993), composer, musician, film director >> > > -- > > You received this message because you are subscribed to the Google Groups > "NLUG" group. > To post to this group, send email to nlug-t...@googlegroups.com. > To unsubscribe from this group, send email to > nlug-talk+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/nlug-talk?hl=en. > > > -- You received this message because you are subscribed to the Google Groups "NLUG" group. To post to this group, send email to nlug-t...@googlegroups.com. To unsubscribe from this group, send email to nlug-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/nlug-talk?hl=en.
Re: [nlug] MySQL Letter to the EC
More reasons to use Postgres. -- Tim On Sun, Dec 13, 2009 at 6:57 PM, John R. Dennison wrote: > I normally do not forward material to this list, but this is important > enough to do so. > >> I thought I post this link >> http://monty-says.blogspot.com/2009/12/help-saving-mysql.html >> in case anyone isn't aware of this yet and wants to email the EC. > > I urge users of MySQL to read this link and if they feel inclined (which > I hope most of you would) to mail the EC by the listed deadline > (tomorrow). > > Oracle owning MySQL is a horrible thing to contemplate, if for no other > reason than their track record with InnoDB. > > > > > John > > -- > Without deviation from the norm, progress is not possible. > > -- Frank Zappa (1940-1993), composer, musician, film director > -- You received this message because you are subscribed to the Google Groups "NLUG" group. To post to this group, send email to nlug-t...@googlegroups.com. To unsubscribe from this group, send email to nlug-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/nlug-talk?hl=en.
Re: [nlug] MySQL Letter to the EC
On Sun, Dec 13, 2009 at 7:27 PM, Howard Coles wrote: > It's better than MS owning it, which is what has strongly been hinted at > from Redmond. > If a fork were to be made right this second of it, would oracle really have the power to force that fork to cease and desist? If so, then open source software has a bigger problem then this one off instance. Andrew McElroy > See ya' > Howard Coles Jr. > John 3:16! > > Choose Life! > > On Dec 13, 2009 6:57 PM, "John R. Dennison" wrote: > > I normally do not forward material to this list, but this is important > enough to do so. > >> I thought I post this link >> http://monty-says.blogspot.com/2009/12/help-saving-mysql.html >> in case anyone isn't aware of this yet and wants to email the EC. > > I urge users of MySQL to read this link and if they feel inclined (which > I hope most of you would) to mail the EC by the listed deadline > (tomorrow). > > Oracle owning MySQL is a horrible thing to contemplate, if for no other > reason than their track record with InnoDB. > > > > > John > > -- > Without deviation from the norm, progress is not possible. > > -- Frank Zappa (1940-1993), composer, musician, film director > > -- > > You received this message because you are subscribed to the Google Groups > "NLUG" group. > To post to this group, send email to nlug-t...@googlegroups.com. > To unsubscribe from this group, send email to > nlug-talk+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/nlug-talk?hl=en. > -- You received this message because you are subscribed to the Google Groups "NLUG" group. To post to this group, send email to nlug-t...@googlegroups.com. To unsubscribe from this group, send email to nlug-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/nlug-talk?hl=en.
Re: [nlug] MySQL Letter to the EC
It's better than MS owning it, which is what has strongly been hinted at from Redmond. See ya' Howard Coles Jr. John 3:16! Choose Life! On Dec 13, 2009 6:57 PM, "John R. Dennison" wrote: I normally do not forward material to this list, but this is important enough to do so. > I thought I post this link > http://monty-says.blogspot.com/2009/12/help-saving-mysql.html > in case anyone isn't aware of this yet and wants to email the EC. I urge users of MySQL to read this link and if they feel inclined (which I hope most of you would) to mail the EC by the listed deadline (tomorrow). Oracle owning MySQL is a horrible thing to contemplate, if for no other reason than their track record with InnoDB. John -- Without deviation from the norm, progress is not possible. -- Frank Zappa (1940-1993), composer, musician, film director -- You received this message because you are subscribed to the Google Groups "NLUG" group. To post to this group, send email to nlug-t...@googlegroups.com. To unsubscribe from this group, send email to nlug-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/nlug-talk?hl=en.
[nlug] MySQL Letter to the EC
I normally do not forward material to this list, but this is important enough to do so. > I thought I post this link > http://monty-says.blogspot.com/2009/12/help-saving-mysql.html > in case anyone isn't aware of this yet and wants to email the EC. I urge users of MySQL to read this link and if they feel inclined (which I hope most of you would) to mail the EC by the listed deadline (tomorrow). Oracle owning MySQL is a horrible thing to contemplate, if for no other reason than their track record with InnoDB. John -- Without deviation from the norm, progress is not possible. -- Frank Zappa (1940-1993), composer, musician, film director pgp5MAMIR9OcY.pgp Description: PGP signature