Skip to content
HomeInsights

Insights

Ideas for building
better software.

Engineering perspectives on architecture, product development, AI, and the everyday decisions behind useful software.

From the engineering desk

Browse practical articles or follow the latest technology updates.

Subscribe via RSS →

Curated links from external sources — not 360Softy original articles.

ExternalDatabase
PlanetScale Blog

What's new in Postgres 19

Postgres has never had a great built-in way to shrink a bloated table. VACUUM identifies dead space for reuse, but doesn't return it to the operating system. VACUUM FULL and CLUSTER do, but they lock the table for the whole rewrite. For a decade, operators have been forced to reach for extensions like pg_repack and pg_squeeze. Postgres 19 finally brings that capability into core. Among many, the three most notable changes in Postgres 19 are: REPACK rewrites a bloated table, online JIT disabled

PlanetScale BlogRead original
ExternalSoftware Engineering
DEV Community

Your budgeting app is lying to you about last month

I build a multi-currency personal-finance app. This is one of the The symptom You spent 200 zł on groceries in March. Your base currency is euros. That's not a rounding quirk. It means your financial history is being rewritten with today's exchange rate, and you can't trust any The naive multi-currency data model looks reasonable: transaction { amount: 200 currency: "PLN" date: "2026-03-14" } Then, to show a total in the user's base currency, you convert on read: const e

webdevjavascriptdatabase
DEV CommunityRead original
ExternalSoftware Engineering
DEV Community

My app's anti-theft feature locked every user out

A real incident from the finance app I build solo. The security design The textbook setup Short-lived access token, long-lived rotating refresh token. Every It presents its refresh token. The server verifies it, revokes it, and issues a brand-new access + refresh pair. The old refresh token is now dead — single use. And the part everyone recommends (OWASP calls it refresh-token reuse already , treat it as theft. An attacker who stole a token and revoke every session for that user so

securitywebdevnode
DEV CommunityRead original
ExternalSoftware Engineering
DEV Community

Automate FOMC and CPI Alerts with n8n and a Free Economic Calendar API

If you trade — or just hold anything denominated in dollars — you already know the drill: FOMC decisions, CPI prints, and NFP releases move markets in seconds, and the only warning you get is whatever tab you happened to leave open. This post walks through a small n8n workflow that polls an economic calendar every morning and pushes high-impact USD events straight to Telegram. Total build time: about 15 minutes. Total cost: $0 on free tiers. ForexFactory's calendar is the de facto standard for r

n8nautomationapi
DEV CommunityRead original
ExternalSoftware Engineering
DEV Community

How Reading a Design Patterns Book Led Me to Audit My Rust Framework with UML and Merise

I was reading a design patterns book. I got to the UML class diagrams — and I stopped. Because the diagram on the page was describing something Rust already says in its own syntax. A struct is a class. Option<T> is a 0..1 association. Vec<T> is 1..N. Ownership is composition. The formalism I was looking at, drawn as boxes and diamonds, was the same information the compiler already had — just in a different notation. Which led to an uncomfortable thought. If the type system already encodes what U

rustarchitectureshowdev
DEV CommunityRead original

Let’s start with a conversation

Tell us what you’re working on.

An idea, a challenge, or a system that needs to work better. We’ll help you understand the next step.