Posts Tagged “sqlite”

Things about the SQLite database. The greatest embedded database ever.

• Pa Lottery Data Viz Tool 20 March 2019
  • data-visualization
  • lottery
  • sqlite

  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
  • database
  • sqlite
  • tutorial

  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
  • programming
  • sqlite
  • tutorial

  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 will remedy.