Blog Post: Database.xlsx

Fred and Loathing on The Internet

Welcome to the public web log of Fred Lambuth



Database.xlsx

2023-Jun-08

There has been work done on the complete codebase rewrite. Down to the data model, mind you! I’m saving that stuff to a different git repository. So far what I have are some very, very sparse SQL create table statements. My aim is for each table to only have as few columns as possible with the values only containing the most essential data. This is academic since the cheapest cloud server I can rent can handle any Sqlite or Python stuff I throw at it on the scale my personal stuff operates on. The academic stuff I hope to gather from this is just how handy-dandy foreign keys and surrogate keys are at streamlining how I can write views in Flask-SQLAlchemy.

There are some updates to the frontend. HOpefully it can be easily attached to the ground up work I’m doing on the other git. The /dash/24 link will show you my listening history of the previous calendar month, in a 24 Hour Histogram, color coded by the day of the week. I can see my dinner music bump in the 18-19 hrs time frame.

My enjoyment of that 500+ page monster book springboarded me right into another. This time it's a lengthy non-fiction one about the evolutionary history of mammals, starting at their breakoff point from reptiles. Mammals come from synapsids and reptiles come from diapsids. The author- an Illinois native digging for rocks as a boy now teaching paleontology in England- wrote this rather quickly after coming to fame about a similar titled and scoped book about dinosaurs. I love it so far but I can sense the need for some indulgent fiction after this one.


Add Comment