Is SQLite a good fit for text editors?

Question

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"

muzani · Accepted Answer

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.

eternityforest · Answer

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.

diehunde · Answer

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

Is SQLite a good fit for text editors?

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.

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.

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