Databases

How To Install WordPress with Caddy on Ubuntu 16.04 — step-by-step Linux tutorial on Progressive Robot

How To Install WordPress with Caddy on Ubuntu 16.04

WordPress is a CMS that can be used to set up blogs and websites quickly and easily. In this guide, we’ll set up WordPress with Caddy. Caddy is a new web server quickly gaining popularity for its wide array of unique features, like HTTP/2 support and automatic TLS encryption with Let’s Encrypt, a popular free certificate provider.

Read more
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
CHAT