» Tag
sql
29 postsSemcast: A SQL Engine with Semantic Operators for Unstructured Data
Semcast enhances SQL with semantic operators to query unstructured data effectively.
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.
Generating Typed JDBC Code from SQL Files
Learn about generating typed JDBC code from SQL files for Kotlin.
SELECT first_name, last_name vs SELECT first_name || ' ' || last_name: Accuracy Issues
Explore the impact of column concatenation on SQL evaluation accuracy and solutions.
Kysely: Type-Safe SQL Query Builder for Node.js
Kysely helps you create type-safe SQL queries for Node.js. Explore setup and usage here.