databases icon indicating copy to clipboard operation
databases copied to clipboard

This repository contains all the material for the HackYourFuture module "Databases: Store and retrieve data with MySQL"

Results 13 databases issues
Sort by recently updated
recently updated
newest added

Bumps [knex](https://github.com/knex/knex) from 0.21.1 to 2.4.0. Release notes Sourced from knex's releases. 2.4.0 New features: Support partial unique indexes #5316 Make compiling SQL in error message optional #5282 Bug fixes...

dependencies

Bumps [decode-uri-component](https://github.com/SamVerschueren/decode-uri-component) from 0.2.0 to 0.2.2. Release notes Sourced from decode-uri-component's releases. v0.2.2 Prevent overwriting previously decoded tokens 980e0bf https://github.com/SamVerschueren/decode-uri-component/compare/v0.2.1...v0.2.2 v0.2.1 Switch to GitHub workflows 76abc93 Fix issue where decode...

dependencies

Hi folks, I'm proposing here a rubric to evaluate students' homework. The follow-up for this is a "perfect homework" that we will store in a private repo to make it...

I ran this QA with two exercises 1. Do normalization together 2. Build a small API using MongoDB

1. Reading materials for week 3 miss rules for 2NF and 3NF 2. The rules for 1NF do not completely match in the reading and video materials.

This doesn't work: PREPARE example FROM SELECT name, salary FROM employees where id = ?; It looks like it should be this instead: PREPARE example FROM 'SELECT name, salary FROM...

it's not a 'versus' discussion, it's about what data to put in which db. Most (big) projects these days use both types of DB's in a single project MySQL is...

By week 3 the students are used to work with the promisified execQuery. The exercise could be upgraded so there are less questions about the weirdness / old school approach....

This subject is highly theoretical (and even feels unnatural to and to students) when designing a database. IMHO without this topic they would be just a good in database designing...

Students where asking about `set autocommit = 0` In my opinion we shouldn't mention this syntax and only keep the subject concise by only talking about `START TRANSACTION`, `COMMIT` and...