A developer argues that learning programming fundamentals remains essential even as AI coding agents become prevalent, because understanding concepts like HTTP, Git, and SQL is necessary to guide agents, review their output, and catch their mistakes.
Parquet files offer a simpler, more performant alternative to custom APIs for serving bulk open data. Hosted statically with CORS enabled and queryable via SQL through tools like DuckDB, they eliminate the need for users to learn complex API documentation while enabling efficient data access from browsers, Python, R, and Excel. The author advocates for organizations to serve canonical parquet files at predictable URLs alongside derived formats like CSVs and reports.
OmniSelect FileSQL is a privacy-focused browser application that converts CSV, Excel, JSON, XML, and other data formats into SQL tables without uploading files or requiring accounts. Users can query data in plain English or SQL, with results exported as CSV, JSON, Excel, or Parquet, all processed locally in the browser.
A new inference engine called Quail combines query planning with inference optimization to achieve over 1 billion tokens per minute on a single H100 GPU, delivering 1.84x faster performance than vLLM on AI-SQL queries. The system optimizes for structured data transformation workloads by intelligently managing key-value cache across requests, enabling cost-effective inference at under 6 cents per billion tokens.
duckdb.mk is a minimal Makefile-based build system for local DuckDB projects that automatically parses SQL queries into dependency graphs and generates Parquet tables, requiring only DuckDB, GNU Make, and curl with no configuration needed.
A tool demonstration showing how to check PostgreSQL migration safety using the safe-not-safe CLI utility, which parses SQL statements with libpg_query WASM to validate migration scripts.
Lix is a version control system that manages both files and SQL tables in a single repository, supporting branching, diffing, merging, and rollback for both data types. It enables real-time collaboration and can be embedded in applications or connected to servers, addressing the limitation of traditional version control systems that handle files but not application data.
SQL Easy is a free, ad-free browser-based learning platform with 31 hands-on SQLite exercises designed to teach SQL fundamentals without signup or installation. Built by the Beekeeper Studio team, it uses immediate feedback and hints to help users learn practical SQL skills used across marketing, product management, engineering, and data roles.
A developer ported the original 1993 Doom game to SQL, running the game logic and renderer entirely within a database while Python handles timing, input, and display. The game runs at 35 FPS with frame rendering up to 60 Hz, supports multiplayer deathmatch, and maintains the original game's feel and visual fidelity using BSP trees for proper depth ordering.
FireWand is a lightweight web-based manager for Google Cloud's Firebase Data Connect (PostgreSQL) databases, offering fast browsing, filtering, sorting, and inline editing of tables without page reloads. It includes a SQL console for raw queries and uses Google Cloud IAM for authentication, never storing passwords. The first GCP project is free forever, with additional projects available for $2.99/month or $29.90/year.
TQL is a terminal-based database client built with Laravel tools that displays SQL queries as you work, integrates with AI agents through a shared query engine, and uses color-coded connection tags to distinguish environments. It installs as a single standalone binary supporting SQLite, MySQL, PostgreSQL, and SQL Server, with no configuration required.
DuckDB's LATERAL join enables calling APIs for each row in a table without explicit loops, using table functions that return zero or more rows per input. The Vector Gateway Interface (VGI) optimizes these remote API calls by exchanging data as Apache Arrow, allowing functions written in any language to run in separate processes.
MariaDB's official documentation now lists LibreDB Studio, a web-based SQL IDE that deploys as a container or Helm chart. The tool offers schema-aware editing, entity-relationship diagrams, schema comparison, query plans, and performance monitoring, with support for MariaDB, MySQL, PostgreSQL, Oracle, and other databases.
DuckDB has introduced support for a new SQL IDE, expanding its tooling ecosystem. The documentation covers installation, client APIs across multiple languages (Python, R, Java, Rust, Go, Node.js), SQL statements and functions, data import/export capabilities, and various extensions for enhanced functionality.
A developer ported the original 1993 Doom game engine to SQL, running the game logic and renderer entirely within a database while achieving 35 FPS gameplay and up to 60 Hz frame rendering. The project uses Python only for input handling, timing, and display, with multiplayer deathmatch support and live game state queryable via SQL.
A space war game where players control PostgreSQL roles to manage fleets using SQL commands. Players buy ships with INSERT statements, maneuver them via function calls, and view battles through database views, with the option to interact via a clickable map interface.
SQLazy is a tool that combines AI assistance with compiler verification to generate production-ready SQL queries step-by-step, eliminating AI hallucinations by having a compiler—not an LLM—produce the final SQL code. Users describe queries in natural language, verify the logic at each step, and compile into auditable SQL that works across multiple database dialects without manual rewriting.
Database normalization is the process of structuring relational databases according to normal forms to reduce data redundancy and improve integrity, a concept first proposed by Edgar Codd in 1970. It involves organizing tables and columns to enforce proper dependencies and eliminate undesirable anomalies like insertion, update, and deletion problems. Higher normal forms (2NF through 5NF) were subsequently defined by Codd and other computer scientists to further refine database design principles.
SQLBraid is a SQL-first TypeScript data-access toolkit that allows developers to write raw SQL with TypeScript type safety, avoiding query-builder DSLs. It provides safe value binding, dynamic SQL, result contracts, and supports multiple databases including PostgreSQL, MySQL, SQLite, and Oracle through driver-specific subpaths.