Databases

How To Optimize Queries and Tables in MySQL and MariaDB on a VPS — step-by-step Databases tutorial on Progressive Robot

How To Optimize Queries and Tables in MySQL and MariaDB on a VPS

MySQL and MariaDB are popular database management systems that can be used in conjunction with an application or a website. While the querying syntax is easy to learn and very powerful, some operations take a long time. This article will discuss some steps you can take to optimize your queries and table structure.

Read more
How To Use Many-to-Many Database Relationships with Flask and SQLite — step-by-step Databases tutorial on Progressive Robot

How To Use Many-to-Many Database Relationships with Flask and SQLite

In this tutorial, you’ll modify an application built using Flask and SQLite by adding a Many-to-Many relationship to it. A many-to-many database relationship is a relationship between two tables where a record in each table can reference several records in the other table. For example, in a blog, a table for posts can have a many-to-many relationship with a table for storing authors.

Read more
CHAT