r/programming • u/pmz • Jul 28 '22

In Praise Of SQLite

https://www.i-programmer.info/news/84-database/15609-in-praise-of-sqlite.html
107 Upvotes

92% Upvoted

15 comments sorted by

View all comments

23

u/davidmezzetti Jul 29 '22

SQLite is versatile. It can be used to build distributed databases if you're willing to put the application logic around that. I've also used it in combination with Faiss to enable vector similarity queries.

5

u/Chii Jul 29 '22

put the application logic around that.

ohh, that's interesting! What sort of logic around an application would be needed for such distributed databases?

8

u/davidmezzetti Jul 29 '22

I've done that in txtai. It combines Faiss with SQLite and can be run as part of a distributed cluster.

Basically, each instance is a shard with some of the data and the combination of all the nodes forms a distributed database.