PostgreSQL o'rnatish va sozlash

PostgreSQL — eng kuchli ochiq manba ma'lumotlar bazasi.

Ubuntu da o'rnatish

sudo apt update
sudo apt install postgresql postgresql-contrib
sudo systemctl start postgresql
sudo systemctl enable postgresql

PostgreSQL ga kirish

sudo -u postgres psql

Foydalanuvchi va ma'lumotlar bazasi yaratish

-- Foydalanuvchi yaratish
CREATE USER sherali WITH PASSWORD 'parol123';

-- Ma'lumotlar bazasi yaratish
CREATE DATABASE mydb OWNER sherali;

-- Huquq berish
GRANT ALL PRIVILEGES ON DATABASE mydb TO sherali;

-- Chiqish
\q

Asosiy buyruqlar

-- Ro'yxatlar
\l          -- ma'lumotlar bazalari
\dt         -- jadvallar
\d jadval   -- jadval tuzilmasi
\du         -- foydalanuvchilar

-- Ulash
\c mydb

Jadval yaratish

CREATE TABLE talabalar (
    id SERIAL PRIMARY KEY,
    ism VARCHAR(100) NOT NULL,
    email VARCHAR(200) UNIQUE,
    yosh INTEGER CHECK (yosh > 0 AND yosh < 120),
    yaratilgan TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE INDEX idx_talaba_email ON talabalar(email);

Python bilan ulash

pip install psycopg2-binary

import psycopg2

conn = psycopg2.connect(
    host="localhost",
    database="mydb",
    user="sherali",
    password="parol123"
)
cur = conn.cursor()
cur.execute("SELECT * FROM talabalar")
rows = cur.fetchall()