SQL Server / MySQL / PostgreSQL — the index differences

·1 views

I was reading an article comparing PostgreSQL and MySQL recently. PostgreSQL: cool features, lots of knobs, but index writes are expensive. That got me thinking — I use both of these, so let me add SQL Server too, since that's the one I use the most. SQL Server has two kinds of indexes: clustered and non-clustered. MySQL's InnoDB forces every table to have an index.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Proof-of-Antiquity: El Consenso que Valora la Edad del Hardware

En un mundo donde la escalabilidad y la eficiencia energética dominan las conversaciones sobre blockchain, RustChain introduce una propuesta radicalmente contraintuitiva: Proof-of-Antiquity (PoA). A diferencia de Proof-of-Work (PoW), que premia la potencia bruta, o Proof-of-Stake (PoS), que favorece la riqueza acumulada, PoA otorga autoridad proporcional a la antigüedad del hardware. No se trata de una curiosidad técnica, sino de una filosofía de gobernanza descentralizada que busca resistir la centralización inducida por la obsolescencia tecnológica. Proof-of-Antiquity es un mecanismo de cons

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Access Atlas: keyboard repair plans from structured W3C guidance

This is a submission for the Sanity Challenge, Path One: Ship an Agent That Queries Real Content. Access Atlas is a small keyboard and focus repair agent. Give it a symptom such as “Tab leaves my modal” or “arrowing through tabs loads every slow panel,” and it selects source-linked guidance from Sanity. The product plan brings together the repair steps, prerequisites, constraints, suggested manual checks, expected observations, and original W3C source. The corpus contains seven repair topics.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

The BMW manual was off-limits, so I built my friend something better

This is a submission for the Hacktoberfest Weekend Challenge: Build for a Friend My friend repairs his own BMW E90 325i. Not professionally, not as a hobby exactly, just the way someone does when they'd rather understand their car than hand it to someone who won't explain it back. Watching him work, the actual bottleneck is never the wrench. It's that the information is scattered. A torque spec lives in a forum post from 2013.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

VMware Tanzu Agent Deployment: Build Packs, MCP Gateways, and Multi-Tenant Security

AI agents are crossing the chasm from developer laptops to enterprise infrastructure. When that happens, security boundaries, multi-tenancy, and compliance become non-negotiable. VMware Tanzu Platform is deploying agents alongside traditional applications in production environments, and the plumbing looks different from what you build in a prototype. Nick Kuhn from VMware Tanzu Platform walked through what changes when agents run in enterprise environments: agent build packs, MCP gateways, shared memory coordination, identity management, and sandboxing primitives. This is platform engineering

0 comments Read more at DEV Community