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