all AI news
stanchion
Jan. 31, 2024, 10:32 p.m. |
Simon Willison's Weblog simonwillison.net
Dan Gallagher's new (under-development) SQLite extension that adds column-oriented tables to SQLite, using a virtual table implemented in Zig that stores records in row groups, where each row group has multiple segments (one for each column) and those segments are stored as SQLite BLOBs.
I'm surprised that this is possible using the virtual table mechanism. It has the potential to bring some of the analytical querying performance we've seen in engines like DuckDB to SQLite itself.
Via Alex Garcia
column dan development extension multiple records sqlite table tables virtual
More from simonwillison.net / Simon Willison's Weblog
Fast groq-hosted LLMs vs browser jank
1 day, 4 hours ago |
simonwillison.net
AI counter app from my PyCon US keynote
2 days, 2 hours ago |
simonwillison.net
Understand errors and warnings better with Gemini
2 days, 20 hours ago |
simonwillison.net
Commit: Add a shared credentials relationship from twitter.com to x.com
2 days, 22 hours ago |
simonwillison.net
Jobs in AI, ML, Big Data
Software Engineer for AI Training Data (School Specific)
@ G2i Inc | Remote
Software Engineer for AI Training Data (Python)
@ G2i Inc | Remote
Software Engineer for AI Training Data (Tier 2)
@ G2i Inc | Remote
Data Engineer
@ Lemon.io | Remote: Europe, LATAM, Canada, UK, Asia, Oceania
Artificial Intelligence – Bioinformatic Expert
@ University of Texas Medical Branch | Galveston, TX
Lead Developer (AI)
@ Cere Network | San Francisco, US