15:[[31152490,{"by":"barryhennessy","descendants":325,"id":31152490,"kids":[31153130,31153207,31152965,31153727,31152773,31153317,31152898,31152841,31156151,31152778,31153705,31156603,31152927,31153223,31159083,31159042,31153159,31154776,31152995,31156732,31157679,31152978,31155693,31153013,31153163,31155569,31153228,31152678,31152910,31156510,31153276,31157707,31154651,31154612,31154772,31152935,31153561,31154902,31154307,31156220,31152704,31154131,31153382,31154481,31155636,31157425,31155042,31153685,31249680,31157887,31153154,31153096,31157599,31152870,31152785,31164575,31207584,31152718,31155920,31154589,31155572,31160072,31156444,31153600,31153519,31155653,31154244,31158812,31156758,31157670,31153711,31154344,31159495,31152964,31157310,31153084,31157420,31157509,31156667,31153956,31153489,31156196,31152954,31153503,31168842,31156476,31154180,31161722,31152861,31154505,31153140,31154903,31157568,31157436,31159504,31159714,31153542,31153976,31154178,31153239,31154740,31154009,31156665,31157177,31153251,31155974,31152852,31153327,31153799,31161230,31155686,31153590,31153441,31159515,31153476,31165613,31165408,31156824,31154148,31154161,31155632,31153559,31169868,31153446],"score":518,"text":"I periodically hear about projects that use/have used sqlite as their sole datastore. The theory seems to be is that you can test out an idea with fewer dependencies (and cost) and that it scales surprisingly far.

There are even distributed versions being built for reliability in the cloud: dqlite by canonical (of Ubuntu fame) and rqlite

Given the complexity it seems like there are use cases or needs here that I'm not seeing and I'd be very interested to know more from those who've tried.

Have you tried this?\nDid it go well? Or blow up?\nWere there big surprises along the way?

- https://sqlite.org\n- https://dqlite.io\n- https://github.com/rqlite/rqlite","time":1650881165,"title":"Ask HN: Have you used SQLite as a primary database?","type":"story"}]]

user:	vietdate
created:	March 18, 2022
karma:	1