Tag: sqlite

Posts tagged "sqlite"

#	Title	Date	Author
61	Geopoly in SQLite sqlite geopoly gis geojson database datasette spatial	2025-09-27	Online Source
60	SQLite BLOB literals TIL sqlite	2025-09-21	Online Source
59	Subqueries in select expressions in SQLite - also window functions TIL sqlite	2025-09-14	Online Source
58	Creating a minimal SpatiaLite database with Python spatialite sqlite python gis database geospatial	2025-08-31	Online Source
57	Identifying column combination patterns in a SQLite table TIL sqlite	2025-08-16	Farshid Ashouri
56	Finding the SQLite version used by Web SQL in Chrome sqlite chrome web-sql javascript browser debugging	2025-07-26	Farshid Ashouri
55	Compiling and running sqlite3-rsync sqlite compilation cli database synchronization wal	2025-07-12	Farshid Ashouri
54	--- python sqlite cli	2025-05-04	Online Source
53	Replicating SQLite with rqlite TIL sqlite	2025-05-03	Farshid Ashouri
52	Embedding paragraphs from my blog with E5-large-v2 llm embeddings ai nlp python cli sqlite postgresql data-analysis	2025-04-06	Online Source
51	Trying out SQLite extensions on macOS TIL sqlite	2025-02-23	Online Source
50	SQLite pragma_function_list() TIL sqlite	2025-01-18	Online Source
49	How to run MediaWiki with SQLite on a macOS laptop mediawiki sqlite macos php web-server datasette	2025-01-12	Online Source
48	Combining CTEs and VALUES in SQLite sqlite sql cte database	2024-12-29	Farshid Ashouri
47	Calculating the size of a SQLite database file using SQL sqlite sql database cli bash awk gpt-4	2024-12-28	Farshid Ashouri
46	Exporting Amplitude events to SQLite amplitude sqlite sqlite-utils data-export data-import cli json	2024-12-15	Farshid Ashouri
45	SQLite triggers TIL sqlite	2024-12-08	Online Source
44	GUnion to combine geometries in SpatiaLite spatialite sqlite gis geojson datasette sql geospatial	2024-11-09	Farshid Ashouri
43	Combining substr and instr to extract text sqlite sql string-manipulation database	2024-10-27	Farshid Ashouri
42	Importing CSV data into SQLite with .import TIL sqlite	2024-10-12	Farshid Ashouri
41	Lag window function in SQLite TIL sqlite	2024-10-06	Online Source
40	One-liner for running queries against CSV files with SQLite TIL sqlite	2024-10-06	Farshid Ashouri
39	Saving an in-memory SQLite database to a file in Python TIL sqlite	2024-09-15	Farshid Ashouri
38	How to read Hacker News threads with most recent comments first hacker-news api json datasette sqlite cli web-scraping	2024-09-07	Farshid Ashouri
37	Comparing database rows before and after with SQLite JSON functions sqlite sql json database data-analysis	2024-08-25	Online Source
36	The simplest recursive CTE TIL sqlite	2024-08-17	Farshid Ashouri
35	SQLite VACUUM: database or disk is full TIL sqlite	2024-07-20	Farshid Ashouri
34	Enabling WAL mode for SQLite database files sqlite database wal performance cli bash	2024-05-18	Farshid Ashouri
33	Sort by number of JSON intersections TIL sqlite	2024-05-05	Online Source
32	SQLite aggregate filter clauses TIL sqlite	2024-04-14	Farshid Ashouri
31	SQLite can use more than one index for a query TIL sqlite	2024-03-10	Farshid Ashouri
30	SQLite timestamps with floating point seconds TIL sqlite	2024-03-03	Farshid Ashouri
29	Querying for items stored in UTC that were created on a Thursday in PST TIL sqlite	2024-02-04	Farshid Ashouri
28	Export a Mastodon timeline to SQLite mastodon api sqlite sqlite-utils cli json pagination	2024-01-21	Online Source
27	Figuring out if a text value in SQLite is a valid integer or float sqlite sql data-types validation database	2024-01-21	Online Source
26	The SQLite now argument is stable within the same query TIL sqlite	2024-01-06	Online Source
25	Compile a new sqlite3 binary on Ubuntu sqlite ubuntu linux compilation cli database	2023-12-17	Farshid Ashouri
24	Splitting on commas in SQLite TIL sqlite	2023-12-10	Farshid Ashouri
23	Atuin for zsh shell history in SQLite zsh shell history sqlite atuin cli macos	2023-11-26	Online Source
22	Track timestamped changes to a SQLite table using triggers TIL sqlite	2023-10-28	Farshid Ashouri
21	Compile and run a new SQLite version with the existing sqlite3 Python library on macOS sqlite python macos compilation environment-variables cli datasette	2023-10-22	Online Source
20	Compiling the SQLite spellfix.c module on macOS sqlite compilation macos datasette extensions cli	2023-10-01	Farshid Ashouri
19	List all columns in a SQLite database TIL sqlite	2023-09-17	Farshid Ashouri
18	Null case comparisons in SQLite TIL sqlite	2023-09-17	Online Source
17	Copy tables between SQLite databases sqlite database cli bash data-transfer	2023-09-16	Online Source
16	Returning related rows in a single SQL query using JSON TIL sqlite	2023-08-20	Online Source
15	Counting SQLite virtual machine operations sqlite database performance cli python debugging	2023-08-13	Farshid Ashouri
14	Fixing broken text encodings with sqlite-transform and ftfy sqlite encoding data-cleaning python cli ftfy	2023-07-29	Online Source
13	Trying out cr-sqlite on macOS TIL sqlite	2023-07-15	Farshid Ashouri
12	Using LD_PRELOAD to run any version of SQLite with Python TIL sqlite	2023-07-01	Online Source
11	Deno KV deno deno-kv sqlite database key-value-store cloud serverless javascript typescript	2023-06-17	Farshid Ashouri
10	Loading SQLite extensions in Python on macOS TIL sqlite	2023-06-17	Farshid Ashouri
9	Consecutive groups in SQL using window functions sql window-functions database data-analysis sqlite	2023-05-28	Online Source
8	Finding the largest SQLite files on a Mac macos sqlite cli filesystem productivity	2023-05-28	Farshid Ashouri
7	Using pysqlite3 on macOS TIL sqlite	2023-05-06	Farshid Ashouri
6	Tracking SQLite table history using a JSON audit log TIL sqlite	2023-02-25	Online Source
5	Ordered group_concat() in SQLite TIL sqlite	2023-02-18	Farshid Ashouri
4	Building a specific version of SQLite with pysqlite on macOS/Linux sqlite python macos linux compilation pysqlite3 packaging	2023-02-11	Farshid Ashouri
3	Comparing two training datasets using sqlite-utils llm ai data-analysis sqlite sqlite-utils json cli huggingface	2023-01-28	Online Source
2	Browse files (including SQLite databases) on your iPhone with ifuse iphone macos sqlite cli debugging homebrew filesystem	2023-01-15	Farshid Ashouri
1	Unix timestamp in milliseconds in SQLite TIL sqlite	2023-01-08	Online Source