Skip to content

Standard Reader

Tag

Mysql

Articles and publications tagged Mysql across the Atmosphere.

61articles17publications

Articles

Publications

Morning Dew by Alvin Ashcraft – Daily links for Windows and .NET developers.Aug 6, 2026

Dew Drop - August 6, 2026 (#4727)

Daily LinksDevelopment

Morning Dew by Alvin Ashcraft – Daily links for Windows and .NET developers.Jul 24, 2026

Dew Drop - July 24, 2026 (#4719)

Daily LinksDevelopment

Markus KniebesJul 8, 2026

MariaDBs impliziter Rollback frisst Doctrine-Savepoints

FiregapJun 26, 2026

How to Channel Special Interests Into Digital Sovereignty

Neurodivergent kids often dive deep into "special interests." Instead of viewing this as an obsession to be managed, channel it into mastery.

PythonRaspberry Pi

Morning Dew by Alvin Ashcraft – Daily links for Windows and .NET developers.Jun 25, 2026

Dew Drop - June 25, 2026 (#4698)

Daily LinksDevelopment

Morning Dew by Alvin Ashcraft – Daily links for Windows and .NET developers.Jun 2, 2026

Dew Drop - June 2, 2026 (#4681)

Daily LinksDevelopment

Morning Dew by Alvin Ashcraft – Daily links for Windows and .NET developers.Jun 1, 2026

Dew Drop - June 1, 2026 (#4680)

Daily LinksDevelopment

Sahil Kapoor's PlaybookMay 12, 2026

Database replication is the practice of keeping multiple copies of the same data on different nodes for availability, durability, and read scaling. Almost every production database runs with at least one replica; the design choices are around topology, synchronisation, and failover. Common topologies * Primary-replica (master-slave). One node accepts writes, replicas follow. Standard in PostgreSQL, MySQL, MongoDB, Redis. * Multi-leader. Multiple nodes accept writes; replicate to each other;

PostgreSQLMySQL

Sahil Kapoor's PlaybookMay 12, 2026

OLTP (Online Transaction Processing) describes the class of database workloads characterised by many short-lived, latency-sensitive transactions: row-level reads and writes that back interactive applications. OLTP contrasts with OLAP (Online Analytical Processing), where queries scan large fractions of historical data for analytics. OLTP characteristics * Short transactions. A few row reads and writes; complete in milliseconds. * High concurrency. Thousands to hundreds of thousands of trans

PostgreSQLMySQL

Sahil Kapoor's PlaybookMay 12, 2026

Multi-Version Concurrency Control (MVCC) is a concurrency mechanism in which writers do not block readers and readers do not block writers. Instead of locking rows for the duration of a transaction, the database keeps multiple versions of each row, and each transaction sees a consistent snapshot of the data as of its start time. How it works Every row carries internal metadata about which transaction created it and (if applicable) which transaction deleted or updated it. A transaction sees a

PostgreSQLMySQL

Sahil Kapoor's PlaybookMay 12, 2026

SQL (Structured Query Language) is the declarative language for defining, querying, and manipulating relational databases. Despite decades of speculation about its replacement, SQL remains the dominant data interface across analytics, transactional systems, and increasingly across distributed and embedded databases. Statement categories * DDL (Data Definition Language): CREATE, ALTER, DROP for schemas, tables, indexes * DML (Data Manipulation Language): SELECT, INSERT, UPDATE, DELETE * DCL

PostgreSQLMySQL

Morning Dew by Alvin Ashcraft – Daily links for Windows and .NET developers.May 11, 2026

Dew Drop – May 11, 2026 (#4665)

Daily LinksDevelopment

Sahil Kapoor's PlaybookMay 1, 2026

An ORM (Object-Relational Mapper) is a library that translates between application objects and relational database rows. ORMs handle query construction, parameter binding, result hydration into objects, schema migrations, and relationship navigation, so applications can work with domain objects instead of raw SQL strings. Common ORMs by language * JavaScript / TypeScript: Prisma, Drizzle, TypeORM, Sequelize, MikroORM, Kysely (query builder, not strictly ORM) * Python: SQLAlchemy, Django ORM

The Cloudflare BlogApr 16, 2026

Deploy Postgres and MySQL databases with PlanetScale + Workers

Morning Dew by Alvin Ashcraft – Daily links for Windows and .NET developers.Apr 16, 2026

Dew Drop – April 16, 2026 (#4648)

Daily LinksDevelopment

Morning Dew by Alvin Ashcraft – Daily links for Windows and .NET developers.Apr 13, 2026

Dew Drop – April 13, 2026 (#4645)

Daily LinksDevelopment

Morning Dew by Alvin Ashcraft – Daily links for Windows and .NET developers.Apr 10, 2026

Dew Drop – April 10, 2026 (#4644)

Daily LinksDevelopment

Morning Dew by Alvin Ashcraft – Daily links for Windows and .NET developers.Apr 6, 2026

Dew Drop – April 6, 2026 (#4640)

Daily LinksDevelopment

Sahil Kapoor's PlaybookApr 5, 2026

Batch Processing in Modern Systems

Batching in distributed systems is like a tax strategy. Every database write, every API call, every network request carries overhead you can't avoid. The only question is how many times you pay it. Process a thousand records individually and you pay a thousand times. Batch them and you pay once.

MySQLthis deep dive by Laurenz Albe

Morning Dew by Alvin Ashcraft – Daily links for Windows and .NET developers.Apr 1, 2026

Dew Drop – April 1, 2026 (#4637)

Daily LinksDevelopment

Morning Dew by Alvin Ashcraft – Daily links for Windows and .NET developers.Mar 30, 2026

Dew Drop – March 30, 2026 (#4635)

Daily LinksDevelopment

Morning Dew by Alvin Ashcraft – Daily links for Windows and .NET developers.Mar 26, 2026

Dew Drop – March 26, 2026 (#4633)

Daily LinksDevelopment

Morning Dew by Alvin Ashcraft – Daily links for Windows and .NET developers.Mar 17, 2026

Dew Drop – March 17, 2026 (#4626)

Daily LinksDevelopment

Morning Dew by Alvin Ashcraft – Daily links for Windows and .NET developers.Mar 12, 2026

Dew Drop – March 12, 2026 (#4623)

Daily LinksDevelopment