2. Install SQLite and DB Browser (Windows and Mac)
2.6 Common Install Errors and How to Fix Them
Why. Install friction stops practice — fix the usual blockers once.
What. Common issues: SmartScreen, macOS quarantine, opening CSV instead of .db, wrong folder.
How. Use the official installer, open .db (not only CSV), and keep datasets in a short path.
Steps
- Cannot find app: search Start / Launchpad for DB Browser.
- File greyed out: finish New Database or Open first.
- SQL error near CREATE: you may have run seed twice — New Database and run once.
- Results empty: confirm you are on Execute SQL and clicked Run.
Ravindra Bagale's Tip
Keep a folder Desktop/sql-practice with .db and .sql together.
Ravindra Bagale's Tip – मराठी
Desktop/sql-practice फोल्डरमध्ये .db आणि .sql एकत्र ठेवा.
Ravindra Bagale's Tip – हिंदी
Desktop/sql-practice फ़ोल्डर में .db और .sql साथ रखें।