Hacker GitHub

← All repos

simonw/datasette-lite

View on GitHub ↗ ★ 411 CSS

Datasette running in your browser using WebAssembly and Pyodide

18 mentions on Hacker News by 8 people: 0 stories, 18 comments · first 2022-05-04 · latest 2025-12-26

Mentions per year 18 mentions · busiest year 2022 (6)
20082026
AllStoriesComments NewestTopOldest
  1. …website like GitHub Pages - this can be a great plan, there is also Datasette in a browser now: https://github.com/simonw/datasette-lite But that's different from how you collect the data in a git repository in the first place - or are you…
    comment by jarofgreen · 2025-12-26 · in Package managers keep using Git as a database, it never works out
  2. …work with jupyterlite and emscripten-forge yet FWIU; but does build SQLite in WASM with pyodide. https://github.com/simonw/datasette-lite pygwalker: https://github.com/Kanaries/pygwalker .. https://news.ycombinator.com/item?id=35895899 How…
    comment by westurner · 2025-02-27 · in Show HN: Probly – Spreadsheets, Python, and AI in the browser
  3. …IPFS gateway URLs with SRI hashes? datasette-lite > "Could this use the SQLite range header trick?" https://github.com/simonw/datasette-lite/issues/28 From xeus-sqlite-kernel > "Loading SQLite databases from a remote URL"…
    comment by westurner · 2024-11-28 · in Show HN: TeaTime – distributed book library powered by SQLite, IPFS and GitHub
  4. …a TeaTime like website, using the same databases. > datasette-lite > Loading SQLite databases: https://github.com/simonw/datasette-lite#loading-sqlite-data ... I haven't seen datasette before. What are the biggest benefits you think it has…
    comment by yoavm · 2024-11-27 · in Show HN: TeaTime – distributed book library powered by SQLite, IPFS and GitHub
  5. …build of datasette with the pyodide python distribution. datasette-lite > Loading SQLite databases: https://github.com/simonw/datasette-lite#loading-sqlite-data... jupyter-lite is a WASM build of jupyter which also supports sqlite in…
    comment by westurner · 2024-11-27 · in Show HN: TeaTime – distributed book library powered by SQLite, IPFS and GitHub
  6. …but not yet DuckDB (?) with Pyodide in WASM, and there's also JupyterLite as a datasette plug-in: https://github.com/simonw/datasette-lite https://news.ycombinator.com/user?id=simonw https://news.ycombinator.com/from?site=simonwillison.net…
    comment by westurner · 2024-08-12 · in The most cited authors in the Stanford Encyclopedia of Philosophy
  7. Also see: https://github.com/simonw/datasette-lite
    comment by rcaught · 2024-04-09 · in Sqlime: Online SQLite Playground
  8. …but not yet DuckDB (?) with Pyodide in WASM, and there's also JupyterLite as a datasette plug-in: https://github.com/simonw/datasette-lite
    comment by westurner · 2024-03-27 · in Show HN: WhatTheDuck – open-source, in-browser SQL on CSV files
  9. …datasette.io/en/stable/cli.html#running... and optionally datasette / datasette-lite ?csv= for a GUI: https://github.com/simonw/datasette-lite#loading-csv-data
    comment by westurner · 2023-12-28
  10. …[Full Container or Serverless] https://docs.datasette.io/en/stable/publish.html datasette-lite: https://github.com/simonw/datasette-lite : > You can use this tool to open any SQLite database file that is hosted online and served with a…
    comment by westurner · 2023-09-11 · in Code-gov: A collection point for all Code.gov repositories
  11. …even if only a small fraction of the whole database has been downloaded. #. simonw/datasette-lite: https://github.com/simonw/datasette-lite datasette, *-to-sqlite, dogsheep "Loading SQLite databases" [w/ datasette]…
    comment by westurner · 2023-08-09 · in SQLedge: Replicate Postgres to SQLite on the Edge
  12. From https://github.com/simonw/datasette-lite/issues/26 : > Micropip or Mambalite or picomamba or Zig. > "Better integration with conda/conda-forge for building packages" [pyodide/pyodide#795]( https://github.com/pyodide/pyodide/issues/795…
    comment by westurner · 2023-01-14 · in A 116kb WASM of Blink that lets you run x86_64 Linux binaries in the browser
  13. …the datasette-lite Python UI which runs in Emscripten to be able to look at multi-GB databases at https://github.com/simonw/datasette-lite/pull/49 . It uses a hacked up chunk'd lazyFile implementation from emscripten and others to grab…
    comment by crazysim · 2022-10-28 · in SQLite in the browser with WASM/JS
  14. …Database which came out to about 28GB after processing: POC, non-merging Log/Draft PR for the hack: https://github.com/simonw/datasette-lite/pull/49 You can run queries through to datasette-lite if you URL hack into it and just get to the…
    comment by crazysim · 2022-10-12 · in Hosting SQLite databases on any static file hoster (2021)
  15. See also https://github.com/simonw/datasette-lite : Datasette running in your browser using WebAssembly and Pyodide
    comment by nl · 2022-08-17 · in Learn Postgres at the Playground – Postgres compiled to WASM running in browser
  16. Close https://github.com/simonw/datasette-lite
    comment by pletnes · 2022-08-16 · in SQLite is not a toy database (2021)
  17. Oh wow! I wonder how hard it would be to load that module into https://github.com/simonw/datasette-lite Hah, turns out I have an issue for that already, which I'd forgotten about: https://github.com/simonw/datasette-lite/issues/30
    comment by simonw · 2022-07-30 · in A SQLite extension for reading large files line-by-line
  18. I have an open issue for that here: https://github.com/simonw/datasette-lite/issues/28 My initial hunch is that this will be really difficult - probably require a fork of something like https://github.com/coleifer/pysqlite3 then compiled…
    comment by simonw · 2022-05-04 · in Datasette Lite: a server-side Python web application running in a browser