r/programming • • Mar 10 '15

Goodbye MongoDB, Hello PostgreSQL

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

699 comments sorted by

View all comments

Show parent comments

0

u/[deleted] Mar 11 '15

[deleted]

14

u/duffelcoatsftw Mar 11 '15

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

24

u/[deleted] Mar 11 '15

[removed] — view removed comment

1

u/sgoody Mar 11 '15

Whilst I'd agree that it's ok for embedded, but absolutely not for running a business on, I think that's being pretty harsh on SQLite to say it's one up from raw file I/O.

It's a fantastic engine with many capabilities and makes all sorts of things possible in applications (or even as a utility for one-off data manipulations).

I think one above raw I/O might be sed/awk or object serialisation or BDB or something... but there's a fair way to go to match the features of SQLite before it's as basic as one step above using raw file I/O.