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…
Latest Web news from Tech News
All topics
AI
agents
ai
api
architecture
automation
aws
beginners
career
claude
database
devchallenge
devops
javascript
learning
linux
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
tutorial
typescript
webdev
Pagination records using JooqTemplate
Paginated queries with automatic total count calculation. Supports specifying result fields. public < E > LimitResult < List < E >, E &…
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 …
Три задачи discovery при работе с PostgreSQL master/replica — и как их решить
Когда у приложения появляется несколько хостов PostgreSQL, начинается головная боль: нужно динамически находить мастера после failover, выбирать репли…
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…
PostgreSQL 22P01 Error: Causes and Solutions Complete Guide
PostgreSQL Error 22P01: Floating Point Exception PostgreSQL error code 22P01 is raised when a floating-point operation produces an exceptional result …
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 …
Indexes: Quickstart Using PostgreSQL (15 sec read)
Let's consider a table user . When we execute a query to find Emily , we are actually going through each record , looking whether the name column equa…
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 охватывают огромный простор нав…
SQL Explorer: Run Full SQL on CSV, Parquet & JSONL Files in Your Browser
Query large local files with industry-grade SQL — without uploading anything. Utilora SQL Explorer brings the power of DuckDB directly into your brows…
PostgreSQL 2201X Error: Causes and Solutions Complete Guide
PostgreSQL Error 2201X: invalid row count in result offset clause PostgreSQL error code 2201X ( invalid_row_count_in_result_offset_clause ) is thrown …
SQL Formatting Best Practices: A Practical Guide for Engineers
SQL is arguably the most widely used language in software engineering, yet it is often the least carefully written. Most teams enforce strict linting …
QN : Ingest and transform data in a lakehouse
lakehouse has two storage areas ; Files and Tables Files Store structured, queryable data by sql Supports schema definitions and ACID transactions Tab…
Pandas vs SQL, when to use each
Pandas and SQL do a lot of the same things: filter rows, group, aggregate, join. So analysts reasonably ask which to learn and when to use which. The …