Christian Fazzini wrote:
Just thinking out loud. about switching from pgsql to mysql.
You would be making a huge mistake.
haven't experienced any differences between the two databases.
That's nearly unbelievable unless you haven't been using either much, or
unless you've been using the most absolutely basic features.
been using mysql for the past few years. I like it more because am a
mac interface junkie and mysql has sequel pro. Not that this is a
determining factor. But pgsql also has navicat (in my opinion, not as
good as sequel pro).
Don't choose your DB server based on pretty graphical clients. MySQL is
far inferior to Postgres in virtually every respect. Postgres performs
better, lets you have referential integrity along with a fast storage
engine, and is more extensible (PostGIS would not be possible in MySQL,
for example). I think MySQL is *still* too brain-dead to scan table
indices backwards, and its procedural language (if you ever need it) is
so bad as to be nearly useless. Also, Postgres' syntax adheres more
closely to the SQL standard.
MySQL's advantages over Postgres include ease of setup and (so I've
heard) clustering...and that's it. For most projects, it is a mistake
to choose MySQL over Postgres.
The more important thing is, web hosts that I have spoken to have said
that pgsql takes up a considerable amount of RAM than mysql...
Never heard this.
RAM on a web host means more $$$.
So configure your Postgres install to use less RAM. Or use Heroku,
which has Postgres ready configured.
Moreover, since I've switched from Symfony PHP. Most of my other web
projects will be hosted with a mysql db.
That's just compounding the mistake.
I am sure there may be other more significant differences. But for my
every day use as a web developer, I don't really notice the internal
features that pgsql has over mysql.
What are you thoughts
You'll notice the difference as soon as you try to do something
non-trivial. Stick with Postgres. It's by far the better product. The
fact that the differences are under the hood doesn't make them less
important. There are also no commercial entities causing uncertainty as
to its fate.