WiseLibs/better-sqlite3
View on GitHub ↗ ★ 7,543 JavaScript
The fastest and simplest library for SQLite3 in Node.js.
19 mentions on Hacker News by 18 people: 5 stories, 14 comments · first 2018-03-19 · latest 2025-10-20
20082026
-
I’ve enjoyed https://github.com/WiseLibs/better-sqlite3/blob/master/docs/... as a code of conduct. Simple, well-motivated, well-practiced (I think). Unlike more convoluted CoCs, it’s tightly scoped on work, not fun. Specific labor intended…
comment by hitekker · 2025-09-27 · in Eric S. Raymond to the OSS community on codes of conduct: Refuse to have one -
…with generated columns and indexes, but I haven’t found a proper use for this yet in my work. [1] https://github.com/WiseLibs/better-sqlite3/blob/HEAD/docs/ap...
comment by DecoPerson · 2025-06-16 · in SQLite Date and Time Functions (2007) -
These may be useful reading: https://github.com/TryGhost/node-sqlite3/issues/408#issue-57... https://github.com/WiseLibs/better-sqlite3/issues/32#issueco... Copying a quote from the second: > The sqlite3 C API serializes all operations…
comment by darthShadow · 2025-01-27 · in Supercharge SQLite with Ruby Functions -
…you're a prodigy or have a sizable team and will come with numerous downsides. I can recommend https://github.com/WiseLibs/better-sqlite3 and https://github.com/loveencounterflow/dbay
comment by DemocracyFTW2 · 2023-08-31 · in How practicle is it to have a textfile based database with an SQLite API? -
…Notion's desktop app anyways. The "why should I use this" bits sound boastful but are reasonable. https://github.com/WiseLibs/better-sqlite3#why-should-i-use-...
comment by jitl · 2023-08-08 · in Show HN: Doculite – Use SQLite as a Document Database -
…writes? There's no client-server setup here, using async / await just introduces pointless waiting. https://github.com/WiseLibs/better-sqlite3
comment by zdragnar · 2023-08-07 · in Show HN: Doculite – Use SQLite as a Document Database -
…to handle the networking and database replication so that it doesn't rely on the underlying DB. [0] https://github.com/WiseLibs/better-sqlite3/blob/HEAD/docs/ap... [1] https://replicache.dev/
comment by yoz · 2023-01-06 · in I Migrated from a Postgres Cluster to Distributed SQLite with LiteFS -
…writes are via https://github.com/photostructure/exiftool-vendored.js/ Persistence is via SQLite: https://github.com/WiseLibs/better-sqlite3 Image transforms are via Sharp: https://sharp.pixelplumbing.com/ My more nerdier blog posts are…
comment by mceachen · 2022-10-02 · in Lychee – Self-hosted photo-management done right -
…be great to have some benchmarks against better-sqlite and the regular sqlite libraries, like in https://github.com/WiseLibs/better-sqlite3
comment by jackbravo · 2022-09-29 · in Flyweight: An ORM for SQLite -
I tried to replace SQLite with DuckDB for a customized install of better-sqlite3[1] and failed. [1] https://github.com/JoshuaWise/better-sqlite3
comment by DemocracyFTW2 · 2022-05-27 · in Range joins in DuckDB -
Best option for SQlite with node is this. https://github.com/JoshuaWise/better-sqlite3 Author is all over the issues section, and seems very knowledgeable about how SQLite works.
comment by LAC-Tech · 2022-05-10 · in I'm all-in on server-side SQLite -
…ttps://github.com/mattn/go-sqlite3/pull/1019 [1] https://github.com/mapbox/node-sqlite3/pull/1550 [2] https://github.com/JoshuaWise/better-sqlite3/pull/778 [3] https://github.com/multiprocessio/datastation
comment by eatonphil · 2022-03-22 · in Ask HN: Do you contribute to open source projects? -
you can write your own table-valued, aggregate and window functions when you use better-sqlite3 (see https://github.com/JoshuaWise/better-sqlite3/blob/master/doc... see Database#function(), Database#aggregate(), Database#table()) in…
comment by DemocracyFTW · 2021-08-05 · in In Praise of PostgreSQL -
…instead which came with the benefits of being able to use other jdbc libraries like honeysql. [1] https://github.com/JoshuaWise/better-sqlite3
comment by pmlamotte · 2018-05-17 · in A SQLite Tutorial with Node.js