Files

 main

/

sqlite

/

Copy path

Directory actions

More options

Directory actions

More options

Latest commit

simonw

Better link to triggers.py

May 10, 2025

50aca75 · May 10, 2025

History

History

/

sqlite

/

Top

Folders and files

Name		Name	Last commit message	Last commit date
parent directory ..
blob-literals.md		blob-literals.md	Update blob-literals.md	Jul 29, 2020
build-specific-sqlite-pysqlite-macos.md		build-specific-sqlite-pysqlite-macos.md	Works on Linux too	Aug 15, 2021
column-combinations.md		column-combinations.md	Demo datasette-query-links	Mar 21, 2022
compare-before-after-json.md		compare-before-after-json.md	Comparing database rows before and after with SQLite JSON functions	Dec 14, 2022
comparing-datasets.md		comparing-datasets.md	Comparing two training datasets using sqlite-utils	May 23, 2023
compile-spellfix-osx.md		compile-spellfix-osx.md	Compiling the SQLite spellfix.c module on macOS	Sep 19, 2020
compile-sqlite3-rsync.md		compile-sqlite3-rsync.md	It's make sqlite3-rsync	Oct 6, 2024
compile-sqlite3-ubuntu.md		compile-sqlite3-ubuntu.md	Typo	Sep 2, 2020
copy-tables-between-databases.md		copy-tables-between-databases.md	Explain the UPDATE line	Apr 3, 2023
counting-vm-ops.md		counting-vm-ops.md	Counting SQLite virtual machine operations	Mar 21, 2022
cr-sqlite-macos.md		cr-sqlite-macos.md	Explained with a villainous twist	Sep 13, 2023
cte-values.md		cte-values.md	Typo	Feb 3, 2023
database-file-size.md		database-file-size.md	Calculating the size of a SQLite database file using SQL	Aug 21, 2023
enabling-wal-mode.md		enabling-wal-mode.md	typo (#57)	Oct 27, 2023
fixing-column-encoding-with-ftfy-and-sqlite-transform.md		fixing-column-encoding-with-ftfy-and-sqlite-transform.md	bash syntax highlighting in a few places	Jan 19, 2021
floating-point-seconds.md		floating-point-seconds.md	SQLite timestamps with floating point seconds	Mar 14, 2024
function-list.md		function-list.md	Typo: beacuse -> because	Aug 24, 2022
geopoly.md		geopoly.md	Geopoly in SQLite	Jan 4, 2023
import-csv.md		import-csv.md	Importing CSV data into SQLite with .import	Jul 14, 2021
json-audit-log.md		json-audit-log.md	Fix horizontal scrollbar on Mobile Safari	Feb 27, 2024
json-extract-path.md		json-extract-path.md	Update json-extract-path.md	Sep 20, 2022
lag-window-function.md		lag-window-function.md	Create lag-window-function.md	Apr 19, 2020
ld-preload.md		ld-preload.md	Running Datasette tests, extra CPP flags	Mar 5, 2022
list-all-columns-in-a-database.md		list-all-columns-in-a-database.md	More functions this works with	Dec 18, 2020
multiple-indexes.md		multiple-indexes.md	Fixed broken link	Dec 12, 2022
now-argument-stability.md		now-argument-stability.md	The SQLite now argument is stable within the same query	Feb 5, 2023
null-case.md		null-case.md	Update null-case.md	Apr 22, 2020
one-line-csv-operations.md		one-line-csv-operations.md	import -csv	Jun 22, 2022
ordered-group-concat.md		ordered-group-concat.md	Typo	Jun 21, 2022
pragma-function-list.md		pragma-function-list.md	As a SQL view to support facets	Mar 20, 2024
pysqlite3-on-macos.md		pysqlite3-on-macos.md	Using pysqlite3 on macOS	Jul 10, 2021
python-sqlite-environment.md		python-sqlite-environment.md	A one-liner to output details of the current Python's SQLite	Aug 19, 2023
python-sqlite-memory-to-file.md		python-sqlite-memory-to-file.md	Saving an in-memory SQLite database to a file in Python	Apr 9, 2023
related-content.md		related-content.md	Link to new approach	Aug 15, 2023
related-rows-single-query.md		related-rows-single-query.md	Removed accidental character	Sep 16, 2022
replicating-rqlite.md		replicating-rqlite.md	I wrote rqlite, not Raft. :-) (#35)	Dec 28, 2020
simple-recursive-cte.md		simple-recursive-cte.md	Removed rogue ```	Mar 25, 2022
sort-by-number-of-json-intersections.md		sort-by-number-of-json-intersections.md	Copilot animation	Aug 17, 2022
splitting-commas-sqlite.md		splitting-commas-sqlite.md	Splitting on commas in SQLite	Feb 1, 2021
sqlite-aggregate-filter-clauses.md		sqlite-aggregate-filter-clauses.md	As of 3.30.0	Aug 13, 2021
sqlite-extensions-python-macos.md		sqlite-extensions-python-macos.md	Loading SQLite extensions in Python on macOS	Jan 8, 2023
sqlite-tg.md		sqlite-tg.md	Update sqlite-tg.md	Sep 26, 2023
sqlite-triggers.md		sqlite-triggers.md	Better link to triggers.py	May 10, 2025
sqlite-vec.md		sqlite-vec.md	Update link to code	Aug 11, 2024
sqlite-version-macos-python.md		sqlite-version-macos-python.md	Note about Homebrew python	Jan 16, 2024
sqlite-version-websql-chrome.md		sqlite-version-websql-chrome.md	Finding the SQLite version used by Web SQL in Chrome	Oct 28, 2022
steampipe.md		steampipe.md	More interesting example SQL query	Dec 21, 2023
subqueries-in-select.md		subqueries-in-select.md	Simplified to use just one window function	Feb 9, 2023
substr-instr.md		substr-instr.md	Combining substr and instr to extract text	Feb 16, 2022
text-value-is-integer-or-float.md		text-value-is-integer-or-float.md	Updated some links	Dec 29, 2020
track-timestamped-changes-to-a-table.md		track-timestamped-changes-to-a-table.md	Initializing for a new table	Aug 19, 2021
triggers.py		triggers.py	SQLite triggers	May 10, 2025
trying-macos-extensions.md		trying-macos-extensions.md	Fix key/keg typo (#59)	Oct 27, 2023
unix-timestamp-milliseconds-sqlite.md		unix-timestamp-milliseconds-sqlite.md	SQLite 3.42.0 milliseconds solution	May 18, 2023
utc-items-on-thursday-in-pst.md		utc-items-on-thursday-in-pst.md	Querying for items stored in UTC that were created on a Thursday in PST	Mar 13, 2021
vacum-disk-full.md		vacum-disk-full.md	SQLite VACUUM: database or disk is full	Aug 29, 2022
View all files