A fast SQLite PWA notebook for CSV files

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

Our great sponsors
  • SonarLint - Deliver Cleaner and Safer Code - Right in Your IDE of Choice!
  • Scout APM - Less time debugging, more time building
  • SaaSHub - Software Alternatives and Reviews
  • sqliteviz

    Instant offline SQL-powered data visualisation in your browser

  • datastation

    App to easily query, script, and visualize data from every database, file, and API.

    Here's another one [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

  • SonarLint

    Deliver Cleaner and Safer Code - Right in Your IDE of Choice!. SonarLint is a free and open source IDE extension that identifies and catches bugs and vulnerabilities as you code, directly in the IDE. Install from your favorite IDE marketplace today.

  • jupyterlite

    Wasm powered Jupyter running in the browser 💡 (by jtpio)

    This is really wonderful! The discussion about lay people'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.

    https://github.com/jtpio/jupyterlite

    https://github.com/gzuidhof/starboard-notebook

  • starboard-notebook

    In-browser literate notebooks

    This is really wonderful! The discussion about lay people'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.

    https://github.com/jtpio/jupyterlite

    https://github.com/gzuidhof/starboard-notebook

  • q

    q - Run SQL directly on delimited files and multi-file sqlite databases (by harelba)

    Second this recommendation for the terminal. For my CLI toolbox, VisiData is my favorite.

    I find VisiData is great for quickly exploring and querying data that from the CLI. It can handle many types of files (SQLite, CSV, TSV, Excel, JSON, YAML, etc). Visidata loads all the data into memory, and so is very responsive when exploring the data. It allows you to quickly do all sorts of of adhoc queries interactively, without having to write a valid SQL query.

    I haven't used Q. When I first heard of it, I liked the idea that Q allowed you to run random queries on CSV and TSV files. However, it seemed like it would be slow if you wanted to do follow up queries, since it had to repopulate the in memory SQLite file for each query. Though it looks like the latest version has a way to cache the generated sqlite file. So that seems like it could help.

    Also, if I have some CSV, TSV, JSONL data sqlite-utils is useful for converting them to SQLite, and then exploring with Visidata or SQL queries.

    Q: https://github.com/harelba/q

  • sqlite-utils

    Python CLI utility and library for manipulating SQLite databases

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts