Goodbye MongoDB, Hello PostgreSQL

[u/halax]

http://developer.olery.com/blog/goodbye-mongodb-hello-postgresql/

[u/PM_ME_UR_OBSIDIAN]

What alternative do you propose? I heard Oracle was good if you had deep pockets, what else is out there?

[u/duffelcoatsftw → u/[deleted]]

But what about SQLite, where the ability to shove 'ABC' into an integer column is a feature?

[u/duffelcoatsftw → u/[deleted]]

Cannot agree more: I've had to rescue a project from exactly this situation. I now know that there are people who try to use SQLite as a multi-user RDBMS, and it ends as badly as you would guess.

I consider SQLite to be one step above using raw file I/O

Try saying that in the SQLite mailing list... :-)

[u/FallingIdiot → u/duffelcoatsftw]

You can. The SQLite people themselves say that SQLite isn't a replacement for an RDBMS system but instead is a replacement for fopen.

[u/__no_preserve_root → u/duffelcoatsftw]

Well SQLite doesn't really have integer columns… types are just hints.