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.

Image for post
Image for post
Wilbrow, Marc. “Generate all 16 possible 2-variable shaded Venn diagrams in TikZ? Stack Exchange. Dec 11, 2015. https://tex.stackexchange.com/questions/266326/generate-all-16-possible-2-variable-shaded-venn-diagrams-in-tikz

The first thing I’ll do in this article is explain how to create your database containing your tables and data in SQLite. …


Image for post
Image for post
Model-View-Controller Diagram

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.

The MVC Framework

Let’s take a second to go over what each part of the MVC covers:

  • Models: The backend of the application. This is where all the data manipulation happens. These files will consist of Python, Ruby, etc.
  • Views: The frontend of the application. These files consist of HTML, CSS, etc. This is the only part the user interacts with directly.
  • Controllers: Connects the…

Danielle Leppert-Simenauer

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store