Databases

How To Implement Caching in Node.js Using Redis — step-by-step Databases tutorial on Progressive Robot

How To Implement Caching in Node.js Using Redis

Redis is an in-memory database that stores data in the server memory and a popular tool to cache data. You can connect to Redis in Node.js using the node-redis module, which gives you methods to retrieve and store data in Redis. You’ll build an Express app to retrieve data from a RESTful API using the axios module, modifying the app to store the data in Redis using the node-redis module. You will also use Express middleware to cache data.

Read more
How To Use MySQL Query Profiling — step-by-step Databases tutorial on Progressive Robot

How To Use MySQL Query Profiling

MySQL query profiling is a useful technique when trying to analyze the overall performance of a database driven application. When developing a mid to large size application, there tends to be hundreds of queries distributed throughout a large code base. This article will demonstrate some useful query profiling techniques using tools that are built into MySQL server.

Read more
Managed Databases Connection Pools and PostgreSQL Benchmarking Using pgbench — step-by-step Databases tutorial on Progressive Robot

Managed Databases Connection Pools and PostgreSQL Benchmarking Using pgbench

In this tutorial we’ll use `pgbench`, PostgreSQL’s built-in benchmarking tool, to run load tests on a the cloud provider Managed PostgreSQL Database. We’ll dive in to connection pools, describe how they work, and show how to create one using the Cloud Control panel. Finally, using results from the `pgbench` tests, we’ll demonstrate how using a connection pool can be an inexpensive method of increasing database throughput.

Read more
CHAT