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...
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
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...
simonwillison.net/2025/Nov/4/d...
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...
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
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...
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...
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.
Doesn't prove that ChatGPT wrote it, but at least shows they used ChatGPT when researching.
![Screenshot from article that says:
A paragraph on page 29 also cites a fact to a 2024 Gothamist article, and includes the site where the source was generated: ChatGPT.
[23] https://gothamist.com/news/heres-what-nycs-mayoral-candidates-say-about-freezing-the-rent?
utm_source=chatgpt.com](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:fjqvlcfakpht4exffejyfc25/bafkreigo5lrrcbmxtetlxykg2hdjttxxf7zexatzhngtycojzxdjy5rkwe@jpeg)
April 15, 2025 at 12:32 AM
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.
Doesn't prove that ChatGPT wrote it, but at least shows they used ChatGPT when researching.
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)
(further evidence that the LA tech scene is elite)
Finally got around to publishing part two of my series on SQLite and RAG! Includes full code walkthrough and repo access. Definitely the simplest way to do RAG. Uses sqlite-vec. Thank @alexgarcia.xyz!
losangelesaiapps.com/retrieval-au...
losangelesaiapps.com/retrieval-au...
Retrieval Augmented Generation in SQLite
Can we really do RAG with a single-file architecture? An owl standing on some books. This is the second in a two-part series on using SQLite for machine learning. In my last article, I dove into how...
losangelesaiapps.com
February 18, 2025 at 8:51 PM
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)
(further evidence that the LA tech scene is elite)
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...
thescoop.org/archives/202...
LLM Extraction Challenge: Fundraising Emails – Derek Willis
Academic and journalist
thescoop.org
January 27, 2025 at 6:42 PM
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...
thescoop.org/archives/202...
Please merge my +321,000 line PR, it's only a few small changes 🥺
November 27, 2024 at 9:41 PM
Please merge my +321,000 line PR, it's only a few small changes 🥺
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! 🤯
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
let's goooo
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
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 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
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
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 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
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 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...
metadata filtering has been merged in sqlite-vec. Release coming soon!
November 20, 2024 at 9:02 AM
metadata filtering has been merged in sqlite-vec. Release coming soon!
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...
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
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...
Wednesday November 20th at 10am PST, in the
@mozilla.ai Discord
(will be recorded)
discord.gg/4ZMAgmrwqf?e...
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
Sqlite now with vector search! github.com/asg017/sqlit... courtesy of @alexgarcia.xyz