Major Database Servers/Solutions
- MySQL (Oracle) / MariaDB
- SQL Server (Microsoft)
- PostgreSQL
- SQLite
- Redis – 38.4k – In-memory database that persists on disk.
- CockroachDB – 16.9k
- MongoDB – 16.6k
- Cassandra (Apache)
- CouchDB (Apache)
- Oracle
- IBM DB2
Learn SQL
- Select Star SQL – Interactive online book (free) that teaches SQL.
- SQLZOO
- SQL Murder Mystery – You’ll need some SQL knowledge to get started, they recommend Select Star SQL above.
Database Management
- sqlitebrowser – 11.8k
- dbeaver – 10.1k
- SQLGate IDE
MySQL/MariaDB Commands/SQL
- Login to MySQL: mysql -u username -p
- Create User / Grant Permissions on Database: GRANT ALL PRIVILEGES ON nameofdb.* TO ‘username’@’localhost’ IDENTIFIED BY ‘password’;
FLUSH PERMISSIONS; - Show MySQL Users: select user, host from mysql.user;
- Installing PHP’s MySQL extension: apt-get install php-mysql
Serverless Database Solutions
- MySQL (Oracle) / MariaDB
- SQL Server (Microsoft)
- SQLite
- PostgresSQL
- MongoDB
- Cassandra (Apache)
- CouchDB (Apache)
- RethinkDB
- Firebird
- Oracle
- IBM DB2
Concepts
- CRUD
- Relational Databases
- Normalization
- Data Modeling
- Entity Relationship Modeling
- ACID
- Tables
- Views
- Stored Procedures
- Triggers
- User Defined Types
- Indexes
- Object-Relational Mapper (ORM)
Serverless Database Solutions
- Dan O’Donnell. What Front-End Developers Need to Know about Serverless Databases. the new stack, 9/2019.
- Good overview of serverless databases, not just for front-end devs.
- Mike Melanson. This Week in Programming: Whither Serverless? the new stack, 10/2019.
- Good read to temper the optimism in O’Donnell’s article above.
Other DB Solutions
- Firebird
- RethinkDB