Database

Image: Managed cloud hostingagsandrewshut­ter­stock

Managed cloud hosting

More and more website operators are turning to managed cloud hosting as a solution for their server en­vi­ron­ment. This option promises flexible scal­a­bil­i­ty of required resources in real time, along with a wide range of services offered by the provider including the in­stal­la­tion,…

Read more
Image: Use PHP to Insert Information Into a MySQL/MariaDB Database From an HTML FormGoro­denkoffshut­ter­stock

Use PHP to Insert In­for­ma­tion Into a MySQL/MariaDB Database From an HTML Form

A PHP script is a con­ve­nient way to accept in­for­ma­tion submitted from a website's HTML form and insert it into a MySQL/MariaDB database. This tutorial will cover how to create a basic PHP script for inserting data, and an HTML form to take user input from a webpage and pass it to…

Read more
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: 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: 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 alternatives to SQL are there?Wright Studioshut­ter­stock

What al­ter­na­tives to SQL are there?

In terms of databases, al­ter­na­tives to the SQL approach have existed for quite some time. The ad­van­tages of a re­la­tion­al system shouldn’t be over­looked though. In fact, it might be exactly what your project requires. Here, we’ll go over which NoSQL solutions are worth con­sid­er­ing…

Read more
Image: How to perform a MariaDB backup to secure your dataTitima Ongkan­tongShut­ter­stock

How to perform a MariaDB backup to secure your data

A reliable backup is crucial for the smooth operation of MariaDB. Errors during updates, hardware failures or security incidents can put your data at risk, po­ten­tial­ly causing complete data loss. To avoid this, it's important to regularly create backups and test them. MariaDB…

Read more
Image: How to install MariaDB on WindowsTitima Ongkan­tongShut­ter­stock

How to install MariaDB on Windows

In­stalling MariaDB on Windows is straight­for­ward and can be completed in just a few steps. The setup wizard guides you through each stage. Once installed, you’ll have a fully func­tion­al database server ready to go. You can execute queries, store data and manage users with ease.…

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 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