>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" <nesma...@gmail.com> wrote: > On Sun, Dec 13, 2009 at 8:07 PM, Tim Jackson <jackson....@gmail.com> > 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 <j...@gerdesas.com> > 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.
