Discussion in 'OT Technology' started by daneeyah, Oct 19, 2007.
What are the major differences in terms of syntax between these two?
Take a look at the date on that article. That article is wayyyyy old.
Mysql 5.1 which is in RC right now, has triggers, data partitioning as well as row level replication. It's really has developed into a major and competent data storage application.
But really this is one of those Ford vs Chevy type of arguments. The syntax is pretty much the same with just a couple of differences but not much.
PostGRES is nice for GIS
Why is that?
Side Note: What type of work do you do with GIS?
Well for one its very fast ( compared to ESRI stuff ) and its free.
Hmn.. I just did a bit of research, I guess MySQL supports GIS extensions as well.
PG makes it all so easy and fast though.
I guess crap on a stick > ESRI.
I do work with Bus routes, stops, etc.
Thanks everyone for your help
Do you guys mind giving me a quick example of how you would write something in postgressql and then the same statement in mysql?
Any simple statement in which I can see the syntax difference.
Years ago, MySQL was a "entry-level" website database solution mildly above Microsoft Access.
However, now, MySQL is a competent mid-grade product.
Not gonna compete with DB2 or Oracle at the high-end, but for most people, it's a great product.
I've always worked with MySQL just because it seems to be more widely supported and easier to use with PHP.
Basic CRUD is the same through out. It's going to be special functions that show up in each of the respective databases.. What exactly are you trying to do?