Alex Garcia (@agarcia_me) 's Twitter Profile
Alex Garcia

@agarcia_me

software engineer who likes data a lot, open for freelancing! • he/him/his

ID: 3222061490

linkhttps://alexgarcia.xyz calendar_today21-05-2015 07:24:48

1,1K Tweet

1,1K Followers

1,1K Following

Alex Garcia (@agarcia_me) 's Twitter Profile Photo

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/sqli…

Philipp Schmid (@_philschmid) 's Twitter Profile Photo

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! 🤯 TL;DR: 💡 Store metadata like

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! 🤯

TL;DR:
💡 Store metadata like
Alex Garcia (@agarcia_me) 's Twitter Profile Photo

I'll be giving a talk about sqlite-vec this Saturday 7:30am PST in the Bengaluru Discord, come through! Will go into all-in on sqlite-vec, how it works, how SQLite extensions are built, and cool upcoming projects/features of sqlite-vec 💯

Alex Garcia (@agarcia_me) 's Twitter Profile Photo

I gave a 1hr talk about sqlite-vec to the Bengaluru System Meetup folks over the weekend, check it out! Explains vector search, embeddings, databases, sqlite-vec features, and virtual tables in SQLite! youtube.com/watch?v=GpTOsT…

Alex Garcia (@agarcia_me) 's Twitter Profile Photo

To be clear: Not all SQLite tests are proprietary. The separate and extremely comprehensive TH3 test suite is closed-source and requires a license. Fun fact: no-one has every bought the TCH SQLite license, according to Hipp in a podcast a few yrs ago sqlite.org/testing.html

Alex Garcia (@agarcia_me) 's Twitter Profile Photo

I talked with Nicolay on the "How AI is Built" podcast about sqlite-vec, check it out! Matryoshka vs binary quantization, using llama.cpp for on-device embeddings inference, and more!

Alex Garcia (@agarcia_me) 's Twitter Profile Photo

If you ask applications developers if SQL columns should have strict types, of course they'll say yes! Tho flexible types are super useful in many data analysis projects, especially w/ messy data (Excel, untyped CSVs, etc) But what should be default? Probably strict tbh

Alex Garcia (@agarcia_me) 's Twitter Profile Photo

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)

Alex Garcia (@agarcia_me) 's Twitter Profile Photo

node:sqlite is now available in Deno! Though no extension support yet, which the "real" node.js node:sqlite has: nodejs.org/api/sqlite.htm…

Mements | Agents made Easy (@mementsofficial) 's Twitter Profile Photo

smart cross-chain wallet with instant preview of user intention, next gen UX much better than "chat wallets". inspired by Ronith's dynamic prompt field and built on our Sati Agentic Framework with embedded vector database based on Alex Garcia's sqlite-vec extension.

smart cross-chain wallet with instant preview of user intention, next gen UX much better than "chat wallets".

inspired by <a href="/ronithhh/">Ronith</a>'s dynamic prompt field and built on our Sati Agentic Framework with embedded vector database based on <a href="/agarcia_me/">Alex Garcia</a>'s sqlite-vec extension.