Articles

For side-by-side syntax and behavior across database engines, browse the cross-database SQL comparison guides.

How to Install PostgreSQL on Ubuntu 24.04 LTS

Install Ubuntu’s PostgreSQL 16 package or PostgreSQL 18 from PostgreSQL’s official APT repository on Ubuntu 24.04 LTS, then verify the server.

How to Install MariaDB 12.3 LTS on Debian 13

Install MariaDB 12.3 LTS on Debian 13 (Trixie) from MariaDB’s APT repository, verify the server, and create a local application database.

How to Install MariaDB 12.3 LTS on Ubuntu 26.04

Install MariaDB 12.3 LTS on Ubuntu 26.04 from MariaDB’s APT repository, verify the server, and create a local application database.

How to Install PostgreSQL on Debian 13 (Trixie)

Install PostgreSQL on Debian 13 from Debian’s repository or PGDG, choose PostgreSQL 18, create a database role, and verify the server.

How to Install MySQL 9.7 LTS on Fedora 44

Install MySQL 9.7 LTS on Fedora 44 x86_64, verify Oracle’s DNF repository, set the root password, and check the server version.

How to Install MySQL 9.7 LTS on Debian 13

Install MySQL 9.7 LTS on Debian 13 (Trixie), confirm APT is using Oracle’s repository, and verify the server and connection.

SQL Server UPSERT: Insert or Update a Row

Learn a SQL Server insert-or-update pattern with a transaction, UPDLOCK, and SERIALIZABLE, plus when MERGE fits and how unique keys protect data.

SQLite UPSERT: ON CONFLICT DO UPDATE Examples

Learn SQLite ON CONFLICT DO UPDATE and DO NOTHING with runnable UPSERT examples, excluded values, and unique constraint caveats.

Install MariaDB on openSUSE with zypper

Install MariaDB Server on openSUSE with zypper, start its systemd service, secure the local instance, and create a database and user.

Install PostgreSQL on Ubuntu 26.04 LTS

Install PostgreSQL on Ubuntu 26.04 LTS, create an application role and database, or choose a major version from PGDG; verify the service and connect with psql.