LibraryCarpentry / lc-sql

Library Carpentry: SQL
https://librarycarpentry.org/lc-sql/
Other
12 stars 37 forks source link

Move Backing Up with SQL to the top of the Creating tables... episode? #135

Open libcce opened 3 years ago

libcce commented 3 years ago

Should "Backing Up with SQL" in "Creating tables and modifying data" be moved to the top of the episode: https://librarycarpentry.org/lc-sql/09-create/index.html

In other words, before you make changes to your database... make sure you back up and version your database. Instead of "Be very careful when doing this: if you drop the wrong table, hope that the person maintaining the database has a backup, but it’s better not to have to rely on it."

I also wonder if this should be an exercise, that we can highlight backing up your SQL and that versioning is an option with the caveats. Instead of the exercise we can include the action to dump the database and save it with the ISO 8601 date and name?

mimkes commented 3 years ago

Yes, your thought all make sense. But we could also include 2 exercises? One for dumping and one for adding/creating/updating?

libcce commented 3 years ago

It's the exercise on dumping that I'm not sure about. We have to consider the overall time to teach the lesson. So just thinking of this when I suggest that maybe it can just be a highlight?

mimkes commented 3 years ago

Yes, we could dump the dumping exercise. Anyway, I am not sure how to use .dump with the DB browser. The browser offers importing and exporting, but I am not sure how to use .dump .

jyssy commented 3 years ago

@mimkes, @libcce We could also add the .dump or backing up as an FYI, or something if we don't want to add it to the lesson (because of timing). thoughts?

mimkes commented 3 years ago

An FYI sounds like a good idea to me.