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.
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…
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.
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…
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.
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?
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?
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.
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.
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.
