sqlite_drv 0.44.2 [new]
An Elixir SQLite3 library. Fork of exqlite adding preupdate and commit hooks.
Licenses: MIT
An Elixir SQLite3 library. Fork of exqlite adding preupdate and commit hooks.
Licenses: MIT
November 7, 2026 at 4:45 AM
sqlite_drv 0.44.2 [new]
An Elixir SQLite3 library. Fork of exqlite adding preupdate and commit hooks.
Licenses: MIT
An Elixir SQLite3 library. Fork of exqlite adding preupdate and commit hooks.
Licenses: MIT
📦 dolthub/doltlite-php 0.51.10
DoltLite for PHP: SQLite with Git-style version control (branch, commit, merge, diff), bound over FFI with the SQLite3-class API shape.
🔗 https://github.com/dolthub/doltlite-php
DoltLite for PHP: SQLite with Git-style version control (branch, commit, merge, diff), bound over FFI with the SQLite3-class API shape.
🔗 https://github.com/dolthub/doltlite-php
November 8, 2026 at 8:12 PM
📦 dolthub/doltlite-php 0.51.10
DoltLite for PHP: SQLite with Git-style version control (branch, commit, merge, diff), bound over FFI with the SQLite3-class API shape.
🔗 https://github.com/dolthub/doltlite-php
DoltLite for PHP: SQLite with Git-style version control (branch, commit, merge, diff), bound over FFI with the SQLite3-class API shape.
🔗 https://github.com/dolthub/doltlite-php
CVE-2024-0232 MEDIUM (CVSS 4.7)
A heap use-after-free issue has been identified in SQLite in the jsonParseAddNodeArray() function in sqlite3.c
Fix: https://patchthecve.com/cve/CVE-2024-0232.html
A heap use-after-free issue has been identified in SQLite in the jsonParseAddNodeArray() function in sqlite3.c
Fix: https://patchthecve.com/cve/CVE-2024-0232.html
November 6, 2026 at 2:38 PM
CVE-2024-0232 MEDIUM (CVSS 4.7)
A heap use-after-free issue has been identified in SQLite in the jsonParseAddNodeArray() function in sqlite3.c
Fix: https://patchthecve.com/cve/CVE-2024-0232.html
A heap use-after-free issue has been identified in SQLite in the jsonParseAddNodeArray() function in sqlite3.c
Fix: https://patchthecve.com/cve/CVE-2024-0232.html
sqlite3と仲良くなろうとしているところです。
November 3, 2026 at 6:42 PM
sqlite3と仲良くなろうとしているところです。
Free SQLite backup tip: `sqlite3 app.db '.backup backup.db'` uses SQLite's online backup mechanism instead of blindly copying a live database file. Test restoring the backup before trusting it. It is not a substitute for off-host retention or a recovery plan.
November 7, 2026 at 4:35 PM
Free SQLite backup tip: `sqlite3 app.db '.backup backup.db'` uses SQLite's online backup mechanism instead of blindly copying a live database file. Test restoring the backup before trusting it. It is not a substitute for off-host retention or a recovery plan.
📦 dolthub/doltlite-php 0.51.9
DoltLite for PHP: SQLite with Git-style version control (branch, commit, merge, diff), bound over FFI with the SQLite3-class API shape.
🔗 https://github.com/dolthub/doltlite-php
DoltLite for PHP: SQLite with Git-style version control (branch, commit, merge, diff), bound over FFI with the SQLite3-class API shape.
🔗 https://github.com/dolthub/doltlite-php
November 5, 2026 at 6:17 PM
📦 dolthub/doltlite-php 0.51.9
DoltLite for PHP: SQLite with Git-style version control (branch, commit, merge, diff), bound over FFI with the SQLite3-class API shape.
🔗 https://github.com/dolthub/doltlite-php
DoltLite for PHP: SQLite with Git-style version control (branch, commit, merge, diff), bound over FFI with the SQLite3-class API shape.
🔗 https://github.com/dolthub/doltlite-php
An indexing step catalogues my collection and populates a SQLite3 db. A simple web based UI lets me browse everything (with all sorts of filters) or search. I can zoom in/out, play music/sound files, and save asset packs or individual assets for later, to build up my own curated collection.
November 7, 2026 at 5:12 AM
An indexing step catalogues my collection and populates a SQLite3 db. A simple web based UI lets me browse everything (with all sorts of filters) or search. I can zoom in/out, play music/sound files, and save asset packs or individual assets for later, to build up my own curated collection.
📦 dolthub/doltlite-php 0.51.8
DoltLite for PHP: SQLite with Git-style version control (branch, commit, merge, diff), bound over FFI with the SQLite3-class API shape.
🔗 https://github.com/dolthub/doltlite-php
DoltLite for PHP: SQLite with Git-style version control (branch, commit, merge, diff), bound over FFI with the SQLite3-class API shape.
🔗 https://github.com/dolthub/doltlite-php
November 4, 2026 at 11:59 PM
📦 dolthub/doltlite-php 0.51.8
DoltLite for PHP: SQLite with Git-style version control (branch, commit, merge, diff), bound over FFI with the SQLite3-class API shape.
🔗 https://github.com/dolthub/doltlite-php
DoltLite for PHP: SQLite with Git-style version control (branch, commit, merge, diff), bound over FFI with the SQLite3-class API shape.
🔗 https://github.com/dolthub/doltlite-php
db=sqlite3.connect(f'file:{B}/flow.sqlite?mode=ro',uri=True)
rows=db.execute("select id,title,createdAt,summary,notes,participantNames,speakerAssignments,speakerMap from Meetings where isDeleted=0 and isTourDemo=0 order by createdAt").fetchall()
rows=db.execute("select id,title,createdAt,summary,notes,participantNames,speakerAssignments,speakerMap from Meetings where isDeleted=0 and isTourDemo=0 order by createdAt").fetchall()
November 2, 2026 at 7:54 PM
db=sqlite3.connect(f'file:{B}/flow.sqlite?mode=ro',uri=True)
rows=db.execute("select id,title,createdAt,summary,notes,participantNames,speakerAssignments,speakerMap from Meetings where isDeleted=0 and isTourDemo=0 order by createdAt").fetchall()
rows=db.execute("select id,title,createdAt,summary,notes,participantNames,speakerAssignments,speakerMap from Meetings where isDeleted=0 and isTourDemo=0 order by createdAt").fetchall()
python3 - <<'EOF'
import json,re,sqlite3,pathlib
exec("def J(x):\n try: return json.loads(x)\n except Exception: return None")
B=pathlib.Path.home()/'Library/Application Support/Wispr Flow'
O=pathlib.Path.home()/'Desktop/wispr-export'
O.mkdir(parents=True,exist_ok=True)
import json,re,sqlite3,pathlib
exec("def J(x):\n try: return json.loads(x)\n except Exception: return None")
B=pathlib.Path.home()/'Library/Application Support/Wispr Flow'
O=pathlib.Path.home()/'Desktop/wispr-export'
O.mkdir(parents=True,exist_ok=True)
November 2, 2026 at 7:54 PM
python3 - <<'EOF'
import json,re,sqlite3,pathlib
exec("def J(x):\n try: return json.loads(x)\n except Exception: return None")
B=pathlib.Path.home()/'Library/Application Support/Wispr Flow'
O=pathlib.Path.home()/'Desktop/wispr-export'
O.mkdir(parents=True,exist_ok=True)
import json,re,sqlite3,pathlib
exec("def J(x):\n try: return json.loads(x)\n except Exception: return None")
B=pathlib.Path.home()/'Library/Application Support/Wispr Flow'
O=pathlib.Path.home()/'Desktop/wispr-export'
O.mkdir(parents=True,exist_ok=True)
📦 dolthub/doltlite-php 0.51.6
DoltLite for PHP: SQLite with Git-style version control (branch, commit, merge, diff), bound over FFI with the SQLite3-class API shape.
🔗 https://github.com/dolthub/doltlite-php
DoltLite for PHP: SQLite with Git-style version control (branch, commit, merge, diff), bound over FFI with the SQLite3-class API shape.
🔗 https://github.com/dolthub/doltlite-php
November 1, 2026 at 6:14 PM
📦 dolthub/doltlite-php 0.51.6
DoltLite for PHP: SQLite with Git-style version control (branch, commit, merge, diff), bound over FFI with the SQLite3-class API shape.
🔗 https://github.com/dolthub/doltlite-php
DoltLite for PHP: SQLite with Git-style version control (branch, commit, merge, diff), bound over FFI with the SQLite3-class API shape.
🔗 https://github.com/dolthub/doltlite-php
📦 black-rainbow-labs/inillucent v2.10.0
Embedded SQL database with full-text and vector search, a sqlite3-shaped shell, and an MCP server.
🔗 https://github.com/Black-Rainbow-Labs/Inillucent
Embedded SQL database with full-text and vector search, a sqlite3-shaped shell, and an MCP server.
🔗 https://github.com/Black-Rainbow-Labs/Inillucent
November 1, 2026 at 10:59 AM
📦 black-rainbow-labs/inillucent v2.10.0
Embedded SQL database with full-text and vector search, a sqlite3-shaped shell, and an MCP server.
🔗 https://github.com/Black-Rainbow-Labs/Inillucent
Embedded SQL database with full-text and vector search, a sqlite3-shaped shell, and an MCP server.
🔗 https://github.com/Black-Rainbow-Labs/Inillucent
A little wardriving on the way to Minneapolis
October 30, 2026 at 2:32 PM
A little wardriving on the way to Minneapolis
📦 black-rainbow-labs/inillucent v2.9.0
Embedded SQL database with full-text and vector search, a sqlite3-shaped shell, and an MCP server.
🔗 https://github.com/Black-Rainbow-Labs/Inillucent
Embedded SQL database with full-text and vector search, a sqlite3-shaped shell, and an MCP server.
🔗 https://github.com/Black-Rainbow-Labs/Inillucent
October 30, 2026 at 5:59 PM
📦 black-rainbow-labs/inillucent v2.9.0
Embedded SQL database with full-text and vector search, a sqlite3-shaped shell, and an MCP server.
🔗 https://github.com/Black-Rainbow-Labs/Inillucent
Embedded SQL database with full-text and vector search, a sqlite3-shaped shell, and an MCP server.
🔗 https://github.com/Black-Rainbow-Labs/Inillucent
🚨 EUVD-2026-113918
📊 n/a
📝 CallBackery versions before 0.62.0 for Perl allow OS command execution via sqlite3 shell commands in a restored configuration backup.
restoreConfigBlob() feeds the ...
🔗 https://euvd.enisa.europa.eu/vulnerability/EUVD-2026-113918
#cybersecurity #infosec #cve #euvd
📊 n/a
📝 CallBackery versions before 0.62.0 for Perl allow OS command execution via sqlite3 shell commands in a restored configuration backup.
restoreConfigBlob() feeds the ...
🔗 https://euvd.enisa.europa.eu/vulnerability/EUVD-2026-113918
#cybersecurity #infosec #cve #euvd
October 30, 2026 at 3:04 PM
🚨 EUVD-2026-113918
📊 n/a
📝 CallBackery versions before 0.62.0 for Perl allow OS command execution via sqlite3 shell commands in a restored configuration backup.
restoreConfigBlob() feeds the ...
🔗 https://euvd.enisa.europa.eu/vulnerability/EUVD-2026-113918
#cybersecurity #infosec #cve #euvd
📊 n/a
📝 CallBackery versions before 0.62.0 for Perl allow OS command execution via sqlite3 shell commands in a restored configuration backup.
restoreConfigBlob() feeds the ...
🔗 https://euvd.enisa.europa.eu/vulnerability/EUVD-2026-113918
#cybersecurity #infosec #cve #euvd
Practice SQL in the browser: no Docker, autocomplete, AI, or "which Database version,".
https://jeffbailey.us/blog/2026/10/22/learn-sql/
#SQL #Databases #SoftwareEngineering
https://jeffbailey.us/blog/2026/10/22/learn-sql/
#SQL #Databases #SoftwareEngineering
Learn SQL: Queries, Joins, Aggregates, and Query Plans
Learn SQL with sqlite3: filter, join, group, and rank rows, read a query in execution order, and use EXPLAIN to find out why a query is slow.
jeffbailey.us
October 31, 2026 at 12:20 AM
Practice SQL in the browser: no Docker, autocomplete, AI, or "which Database version,".
https://jeffbailey.us/blog/2026/10/22/learn-sql/
#SQL #Databases #SoftwareEngineering
https://jeffbailey.us/blog/2026/10/22/learn-sql/
#SQL #Databases #SoftwareEngineering
📦 dolthub/doltlite-php 0.51.5
DoltLite for PHP: SQLite with Git-style version control (branch, commit, merge, diff), bound over FFI with the SQLite3-class API shape.
🔗 https://github.com/dolthub/doltlite-php
DoltLite for PHP: SQLite with Git-style version control (branch, commit, merge, diff), bound over FFI with the SQLite3-class API shape.
🔗 https://github.com/dolthub/doltlite-php
October 29, 2026 at 9:14 PM
📦 dolthub/doltlite-php 0.51.5
DoltLite for PHP: SQLite with Git-style version control (branch, commit, merge, diff), bound over FFI with the SQLite3-class API shape.
🔗 https://github.com/dolthub/doltlite-php
DoltLite for PHP: SQLite with Git-style version control (branch, commit, merge, diff), bound over FFI with the SQLite3-class API shape.
🔗 https://github.com/dolthub/doltlite-php
This is in ToyBox, which should get mirrored to github in about two hours: github.com/krgamestudio...
GitHub - krgamestudios/ToyBox: A test game for The Toy Scripting Langauge. Requires raylib, sqlite3 and Toy. Mirrored nightly.
A test game for The Toy Scripting Langauge. Requires raylib, sqlite3 and Toy. Mirrored nightly. - krgamestudios/ToyBox
github.com
October 28, 2026 at 10:54 AM
This is in ToyBox, which should get mirrored to github in about two hours: github.com/krgamestudio...
HIGH severity: CallBackery <0.62.0 exposes sensitive config dumps in /tmp — world-readable, exploitable via symlink. Upgrade to 0.62.0+ to secure credentials. https://radar.offseq.com/threat/cve-2026-118990-cwe-379-creation-of-temporary-file-in-directory-with-insecure-permissions-in-1f67aa1816ead...
CVE-2026-118990: CWE-379 Creation of Temporary File in Directory with Insecure P
CallBackery before version 0.62.0 has a vulnerability (CWE-379) where the getConfigBlob() function uses the sqlite3 shell to write a configuration database dump to a predictable temporary file in /tmp (named cbdump<pid>). This file is creat
radar.offseq.com
October 30, 2026 at 1:30 PM
HIGH severity: CallBackery <0.62.0 exposes sensitive config dumps in /tmp — world-readable, exploitable via symlink. Upgrade to 0.62.0+ to secure credentials. https://radar.offseq.com/threat/cve-2026-118990-cwe-379-creation-of-temporary-file-in-directory-with-insecure-permissions-in-1f67aa1816ead...
With _txlock=immediate in the DSN, mattn/go-sqlite3 sends BEGIN IMMEDIATE for every transaction, read-only ones included. modernc.org/sqlite sends a plain BEGIN when you pass sql.TxOptions{ReadOnly: true}, so reads don't queue behind writers.
October 27, 2026 at 6:38 AM
With _txlock=immediate in the DSN, mattn/go-sqlite3 sends BEGIN IMMEDIATE for every transaction, read-only ones included. modernc.org/sqlite sends a plain BEGIN when you pass sql.TxOptions{ReadOnly: true}, so reads don't queue behind writers.
Plain Node.js (I wrote my own mini router, not Express) plus better-sqlite3, in a Docker Compose stack. A separate watchdog container restarts the core if it crashes. The '24/7' part is just an internal timer loop running scheduled jobs, not an external queue or cron service.
October 27, 2026 at 6:30 AM
Plain Node.js (I wrote my own mini router, not Express) plus better-sqlite3, in a Docker Compose stack. A separate watchdog container restarts the core if it crashes. The '24/7' part is just an internal timer loop running scheduled jobs, not an external queue or cron service.
Lean and mean. `better-sqlite3` is elite for state. Internal loops are great for simplicity—if logic grows, consider `worker_threads` to keep the timer decoupled. Solid way to prove the movement before adding the weight of a heavy queue.
October 27, 2026 at 12:57 PM
Lean and mean. `better-sqlite3` is elite for state. Internal loops are great for simplicity—if logic grows, consider `worker_threads` to keep the timer decoupled. Solid way to prove the movement before adding the weight of a heavy queue.
SQLite's busy timeout defaults differ by driver: modernc.org/sqlite v1.61.0 leaves it at 0, so a second writer fails within 1 ms. mattn/go-sqlite3 and rusqlite set 5000 ms. Set _busy_timeout in the DSN rather than relying on the default.
October 27, 2026 at 3:35 AM
SQLite's busy timeout defaults differ by driver: modernc.org/sqlite v1.61.0 leaves it at 0, so a second writer fails within 1 ms. mattn/go-sqlite3 and rusqlite set 5000 ms. Set _busy_timeout in the DSN rather than relying on the default.
Zealというオフラインでドキュメントを読むためのソフトウェアを利用していると書いたことがあります。ただしターミナルで使うためにdashtも使っているとも書いた。
実は、dashtではZealでダウンロードしてきたdocsetをそのままは表示できないことが多々あります。独自のやり方で圧縮しているからです。
doctsetは非常にシンプルで、docSet.dsidx というSQLIte3データベースに searchIndexというテーブルがあり、キーワードとドキュメントの存在するファイルパスが関連づけられています。
実は、dashtではZealでダウンロードしてきたdocsetをそのままは表示できないことが多々あります。独自のやり方で圧縮しているからです。
doctsetは非常にシンプルで、docSet.dsidx というSQLIte3データベースに searchIndexというテーブルがあり、キーワードとドキュメントの存在するファイルパスが関連づけられています。
October 28, 2026 at 1:41 AM
Zealというオフラインでドキュメントを読むためのソフトウェアを利用していると書いたことがあります。ただしターミナルで使うためにdashtも使っているとも書いた。
実は、dashtではZealでダウンロードしてきたdocsetをそのままは表示できないことが多々あります。独自のやり方で圧縮しているからです。
doctsetは非常にシンプルで、docSet.dsidx というSQLIte3データベースに searchIndexというテーブルがあり、キーワードとドキュメントの存在するファイルパスが関連づけられています。
実は、dashtではZealでダウンロードしてきたdocsetをそのままは表示できないことが多々あります。独自のやり方で圧縮しているからです。
doctsetは非常にシンプルで、docSet.dsidx というSQLIte3データベースに searchIndexというテーブルがあり、キーワードとドキュメントの存在するファイルパスが関連づけられています。