SQLite WAL Debug, pgstream v1.1.0, & Postgres Scaling Retrospective
SQLite WAL Debug, pgstream v1.1.0, & Postgres Scaling Retrospective Today's Highlights This week's database highlights include a deep dive into SQ…
Open Source
⚑ Report a ProblemLatest Open Source news from Tech News
All topics
AI
agents
ai
api
architecture
automation
aws
beginners
career
claude
database
devchallenge
devops
javascript
linux
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
softwareengineering
tutorial
typescript
webdev
Discovering PII Inside InterSystems IRIS
Data privacy regulations such as GDPR, LGPD, and HIPAA demand that organizations know exactly where Personally Identifiable Information (PII) lives in…
Don't parse SQL to make a query runner read-only
Say you're building a tool that lets people run ad-hoc SQL against a database, and you want a read-only by default mode — a safety net so a fat-finger…
Building a Natural Language Query Interface for Your Database: A Developer's Blueprint
Every product team eventually hits the same wall. Marketing wants to know which signups came from last week's campaign. Support wants a list of custom…
PostgreSQL HA Risks, Replication Internals, & Rapid Branching
PostgreSQL HA Risks, Replication Internals, & Rapid Branching Today's Highlights Today's highlights include critical insights into Patroni's repli…
Dynamic Column Updates in EF Core Without Hand-Rolling SQL Injection
Sometimes you genuinely need the set of columns to update to be data, not code. An operator maps configuration fields to database columns, and you wan…
day 01 of learning data engineering (step1: sql joins and set operators)
So, yes. Today's goal is to get the 30hr SQL Bootcamp completed (or at least as much as I can), I am following Data with Baara. Who gets a 5 on 5 for …
Postgres or ClickHouse? Row vs Column Storage, and When Each Wins
PostgreSQL and ClickHouse both speak SQL, both call themselves databases, and both will happily store your data. That surface similarity gets teams in…
SQLAlchemy Essentials: A Beginner’s Roadmap
Key Takeaways SQLAlchemy is both an ORM and a SQL toolkit — pick one, use both, whatever works for your situation. Learn Engine, Session, and Declarat…
The Deep Mechanics of Online Bulk Deletion in PostgreSQL
MVCC, WAL, vacuum, and replication slots under sustained delete load - and how to delete billions of rows without your database noticing Most "how to …
Three PostgreSQL Master/Replica Discovery Problems — and How to Solve Them
When an application starts using multiple PostgreSQL hosts, the headaches begin: you need to dynamically find the master after a failover, pick a repl…
Why SQL Still Rules the Data World: Surprising Truths from the Relational Revolution
In the hyper-accelerated world of software development, where programming languages often have the shelf life of a smartphone, SQL stands as a defiant…
Top 12 SQL Interview Problems for Data Engineers, With Answers
I've been on both sides of the SQL interview table somewhere around 20 times in a single job search. The pattern is always the same: candidates know S…
Building My First End-to-End ETL Pipeline with Airflow, BigQuery, and Docker
Recently, I completed my first full Data Engineering project: building an end-to-end ETL pipeline using real-world Australian weather data spanning 10…
SELECT FINAL and OPTIMIZE FINAL Are Not the Same Thing
One thing that confused me when I first started learning ClickHouse was the word FINAL . Because eventually you'll come across both: SELECT * FROM eve…
DuckDB Data Inlining, SQLite Fossildelta OOB, Postgres 19 Temporal Data
DuckDB Data Inlining, SQLite Fossildelta OOB, Postgres 19 Temporal Data Today's Highlights Today's highlights include DuckDB's innovative data inlinin…
How I Cut SQL Query Time from 45 Seconds to 8 Seconds on 2.3 Million Rows
I inherited a SQL Server database with 2.3 million rows. Queries took 45 seconds. Users were frustrated. Dashboards timed out. Here is exactly what I …
How I Cut SQL Query Time from 45 Seconds to 8 Seconds on 2.3 Million Rows
I inherited a SQL Server database with 2.3 million rows. Queries took 45 seconds. Users were frustrated. Dashboards timed out. Here is exactly what I …
sqlh — SQL в Go без boilerplate: пишем CRUD за 50 строк
> Zero-boilerplate SQL для Go. Опиши структуру тегами — и это всё. Если вы пишете на Go и работаете с SQL-базами, вы знаете эту боль. Каждый CRUD-з…
When Kubernetes Isn't the Problem: Debugging External Dependencies in AKS
Introduction One of the most common mistakes during incident response is assuming Kubernetes is the problem simply because the application runs on Kub…
Database Management Systems for Beginners: Learn SQL, Tables, Queries, and Data Design.
I often see beginners struggle with databases because most resources either jump straight into SQL syntax or spend too much time on theory. Over the p…
Designing an Expiring-Points System on an RDBMS (with Benchmarks)
This is an English rewrite of an article I originally published in Japanese. I've run the design on PostgreSQL 17 in Docker and folded the measured nu…
PostgreSQL 22003 Error: Causes and Solutions Complete Guide
PostgreSQL Error 22003: Numeric Value Out of Range PostgreSQL error code 22003 ( numeric_value_out_of_range ) is raised when you attempt to store or c…
How to see running queries in Postgres and kill them
Something is slow. Maybe a page takes forever to load, maybe a migration is hanging, maybe your Supabase dashboard just spins. You suspect a query is …
Stop Hiding SQL Behind Your ORM: jOOQ, JPA, and JDBC Under Production Load
Most persistence debates in Java are framed incorrectly. The question is not: Should we use JPA, jOOQ, or JDBC? The real question is: Is this part of …
PostgreSQL 2200G Error: Causes and Solutions Complete Guide
PostgreSQL Error 2200G: Most Specific Type Mismatch PostgreSQL error code 2200G ( most_specific_type_mismatch ) is a SQL-standard data exception that …
SQLite `ON CONFLICT DO SELECT` Proposal, PostgreSQL 19 Features & SQLite Critical Bug
SQLite ON CONFLICT DO SELECT Proposal, PostgreSQL 19 Features & SQLite Critical Bug Today's Highlights This week in databases, a proposal seeks to…
How to Format SQL Queries in Python: Best Practices, Gotchas, and Real-World Examples
Stop writing SQL strings that look like a ransom note. Here's how to write queries that are readable, safe, and maintainable. The Problem With "Good E…
I built an AI-personalized news bot that runs on a single SQLite file — architecture and everything that broke
I built an AI-personalized news bot that runs on a single SQLite file — architecture and everything that broke TL;DR — @futur_e_news_bot . A bilingual…
Обучение универсальным навыкам в IT
Дисклаймер: вся статья это мнение автора, если вы не согласны или готовы предложить что-то, то прошу в комментарии. IT охватывают огромный простор нав…