Ask HN: Is SQLite a good fit for text editors?
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" 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