TIL: If you try to manually INSERT a row into a MySQL table and set an AUTO_INCREMENT column to 0, MySQL ignores the provided value and assumes you want the next increment amount.
Found this whilst migrating a legacy database to a new structure, where the legacy database had foreign keys (not actually defined as constraints) with 0 values.
You can control this with NO_AUTO_VALUE_ON_ZERO in sql_mode (it's on by default I think).
We’re most pleased to announce the release of dbplyr 2.5.0!
dbplyr is a database backend for dplyr that allows you to use a remote database as if it were a collection of local data frames. dbplyr 2.5.0 introduces succinct new syntax for literal table identifiers.
📢 This week: "Recovering from Data Loss Despite Not Having a Backup: A Postgres True Story" 📆 Friday March 15 at 17:00, Ballroom H @ #SCaLE21x — see you there!
It’s official 🐘 I am on my way ✈️ to @nordicpgday & #pgDayParis—and I am so excited 🎉🥳 to see some of my #PostgreSQL favorites—and to meet new ppl in the PG community too.
At Nordic I will give a beginners guide talk about partitioning & sharding—and in Paris I’ll give a lightning talk about fighting the butterflies & giving your first Postgres conference talk.
The language injections feature continues to be one of the slickest features of #JetBrains IDEs, and I'm so happy to see it works flawlessly in #RustRover.
If you're working with #databases in #rust, check this out. It helps you catch silly spelling errors by validating SQL against a schema.
👋 Valued contacts in IT and specifically in the #PostgreSQL / #Database community: I'd love it if you could reach out to me with insights or stories to tell regarding 🧠 mental health in the #IT#workplace. Many thanks in advance 🙏