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­form­a­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­plic­a­tions using MySQL or MariaDB. Our article provides a step-by-step guide to identi­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­gr­eSQL al­tern­at­ives?

While Post­gr­eSQL offers ro­bust­ness and security, if you’re looking for speed or a non-re­la­tion­al approach, al­tern­at­ive solutions are worth con­sid­er­ing. We’ll explore al­tern­at­ives to Post­gr­eSQL 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­is­on in the open-source database world. MariaDB is a powerful client-server system, while SQLite is a light­weight library that runs inside ap­plic­a­tions. Knowing the strengths and limits of MariaDB and SQLite helps de­velopers and busi­nesses…

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­form­ance, strong data integrity and re­li­ab­il­ity, while MongoDB takes a document-oriented approach with sche­ma­less storage, built-in scalab­il­ity and flexible data modelling. 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 found­a­tion for database-driven ap­plic­a­tions. MariaDB delivers fast, flexible data pro­cessing, while RHEL 9 offers a stable en­vir­on­ment that’s easy to maintain. In­stall­a­tion and setup are straight­for­ward, even for users with limited ex­per­i­ence of…

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­ciently, 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 Kuber­netes

Deploying MariaDB on Kuber­netes offers many ad­vant­ages. You can easily start, stop and scale the database. With State­ful­Sets and Per­sist­ent­Volumes, your database remains stable even during restarts. In­teg­ra­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­form­ance. The dis­tri­bu­tion, derived from Red Hat En­ter­prise Linux (RHEL), provides a com­pat­ible platform with long-term support. Together with MariaDB, it offers a reliable en­vir­on­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­is­on?

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­sidered the standard solution for re­la­tion­al databases. However, MariaDB is becoming an at­tract­ive al­tern­at­ive. We compare both systems and…

Read more