Databases

How To Use PostgreSQL with Your Ruby on Rails Application on Ubuntu 20.04 — step-by-step Linux tutorial on Progressive Robot

How To Use PostgreSQL with Your Ruby on Rails Application on Ubuntu 20.04

A PostgreSQL database is a robust and flexible choice for your Ruby on Rails application. In this tutorial, you will set up a Ruby on Rails development environment connected to a PostgreSQL database on an Ubuntu 20.04 server. You will install and configure PostgreSQL, then test your setup by creating a Rails application that uses PostgreSQL as its database server.

Read more
What is MongoDB? — step-by-step Databases tutorial on Progressive Robot

What is MongoDB?

MongoDB, also known as Mongo, is an open-source document database used in many modern web applications. It is classified as a NoSQL database because it does not rely on a traditional table-based relational database structure.

Read more
How To Analyze Managed PostgreSQL Database Statistics Using the Elastic Stack on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Analyze Managed PostgreSQL Database Statistics Using the Elastic Stack on Ubuntu 18.04

Database monitoring is the continuous process of systematically tracking various metrics that show how the database is performing. By observing the performance data, you can gain valuable insights and identify possible bottlenecks, as well as find additional ways of improving database performance. In this tutorial, you’ll import database metrics, generated by the PostgreSQL statistics collector, into Elasticsearch via Logstash.

Read more
How To Configure Remote Access for MongoDB on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Configure Remote Access for MongoDB on Ubuntu 18.04

This tutorial walks you through configuring a MongoDB installation to securely allow access from a trusted remote computer. This will involve updating your firewall rules to provide the remote server access to MongoDB’s default port and changing Mongo’s configuration file to update its IP binding setting.

Read more
How To Create Artisan Commands To Manage Database Records in Laravel — step-by-step Programming tutorial on Progressive Robot

How To Create Artisan Commands To Manage Database Records in Laravel

If you followed along with this series so far, your database tables should be all set by now. However, you still need to implement a way to let users insert new entries in the links table. In this guide, we’ll create Artisan commands to manage database records on your application. At the end, you’ll be able to create, list, and delete links in the database using command-line Artisan commands.

Read more
CHAT