Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Now I just want a spreadsheet style front end to SQLite and I'm nerd sniped into trying to figure out how to do formulas (triggers I suppose).


Congratulations, you're about to reinvent MS Access / DBase / FoxPro... 30 years later.


That's an excellent point.


I'm sorry for the initial sarcasm, it would actually be pretty cool to have those type of apps back. With everything going web-first nowadays, you could take inspiration from SQLite's own SCM, Fossil, that can run both as a CLI or a Web server.


I've been thinking it would be cool to build something like this. What gets me stuck is version controllability and backups.

I think ideally you'd want multiple backends, either SQLite, or flat files that are Git/SyncThing friendly.

I was even thinking the file format could have a file UUID and record timestamps, so that if you put a different version of the same file in the same folder(Like with a SyncThing conflict file) it would give you a merged view, with newest-record-wins logic.

Formulas I think would be the easy part. Just write it all in Python and use one of the many Excel compatible formulas implementations, and just make sure all changes went through the app.

Maybe you could even have a REST API to build other things on top of it.

The web frontend wouldn't be too hard, it could just be a Vue3 app with an HTML table element.

Then you could have a cell type who's value was a query, which would embed a DB browser list widget in the cell, and that cell type could have the option to bind its selected row to another cell.

Like VB+Excel+Access+My fork of Freeboard with inputs in one!


For the most simplistic row-wise formulas, sqlite has generated columns.

I’d assume the issue will be that an sql table is not free form, you can’t randomly decide to write in some other cell.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: