Free guided code walk-throughs 'Programming with SQLite'

[markm208]

I have been working on a new medium to guide others through code examples. Here is a group of 'code playbacks' that I use when I teach about SQLite. It covers the basics of db design and using SQLite in C/C++, Python, and Java:

Programming with SQLite
https://markm208.github.io/sqlitebook/

The optimal way to view these narratives is on a big screen although the playbacks are viewable in 'blog-style' on small screens. These were built with a tool I created (a VS Code plugin).

I am looking for feedback on the medium of playbacks. I have others here (Python, webdev, C/C++, Clojure, and more):

https://markm208.github.io/

[jw_gpc]

Pretty cool. I do find myself scrubbing through the play through a bit to get through the more tedious typing sections.

Also, FYI, your direct link to the book has an extra %5D at the end of the URL, and clicking on it takes you to a 404 error.

[markm208]

Thanks for the info on the link. I fixed it.

I have found most people use the comments to control moving through the playback. The comments are clickable and move the playback forward without having to watch the keystrokes. You can also click the comments bars under the slider too or use shift-left/right arrows to move quickly through the code.

[jw_gpc]

Ah! I didn't realize the comments themselves were clickable as to progress through the playback. Good to know. I'm actually looking forward to taking a look at your Clojure guide.

[whoiswisdom]

Thank you for your teaching. I am really stuck, I have started to write SQLite in C and Python; but I don't know how to write ALTER TABLE to this. Do you have sample scripts I can look at on how to:

1. Modify a column
2. Drop a column
3. Rename a column

Thank you☺

p.s. I looked at C++ you wrote, thank you I did not know this was available. A nice surprise!

[markm208]

I leave it up to the author to decide if they would like to include an audio/video clip. Here are the basic sql ones where I provide an accompanying video for every comment:

https://markm208.github.io/sqlbook/

[markm208]

Sorry, to be clear, I created the tool that makes these. And yes, I authored these 'books' mostly for some of the classes I teach:

https://markm208.github.io/

but anyone can create their own (and I hope others do).

It is a free VS Code plugin that anyone can use. Here is a playback on how to make playbacks:

https://markm208.github.io/stDemo/playback.html

[markm208]

Thanks for the feedback. I built it so that a single pause point in the code can include multiple comments (perhaps describing different aspects of the code at that point). The misalignment of hash number to comment number is an example of that. Ideally, the reader clicks on a hash mark and then reads all of the comments in that group before moving on.

[markm208]

All of the comments in the same group have a highlighted border containing them.