Re:Appropriate Uses for SQLite
by andyidsinga on Wednesday February 14, 2018 @06:45AM
(#16375102)
I've used sqlite as an index for S3 objects ..and stored the DB file in S3 itself. It was very practical to use, and a handy pattern to apply to object storage where the number of objects to be indexed for a given time frame was reasonable for sqlite (I had in 100k range).
Also - easy to dump the sqlite db into a SQL text file then import into something like postgres :)
Also - easy to dump the sqlite db into a SQL text file then import into something like postgres :)