Just used SQLite3. Thanks SQLite3.
July 18, 2026 at 10:56 AM
Just used SQLite3. Thanks SQLite3.
Introducing sqlite3-ffi - a drop-in replacement for the sqlite3 gem for JRuby 🎉 Passes 99% of the sqlite3 test suite and works with Active Record without a custom adapter github.com/ankane/sqlit...
GitHub - ankane/sqlite3-ffi: A drop-in replacement for sqlite3 for JRuby
A drop-in replacement for sqlite3 for JRuby. Contribute to ankane/sqlite3-ffi development by creating an account on GitHub.
github.com
April 26, 2025 at 6:33 PM
Introducing sqlite3-ffi - a drop-in replacement for the sqlite3 gem for JRuby 🎉 Passes 99% of the sqlite3 test suite and works with Active Record without a custom adapter github.com/ankane/sqlit...
better-sqlite3 more like worse-sqlite3
November 3, 2024 at 3:13 AM
better-sqlite3 more like worse-sqlite3
I'm still writing code the hard way. I'm slow. I like to think critically about every line of code and fiddle with variable names until everything looks right. I treat code as a liability and try to ship only what's necessary.
It's hard to imagine writing code any other way.
It's hard to imagine writing code any other way.
February 1, 2026 at 2:52 AM
I'm still writing code the hard way. I'm slow. I like to think critically about every line of code and fiddle with variable names until everything looks right. I treat code as a liability and try to ship only what's necessary.
It's hard to imagine writing code any other way.
It's hard to imagine writing code any other way.
more like worse-sqlite3 amirite
February 8, 2025 at 3:01 PM
more like worse-sqlite3 amirite
more like worse-sqlite3 amirite
October 14, 2025 at 5:44 PM
more like worse-sqlite3 amirite
better-sqlite3 the biggest opp
February 8, 2025 at 2:46 PM
better-sqlite3 the biggest opp
sqlite3.OperationalError: database or disk is full
November 13, 2023 at 1:16 AM
sqlite3.OperationalError: database or disk is full
and, got an APK built!
Gottta like dig up the arm sqlite3 library and do a bit of other assorted housekeeping, but pretty close to Just Working
Gottta like dig up the arm sqlite3 library and do a bit of other assorted housekeeping, but pretty close to Just Working
January 12, 2026 at 3:12 AM
and, got an APK built!
Gottta like dig up the arm sqlite3 library and do a bit of other assorted housekeeping, but pretty close to Just Working
Gottta like dig up the arm sqlite3 library and do a bit of other assorted housekeeping, but pretty close to Just Working
Até você ter que instalar Ruby e sqlite3 is missing. Install SQLite3 from www.sqlite.org first.
*** extconf.rb failed ***
*** extconf.rb failed ***
O mundo de ciência de dados ter ido pro python foi um erro e eu posso provar!
Deveria ter ido pra ruby, isso sim. No ruby as coisas só funcionam. No python pqp, tudo é bizarro e estranho e não funciona. Eu era mais feliz com python só pra scripts rápidos.
Dito isso, django foi um erro maior ainda
Deveria ter ido pra ruby, isso sim. No ruby as coisas só funcionam. No python pqp, tudo é bizarro e estranho e não funciona. Eu era mais feliz com python só pra scripts rápidos.
Dito isso, django foi um erro maior ainda
October 1, 2024 at 7:06 PM
Até você ter que instalar Ruby e sqlite3 is missing. Install SQLite3 from www.sqlite.org first.
*** extconf.rb failed ***
*** extconf.rb failed ***
Fixing it requires some minor sqlite surgery but my code uses cutting-edge(ish) sqlite features that the sqlite3 binary shipping with ubuntu is not compatible with
April 29, 2025 at 12:34 PM
Fixing it requires some minor sqlite surgery but my code uses cutting-edge(ish) sqlite features that the sqlite3 binary shipping with ubuntu is not compatible with
i dropped it instead goodbye better-sqlite3!!!!!
tangled.org/mary.my.id/atc…
tangled.org/mary.my.id/atc…
February 28, 2026 at 1:53 PM
i dropped it instead goodbye better-sqlite3!!!!!
tangled.org/mary.my.id/atc…
tangled.org/mary.my.id/atc…
Hire me. I understand SQLite3, HDF5, and DCOM #OpenForHire
July 27, 2026 at 3:35 PM
Hire me. I understand SQLite3, HDF5, and DCOM #OpenForHire
Rubyists! sqlite3 gem v2.3.0 is released, introducing `Database#optimize`, some new compile-time features enabled, and an eight-year-old encoding bug fixed!
github.com/sparklemotio...
#ruby #sqlite
github.com/sparklemotio...
#ruby #sqlite
Release 2.3.0 / 2024-11-20 · sparklemotion/sqlite3-ruby
2.3.0 / 2024-11-20
Added
The SQLITE_DBPAGE extension is now enabled by default, which implements an eponymous-only virtual table that provides direct access to the underlying database file by inte...
github.com
November 21, 2024 at 2:15 PM
Rubyists! sqlite3 gem v2.3.0 is released, introducing `Database#optimize`, some new compile-time features enabled, and an eight-year-old encoding bug fixed!
github.com/sparklemotio...
#ruby #sqlite
github.com/sparklemotio...
#ruby #sqlite
how on earth do install better-sqlite3 on this machine holy shit
April 1, 2026 at 9:53 AM
how on earth do install better-sqlite3 on this machine holy shit
sqlite3 /pds/account.sqlite
update account set "emailConfirmedAt" = '2024-09-13T19:14:54.266Z' where did = 'did:plc:bnqkww7bjxaacajzvu5gswdf';
update account set "emailConfirmedAt" = '2024-09-13T19:14:54.266Z' where did = 'did:plc:bnqkww7bjxaacajzvu5gswdf';
September 13, 2024 at 7:17 PM
sqlite3 /pds/account.sqlite
update account set "emailConfirmedAt" = '2024-09-13T19:14:54.266Z' where did = 'did:plc:bnqkww7bjxaacajzvu5gswdf';
update account set "emailConfirmedAt" = '2024-09-13T19:14:54.266Z' where did = 'did:plc:bnqkww7bjxaacajzvu5gswdf';
if u could replace better-sqlite3 in the pds with bun's sqlite it would be sick
October 28, 2024 at 10:30 PM
if u could replace better-sqlite3 in the pds with bun's sqlite it would be sick
You were right, and it's 5 of 7 here. Campfire's TruffleRuby lane loads:
declared — puma, bcrypt, nio4r, json, openssl
not — sqlite3, nokogiri
sqlite3 is the hot one (a few hundred rows/request). --cexts-lock=false: 432 → 1,078 req/s at 5 threads
declared — puma, bcrypt, nio4r, json, openssl
not — sqlite3, nokogiri
sqlite3 is the hot one (a few hundred rows/request). --cexts-lock=false: 432 → 1,078 req/s at 5 threads
September 22, 2026 at 7:54 PM
You were right, and it's 5 of 7 here. Campfire's TruffleRuby lane loads:
declared — puma, bcrypt, nio4r, json, openssl
not — sqlite3, nokogiri
sqlite3 is the hot one (a few hundred rows/request). --cexts-lock=false: 432 → 1,078 req/s at 5 threads
declared — puma, bcrypt, nio4r, json, openssl
not — sqlite3, nokogiri
sqlite3 is the hot one (a few hundred rows/request). --cexts-lock=false: 432 → 1,078 req/s at 5 threads
Rubyists, if you're testing Ruby 3.4, please update to sqlite3 v2.5.0.rc1 which packages Ruby 3.4 in the native gems.
github.com/sparklemotio...
Let me know if you have problems!
#ruby #sqlite
github.com/sparklemotio...
Let me know if you have problems!
#ruby #sqlite
Release 2.5.0.rc1 / 2024-12-14 · sparklemotion/sqlite3-ruby
2.5.0.rc1 / 2024-12-14
Ruby
This release introduces native gem packages that include Ruby 3.4.
sha256 checksums
31412951ad83668927cb132fbe4835c3ccdb020f49301ad3c573fb9c3b4869da sqlite3-2.5.0.rc1-a...
github.com
December 14, 2024 at 7:34 PM
Rubyists, if you're testing Ruby 3.4, please update to sqlite3 v2.5.0.rc1 which packages Ruby 3.4 in the native gems.
github.com/sparklemotio...
Let me know if you have problems!
#ruby #sqlite
github.com/sparklemotio...
Let me know if you have problems!
#ruby #sqlite
sqlite3 new.db
sqlite3> .restore backup.sq3
sqlite3> .quit
i love sqlite
sqlite3> .restore backup.sq3
sqlite3> .quit
i love sqlite
September 22, 2025 at 5:04 PM
sqlite3 new.db
sqlite3> .restore backup.sq3
sqlite3> .quit
i love sqlite
sqlite3> .restore backup.sq3
sqlite3> .quit
i love sqlite
only three hard problems in computer science: cache invalidation, naming things, and better-sqlite3 being compiled for the wrong node version
the most advanced artificial intelligence yet devised by humanity:
the most advanced artificial intelligence yet devised by humanity:
July 1, 2026 at 8:27 PM
only three hard problems in computer science: cache invalidation, naming things, and better-sqlite3 being compiled for the wrong node version
the most advanced artificial intelligence yet devised by humanity:
the most advanced artificial intelligence yet devised by humanity: