A fast SQLite PWA notebook for CSV files (opens in new tab)

Vanilla JS nowadays means not using a framework, in yesteryears it meant not using jQuery, in either case, it doesn't preclude from having dependencies.

to be fair, in case the dependencies are pegged to specific known-good versions and are bundled into one or a few files then two concerns with dependencies go away, namely, insanely deep and wide file system trees and the lingering danger of any one of hundreds of software titles getting malware-ized. One could even add that it's probably a good idea to prefer tried-and-tested existing software over writing everything from scratch.

Not OP, but in my opinion:

When I am reading through the source code of somebodies personal project, it's absolutely amazing to:

- see how to do X in discernible, concise, modern JavaScript

- follow along significant architectural decisions

- watch a web API in action, not a specialized abstraction that will necessarily hide some capabilities

That being said: This project doesn't offer much in that regard. It's hard to read and makes little use of modern JavaScript.

> It takes literally tens of minutes to Learn SQL necessary to a single csv file

It might take you, as a programmer or technically literate person, tens of minutes to learn the SQL necessary to parse a csv file.

But I have met a whole raft of people that would firstly take much longer to learn enough SQL to get by, then would still need help when basic syntax error messages came up, and then would get frustrated before getting someone else to do basic analysis for them.

Yes, thanks for sharing.

Visidata[0] is another great tool in this vein I often forget the name of when I really need it. Python, in the terminal, kind of like vim on CSV with graphing capabilities.

0. https://www.visidata.org/

hey there, i've left a github issue / feature request.

Column UI would be awesome

Here's another one I'm working on [0]. Run it as a desktop Electron app or as a server/web app. There's also a serverless/in-memory web app demo running here [1].

[0] https://github.com/multiprocessio/datastation

[1] https://app.datastation.multiprocess.io