Would anybody here use MySql for a new project? If so, why?
Would anybody here use MySql for a new project? If so, why?
They are both plenty feature complete to work well for relational data type problems. Grab the one you have more exposure to and you'll be fine.
That said, I'm still using mysql-innodb (latest percona) because the built-in replication has had more time to bake and its concurrency model (think 100k qps+) is plain better. For further reading see:
Ultimately, I think familiarity is and will always be the biggest driver for experienced devs who choose a DB.
There's also the NDB and Galara Cluster, but you want a specific use-case to justify the added complexity and overhead.
I've seen Blackhole used in production, but that was an odd one involving a... unique... replication setup. The CSV engine is pretty awesome for huge data imports, but again, pretty unusual for actual use.
[0] https://mariadb.com/kb/en/mariadb/why-does-mariadb-102-use-i...
MySQL is fast enough, usually has enough features, I know how to tune it and queries, and I normally only bump into 2-3 things in a project which would've been easier with PostgreSQL. And can work around them.
The backwards-incompatible SQL_MODE changes between MySQL 5.6 and 5.7 made me reconsider, as legacy apps needed updating.
tl;dr: yes. But PostgreSQL would be easier for some items
Uhm, err, that change is to stop the database from silently trowing away your data. It's not about "fast enough", or "easy". It's about your database actually saving your data.
If you're happy for your "database" to keep quietly throwing away data in order to keep legacy apps "working", you can just disable strict mode.
Across multiple businesses, they've upgraded servers and got MySQL 5.7 installed, only to wonder why the app has stopped working. People didn't expect that from a point release/the default new operating system package. We could argue the point, but it's the expectation of businesses vs software engineers.
http://www.brightball.com/articles/why-should-you-learn-post...
1. Did you use magento/Drupal/WordPress/etc PHP framework
2. Did you host on a 20$ per month server with unlimited bandwidth and free database ?
Apparently postgresql is difficult to run in a properly restricted bsd jail. Other than that, I'd be hard pressed to come up with reasons to prefer mysql on technical merit over either postgresql, or, say redis or something.
Is there anything else that's needed to properly restrict the jail?
https://forums.freebsd.org/threads/59371/
Apparently this can(should?) be tweaked a bit since 11-release:
https://www.freebsd.org/cgi/man.cgi?query=jail&sektion=&n=1
> allow.sysvipc A process within the jail has access to System V IPC primitives. This is deprecated in favor of the per-mod- ule parameters (see below). When this parameter is set, it is equivalent to setting sysvmsg, sysvsem, and sysvshm all to ``inherit''.
I interpret that as it still being the case that setting this to the (equivalent of) the deprecated setting, one looses much of the protection a jail normally gives.
That's essentially my reasons for preferring PostgreSQL.