SQLite does not support Right Outer Joins or Full Outer Joins so in this article I am going to get into how to get around that as well as deep dive into all joins in sqlite.
The picture below contains eight Venn diagrams. Each represents a set of data you may want to extract from two tables or a type of join you may want to perform using SQLite to extract that data.
The first thing I’ll do in this article is explain how to create your database containing your tables and data in SQLite. …
Model-View-Controller (MVC) is one framework for building web applications. It follows several principles of software engineering that make it so successful. Here I lay out the MVC framework, several software engineering principles, and the connection between the two.
Let’s take a second to go over what each part of the MVC covers: