3 ms·
I can get that comments are not "big data" but SQlite seems underwhelming. Any reason why this choice was made?
by foolinaround 12y ago
I can get that comments are not "big data" but SQlite seems underwhelming.
Any reason why this choice was made?
- infogulch 12y agoUnderwhelming? Do you have a case for this where SQLite wouldn't be good enough?
- jimstr 12y agoWhen having more than one web server (and no shared file system) ?
- alexcasalboni 12y ago"SQLite is not designed to compete with Oracle. SQLite is designed to compete with fopen()." http://www.sqlite.org/whentouse.html http://www.sqlite.org/whentouse.html How about something towards the Cloud direction, like AWS RDS? MySQL, Oracle, SQL Server, PostgreSQL or Aurora might work better.
- yellowapple 12y agoFor me, it's not really so much "not good enough" as much as it is "I'm already using PostgreSQL as a database and I'd rather not have to maintain two separate SQL database implementations on my servers if I can avoid it".
- skuhn 12y agoWell on the plus side, sqlite has no daemon and pretty much requires no care and feeding. However, I also think it is totally wrong for this use case.
- yellowapple 12y agoTrue, though it still means having to check yet another place to make sure everything's backed up properly, etc.