Database

Image: How to fetch data with PHP mysqli_query?Virrage Imagesshut­ter­stock

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 con­nect­ing to a MySQL/MariaDB database, re­triev­ing in­for­ma­tion from a simple table with `PHP…

Read more
Image: How to fix “error establishing a database connection” in MySQL/MariaDBOllyyshut­ter­stock

How to fix “error es­tab­lish­ing a database con­nec­tion” in MySQL/MariaDB

The “error es­tab­lish­ing a database con­nec­tion” often blocks access to websites and ap­pli­ca­tions using MySQL or MariaDB. Our article provides a step-by-step guide to iden­ti­fy­ing and fixing the cause. Learn how to check cre­den­tials, reset passwords, and test con­nec­tions from the…

Read more
Image: What are the top 6 PostgreSQL alternatives?REDPIXEL.PLShut­ter­stock

What are the top 6 Post­greSQL al­ter­na­tives?

While Post­greSQL offers ro­bust­ness and security, if you’re looking for speed or a non-re­la­tion­al approach, al­ter­na­tive solutions are worth con­sid­er­ing. We’ll explore al­ter­na­tives to Post­greSQL 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 Ongkan­tongShut­ter­stock

What are the dif­fer­ences between MariaDB and SQLite?

MariaDB vs SQLite is a frequent com­par­i­son in the open-source database world. MariaDB is a powerful client-server system, while SQLite is a light­weight library that runs inside ap­pli­ca­tions. Knowing the strengths and limits of MariaDB and SQLite helps de­vel­op­ers and busi­ness­es…

Read more
Image: MariaDB vs. MongoDB: How do they compare?Titima Ongkan­tongShut­ter­stock

MariaDB vs. MongoDB: How do they compare?

MariaDB vs MongoDB – which database is the better fit for your project? MariaDB delivers proven SQL per­for­mance, strong data integrity and re­li­a­bil­i­ty, while MongoDB takes a document-oriented approach with schema­less storage, built-in scal­a­bil­i­ty and flexible data modeling. In…

Read more
Image: How to install MariaDB on RHEL 9Titima Ongkan­tongShut­ter­stock

How to install MariaDB on RHEL 9

MariaDB and RHEL 9 create a solid foun­da­tion for database-driven ap­pli­ca­tions. MariaDB delivers fast, flexible data pro­cess­ing, while RHEL 9 offers a stable en­vi­ron­ment that’s easy to maintain. In­stal­la­tion and setup are straight­for­ward, even for users with limited ex­pe­ri­ence in…

Read more
Image: How to install MariaDB on Ubuntu 24.04Titima Ongkan­tongShut­ter­stock

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 ef­fi­cient­ly, supports trans­ac­tions and allows multiple user accounts with clearly defined rights. Ubuntu 24.04 provides a…

Read more
Image: How to install MariaDB via KubernetesTitima Ongkan­tongShut­ter­stock

How to install MariaDB via Ku­ber­netes

Deploying MariaDB on Ku­ber­netes offers many ad­van­tages. You can easily start, stop and scale the database. With State­fulSets and Per­sis­tentVol­umes, your database remains stable even during restarts. In­te­gra­tion via an internal service allows secure access to MariaDB for other…

Read more
Image: How to install MariaDB on AlmaLinux 9Titima Ongkan­tongShut­ter­stock

How to install MariaDB on AlmaLinux 9

MariaDB runs smoothly on AlmaLinux 9 with minimal effort and reliable per­for­mance. The dis­tri­b­u­tion, derived from Red Hat En­ter­prise Linux (RHEL), provides a com­pat­i­ble platform with long-term support. Together with MariaDB, it offers a reliable en­vi­ron­ment for database-driven…

Read more
Image: What are the key differences in a MariaDB vs. MySQL comparison?kentohShut­ter­stock

What are the key dif­fer­ences in a MariaDB vs. MySQL com­par­i­son?

MySQL is one of the most widely used database man­age­ment systems worldwide. The open-source software has been available since 1995 and is con­sid­ered the standard solution for re­la­tion­al databases. However, MariaDB is becoming an at­trac­tive al­ter­na­tive. We compare both systems and…

Read more