Databases

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
How To Create Queries in MongoDB — step-by-step Databases tutorial on Progressive Robot

How To Create Queries in MongoDB

MongoDB provides a robust query mechanism that makes it straightforward to define filtering criteria when retrieving documents. In this tutorial, you’ll learn how to query MongoDB collections using a different range of filters and conditions. You will also learn what cursors are and how to use them within the MongoDB shell.

Read more
CHAT