SQL Doldrums: transactions

UPDATE pages SET n_comments = n_comments + 1 WHERE id = 2;
  1. Configure your database system specifically for your news app. For instance, turn off automatic fsync. (In practice, this can be very hard — especially if you run two apps that need different things, or if you share your project with other developers.)
  2. Don’t use SQL. (In practice, this is often easy.)

--

--

--

Journalist, ex software engineer

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Adam Hooper

Adam Hooper

Journalist, ex software engineer

More from Medium

Introduction to SQL

Introduction to SQL

RabbitMQ Server And Clustering Setup on Ubuntu 18.04

SQL vs NoSQL, Which is better?

How I learn Structured Query Language (SQL)