Databases

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 Secure MongoDB on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Secure MongoDB on Ubuntu 18.04

MongoDB doesn’t have authentication enabled by default, meaning that any user with access to the server where the database is installed can add and delete data without restriction. In order to secure this vulnerability, this tutorial will walk you through creating an administrative user and enabling authentication. You’ll then test to confirm that only this administrative user has access to the database.

Read more
How To Get Total Result Count in Laravel Eloquent — step-by-step Programming tutorial on Progressive Robot

How To Get Total Result Count in Laravel Eloquent

When working with database query results, it is often useful to obtain only the total number of rows in a result set, instead of pulling the full dataset content with a regular query. Eloquent offers a few different aggregate methods that return a scalar value instead of an Eloquent object, such as count(), max(), and sum(). In this part of the series, you’ll update the main application view to show the total number of links in each list, using the count() method.

Read more
CHAT