Posts Tagged “sqlite”
Things about the SQLite database. The greatest embedded database ever.
Pa Lottery Data Viz Tool
20 March 2019
In this post, I provide access to a data visualizer for the Pennsylvania
lottery using data I pull regularly from their RSS feed. This tool uses
SQLite and some scripts to automatically pull data to this post which is
then visualized using Chart.js. I created histograms of the most
common drawn numbers for the drawings in which a particular number
appears, and you can see that visualized below in the charts.
Creating a Database to Track How Long You Worked
23 June 2016
I actually created a sqlite database to track exactly how long I worked at
various jobs. I created this database, because I don’t trust the payroll
system we use at work. I will share the schema and views in this post. If
you don’t want to read through this post you can get it here.
A SQLite Tutorial
24 May 2015
This is my in-depth SQLite tutorial for C++. This is the first
tutorial I am doing on this website. It is really difficult to find a good
tutorial for prepared statements with SQLite, and that is what this tutorial