Ibis: Write Once, Query 22+ SQL Databases
Plus auto-update LLM memory with mem0
Grab your coffee. Here are this week’s highlights.
📅 Today’s Picks
mem0: Auto-Update LLM Memory When Facts Change
Problem
Developers commonly store conversation embeddings in ChromaDB or Pinecone, then retrieve similar chunks before each LLM response.
But these systems do not handle changing information. When facts evolve, they simply accumulate, leaving your AI with conflicting context and no way to resolve it.
Solution
mem0 introduces a smarter memory layer. It identifies contradictions, updates existing knowledge, and ensures only the latest facts are retained.
Key capabilities:
Extracts structured facts directly from raw conversations
Conflict resolution that replaces outdated facts instead of duplicating them
Memory isolation across users, sessions, and agents
Retrieves context semantically, not just by similarity
Ibis: Write Once, Query 22+ SQL Databases
Problem
Running queries across multiple databases often means rewriting the same logic for each backend’s SQL dialect. A query that works in DuckDB may require syntax changes for PostgreSQL, and another rewrite for BigQuery.
Solution
Ibis removes that friction by compiling Python expressions into each backend’s native SQL. Swap the connection, and the same code runs across 22+ databases.
Key features:
Write once, run on DuckDB, PostgreSQL, BigQuery, Snowflake, and 18+ more
Lazy execution that builds and optimizes the query plan before sending it to the database
Intuitive chaining syntax similar to Polars
☕️ Weekly Finds
doccano [Data Processing] - Open source annotation tool for text classification, sequence labeling, and sequence-to-sequence tasks
Data Formulator [Data Visualization] - AI-powered data visualization tool that transforms and explores data with drag-and-drop charts and AI agents
qsv [Data Processing] - Blazing-fast CLI toolkit for querying, transforming, and analyzing CSV data at scale
💬 Rate Your Experience
How would you rate your newsletter experience? Share your feedback →
🔍 Explore More on CodeCut
Tool Selector - Discover 70+ Python tools for AI and data science
Production Ready Data Science - A practical book for taking projects from prototype to production