Pointer

This article discusses the concept of upsert in SQL and explains how it works in different database management systems (DBMS) like MySQL, SQLite, and PostgreSQL. It provides examples and code snippets for each DBMS to demonstrate the various ways to perform upsert operations.

Upsert in SQL

freeCodeCamp

The SQL Handbook is a free and open text-based handbook for Web Developers. Try the interactive version of this SQL course on Boot.dev, complete with coding challenges and projects. Watch the video walkthrough of this course on FreeCodeCamp's YouTube channel.

The SQL Handbook – A Free Course for Web Developers

Fly.io

Skip the API, Ship Your Database, and LiteFS Cloud: managed backups and point-in-time restores for LiteFS. LiteFS uses a program called Corrosion that gossips state between all our servers. It tracks VM statuses, health checks, and a plethora of other information for each server.

Skip the API, Ship Your Database

SQLite is a lightweight, serverless, and self-contained SQL database engine that is embedded directly into applications. It is widely used in mobile and desktop applications for local storage and offline access to structured data. Readers can learn how SQLite provides a reliable and efficient solution for data storage in applications with features such as zero configuration, small footprint, and transactional integrity, making it suitable for embedded and standalone applications.

Best of SQLite — September 2023