MySQL

PostgreSQL vs. MySQL

PostgreSQL vs. MySQL

  • Know-how

Many web developers will already be familiar with MySQL as a relational database management system (RDBMS). Those managing more professional projects may be aware of its powerful competitor PostgreSQL. But did you know the latter is an object-relational database management system (ORDBMS)? Find out what this difference means in practical terms.

PostgreSQL vs. MySQL
MySQL Tutorial

MySQL Tutorial

  • Know-how

Along with Oracle and Microsoft SQL server, MySQL is one of the most popular management systems for relational databases. Nowadays the software developed by MySQL AB belongs to the product portfolio of the Oracle Corporation and is proprietarily marketed under a dual license. Since 2009, an open source MySQL fork, known as MariaDB, has also been available from the original developers. Here we give…

MySQL Tutorial
How to Use PostgreSQL with Your Ruby on Rails Application on Ubuntu 16.04

How to Use PostgreSQL with Your Ruby on Rails Application on Ubuntu 16.04

  • Know-how

Learn how to use PostgreSQL with your Ruby on Rails application, instead of the default SQLite database. SQLite is an easy-to-configure, lightweight product which ships with Ruby on Rails by default. However, PostgreSQL is a more robust solution which provides more advanced features, scaling, and stability, which may make it more suitable for your Ruby on Rails project.

How to Use PostgreSQL with Your Ruby on Rails Application on Ubuntu 16.04
XAMPP tutorial: installation and first steps

XAMPP tutorial: installation and first steps

  • Tools

The software packet XAMPP is a collection of popular applications like the web server Apache, a leading database management system (either MySQL or MariaDB), the scripting languages PHP and Perl, and more – all together in a compact test server. Our XAMPP tutorial will take you through the installation and configuration process, with the aid of clear instructions and screenshots, to help you set…

XAMPP tutorial: installation and first steps
How to check and update your MySQL version

How to check and update your MySQL version

  • Technical matters

Your database management system is not always kept up to date automatically. If this is the case, you should definitely perform the necessary steps manually for the sake of security. We’ll explain how you can check your MySQL version and what steps you can take to bring it up to date.

How to check and update your MySQL version
SQL injection

SQL injection

  • Security

There are daily reports on how security gaps in applications are exploited – because hardly a day goes by without a new gap being discovered or a known gap being closed. One attack method, which has always been based on exploiting such weak points, is called SQL injection. But what is actually hidden behind the malicious database exploitation and how can you protect your database system from it?

SQL injection
How to backup databases

How to backup databases

  • Security

Backing up your data is a popular option for securing your database. In order to create backup copies, you need additional hardware and to install a suitable backup structure. How do you secure your own network and web server against attacks and proceed to protect your databases?

How to backup databases
MySQL

MySQL

  • Know-how

Databases are required for almost every web application. Whether you want to manage and store customer or employee data, there’s hardly any way around a database. And with MySQL, creating databases is super easy. Let’s take a closer look at what MySQL is, its features, and application areas.

MySQL
MySQL vs. MongoDB, which database is better?

MySQL vs. MongoDB, which database is better?

  • Technical matters

Would you rather relational database management or a flexible NoSQL solution? When choosing the right tool for your data, it’s worth comparing MongoDB vs. MySQL. We’ll show you how the two software solutions differ from each other, what advantages and disadvantages they offer and who could win the MySQL vs. MongoDB duel.

MySQL vs. MongoDB, which database is better?
How to replace substrings with MySQL REPLACE

How to replace substrings with MySQL REPLACE

  • Technical matters

Even when you’re careful, spelling errors in a table can’t always be avoided. Outdated information can also creep in. The solution is MySQL REPLACE. This command lets you to replace substrings in a string and quickly fix errors. We’ll show you how it works and how MySQL REPLACE is structured.

How to replace substrings with MySQL REPLACE
We use cookies on our website to provide you with the best possible user experience. By continuing to use our website or services, you agree to their use. More Information.