» Tag
sql
42 postsRead Your Writes: Introducing WAIT FOR in PostgreSQL 19
The WAIT FOR command in PostgreSQL 19 ensures read-your-writes consistency on async replicas.
DuckDB v2.0: Your Database Deserves a Better Parser
DuckDB v2.0 enhances user experience by replacing the PostgreSQL parser with a PEG-based parser for better extensibility and easier query writing.
0-day security update available for Metabase
Update your Metabase instance following the newly discovered 0-day vulnerability.
CommitBrief — AI code reviews, right in your terminal
A provider-agnostic, local-first CLI that reviews your staged changes, a historic range, or a whole GitHub pull request. Zero telemetry, no server. Free and open source.
commitbrief.comHelicone Enables Users to Write SQL Directly to a Shared ClickHouse
Helicone has launched HQL, allowing users to write SQL queries on a shared ClickHouse. Security is ensured through row policies.
Implementing a Neural Network in SQL: A Novel Approach
The potential for developing neural networks in SQL has been explored. New features in the Xarray-SQL library present significant relational operations.
85 hours spent updating 234 rows in the database
An unexpected query in the database spent 85 hours updating 234 rows. Important lessons on performance improvements were drawn.
Text-to-SQL Access Error: "No Records Found" Message
Schemagate prevents access errors in NL2SQL models, reducing costs and improving accuracy.
pg_raw_parse: A Rust Library for Parsing PgSQL
pg_raw_parse is a Rust library that speeds up SQL parsing for Postgres.
PostgreSQL 15: Discrepancies Between Manual and Scheduled Query Times
Explore the performance differences in PostgreSQL 15 between manual and scheduled queries.
Generating Typed JDBC Code from SQL Files
Learn about generating typed JDBC code from SQL files for Kotlin.