Engines & Performance articles

Engines & Performance 405 What time the server is on, and why PHP and MySQL can disagree A form that records the wrong time, an order dated yesterday, a scheduled job firing two hours early - it is nearly...
Engines & Performance 254 MySQL or MariaDB: which one runs here, and does it matter Shared hosting here runs MariaDB, not Oracle’s MySQL Server. At the time of writing the version is 10.11.16. For...
Engines & Performance 239 Installing PostgreSQL on a VPS On a VPS running Ubuntu 22.04 LTS, as root, you install PostgreSQL with apt install postgresql postgresql-contrib....
Engines & Performance 218 Creating a PostgreSQL user and database, and connecting with psql On a VPS with PostgreSQL already installed, enter as the system user postgres with sudo -u postgres psql, then...
Engines & Performance 239 PostgreSQL in cPanel: creating a database and connecting from PHP On shared hosting PostgreSQL 13.23 is active and has tools in cPanel. Create the database and user under PostgreSQL...
Engines & Performance 235 PostgreSQL or MySQL: which one for your project If you are installing WordPress, Joomla, PrestaShop or another ready-made application, use MySQL (here, MariaDB):...
Engines & Performance 246 Character sets: utf8mb4, collation, and the question marks in your text If accented text shows up as ??? or as é instead of é, the database, the connection and the page are not speaking...
Engines & Performance 233 Slow queries: how to find them and the fixes that work most often A site that is slow because of the database almost always has one or two queries doing all the work, and the most...
Engines & Performance 218 SQLite or MySQL: which one fits a small project The short answer: SQLite fits a small application with few users writing at the same time and nobody from outside...
Engines & Performance 242 MongoDB on a VPS: install it, lock it down, and why not to expose it The short answer: MongoDB is a database that stores documents (like JSON) instead of tables. It is not part of...
Engines & Performance 228 Tuning MariaDB on a VPS: the few settings worth changing, and how to measure The short answer: MariaDB already comes with reasonable values. Tuning only pays when you have measured that the...