Discussion
Loading...

#Tag

  • About
  • Code of conduct
  • Privacy
  • Users
  • Instances
  • About Bonfire
Fedor Indutny
@indutny@mean.engineer  ·  activity timestamp 2 weeks ago

It is so cool that likely one of the fastest (especially compared to better-sqlite3) sqlite bindings for Node.js out there is the one we use for Signal Desktop client.

https://github.com/signalapp/node-sqlcipher

I should find motivation to upstream my ideas to back to Node.js core (JS level parameter binding and row parsing through a compiled function), but I’m… too lazy for that. Happy to explain how it all works to anyone interested, though!

#NodeJS#JavaScript #sqlite3

  • Copy link
  • Flag this post
  • Block
John Siracusa
tante
phildini
John Siracusa and 3 others boosted
JP Mens
@jpmens@mastodon.social  ·  activity timestamp last month

The things I learn, even at my age, simply by reading documentation are WILD!

Today: #SQLite3

"In addition to reading and writing SQLite database files, the sqlite3 program will also read and write ZIP archives."

https://sqlite.org/cli.html

I create a zip file with two files in it, load it in sqlite3, select the data from one of the files, DELETE the other from the "virtual zip table" and presto: file is gone.
I create a zip file with two files in it, load it in sqlite3, select the data from one of the files, DELETE the other from the "virtual zip table" and presto: file is gone.
I create a zip file with two files in it, load it in sqlite3, select the data from one of the files, DELETE the other from the "virtual zip table" and presto: file is gone.
  • Copy link
  • Flag this post
  • Block
JP Mens
@jpmens@mastodon.social  ·  activity timestamp last month

The things I learn, even at my age, simply by reading documentation are WILD!

Today: #SQLite3

"In addition to reading and writing SQLite database files, the sqlite3 program will also read and write ZIP archives."

https://sqlite.org/cli.html

I create a zip file with two files in it, load it in sqlite3, select the data from one of the files, DELETE the other from the "virtual zip table" and presto: file is gone.
I create a zip file with two files in it, load it in sqlite3, select the data from one of the files, DELETE the other from the "virtual zip table" and presto: file is gone.
I create a zip file with two files in it, load it in sqlite3, select the data from one of the files, DELETE the other from the "virtual zip table" and presto: file is gone.
  • Copy link
  • Flag this post
  • Block
Log in

bonfire.cafe

A space for Bonfire maintainers and contributors to communicate

bonfire.cafe: About · Code of conduct · Privacy · Users · Instances
Bonfire social · 1.0.0-rc.2.21 no JS en
Automatic federation enabled
  • Explore
  • About
  • Members
  • Code of Conduct
Home
Login