Posts Tagged “sqlite”
Things about the SQLite database. The greatest embedded database ever.
Building a Nutrition Macro Calculator Spreadsheet
11 August 2022
I really want to lose some weight this month, but nutrition is hard,
and it can’t run on instinct. So I made a spreadsheet to calculate
calories and macros. I’m not a dietician or a nutritionist so my diet
numbers should definitely not be trusted. I just followed examples and
combined them to build my diet. What can be trusted is how I loaded the
information from official government sources, and how I did my research.
Search Suggestions on My Website
27 July 2021
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.
Adding Search to My Static Blog Using AWS Lambda and SQLite
09 July 2021
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.
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