[lug] MySQL vs PostgreSQL
Dan Ferris
dan at usrsbin.com
Fri Aug 3 18:00:34 MDT 2012
MySQL is very loosy goosey with your data by default.
Here is a comparison that shows how MySQL behaves vs. Postgres. I think
you can make MySQL much stricter, but you would not want to use the
default settings anywhere you cared about data integrity.
http://wekeroad.com/2012/07/19/postgresql-rising
The downside of Postgres is that it's not easy. I have been dealing
with it for 2 years and I still suck at it. :)
Dan
On 8/3/2012 4:44 PM, Gordon Golding wrote:
> Somebody has a PostgreSQL system.
> They want to do an entire new large data warehouse.
> I used to work with Postgres, now with MySQL.
> It seems I just don't see Postgres mentioned that much any more.
> Would it be best to build the new data warehouse on MySQL?
> Any comments on one over the other?
>
> Gordon
>
>
> _______________________________________________
> Web Page: http://lug.boulder.co.us
> Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
> Join us on IRC: irc.hackingsociety.org port=6667 channel=#hackingsociety
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lug.boulder.co.us/pipermail/lug/attachments/20120803/d7d1c763/attachment.html>
More information about the LUG
mailing list