From Dev.to Community
Tech Articles
Curated developer articles, tutorials, and guides � auto-updated hourly
Athreya aka Maneshwar2d ago • 2 min read
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 i...
#webdev#programming#database#architecture
19 1
Sualeh Fatehi2d ago • 3 min read
SchemaSpy vs SchemaCrawler - Which Database Documentation Tool is Right for You?
A fair comparison of two free, open-source database documentation tools - what each does best, when ...
#database#devops#sql#opensource
7 2
Franck Pachot3d ago • 6 min read
The Autovacuum Scale Factor Problem at Scale - Know Your Defaults
In PostgreSQL, autovacuum and autoanalyze exist to clean up dead tuples (old versions of...
#postgres#sql#database#performane
1 2
Alex Merced2d ago • 14 min read
Apache Data Lakehouse Weekly: May 21-27, 2026
The week after a major release tends to look quiet on a project's dev list. This one did not. With.....
#database#dataengineering#news#opensource
0 0
VisuaLeaf9h ago • 5 min read
MongoDB `$facet` Explained: One Query, Multiple Results
Sometimes one MongoDB aggregation needs to return more than one result. For example, from the same....
#mongodb#nosql#developers#database
7 1
Tejas5d ago • 5 min read
Under the Hood: Demystifying Database Internals (InnoDB vs. ARCHIVE)
Most developers treat database engines as black boxes: you write a query, and data magically returns...
#systemdesign#database#intenal#systems
3 1
Mohamed Hussain S4d ago • 4 min read
Why Too Many Parts Hurt ClickHouse Performance
A lot of people initially think ClickHouse performance problems come from: large queries bad...
#clickhouse#database#dataengineering#backend
3 1
Ishaan6d ago • 2 min read
Visualizing Database Design: From Interactive Canvas to Drizzle, Prisma, and SQL in Real-time
Every full-stack developer has been there: you are planning a new feature, sketching out database....
#webdev#showdev#database#javascript
4 1
srinivas reddy gouru3d ago • 11 min read
How Spring Data JPA, JPA, and Hibernate work together
The Magic Line That Raises the Right Question Spring Data JPA is a library that lets you...
#backend#database#java#springboot
1 0
Vadym Arnaut1d ago • 2 min read
The auth_rls_initplan linter has a blind spot: SECURITY DEFINER bodies
If you've ever migrated a Supabase project to the wrapped (SELECT auth.uid()) pattern, you know the....
#supabase#postgres#webdev#database
3 0
Lovanaut 1d ago • 11 min read
Form Responses as Institutional Memory: Designing the Record Layer"
Most form schemas I have seen were designed for the wrong time horizon. They were designed for the....
#architecture#database#softwareengineering#systemdesign
5 0
Joud Awad5d ago • 1 min read
19/30 Days System Design Questions!
Your checkout endpoint has a 400ms P95. Profiling shows 70% of that is DB reads. You add a read...
#architecture#database#distributedsystems#systemdesign
1 4
Sandesh Ojha6d ago • 3 min read
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...
#database#networking#showdev#systems
0 0
M. Alwi Sukra1d ago • 8 min read
TIL - Graph Thinking Without a Graph Database
This week I read DDIA Chapter 2 related to data models. Most of it felt familiar. Relational vs...
#software#database
0 0
Rabinarayan Patra1d ago • 10 min read
How to Set Up an SSH Tunnel for Local Database Access
The single fastest way to wake up to a ransom note is to expose your Postgres port directly to the.....
#database#postgres#security#tutorial
0 0
Carlos Oliva Pascual3d ago • 2 min read
Zero-Downtime Database Migrations in Production (2026)
The expand-contract pattern, safe vs dangerous operations, and how to rename a column without breaki...
#postgres#database#nextjs#webdev
1 2
钟智强6d ago • 8 min read
QuestDB 爆高危漏洞：无需密码，即可掌控你的数据库！附漏洞细节与临时缓解方案
...
#cybersecurity#database#news#security
0 0
Mark Nelson1d ago • 17 min read
Agent‑safe change delivery on Oracle: discovery, online mechanics, idempotent migrations, and provable rollbacks
This is article 7 of 8 in my Oracle AI Database Skills series. Key Takeaways The safety...
#agents#database#devops#sql
0 0
Eugene Zimin6d ago • 15 min read
The Blueprint Beneath the Blueprint: Designing Data Model and Choosing Its Database
Lesson 2 of Build a Twitter Clone - A Practical Guide to Software Modelling A diagram...
#database#web#architecture#data
0 0
Truffle6d ago • 6 min read
Producer audit clean, six tests red
I shipped a DuckDB fix that moved a state-setting block past a type-dispatch. The producer-side sibl...
#cpp#debugging#database#programming
0 0
Alex Serban4d ago • 5 min read
The pgAudit Attribution Gap: Why Role-Level Logging Fails GDPR and How to Close It
What pgAudit Actually Logs pgAudit is a PostgreSQL extension that captures query-level...
#security#devops#database#startup
0 1
BaoDev Studio4d ago • 3 min read
Postgres JSONB indexes: GIN vs BTREE on the same column
caught this in production last quarter and the answer is more boring than i expected: GIN and BTREE....
#postgressql#database#performance#json
0 0
Jansen0031d ago • 2 min read
I Built a Python MCP Server for Databases — So Claude Can Query My DB Directly
I got tired of switching between Claude Code and my database client every time I needed to check som...
#database#mcp#python#showdev
0 0
Mark Nelson1d ago • 34 min read
How to Enforce Role-Based Data Access in AI Applications with Oracle Deep Data Security
Key Takeaways AI assistants should not rely on prompts or application code to enforce...
#ai#database#rag#security
0 0