2 ms·

I don't think postgres is the default over mysql. I think WordPress and php guys default to MySQL. I think python and Django guys end up defaulting to Postgre

I don't think postgres is the default over mysql. I think WordPress and php guys default to MySQL. I think python and Django guys end up defaulting to Postgres. Rails and node.js I am less sure what the default is, maybe mongodb? I don't think either camp has really changed since Oracle came along. A lot of momentum in different stacks.

bshimmin 10y ago
The actual default for Rails is SQLite [1], though a lot of people (perhaps a majority) use PostgreSQL. You certainly can use MongoDB with Rails via Mongoid, though I'm not sure vast numbers of people do, comparatively. For Node, well, it varies, but at least once upon a time, people used to talk about the "MEAN" stack (MongoDB, Express, Angular, Node) - MongoDB and Node are certainly often used together. [1] Not MySQL - edited as per the below correction.
- werdnapk 10y ago
  The default for Rails is sqlite and has been for quite a while now.
  - bshimmin 10y ago
    You're quite right. It's so long since I've used Rails with anything other than Postgres I knew that it couldn't be the default because of having to specify the configuration flag, but it escaped me that it would be SQLite. Thanks for the correction.
  - brianwawok 10y ago
    Well I guess Django ships with sqllite but postgres is the normal thing to flip on. Good to know rails is the same...
schneidmaster 10y ago
Yeah, as others have noted, the default for Rails is definitely not Mongo. SQLite is the default and thus ends up getting used a lot in development. Production is a relatively even split between Postgres and MySQL, although I think it tilts slightly towards Postgres in part because that's the default on Heroku. (I have no data to back this up, just my sense of things.)
0x6c6f6c 10y ago
The momentum I've seen hasn't been MySQL -> Postgres but rather MySQL -> MariaDB. Oracle's control over MySQL and the shift towards Open Core over FOSS fundamentals has pushed some companies to use the compatible MariaDB option over it. Most Linux distros use MariaDB by default now, meaning more LAMP stacks by default having MariaDB over Oracle's MySQL. I'm certainly not saying MariaDB is taking over MySQL, just the trend I've seen being a RHEL Sys Admin.

bshimmin 10y ago

The actual default for Rails is SQLite [1], though a lot of people (perhaps a majority) use PostgreSQL. You certainly can use MongoDB with Rails via Mongoid, though I'm not sure vast numbers of people do, comparatively. For Node, well, it varies, but at least once upon a time, people used to talk about the "MEAN" stack (MongoDB, Express, Angular, Node) - MongoDB and Node are certainly often used together. [1] Not MySQL - edited as per the below correction.

werdnapk 10y ago
The default for Rails is sqlite and has been for quite a while now.
- bshimmin 10y ago
  You're quite right. It's so long since I've used Rails with anything other than Postgres I knew that it couldn't be the default because of having to specify the configuration flag, but it escaped me that it would be SQLite. Thanks for the correction.
- brianwawok 10y ago
  Well I guess Django ships with sqllite but postgres is the normal thing to flip on. Good to know rails is the same...

schneidmaster 10y ago

Yeah, as others have noted, the default for Rails is definitely not Mongo. SQLite is the default and thus ends up getting used a lot in development. Production is a relatively even split between Postgres and MySQL, although I think it tilts slightly towards Postgres in part because that's the default on Heroku. (I have no data to back this up, just my sense of things.)

0x6c6f6c 10y ago

The momentum I've seen hasn't been MySQL -> Postgres but rather MySQL -> MariaDB. Oracle's control over MySQL and the shift towards Open Core over FOSS fundamentals has pushed some companies to use the compatible MariaDB option over it. Most Linux distros use MariaDB by default now, meaning more LAMP stacks by default having MariaDB over Oracle's MySQL. I'm certainly not saying MariaDB is taking over MySQL, just the trend I've seen being a RHEL Sys Admin.