architecture

4 articles · newest first

Editorial illustration of a traveler with a backpack at a fork in a path, a lavender elephant on the left branch and a coral dolphin on the right

Postgres vs MySQL for a new project: pick Postgres unless one of these is true

Both are free and mature. For a new app in 2026, the docs tilt toward Postgres: a permissive licence, indexed jsonb, a free vector extension and hosts on every budget. Here is what each project's own documentation says, what I could not verify, and the cases where MySQL still wins.

Aliteq Team · Oct 16 · 9 min

Photo of a small matte black server box with two glowing coral lights sitting on a desk above an open drawer of blank folders

Software

SQLite in production: when one file is enough, and how to back it up

SQLite is a whole database in one file, and its own docs say it fits most websites. The catch is one writer at a time and a backup plan you have to build. Here is when it is enough, what WAL mode changes, and where D1 and Turso fit.

Aliteq Team · Oct 16 · 11 min

Hand-drawn illustration of one large house with neatly separated rooms beside a few small huts joined by a tangle of coral wires

Software

Modular monolith vs microservices: what a small team should build first

Microservices split your app into many small programs that talk over a network. That fixes some problems and creates others. Here is the plain-English decision for a small team, what a modular monolith is, and what a saga is when one action touches two databases.

Aliteq Team · Oct 8 · 9 min

Flat illustration of a person holding up a coral stopwatch in front of a large empty cloud with one lit window

Software

Serverless explained: what Cloudflare Workers and AWS Lambda really bill you for

There is still a server. You just stop owning it. Here is how Workers and Lambda differ in how they run your code, start cold, and charge you, with the real list prices and the one month our own site hit the free plan's limit.

Aliteq Team · Oct 6 · 9 min