I previously talked about the search engine I recently added to my
blog, and this is an extension to that previous post. Here I will
discuss how I added a simple search suggestion option. It works for my
website with the limited vocabulary and time to return results, but if I
was working on a larger site I might try to make it smarter. So here’s
how I implemented it.
I always wanted to have search on my site, but it’s statically hosted,
so I can’t have any dynamic content on it. I recently resolved that by
creating a little tiny lambda function on AWS that queries a SQLite
database hosted on S3. Here I’ll walk you through how I created the
back-end for it, and in some later posts I’ll include details on
calculating the cost.
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.
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.
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