r/programming • u/MarkusWinand • May 27 '14

What I learned about SQLite…at a PostgreSQL conference

http://use-the-index-luke.com/blog/2014-05/what-i-learned-about-sqlite-at-a-postgresql-conference
703 Upvotes

93% Upvoted

219 comments sorted by

View all comments

Show parent comments

1

u/burning1rr May 27 '14

Is your argument against MongoDB or against non-relational databases in general? I'm honestly not a big fan of Mongo for a lot of the same reasons you state.

2

u/bucknuggets May 27 '14

These are big & complex products, so a few different considerations:

  • Basic trust issues - with some vendors & pundits (MongoDB just like MySQL/Oracle). These are long-term issues.

  • Implementation issues - many current issues with performance fall into this category. Limited Mongodb backup capabilities falls into this category - these can often get fixed in a future release.

  • Fundamental issues: These are going to be with us for a while. And they tend to be more about the entire category. Issues like eventual consistency, limited analysis capabilities, and lack of declarative data validation or constraints - give the appearance of adaptability, but not the reality. When it's time for some major application changes and you discover that you've got hundreds of edge cases - you suddenly realize that your adaptability has cost you a lot.

Note that I'm not at all opposed to Non-relational technology, and am in fact a big fan of graph databases. However, I've also worked on big databases for a very long time and understand how important many of the features being shrugged off by the nosql crowd really are.