Data Science · मराठी आवृत्ती

24.2 Connection basics — read-only mindset

By Ravindra Bagale

या course चे सर्व chapters (py + ch)

हे का शिकायचं?

Analysis account ला SELECT पुरेसं. UPDATE/DELETE rights analysis साठी नको.

हे काय आहे?

Connection string / URL सुरक्षित ठेवा. Password code मध्ये hardcode करू नका.

कसं करायचं?

Step 1. Read-only user वापरा.

Step 2. Credentials env / vault मध्ये.

Step 3. Connection उघडा, query, बंद करा.

Step 4. Prod data असल्यास approval नियम पाळा.

उदाहरणं: copy करा आणि चालवा

Person	Access
Ravindra Bagale (analyst learner)	Read-only on `orders`, `stores`
DBA / backend	Write rights on production
Shared training laptop	Local SQLite copy only

उदाहरण A — SQLite classroom file (no password).

import sqlite3
from pathlib import Path

db_path = Path("data/blinkit_lab.db")
db_path.parent.mkdir(parents=True, exist_ok=True)
con = sqlite3.connect(db_path)
print("connected", db_path.resolve())
con.close()

उदाहरण B — Secrets via environment (shape only).

import os

# Set once in the terminal (example — use YOUR practice values):
#   export DS_DB_URL="sqlite:///data/blinkit_lab.db"
url = os.environ.get("DS_DB_URL", "sqlite:///data/blinkit_lab.db")
print("using", url.split("@")[-1])  # avoid printing passwords

उदाहरण C — Who gets which access (fictional ops).

Person	Access
Ravindra Bagale (analyst learner)	Read-only on `orders`, `stores`
DBA / backend	Write rights on production
Shared training laptop	Local SQLite copy only