Daniel Halasz: Databases, 2 weeks

[danielhalasz]

module repository

SQL

• sqlteaching
• SQL Murder Mystery

Tooling

• TablePlus is a modern, native, and friendly GUI tool for several relational databases: SQLite, MySQL, PostgreSQL & more.
• DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.
• SQLite Viewer is an online SQLite editor.
• SQLite Editor by SQLite Tutorial is also an online SQLite editor, specifically for the Chinook sample database.
• vscode-sqlite is a VSCode extension to explore and query SQLite databases.

SQLite & Node.js

• ./node-query-scripts - practice querying an SQLite database from Node.js
• References
  • SQLite Node.js Guide
  • node-sqlite3 has good docs
  • developerhowto tutorial article
  • PetsApp: video tutorial (SQLite starts at #7), starter code & finished to study

[danielhalasz]

Week 1

• my hyf slack project

Check-In

I have successfully finished replacing the JSON "database" with a SQLite version and can read data from it. Next week I will implement the write & update functionalities. I have also tried using Mongo Atlas and to connect to a MongoDB database, and have managed to read from it too.

Sunday Prep Work

Learning about Bootstrap & React to boost the final project, if there will be time for it (I am an idealist :))