Ask HN: Is SQLite a good fit for text editors?

11 pointsasciiresort3y ago3 comments

The SQLite website mentions it is the mostly deployed SQL database and found in:

"Every Android device Every iPhone and iOS device Every Mac Every Windows10 machine Every Firefox, Chrome, and Safari web browser Every instance of Skype Every instance of iTunes Every Dropbox client Every TurboTax and QuickBooks PHP and Python Most television sets and set-top cable boxes Most automotive multimedia systems Countless millions of other applications"

3 comments

muzani3y ago

Yes, why not? The drawback of SQLite appears to be that it only allows one user at a time, which fits client side perfectly fine.

eternityforest3y ago

For what purpose in a text editor? Hopefully not for user settings, some people like to version control those.

For "recently opened", indexing, etc it seems appropriate.

diehunde3y ago

I think it is. Some neovim plugins such as Telescope which is widely used and praised use SQLite[1]

[1] https://github.com/kkharji/sqlite.lua#-powered-by-sqlitelua

j / k navigate · click thread line to collapse