CreatorDesk: a self-hosted approval loop for commission artists
This is a submission for the Hacktoberfest Open-Source AI Challenge Week 2: Side Hustle What I Built CreatorDesk is a self-hosted, open-source tool…
Architecture
⚑ Report a ProblemLatest Architecture news from Tech News
All topics
agents
ai
api
architecture
automation
aws
backend
beginners
career
database
devchallenge
devops
javascript
llm
machinelearning
mcp
news
opensource
performance
productivity
programming
python
react
security
showdev
softwareengineering
systemdesign
tutorial
typescript
webdev
Announcing det: - Fast, local-first SQL ETL workspace and pipeline orchestration engine
What if you could build complete, production-grade ETL pipelines in Pure SQL… without Jinja templates, without a database server, and without heavy…
Optimistic vs Pessimistic Locking: Handling Race Conditions in High-Contention Databases
Imagine an inventory table for an e-commerce flash sale: Item: Nintendo Switch (Stock: 1) Two customers (Alice and Bob) click "Buy Now" at the exact…
Finding double-billed shipments before the carrier's invoice ages out
Carrier invoices contain duplicates. Not many, and not usually in bad faith, but enough that any operation shipping across several carriers and seve…
How I stream row changes out of SQLite without touching the app (reading the WAL)
SQ Lite has no way to tell another process "row 42 in users just changed." I wanted that, so I built tailite : it follows a live SQLite database fro…
Mastering the Quantified Self: Building a 24/7 Personal Health Dashboard with Grafana and TimescaleDB 🚀
Have you ever felt like your health data is trapped in a "walled garden"? Between Apple Health on your iPhone and Google Fit on your secondary Andro…
ersioning Business Semantics for Enterprise AI
Your SQL can be perfectly reproducible while your business meaning is not. Suppose a user asks: What was revenue in Q1? Your data agent resolves Rev…
Idempotent APIs Without Idempotency Tokens
A few years into working on a utility billing SaaS platform, I ended up owning a feature that sounds simple on a slide and is genuinely nasty undern…
One CAST made a view 13x slower in PostgreSQL. So I benchmarked MySQL 8.4 against PostgreSQL 17
At one interview I was asked about VIEWs. I answered honestly: in real projects I had barely run into them; for aggregates it is safer to keep a sep…
Designing a Production-Ready Data Science Pipeline: From Raw Events to Monitored Models
A model is only one artifact in a production data science system. The harder engineering problem is creating a reliable path from changing source da…
Архитектура универсального провайдера баз данных на TypeScript без JDBC
В зрелых корпоративных экосистемах вроде Java или .NET инструменты для работы с базами данных опираются на стандартизированные на уровне среды выпол…
Who gets rated higher: age, age gap and the reciprocity myth - from 24 million ratings
In the previous piece I went through 24 million ratings from our app Rate Me (people rate each other's photos 1-10) and showed four things: the dip…
Что стоит за простым уведомлением: история разработки шаблонизатора на C#
Чтобы напомнить клиенту о встрече, нужно собрать в одном сообщении данные из нескольких записей CRM. С этой задачи началась работа над моим шаблониз…
How I built one open-source SQL workspace for five database engines
Working with more than one database engine often means maintaining more than one workflow. The SQL is familiar, but the editor, schema browser, resu…
The Hard Truth About Data Engineering Interviews Nobody Tells You
It's 11 PM. You've solved forty LeetCode mediums this month. Your GitHub has a shiny new Airflow project with green checkmarks all the way down. Tom…
Why RBAC Alone Isn't Enough for Enterprise Data Agents
A user can be blocked from a sensitive column and still receive sensitive information derived from data they are allowed to access. That changes the…
Practical SQL Query Optimization: From Slow Scans to Efficient Indexes
As applications scale from hundreds of thousands to millions of records, poorly optimized database queries quickly become the primary bottleneck of…
Why Using FLOAT for Financial Pipelines is a Silent $100k Trap (and How PostgreSQL NUMERIC Saves Your Ledger)
Here is a simple SQL query that should return 0.3: SELECT 0 . 1 :: FLOAT4 + 0 . 2 :: FLOAT4 ; In PostgreSQL, MySQL, and most relational SQL engines,…
When Runtime Plans Enter the Prompt: A Structured Debate for SQL Review Bots
The following scene is a composite on-call pattern, not a personal claim about one employer. A checkout query crossed its p95 budget during a mid-af…
SQL Date Functions: How to Group by Month Without Losing One
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page you can summarise any table by month in one line, pull the year,…
Prisma vs Drizzle vs Raw SQL: What Every Backend Developer Should Understand Before Choosing an ORM
When most developers start building backend applications, they're usually focused on one thing, getting an API working. Express routes, controllers,…
MCP vs. a Direct Database Connection: A Security and Workflow Comparison
Sooner or later, someone on your team wants to point an AI assistant at the production database. Maybe it's a support engineer who wants to answer "…
Bringing Relational SQL Databases to the P2P World
Have you ever wanted to integrate full-text search (or to be more trendy, vector similarity search) in to your P2P project only to be disappointed b…
Why I Stopped Rushing to Machine Learning and Started with SQL Instead!
I've solved 15 of the 50 problems in LeetCode's SQL 50. I started my first end to end ML project predicting telco customer churn this week. And thre…
Oracle Designer Lost Support in 2013. My AI Agent Develops in It Anyway.
Oracle Designer 10g is a CASE tool from the early 2000s. Support ended in 2013. At my job it is still the center of development: the repository hold…
Read-Only by Design: Letting AI Explore Your Database Without the Risk of Writes
There's a moment every developer hits the first time they connect an AI assistant to a real database: it works beautifully, the model writes a clean…
Your Database Is Making 4 Promises. Here's What ACID Means.
Introduction Your program keeps opening transactions. A signup writes a new user row. A checkout debits one account and credits another. A form subm…
OrioleDB Multi-Version Concurrency Control
MVCC not only tracks row history but also records the search-key space. To better understand PostgreSQL MVCC, it's useful to look at some alternativ…
A Python Model Is Just a Function
Most tools that support both SQL and Python support one of them properly. Python arrives as an escape hatch: a different execution path, a different…
От 12 часов к 30 минутам: как мы join’им миллиарды товарных движений в ClickHouse
Всем привет! Меня зовут Муса. Наша команда занимается витринами данных по товарному учёту. Каждый день мы доставляем около 10 млрд записей…