Alex Garcia
alexgarcia.xyz
Alex Garcia
@alexgarcia.xyz
software engineer alexgarcia.xyz
Reposted by Alex Garcia
Datasette 1.0a20 is out, with an entirely new SQL-powered permissions system. This is by far the most ambitious project I've attempted with the help of coding agents (Claude Code and Codex CLI) - notes on how it works and what I learned along the way:
simonwillison.net/2025/Nov/4/d...
A new SQL-powered permissions system in Datasette 1.0a20
Datasette 1.0a20 is out with the biggest breaking API change on the road to 1.0, improving how Datasette’s permissions system works by migrating permission logic to SQL running in SQLite. …
simonwillison.net
November 4, 2025 at 9:36 PM
New blog post: I've been working on a new parser for the Federal Election Commission's custom `.fec` file format.

Written in Rust, completely open source, and the fastest FEC file parser out there.

If you ever work with federal campaign finance data, check it out!

alexgarcia.xyz/blog/2025/in...
I'm working on libfec, a new FEC file parser and CLI tool
Parse federal campaign filings
alexgarcia.xyz
October 14, 2025 at 4:18 PM
Love this approach for seeing if ChatGPT is used in a document: See if `utm_source=chatgpt.com` appears in any URLs.

Doesn't prove that ChatGPT wrote it, but at least shows they used ChatGPT when researching.
April 15, 2025 at 12:32 AM
Great guide here by Ed for using sqlite-vec + OpenAI embeddings in a RAG system! Includes great use of the new auxiliary columns feature for storing metadata

(further evidence that the LA tech scene is elite)
February 18, 2025 at 8:51 PM
Reposted by Alex Garcia
NEW BLOG POST: Been testing out 20 LLMs at extracting data from political fundraising emails. See the process and results here:

thescoop.org/archives/202...
LLM Extraction Challenge: Fundraising Emails – Derek Willis
Academic and journalist
thescoop.org
January 27, 2025 at 6:42 PM
Please merge my +321,000 line PR, it's only a few small changes 🥺
November 27, 2024 at 9:41 PM
let's goooo
# 2024-11-22
SQLite is all you need! Big sqlite-vec update! 🚀 sqlite-vec is a plugin to support Vector Search in SQLite or LibSQL databases. v0.1.6 now allows storing non-vector data in vec0 virtual tables, enabling metadata conditioning and filtering! 🤯
November 22, 2024 at 5:14 PM
Reposted by Alex Garcia
If you're interested in embeddings and SQLite you should be paying attention to sqlite-vec

Lots of neat stuff in this release - and the blog post provides a very clear explanation of what it can do
sqlite-vec v0.1.6 is now out, with metadata support!

SQLite vector search w/ metadata filters 👀

- Perform extra filtering w/ WHERE clause in KNN queries
- Internally shard vector indexes with partition keys
- Aux columns for easy lookups

read more: alexgarcia.xyz/blog/2024/sq...
sqlite-vec now supports metadata columns and filtering
Metadata, partition key, and auxiliary column support in sqlite-vec
alexgarcia.xyz
November 20, 2024 at 5:53 PM
sqlite-vec v0.1.6 is now out, with metadata support!

SQLite vector search w/ metadata filters 👀

- Perform extra filtering w/ WHERE clause in KNN queries
- Internally shard vector indexes with partition keys
- Aux columns for easy lookups

read more: alexgarcia.xyz/blog/2024/sq...
sqlite-vec now supports metadata columns and filtering
Metadata, partition key, and auxiliary column support in sqlite-vec
alexgarcia.xyz
November 20, 2024 at 4:48 PM
metadata filtering has been merged in sqlite-vec. Release coming soon!
November 20, 2024 at 9:02 AM
Next week I'll be hosting a sqlite-vec online event about metadata filtering, which is coming VERY soon — come through!

Wednesday November 20th at 10am PST, in the
@mozilla.ai Discord

(will be recorded)

discord.gg/4ZMAgmrwqf?e...
Join the Mozilla AI Discord Server!
A global space for sharing and advancing open-source AI. | 3420 members
discord.gg
November 15, 2024 at 7:51 PM
Reposted by Alex Garcia
Sqlite now with vector search! github.com/asg017/sqlit... courtesy of @alexgarcia.xyz
github.com
November 2, 2024 at 2:45 PM