Database programming (SQLite)

Beginning with SQLAlchemy Python

Ok I have been doing Python for a while now and Python is amazing. So thought of writing a blog about it in my new blog. Leaving the chitchat.

We will be performing database operations (CRUD ) in SQLite database. This is a simple database that many programming language support and recommended for beginning database programming for most of them. We will be building a simple todo application to begin with. For further practice, you can create Restaurant Menu App, Remainder App, whatever you like. Be creative. 😎😎😎

We have few steps that we will be following. Importing libraries, connecting to database (*.db) and creating session interface for performing operations.

We will be using SQLAlchemy python module to begin.

Importing dependencies

import sys
from sqlalchemy import Column, ForeignKey, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship
from sqlalchemy import create_engine

These are the dependencies that we will be using for begin with.

Continue reading “Database programming (SQLite)”