Database

Image: How to fetch data with PHP mysqli_query?Virrage Imagesshutterstock

How to fetch data with PHP mysqli_query?

PHP is designed to integrate easily into a website. One of the most common uses of PHP is to fetch content from a database and display it on an HTML page. This tutorial covers connecting to a MySQL/MariaDB database, retrieving information from a simple table with `PHP…

Read more
Image: How to fix “error establishing a database connection” in MySQL/MariaDBOllyyshutterstock

How to fix “error establishing a database connection” in MySQL/MariaDB

The ‘error establishing a database connection’ often blocks access to websites and applications using MySQL or MariaDB. Our article provides a step-by-step guide to identifying and fixing the cause. Learn how to check credentials, reset passwords, and test connections from the…

Read more
Image: What are the top 6 PostgreSQL alternatives?REDPIXEL.PLShutterstock

What are the top 6 PostgreSQL alternatives?

While PostgreSQL offers robustness and security, if you’re looking for speed or a non-relational approach, alternative solutions are worth considering. We’ll explore alternatives to PostgreSQL and outline their benefits so you can find the one that is ideal for your project and…

Read more
Image: What are the differences between MariaDB and SQLite?Titima OngkantongShutterstock

What are the differences between MariaDB and SQLite?

MariaDB vs SQLite is a frequent comparison in the open-source database world. MariaDB is a powerful client-server system, while SQLite is a lightweight library that runs inside applications. Knowing the strengths and limits of MariaDB and SQLite helps developers and businesses…

Read more
Image: MariaDB vs. MongoDB: How do they compare?Titima OngkantongShutterstock

MariaDB vs. MongoDB: How do they compare?

MariaDB vs MongoDB – which database is the better fit for your project? MariaDB delivers proven SQL performance, strong data integrity and reliability, while MongoDB takes a document-oriented approach with schemaless storage, built-in scalability and flexible data modelling. In…

Read more
Image: How to install MariaDB via DockerTitima OngkantongShutterstock

How to install MariaDB via Docker

With Docker, you can set MariaDB up in just a few steps and avoid complex local installation. The database runs in isolation from the rest of the system, preventing conflicts when testing different versions. You can back up and restore data as needed to create a flexible,…

Read more
Image: How to install MariaDB on RHEL 9Titima OngkantongShutterstock

How to install MariaDB on RHEL 9

MariaDB and RHEL 9 create a solid foundation for database-driven applications. MariaDB delivers fast, flexible data processing, while RHEL 9 offers a stable environment that’s easy to maintain. Installation and setup are straightforward, even for users with limited experience of…

Read more
Image: How to install MariaDB on Ubuntu 24.04Titima OngkantongShutterstock

How to install MariaDB on Ubuntu 24.04

On Ubuntu 24.04 you can install MariaDB directly through the package manager, then secure access and start the service. MariaDB processes data reliably and efficiently, supports transactions and allows multiple user accounts with clearly defined rights. Ubuntu 24.04 provides a…

Read more
Image: How to install MariaDB via KubernetesTitima OngkantongShutterstock

How to install MariaDB via Kubernetes

Deploying MariaDB on Kubernetes offers many advantages. You can easily start, stop and scale the database. With StatefulSets and PersistentVolumes, your database remains stable even during restarts. Integration via an internal service allows secure access to MariaDB for other…

Read more
Image: How to install MariaDB on AlmaLinux 9Titima OngkantongShutterstock

How to install MariaDB on AlmaLinux 9

MariaDB runs smoothly on AlmaLinux 9 with minimal effort and reliable performance. The distribution, derived from Red Hat Enterprise Linux (RHEL), provides a compatible platform with long-term support. Together with MariaDB, it offers a reliable environment for database-driven…

Read more