EmbeddingGemma 2: an open, lightweight multimodal embedding model
deepmind.google·6d ago
AI Engineering
Lobsters·Aug 21·5 min read
DuckDB v2.0: Your Database Deserves a Better Parser
TL;DR
DuckDB v2.0 introduces a new PEG-based SQL parser, replacing the previous PostgreSQL-derived parser, enhancing extensibility and ease of evolution.
✦ Why It Matters
Consider adopting DuckDB v2.0 for improved SQL parsing capabilities in your projects.
Key Takeaways
- Explore DuckDB v2.0 for enhanced SQL parsing capabilities.
- Utilize the new PEG parser for easier syntax extensions.
- Leverage improved error reporting for debugging SQL queries.
- Adopt new syntax features like expression statements in your queries.
How It Works
The PEG-based parser operates by defining named rules that describe how SQL input should be matched, allowing for flexible syntax arrangements. It evaluates alternatives in a specified order, reducing parsing conflicts and enabling DuckDB to support both traditional and friendly SQL syntax.
The implementation of packrat parsing further optimizes performance by caching results of grammar evaluations, significantly speeding up the handling of malformed queries.