SQLite DB in python

 SQLite is a self-contained, serverless, and lightweight relational database engine. Unlike traditional client-server databases, it operates directly as a C-library embedded within an application, storing the entire database in a single, standard cross-platform file

# SQLite Viewer vs code extention to graphical view of sqlite db

Quick Python Example

import sqlite3

# Connect to database (creates file if it doesn't exist)

conn = sqlite3.connect('my_database.db')

cursor = conn.cursor()

# Create a table

cursor.execute('''CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT)''')

# Insert data

cursor.execute("INSERT INTO users (name) VALUES ('Bob')")

conn.commit()

# Query

cursor.execute("SELECT * FROM users")

print(cursor.fetchall())

# Close connection

conn.close()