Database Tutorials

Learn how to use DuckDB in Python for lightning-fast SQL analytics on CSV, Parquet, and JSON files. Covers installation, querying, hybrid Pandas/Polars workflows, and performance tips.

Learn to build a sleek, fully-functional CRUD app using PyQt5 and SQLite3 in Python. This comprehensive tutorial takes you from setting up your database to creating a stylish user interface. Ideal for those looking to transition from Tkinter and create more customizable, native-looking GUI apps.

Learn how to build a full-stack notes web app using FastAPI, ReactJS, SQLAlchemy and SQLite.

Learn how to leverage FastAPI, Strawberry, and PostgreSQL to build a fully functional CRUD GraphQL API server in Python.

Learn how to build a CRUD Book store app using Django web framework and Bootstrap, with the ability to create, read, update, and delete books with ease.

Learn how to build the frontend of a CRUD application using Flask, Jinja2, Bootstrap and SQLAlchemy libraries in Python.

Learn how to create a CRUD application as a RESTful API using Flask and SQLAlchemy, making a Bookshop web application as a demonstration in Python.

Learn how to leverage Celery library, Redis database and SocketIO library to build synchronous and asynchronous tasks with Flask in Python.

Learn how to connect to a MongoDB database, list databases, collections, insert data into collections, fetching data from collections and more in Python using pymongo driver module.

Learn how to configure your MySQL server to be able to accept remote connections from Python

Learn how to connect to a MySQL database, create tables, insert and fetch data in Python using MySQL connector.