GorodenkoffshutterstockA PHP script offers a simple and effective way to take information submitted through a website’s HTML form and store it in a MySQL or MariaDB database. This tutorial walks you through the basics of adding form data to your database, including how to create a straightforward PHP…
deepadesignsshutterstockMariaDB originated in 2009 as a fork of MySQL after Oracle acquired Sun Microsystems and with it, MySQL. The development team aimed to provide a completely open-source and community-based alternative. In this guide, you’ll learn about the features offered by MariaDB, the…
G-Stock StudioshutterstockMariaDB proves to be a robust SQL solution for many projects and is used for classic web applications, data-intensive business workloads, and transactional e-commerce platforms. However, depending on project requirements, other solutions might be better suited. In this guide, we…
UndreyShutterstockA MariaDB Galera cluster is a highly available and distributed database cluster that uses Galera technology for data replication. All nodes in the cluster are of equal value and can process read and write operations simultaneously. Thanks to multi-master replication and automatic…
GorodenkoffShutterstockThe Connector/Python module is a practical way to connect to MariaDB databases, execute queries and manage results. Many web apps use MariaDB as a backend database. You can also connect Python web frameworks like Flask or Django with MariaDB. In this tutorial, we explain step by…
GorodenkoffshutterstockWith SHOW TABLES, MariaDB allows you to list all tables within a database, making it easier to access or delete tables. In this article, we’ll take a look at the structure of this MariaDB statement and how to use it. Using simple examples, we’ll also show you how to filter…
Stock-AssoshutterstockTo permanently delete one or more tables in MariaDB, the `DROP TABLE` command can be used. Because the command irrevocably removes specified tables, it should only be accessible to authorized users. In this dedicated article, we will explain more about the command and its options…
Maksim KabakouShutterstockWhen working with several tables, it’s often necessary to combine data records. In MariaDB, you can use the JOIN statement to do this. In this article, we explain how the command works and how the different variants INNER JOIN, LEFT OUTER JOIN and RIGHT OUTER JOIN differ from…
Mr. KosalshutterstockIf a database is no longer required, it’s advisable to delete it from the server. In MariaDB, the command to do this is DROP DATABASE. Since this command permanently removes the database, it should only be used after thorough consideration, as it will also delete all tables and…
REDPIXEL.PLShutterstockIf you want to create a new database using the free and open-source relational database management system MariaDB, you can use the CREATE DATABASE command. This article provides a detailed explanation of how the command functions and explores various optional parameters that can…