Database

Use PHP to Insert Information Into a MySQL/MariaDB Database From an HTML Form
Use PHP to Insert Information Into a MySQL/MariaDB Database From an HTML Form
  • Web development

A PHP script is a convenient way to accept information 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 the PHP script.

Use PHP to Insert Information Into a MySQL/MariaDB Database From an HTML Form
Establishing a database connection MySQLMariaDB error
"Error establishing a database connection" MySQL/MariaDB error
  • Know-how

Learn how to fix "Error establishing a database connection” for MySQL/MariaDB on a Linux Server. With this guide you can easily fix the error for MySQL and MariaDB.

"Error establishing a database connection" MySQL/MariaDB error
Use PHP to Retrieve Information From a MySQL-MariaDB Database
Use PHP to Retrieve Information From a MySQL/MariaDB Database
  • Web development

PHP is designed to easily integrate into a website. One of the most common uses for PHP is to take content from a database and output it on an HTML page. This tutorial will cover how to connect to a MySQL/MariaDB database, pull out information from a simple table, and display it in a simple HTML table.

Use PHP to Retrieve Information From a MySQL/MariaDB Database
UML: activity diagram
Activity diagrams: clearly present chronological activity processes with UML
  • Web development

UML activity diagrams help you to graphically illustrate the chronological sequence of system processes in object-oriented programming. They show which actions take place in which order to execute an activity. With a finished diagram, you can create code frames using XML transfer. Or do you want to map business processes? We show examples of how to create an activity diagram, which symbols belong...

Activity diagrams: clearly present chronological activity processes with UML
Memcached vs. Redis
Memcached vs. Redis: a comparison
  • Technical matters

If you’re looking for a powerful open-source solution for in-memory data storage, you’ll almost certainly find yourself asking “Memcached or Redis”? The two databases have a lot in common, but there are some fundamental differences too. Read on to find out which system best meets your requirements.

Memcached vs. Redis: a comparison
Creating backups with MySQLDumper
MySQLDumper: from installation to backup
  • Technical matters

“Data is the new oil!”. So when it comes to online businesses, loss of data means loss of capital. Important and sensitive data should be backed up at regular intervals. Thanks to free programs such as MySQLDumper you can create MySQL database backups in minutes! Once installed, you can use the software to automatize and administer backups.

MySQLDumper: from installation to backup
What is InnoDB?
InnoDB – the best storage engine for MySQL?
  • Technical matters

InnoDB is currently the default storage engine for MySQL and is recommended for most use cases. The company behind it was acquired by Oracle Systems a number of years ago, and the software is known in particular for being a transaction-safe storage engine. In this article, we’re going to look at some of the features of InnoDB and how it’s different from MyISAM, the previous software.

InnoDB – the best storage engine for MySQL?
Apache Cassandra
Apache Cassandra: distributed management of large databases
  • Technical matters

Apache Cassandra is a column-oriented database management system based on NoSQL. It offers options for horizontal scaling so that you can add any number of individual nodes. Cassandra was originally developed for Facebook, but it is now used by many social networks and scientific institutions that manage large amounts of data. In the following article, we’ll introduce you to this system.

Apache Cassandra: distributed management of large databases
MariaDB Galera Clusters
Galera Cluster for MariaDB: an overview
  • Technical matters

When it comes to running and managing a Database Management System, synchronizing all the interlinked databases is one of the most important and one of the most laborious tasks. However, if you use MariaDB, the Galera Cluster software for Linux can help with this task. It works by distributing database transactions to all the specified servers in real time, optimizing use of resources in the...

Galera Cluster for MariaDB: an overview