Hacker News Reader

Hacker News

Comment by brianwawok | Hacker News Reader

Parent Full thread

brianwawok

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.

View on HN

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.

The default for Rails is sqlite and has been for quite a while now.

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.

Well I guess Django ships with sqllite but postgres is the normal thing to flip on. Good to know rails is the same...

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.)

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.

Reply on news.ycombinator.com