LioranDB Progress
LioranDB: Support the Indian government initiative that Indian data should stay in India. 100% Made in India database. Reduce dependency on foreign te…
Team Management
⚑ Report a ProblemLatest Team Management news from Tech News
All topics
Culture
agents
ai
api
architecture
automation
beginners
career
claude
devchallenge
devops
discuss
javascript
llm
machinelearning
mcp
opensource
productivity
programming
python
react
saas
security
showdev
softwareengineering
startup
testing
tutorial
typescript
webdev
Part 8: Persistence and State - EF Core, Migrations, and Reliability
In the last part, we looked at how expressions make your workflows dynamic. Today, we are discussing the backbone of any production-ready system: Pers…
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…
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…
What Drags Down Throughput in GBase 8a Bulk Loading — and Where to Look First
When loading large volumes into a gbase database cluster, stability matters far more than a single peak throughput number. The same 500 GB data set ta…
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 …
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…
10 API and Database Blunders Every Beginner Makes (and How to Fix Them Before Production Bites Back)
You wrote your first REST endpoint. You ran your first SELECT * . Things worked. Life was good. Then a colleague casually mentioned "idempotency key,"…
The Multi-Tenant Fortress: Bank-Grade Data Isolation in PostgreSQL
In a multi-tenant B2B platform, data leakage is an extinction-level event. If Property A logs into your dashboard and accidentally sees the guest data…
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…
Apache Data Lakehouse Weekly: June 4 to June 11, 2026
The lakehouse community spent this week arguing about versions, and the arguments mattered. Parquet contributors produced the single largest thread ac…
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 …
From Individual Sandbox to Multiplayer: Group Rooms, Linked Servers, and Gamification in T-SQL Online
We just deployed a major update to our SQL Server web sandbox, moving from an individual tool to a collaborative environment: ✅ Group Rooms (Beta): …
A practical SQL query tuning playbook: execution plans, joins, indexes, and the traps
SQL tuning is the process of making a database query run faster and cheaper — cutting response time while minimizing the system resources it burns. He…
I built a free SQL practice game where you work at a fictional Singapore bank
I've been frustrated with SQL learning resources for a while. Most are either: Dry reference docs Toy exercises with no context ("SELECT * FROM employ…
DuckDB Integrates Lance Lakehouse; SQLite CVE Fix; Postgres 19 Beta on K8s
DuckDB Integrates Lance Lakehouse; SQLite CVE Fix; Postgres 19 Beta on K8s Today's Highlights This week, DuckDB introduces integrated vector and hybri…
I got tired of writing the same history table boilerplate, so I built a Postgres extension
There's this problem I kept running into - first during my internship, then again on a freelance project I picked up afterward. Both of them used Post…
🧠 Mastering pinecone fastapi semantic search tutorial
🚀 Overview — Why Semantic Search Matters Semantic search surpasses simple keyword matching because embeddings place texts in a high‑dimensional vector…
The 32-bit Hidden Countdown in ClickHouse Keeper: How an XID Overflow Gave Us Weekly Read-Only Bursts
A production debugging story: tracing recurring 2–5-second read-only storms on a ClickHouse cluster down to a single 32-bit integer — and the one-line…
Before SQL, We Had to Tell Computers Everything. Then One Idea Changed That Forever.
Here's something most SQL tutorials skip entirely: SQL wasn't just a new syntax. It was a new way of thinking . Before SQL existed, most systems were …
I Built a Lightweight Python RAG Orchestrator That Works with SQLite, PGVector and Qdrant
Most RAG frameworks today assume: a huge dependency graph mandatory LLM orchestration opinionated pipelines complex configuration But many real-world …
Vector‑native RAG on Oracle: embeddings, HNSW/IVF, and hybrid search under database governance
Key Takeaways Storing vectors in an Oracle VECTOR column alongside content, metadata, and provenance means retrieval happens inside the database. Exis…
Negative Lookups in Bf-Tree: Caching Things That Don't Exist
Hello, I'm Maneshwar. I'm building git-lrc, a Micro AI code reviewer that runs on every commit. It is free and source-available on Github. Star git-lr…
Range Scans and Tombstones in Bf-Tree
Hello, I'm Maneshwar. I'm building git-lrc, a Micro AI code reviewer that runs on every commit. It is free and source-available on Github. Star git-lr…
I built a Redis clone in C: From blocking I/O to epoll to crash safe persistence
I had been hearing about sockets, TCP connections, and networking for years without truly understanding what any of it meant at the code level. Buildi…
From AI Code Generation to AI System Investigation
I Released AI DB Investigator - A Skill for Structured Database Analysis AI is very good at generating answers. But when it comes to database problems…
DuckDB 1.5.3 Adds Quack Client-Server, SQLite Gets Cypher Graph Extension
DuckDB 1.5.3 Adds Quack Client-Server, SQLite Gets Cypher Graph Extension Today's Highlights This week, DuckDB releases version 1.5.3 with the Quack c…
Stop Naming Your Healthcare Columns Wrong — ISO-11179 Explained
If you've ever inherited a healthcare database with columns named DOB , PatientID , or CLAIM_NUMBER — this guide is for you. Healthcare data engineeri…
🎮 The SQL Arcade : No Boring Textbooks Allowed
Let's be honest: staring at a dry spreadsheet or a thick textbook is probably the worst way to try to learn SQL. It doesn't have to be a grind. If you…
Anatomy of Duck DB for Python Developers
Introduction - SQL without a Server Pandas is widely used for data analysis and almost every data analyst or even data engineers utilize it for faster…