If you need and introduction to SQL and Databases, I recommend reading these articles before diving into this one: Introduction to SQL SQL: Tables and Basic Structure SQL: Data Types SQL: Syntax SQLite is a database that comes pre-installed with…
To connect with a PostgreSQL database, you have to install a specific module with pip: pip install psycopg2 Then you import psycopg2 and to create a connection you call psycopg2.connect(), passing the database, user, password, host, and port. In this…
To connect with a MySQL database, you have to install a specific module with pip: pip install mysql-connector-python Then you import mysql.connector and to create a connection you call mysql.connector.connect(), passing the host, user, and password. In this example we…
Data Types Each field in a Table has a Type. A Data Type is used to specify what kind of object that particular field will store. When creating your own structures, using the right type for the right data is…
This is a direct continuation of my previous article Introduction to SQL. SQL works on a structure with four components: Table, Field, Row, and Column. You can think of those components exactly like the ones in spreadsheets like Excel. A…
It doesn’t matter if you are a frontend, backend, or a full stack developer, knowing SQL is a must have skill. What is SQL and why you should learn it SQL stands for Structured Query Language. It is pronounced SEQUEL.…
Oracle XE is a free Oracle database that you can run locally and is very handy for development purposes. This post shows how to create a docker image with an instance of Oracle XE for you to manage and use…