PostgreSQL scales better with more users http://tweakers.net/reviews/649/7
MySQL accepts the date 31st February 2007 and has several other lax views of rounding data or squeezing it in when it should reject it. http://safari.oreilly.com/0596002114/msql2-CHP-16-SECT-3 MySQL only supports transactions with the InnoDB backend which has been bought by Oracle. http://www.innodb.com/ You can do a hot backup ( backup when the database is open ) of PostgreSQL without buying software - you have to buy the InnoDB hot backup software. The best point for MySQL is that the query "select count(*) from table" is much quicker than PostgreSQL. You have to remember to auto vaccuum a postgresql database to get rid of old data that is no longer required. MySQL is dual licensed both open source and commercial. I still haven't got my head around this one - if you distribute a product that includes MySQL for money then you need to buy a license. PostgreSQL is the BSD license so is totally free to use as you wish. In general if you don't already have expertise in MySQL then you should always choose PostgreSQL - my opinion for what it's worth :-) On 7/20/07, walterbyrd <[EMAIL PROTECTED]> wrote: > > > I know that PostgreSQL is recommended, but why? Are the django > developers assuming a high-traffic, database intensive site. Are the > django developers assuming that you will not be using shared hosting? > > I seems to me, that if you are using shared hosting, and if your > database needs are modest, Sqlite3 might be the best choice. > Especially when Python 2.5 becomes more standard on shared hosting. > > For one thing, with sqlite, you don't have to share a database server > with others. Judging from the way Drupal runs on dot5hosting, or > dreamhost, this might make a real difference. Also sqlite is almost > trivial to setup and administrate. > > Has anybody had any particular difficulties with MySQL? > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
