Ruby on Rails uses SQLite as its database by default, but it also supports the use of MySQL. SQLite is an excellent alternative to a traditional database like MySQL, but it has some limitations, particularly with regards to concurrency and scaling to a high load, which may make MySQL a better choice for your project.
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.
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.
Over the past few years, Joomla has established itself as one of the most popular content management systems. This is thanks to its extensive basic functions and large number of extensions developed by the Joomla community. Its functions and design modifications give Joomla projects the crucial final flourishes and even enable you to run an online shop on this open source CMS.
MySQL is the most used database management system in the world. This open source software has been available for productive use since 1995 and is generally considered a standard solution for users of relational databases. This could change in the near future. MariaDB, a community-developed fork of MySQL is catching up on its predecessor and is consequently becoming an increasingly attractive...
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?
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...
While most content management systems are based on the PHP scripting language, Alchemy CMS uses a less common but more dynamic programming language: Ruby. There are also countless add-ons available from Ruby on Rails that can help to extend your web framework to create complex projects like company websites or online shops. Find out what makes this intuitive CMS a good bet for beginners.
The CMS, papaya, is lauded by its developers as a high performance content management system – a fully justified claim, considering the software’s wide range of smart and powerful functions. But is papaya CMS a viable option for any web project? And what exactly are this program’s strengths and weaknesses?
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...