5 ms·
MySQL is a good database for basing a CMS on. (for a loose definition of database) PostgreSQL is a good SQL database. And don't take me wrong, I'll take MySQL
by raverbashing 13y ago
MySQL is a good database for basing a CMS on. (for a loose definition of database)
PostgreSQL is a good SQL database.
And don't take me wrong, I'll take MySQL instead of PostgreSQL for simple and medium projects.
"Is the barrier to entry too low, and problems are from legions of rank amateurs?"
Maybe. Well, "low barrier to entry" is not a defect.
- cperciva 13y agoMySQL is a good database for basing a CMS on. (for a loose definition of database) It seems to me that the success of MySQL can be tied directly to people using "database" for things where what they really need is "filesystem".
- fatalmind 13y agoSeems like. That's also what this comment on Reddit says: http://www.reddit.com/r/programming/comments/1niheb/mongodb_is_to_nosql_like_mysql_to_sql_in_the_most/ccje34x http://www.reddit.com/r/programming/comments/1niheb/mongodb_...
- bad_user 13y agoHow easy is it to put a lock on a file while writing on it? What happens in an environment where you have multiple frontend servers that need to write to the same file? Are you going to have like one server that does the reading/writing from a file and have like a protocol with which other servers can send commands? Great, you've just invented a half-assed DBMS.
- lmm 13y ago> Great, you've just invented a half-assed DBMS. My first thought is "Yeah, we already have one of those, it's called MySQL"
- ArbitraryLimits 13y agoAgree, except I'd amend it as The success of MySQL can be tied directly to people using "database" for things where what they really need is "network filesystem". The success of SQLite can be tied directly to people using "database" for things where what they really need is "filesystem". Interesting that it's the same dynamic at play.
- sergiosgc 13y ago> And don't take me wrong, I'll take MySQL instead of PostgreSQL for simple and medium projects. Why? I can't see one feature that MySQL delivers better than Pgsql...
- raverbashing 13y agoIt's really funny when I get asked that question, really: PostgreSQL is a pain to setup, the SQL parser is very finnicky and for the past times I spent too much time trying to work around every idiosyncrasy of Postgres when I could have a similar MySQL instance running in a shorter time So, MySQL doesn't waste my time with stupid crap. Now please call me ignorant and downvote me since PostgreSQL fanboys can't take a critique and think their loved database is perfect.
- pnathan 13y agoHonestly, this is not my experience at all, and I'm not a DBA. I install postgres, I fiddle with setting up a user & pg_hba.conf to allow connections, and after that it's basically game on.
- Xylakant 13y agoNot calling you ignorant, but for workloads that a simple, untuned mysql installation is sufficient you can just build yourself a simple, default postgresql installation. Use chef, puppet, terraform,... to make that repeatable and the setup pain goes away.
- raverbashing 13y agoTrue, Chef and Puppet kind of take the pain away between different linux distributions (which is good). But this would be aiming at a deployment. However, one common use case (for me) is having to have a one-off install, which unfortunately kind of prevents that. If my job needed frequently installs of DBs I would have probably gone this way, but it isn't, so today it's PostgreSQL 9.1 on Mac OS, tomorrow (more likely, a year or two from now) it's MySQL on Fedora, etc
- JulianMorrison 13y agoConsider SQLite instead.
- zorbo 13y agoThat's a joke, right? SQLite isn't even in the same ballpark as MySQL. It has a thousand uses, but a replacement for MySQL it is not.
- dragonwriter 13y agoSQLite is a great replacement for MySQL for many of the same reasons and in many of the same circumstances where MySQL is a decent replacement for a non-MySQL RDBMS. Its lighter, simpler, and less overhead for simple tasks.
- JulianMorrison 13y agoSQLite is a replacement for the uses of MySQL that aren't better replaced with postgres.