PostgreSQL vs MySQL: an apples to oranges comparison
ledgersmbdev.blogspot.co.uk
PostgreSQL vs MySQL: an apples to oranges comparison
1–10 of 71 posts
Re: PostgreSQL vs MySQL: an apples to oranges comparison
#2If you cannot compare PostgreSQL to MySQL then what databases can be compared?
Re: PostgreSQL vs MySQL: an apples to oranges comparison
#3If you cannot compare PostgreSQL to MySQL then what databases can be compared?
the point of this article is that Postgres is not just a database
Re: PostgreSQL vs MySQL: an apples to oranges comparison
#4great article. i am amazed. (many articles from ledgersmb folks (or only this person, i don't remember) are great.)
Re: PostgreSQL vs MySQL: an apples to oranges comparison
#5If you cannot compare PostgreSQL to MySQL then what databases can be compared?
the point of this article is that Postgres is not just a database
Sure it is. MySQL is just a database with fewer features (and less rigid ACID compliance.) Like SQLite vs. MSSQL or PG vs. Vertica. Different tools for different jobs.
Re: PostgreSQL vs MySQL: an apples to oranges comparison
#6Earlier quoted context omitted.
the point of this article is that Postgres is not just a database
Sure it is. MySQL is just a database with fewer features (and less rigid ACID compliance.) Like SQLite vs. MSSQL or PG vs. Vertica. Different tools for different jobs.
"Different tools for different jobs"
that's exactly the (or better: one) point of the article. no disagreement here, right?
Re: PostgreSQL vs MySQL: an apples to oranges comparison
#7Earlier quoted context omitted.
Sure it is. MySQL is just a database with fewer features (and less rigid ACID compliance.) Like SQLite vs. MSSQL or PG vs. Vertica. Different tools for different jobs.
"Different tools for different jobs" that's exactly the (or better: one) point of the article. no disagreement here, right?
Nope :)
Re: PostgreSQL vs MySQL: an apples to oranges comparison
#8Are there any books out there that describe how to efficiently use PostgreSQL's object-relation techniques?
Re: PostgreSQL vs MySQL: an apples to oranges comparison
#9Are there any books out there that describe how to efficiently use PostgreSQL's object-relation techniques?
postgres docs are full of performance tips
Re: PostgreSQL vs MySQL: an apples to oranges comparison
#10I think it really depends on the type of apps you write. If you write small - medium rails apps, then the db is usually just dumb storage and if you are careful to use the ORM properly, then DBs are just plug and play. If your app is larger and you need more features, then you look more deeply into the features of each in which, most of the time, POSTGRES is the clear winner.