Learning ORM

The ORM module is used to communicate with relational databases (such as Postgres, MySQL, SQLite, MSSQL, and Oracle). The communication to the database happens from the programming languages (such as V, Python, or C#, to mention a few) using the objects that are created to reflect the database table schema.

At the time of writing this book, V's standard library (vlib) ships with a built-in ORM that supports Postgres, MySQL, and SQLite. It has planned support for the other two popular relational databases, namely MSSQL and Oracle.

Generally, each database defines a standard way to interact and query against the data and this is often referred to as Structured Query Language (SQL). Each of these databases has its version of SQL that we refer to as dialects. Each database has a different dialect that specifies how to communicate with the database to perform queries.

However, by using V's ORM, you don't need to learn about, write, or manage different...