Upserts are useful for anyone who works with a database to know, but the term "upsert" might not even appear in your DBMS's documentation!
So what is an upsert, and why might it not be mentioned in your docs?
6 Things Startups Can Do to Avoid Tech Debt
Imagine walking into this: "About 4 million lines of PHP code, written by underpaid, sometimes not well-meaning, freelancers and students over the span of 8 years. The CEO wrote a large part, but stopped learning new techniques around 2004."
That's how bad tech debt can get when a startup is run without considering that all of those messy shortcuts will eventually have to get cleaned up.
What Is a UUID and Why Should You Care?
When working with a database, it's common practice to use some kind of id field to provide a unique identifier for each row in a table.
Imagine, for example, a customers table. We wouldn't want to use fields such as name or address as unique identifiers, for example, because it's possible more than one customer could have the same name, or share the same address.