Blog | Evan Schwartz
Subscribe via or add it on . {{ posts|tag:"best" }} {{ posts }}...| Evan Schwartz
Partial Indexes| sqlite.org
The SQLite Query Optimizer Overview| sqlite.org
I learned about creating composite indexes on multiple columns in a database, like first name, last name, and birthday, and how important the order is in these indexes. The rule is to use the index from left to right without skipping any columns, and it stops when it hits a range condition. By understanding these rules, we can optimize indexes for better query performance by placing common equality conditions at the beginning and range conditions at the end.| highperformancesqlite.com
Subscribe via or add it on . {{ posts|tag:"best" }} {{ posts }}...| Evan Schwartz
Vector embeddings by themselves are pretty neat. Binary quantized vector embeddings are extra impressive. In short, they can retain 95+% retrieval accuracy with 32x compression 🤯.| Evan Schwartz
