A fast SQLite PWA notebook for CSV files

There are a lot of different solutions knocking around for running queries on one or more CSV files. This is a web-based notebook that prioritizes loading large files quickly so you can get running queries on them as soon as possible. It supports most text files, Excel files, JSON. It can also display your results as graphs.

A PWA <i>and</i> vanilla JavaScript; we need more of these. Fantastic job!

This is really wonderful! The discussion about lay people&#x27;s knowledge of sql reminded me that the Pandas API is often useful for non-sql folk. Likewise there are some projects similar to dirtylittlesql to bring Python data manipulation to the browser.<p><a href="https:&#x2F;&#x2F;github.com&#x2F;jtpio&#x2F;jupyterlite" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;jtpio&#x2F;jupyterlite</a><p><a href="https:&#x2F;&#x2F;github.com&#x2F;gzuidhof&#x2F;starboard-notebook" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;gzuidhof&#x2F;starboard-notebook</a>

Also worth a look, built as a static web spa<p><a href="https:&#x2F;&#x2F;github.com&#x2F;lana-k&#x2F;sqliteviz" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;lana-k&#x2F;sqliteviz</a>

Very cool, but I didn&#x27;t found a way to configure the delimiter (most of my files use ; as a delimiter)

What would be cool is integrating this with OpenAI Codex - the natural language to SQL transformations were impressive when I played around with them.<p>This could then be pitched to non-techie folk who want to simply ask questions from their data on flat file.

Nice app, best of all no Electron needed.

Similar: Microsoft LogParser (<a href="https:&#x2F;&#x2F;www.microsoft.com&#x2F;en-in&#x2F;download&#x2F;details.aspx?id=24659" rel="nofollow">https:&#x2F;&#x2F;www.microsoft.com&#x2F;en-in&#x2F;download&#x2F;details.aspx?id=246...</a>)

Love it! Could you also provide some options for decimal point data? Comma instead of period.<p>It would be great if I could use it as a kernel in JupyterLite!

This is really good! Would be great if there was a way to rename the created tables!

Is it available as Docker Image?