- https://www.quora.com/Why-doesnt-Quora-use-PostgreSQL
- https://www.quora.com/Why-does-Quora-use-MySQL-as-the-data-store-instead-of-NoSQLs-such-as-Cassandra-MongoDB-or-CouchDB
- Typical Programmer - Why Programmers Don’t Like Relational Databases
- Typical Programmer - Abject-Oriented Databases
- 2014.02.21 - DigitalOcean - SQLite vs MySQL vs PostgreSQL: A Comparison Of Relational Database Management Systems - I thought this was a helpful overview.
Tools
- SQLiteBrowser
- I've used this and it works fine.
SQLite
- Installation
- Go to SQLite3 download page
- Go down to the “Precompiled Binaries For Windows” section.
- Download “sqlite-shell” and “sqlite-dll” archive files.
- sqlite-dll-win64-x64-3160200.zip
- Download the sqlite tools .zip
- sqlite-tools-win32-x86-3160200.zip
- Unpack everything in C:\sqlite folder.
- Add that folder to your PATH.
- Go to SQLite3 download page
- Creating the empty .db file:
- Hit the Windows key, type 'cmd', then right-click the 'Command Prompt' result and select 'Run as Administrator'.
- Navigate to the folder where you want the db to be.
- Type 'sqlite3 name_of_the_db.db' and hit 'Enter'.
- Simple example of a schema file:
CREATE TABLE salespeople ( id INTEGER PRIMARY KEY, first_name TEXT NOT NULL, last_name TEXT NOT NULL, commission_rate REAL NOT NULL );