Databases

How To Optimize MySQL with Query Cache on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Optimize MySQL with Query Cache on Ubuntu 18.04

Query cache is a prominent MySQL feature that speeds up data retrieval from a database. In this tutorial, you will first configure MySQL without query cache and run queries to see the duration results. Then you’ll set up query cache and test your MySQL server with it enabled to show the difference in performance.

Read more
How To Use an SQLite Database in a Flask Application — step-by-step Databases tutorial on Progressive Robot

How To Use an SQLite Database in a Flask Application

In web applications, you usually need a database, which is an organized collection of data. SQLite is a simple and fast open source SQL engine that can be used with Python to store and manipulate application data. SQLite works well with Python because the Python standard library provides the sqlite3 module, which you can use to interact with any SQLite database. In this tutorial, you’ll build a small web application that demonstrates how to use SQLite with Flask.

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

How To Use Schema Validation in MongoDB

In MongoDB, the database engine feature that makes it possible to apply constraints on the document structure is called Schema Validation and is built around JSON Schema, an open standard for JSON document structure description & validation. In this tutorial, you’ll learn about schema validation and format requirements in MongoDB, and how to apply these to control structure of documents in a database.

Read more
What is the Relational Model? — step-by-step DevOps tutorial on Progressive Robot

What is the Relational Model?

The relational model is an abstract model used to organize data within a database. In order to control access to a database, write data, run queries, or perform any other tasks related to database management, a database management system must have some kind of underlying model that defines how…

Read more
CHAT