Posts Tagged “sqlite”

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

• Using SQLite Extensions with Gorm 10 August 2024
  • golang
  • programming
  • sqlite

  I’ve been building a site in Golang using Gorm as my object relational mapper because it’s a pain to map things into a struct and use the scan interface. Not really using it as a query builder, but it’s still handy. I recently wanted to use some extensions in my queries to do things like unicode normalization and similar functions. I was also sick of waiting for Cgo compilation times so I switched to a webassembly build of sqlite embedded into my go project.

• Using the SQLite Shell the Right Way 04 July 2024
  • database
  • sqlite
  • tutorial

  I’ve been using the SQLite shell a lot lately to slice and dice data is slightly too large for excel. It’s a very powerful tool to get SQL on the command line without spinning up a large Postres server, and supports most of the SQL standard with syntax similar to Postgres. It’s super fast and supports loading CSV. I want to talk about some quality of life features in it that you probably don’t know about.

• Building a Nutrition Macro Calculator Spreadsheet 11 August 2022
  • database
  • spreadsheet
  • sqlite

  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
  • full-text-search
  • programming
  • python
  • sqlite

  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
  • amazon-web-services
  • aws-lambda
  • cloudformation
  • full-text-search
  • jekyll
  • python
  • sqlite
  • tutorial

  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
  • data-visualization
  • interactive
  • lottery
  • sqlite
  • statistics

  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.