Databases

How To Use Indexes in MongoDB — step-by-step Databases tutorial on Progressive Robot

How To Use Indexes in MongoDB

Indexes are one of the most essential tools the database administrator can use to consciously aid the database engine and improve its performance. In this tutorial, you’ll learn what indexes are, how to create them and check if they are used when querying the database.

Read more
How To Use SQLite with Node.js on Ubuntu 22.04 — step-by-step Linux tutorial on Progressive Robot

How To Use SQLite with Node.js on Ubuntu 22.04

In this tutorial, readers will use node-sqlite3 to create a connection with an SQLite database. Next, they’ll create a Node.js app that creates a table and insert data into the database. Finally, they’ll modify the app to use node-sqlite3 to retrieve, update, and delete data from the database.

Read more
How To Use Transactions in MongoDB — step-by-step Databases tutorial on Progressive Robot

How To Use Transactions in MongoDB

Though they were a staple feature of relational database management systems for many years, ACID transactions are a relatively new feature in MongoDB. This tutorial explains what transactions are and how you can initiate and commit them in a MongoDB database. It also provides an overview of the ACID principles required for any transaction: atomoicity, consistency, isolation, and durability.

Read more
Understanding Database Sharding — step-by-step DevOps tutorial on Progressive Robot

Understanding Database Sharding

Sharded databases have been receiving lots of attention in recent years, but many don’t have a clear understanding of what they are or the scenarios in which it might make sense to shard a database. This conceptual article goes over what sharding is, some of its main benefits and drawbacks, and also a few common sharding methods.

Read more
CHAT