Hacker GitHub

← All repos

jlongster/absurd-sql

View on GitHub ↗ ★ 4,317 JavaScript

sqlite3 in ur indexeddb (hopefully a better backend soon)

25 mentions on Hacker News by 13 people: 3 stories, 22 comments · first 2021-08-12 · latest 2025-03-09

Mentions per year 25 mentions · busiest year 2022 (10)
20082026
AllStoriesComments NewestTopOldest
  1. ▲ 3
    AbsurdSQL – IndexedDB as a persistent back end for SQLite
    story by notpushkin · 2025-03-09 · 2 comments
  2. …SQL on top of IndexedDB by using AlaSQL ( https://github.com/AlaSQL/alasql ) or absurd-sql ( https://github.com/jlongster/absurd-sql ).
    comment by niutech · 2024-07-02 · in What Happens When You Put a Database in the Browser?
  3. ▲ 1
    Absurd-SQL: sqlite3 in ur indexeddb (hopefully a better back end soon)
    story by thunderbong · 2023-12-05 · 0 comments
  4. You can still use < https://github.com/jlongster/absurd-sql >. < https://jlongster.com/future-sql-web >
    comment by bb010g · 2023-09-18 · in What if OpenDocument used SQLite? (2014)
  5. …Something relevant is absurd-sql, but unfortunately that's not even close to production ready :/ https://github.com/jlongster/absurd-sql
    comment by tristanho · 2023-01-12 · in SQLite Wasm in the browser backed by the Origin Private File System
  6. …to drop in absurd-sql [1] to a project, which uses indexeddb to back SQLite. This seems better. [1] https://github.com/jlongster/absurd-sql
    comment by gfodor · 2023-01-12 · in SQLite Wasm in the browser backed by the Origin Private File System
  7. …needed for such a system. 0: https://webkit.org/blog/12257/the-file-system-access-api-wit... 1: https://github.com/jlongster/absurd-sql 2: https://www.sqlite.org/sessionintro.html
    comment by samwillis · 2022-10-28 · in SQLite in the browser with WASM/JS
  8. …the library and noone has stepped up yet. So the whole web story with OCaml isn’t good yet. [1]: https://github.com/jlongster/absurd-sql [2]: https://aantron.github.io/dream/
    comment by thangngoc89 · 2022-10-17 · in Irmin in the Browser (OCaml/MirageOS)
  9. Some ideas for persisting the SQLite database in IndexedDB: https://github.com/jlongster/absurd-sql
    comment by franky47 · 2022-09-25 · in WordPress WASM
  10. …you had to write the whole database out as a binary array to save changes. There is absurd-sql ( https://github.com/jlongster/absurd-sql ), which builds a virtual file system on top of IndexedDB for sqlite, it's incredible, but a bit of an…
    comment by samwillis · 2022-09-01 · in Learn PWA
  11. …access now: https://developer.mozilla.org/en-US/docs/Web/API/File_System... wrt SQLite, icmyi: https://github.com/jlongster/absurd-sql
    comment by gfodor · 2022-08-17 · in Learn Postgres at the Playground – Postgres compiled to WASM running in browser
  12. The strange thing is that AbsurdSQL appears to be 10x more performant than IndexedDB: https://github.com/jlongster/absurd-sql#performance (from memory the was some discussion that it wasn't a completely fair comparison, but even so was…
    comment by samwillis · 2022-05-26 · in SQLite 3 Fiddle
  13. …a custom block based FS on top of IndexedDB. It is somewhat absurd but it works incredibly well! https://github.com/jlongster/absurd-sql I think combining WASM SQLite with the session extension ( https://www.sqlite.org/sessionintro.html )…
    comment by samwillis · 2022-05-26 · in SQLite 3 Fiddle
  14. …do it properly, and is likely to be upstreamed to SQL.JS which is the main SQLite WASM project. 0: https://github.com/jlongster/absurd-sql Many new in browser DB engines are going to get built on top of this. Others that I could see…
    comment by samwillis · 2022-02-19 · in Safari now supports File System Access API with private origin
  15. …sleeve to make these sorts of projects easer, maybe even some sort of distributed block store. 0: https://github.com/jlongster/absurd-sql
    comment by samwillis · 2022-01-25 · in Store SQLite in Cloudflare Durable Objects
  16. …server. (Feel like I’m a cheer leader posting this comment every week) 0: https://sql.js.org/ 1: https://github.com/jlongster/absurd-sql 2: https://www.sqlite.org/sessionintro.html
    comment by samwillis · 2022-01-17 · in TinyBase: A JavaScript library for structured state
  17. …workers, it need some sort of block storage, but it can’t be far off. 0: https://sql.js.org/ 1: https://github.com/jlongster/absurd-sql 2: https://www.sqlite.org/sessionintro.html
    comment by samwillis · 2021-12-29 · in Consider SQLite
  18. …APIs to ensure it has suitable block level support and locking for this type of tool. https://github.com/jlongster/absurd-sql https://jlongster.com/future-sql-web
    comment by samwillis · 2021-12-01 · in SQLite in a PWA (Anita) with FileSystemAccessAPI
  19. …Wasm. I wander if it’s possible to use that here too although it’s obviously a little different? 0: https://github.com/jlongster/absurd-sql 1: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Refe... 2:…
    comment by samwillis · 2021-11-29 · in CPython's main branch running in the browser with WebAssembly
  20. …the speed increase. I think there is a good chance Absurd-SQL will get folded into SQLite.js. 0: https://github.com/jlongster/absurd-sql 1: https://jlongster.com/future-sql-web
    comment by samwillis · 2021-11-23 · in Why IndexedDB is slow and what to use instead
  21. SQL in the browser again: https://github.com/jlongster/absurd-sql
    comment by psychometry · 2021-10-26 · in Offline-First Database Comparison
  22. …and absurd-sql[2] that brings a distributed SQL datastore to the browser. 1) https://rxdb.info/ 2) https://github.com/jlongster/absurd-sql
    comment by mutagen · 2021-10-06 · in Why NoSQL
  23. …all be forced to use IndexedDB and hacky layers like PouchDB built atop it. I'm excited about https://github.com/jlongster/absurd-sql though.
    comment by psychometry · 2021-10-01 · in Downsides of Offline First
  24. …and subscriptions which we already hack together in our application layer using JS et al. [1]: https://github.com/jlongster/absurd-sql [2]: https://github.com/google/lovefield [3]: https://github.com/agershun/alasql [4]:…
    comment by vaughan · 2021-09-06 · in Ask HN: What could a modern database do that PostgreSQL and MySQL can't
  25. ▲ 92
    Absurd-SQL – Use sqlite3 on the web with storage in IndexedDB
    story by timdorr · 2021-08-12 · 11 comments