Using VS-Code and the SQLite3 Editor Extension to make a Quote Database -- Part 2
We continue are demonstration of making a SQLite database using the Visual Studio Code (VS-Code) environment with the SQLite3 Editor extension to make a database on Quotes (like what's behind the Brainy Quotes website). Previously we made an author table. This time we made a Quote table with three fields: a primary key quoteID (auto-incremented), a quoteText , and a foreign key quoteAuthorID that references the pre-existing author table. We show how to insert some records into the quote table. Then we write some SELECT queries. SELECT * . Then SELECT certain fields. Next add a WHERE clause. And finally a JOIN query that displays authors and their quotes.
More Database Introduction: Database Categories and Codd's Rules for Relational Databases
Finding More Patterns in the Perfect-Shuffle (Riffle) Integer Sequence with Wolfram-Cloud