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

11 points by asciiresort 3 years ago | 3 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"

muzani 3 years 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.

eternityforest 3 years 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.

diehunde 3 years 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