From 88c79031efd681aaf96c2148de52221baadc1fb7 Mon Sep 17 00:00:00 2001 From: gennyble Date: Sun, 8 Dec 2024 06:53:59 -0600 Subject: 2024-12-08 06:53 CST --- served/words/a-really-long-week.html | 103 +++++++++++++++++++++++++++++ served/words/alternate-ifc-formatting.html | 28 -------- served/words/debugging-my-sql-query.html | 82 +++++++++++++++++++++++ served/words/weeknotes/2024/48.html | 44 ++++++++++++ served/words/weeknotes/what.html | 24 +------ served/words/words.css | 10 ++- served/words/words.html | 11 ++- served/words/writing.css | 6 ++ 8 files changed, 253 insertions(+), 55 deletions(-) create mode 100644 served/words/a-really-long-week.html delete mode 100755 served/words/alternate-ifc-formatting.html create mode 100644 served/words/debugging-my-sql-query.html create mode 100644 served/words/weeknotes/2024/48.html (limited to 'served/words') diff --git a/served/words/a-really-long-week.html b/served/words/a-really-long-week.html new file mode 100644 index 0000000..74bceb6 --- /dev/null +++ b/served/words/a-really-long-week.html @@ -0,0 +1,103 @@ +--- +template=post +title=A Really Long Week +style=/styles/post.css +style=writing.css + +published=2024-11-13 7:24pm CST + +description=What I've done the last 116 days. +art=images/a-really-long-week.gif +art_alt=A squirrel standing in leaves. The image only has 19 colours and looks slightly unreal. +--- + +
+

space intentionally left blank

+
+ +It has been 116 days since I last wrote a weeknote.
(weeknotes/what.html) + +I like weeknotes. You get little slices of people throughout the year. Get to +learn a bit about them: what they do, how they write. It's nice. + +I meant to be writing weeknotes. I want to! It's hard. But I can do hard things. +I think I can, anyway. I am learning to do hard things. + +Here's what has happened, roughly, in the last 116 days: + +I bought a guitar from a garage sale for $75 in what I describe as an +"unhinged moment". I like the guitar, it is fun! I have not practiced very much +recently but promise to get back to it. Sometime before the end of the year I +will post a little audio clip of me plucking out a tune. + +
+ +I started having heart issues, maybe. Well, I had those more than 116 days ago, +but only just. Since then I have started taking a beta blocker, been to the +emergency room a few more times, and been anxious almost the entire time. It's +not very fun, but a lot of dangerous things have been ruled out so it is likely +I am fine. + +
+ +I switched to estradiol valerate injections from the sublingual tablets. I feel +overall more mentally stable. It's a lot harder to miss an injection than a +twice-a-day tablet. This is really good for me; we love this. + +
+ +Cohost shut down. It went read only 73 days after I wrote my last weeknote. It +was very nice being there and I will miss it. I am slowly reposting things I +put there, a selection of them, to /cohost. I am trying +to do it carefully and with purpose, as I care about these things. + +
+ +A squirrel standing in leaves. The image only has 19 colours and looks slightly unreal. + +
+ +I've been working on an old project called NailyDumber back then +(daily number, first letter swapped), but just called numbers now. It's a +little betting/gambling game with not-real money, of course, called beans. I am +conflicted as I do not like gambling, but I wanted to make it nonetheless. It +will hopefully be fun to play. I will try to get it running by the end of the +year, but I am not very good at deadlines. + +I feel like I am good at programming again when I work on this in a way I have +not in awhile. Perhaps it's the rapid progress or perhaps I have shed some +imposter syndrome since I last did any large programming things, which was +many months ago now. + +
+ +I got a quilt a few days ago. Nothing fancy, just a thing from the supermarket, +but it is a nice autumn orange and it is warm and I like to lay under it. + +
+ +A friend invited me to a friendsgiving at the end of November and it's so cute +I might cry. I am disused to knowing people in the physical world and I am very +excited. He just got a new dog and I am so, so excited to pet the good boy. + +
+ +It's fall. A few days ago I woke up well. It was nice. I walked outside and the +air was pleasantly cool. It was bright and I was smiling. I went and got coffee +where my sister works, decaf because caffeine gives me palpitations now I guess, +and I came home and cracked my window open and worked on numbers. I had a good +time; I enjoyed it. But I think it would've been nice to walk around a little +more. + +I am slightly afraid of where I live now. Not for any good reason, I think, or +any reason really at all. Nothing has happened to make me uneasy. It's more or +less just how I am. I will get over this and I will start walking again. + +On November 5th I wrote this in my notebook:
+
+ I want to be genuine in the face of the world—confident and happy and beautiful and real. +
+ +Thank you for reading; I love you. I hope you love yourself. \ No newline at end of file diff --git a/served/words/alternate-ifc-formatting.html b/served/words/alternate-ifc-formatting.html deleted file mode 100755 index 41f19bf..0000000 --- a/served/words/alternate-ifc-formatting.html +++ /dev/null @@ -1,28 +0,0 @@ ---- -template=post -title=Alternate IFC Formatting -style=/styles/post.css -style=writing.css - -published=2024-07-20 AHH TODO DATE ---- - -I really like weird date formats. The kind of stand-out alternate date format -in my mind is Arvelie -devised by Devine Lu Linvega. - -Arvelie splits the year into 26 months of 14 days each. - ---- - -Arvelie splits the year into 26 months of 14 days each. The year is "when you start journaling" -which I really, very much like. It makes it a kind of relative calendar to whatever you want. -It makes it feel a little more personal, I think. - -Each Arvelie month is a character in the alphabet. The year and day are zero-indexed -which means, if you started journaling in 2020, January 5rd of 2023 is 02A04. - -If you've done the math, 26 * 14, you'll notice there's a day missing—or -even two for leap years! Arvelie handles this rather elegantly. The Year Day, the -last day of the year, is notated with 01. So, with the same start year, -if it was December 31st, 2032, the date would be written was 12+01. \ No newline at end of file diff --git a/served/words/debugging-my-sql-query.html b/served/words/debugging-my-sql-query.html new file mode 100644 index 0000000..e9f5643 --- /dev/null +++ b/served/words/debugging-my-sql-query.html @@ -0,0 +1,82 @@ +--- +template=post +title=Debugging My SQL Query +style=/styles/post.css +style=writing.css + +published=2024-11-13 7:24pm + +description=Tiny retelling about debugging a weird SQL problem. +art=images/awoo.png +art_alt=Some("no such table: awoo") +--- + +working on a project i call naily (or just "numbers") and i had an sql problem :( + +i was trying to load a page that ran an sql query. it was this: + +
SELECT creation_date, state, game, result
+FROM double_dodge
+WHERE player_id = ?1 AND state = ?2;
+ +the error in my terminal read: no such column: creation_date. +so i went and looked at my create table. it looked fine! the relevant bits: + +
CREATE TABLE IF NOT EXISTS double_dodge (
+	...,
+	creation_date TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,
+	...,
+);
+ +so i tried not selecting the creation_date column, but then it got mad at me about +the state column. i can assure you that state, too, was a real column. + +i opened the database in sqlite3. like this, sqlite3 onl.db. after trying to do +\d double_dodge and it telling me that it didn't know what \ meant, +i ran .help like it suggested i did. + +haha, no i didn't. i went to google and searched, apparently, "sqlite cli" which pulled up the +Command Line Shell For SQLite page. i scrolled for a +few dozen seconds and saw .schema which looked promising. +
sqlite> sqlite> .schema double_dodge
+CREATE TABLE double_dodge (
+	(lines redacted for brevity)
+	creation_date TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ +see, it is real. i'm not loosing it. well, i might be. + +next i tried to not run that sql query at all until there was data in it. would that matter? i +didn't know, i'd never used sqlite before, but i thought it wouldn't matter. mostly because that +wouldn't make sense for it too, but also because i did something greatly similar elsewhere in +the project. + +i commented the code out and was able to use the webpage to put data into the table without issue. +more evidence it was real. + +i then uncommented the code and it started to panic again. and it was still poisoning the mutex that +held my database connection (not great probably, the mutex, but). + +does it just say that if it doesn't think the table is real? surely the table is real. we have so +much evidence it is. i changed the table name. +
SELECT creation_date, state, game, result FROM awoo;
+ +
Some("no such table: awoo")
+ +okay, so it knows the table is real. it just doesn't think any of the columns are real. +i tried removing my where clause. + +aha! it ran. + +what's wrong with my where clause? let's look at it again +
SELECT creation_date, state, game, result FROM double_dodge WHERE player_id = ?1 AND state = ?2
+ +those are all columns that exist, even if sqlite does not believe me. oh, i'm not selecting +player_id. that's probably not good. + +
SELECT player_id, creation_date, state, game, result FROM double_dodge WHERE player_id = ?1 AND state = ?2;
+ +success :) + +i am normally good about remembering to select what i where, but i forgot this time. +i wish it gave me an error that made sense, though, as the where was for +player_id which was not anything it was telling me about. \ No newline at end of file diff --git a/served/words/weeknotes/2024/48.html b/served/words/weeknotes/2024/48.html new file mode 100644 index 0000000..d4bc4ac --- /dev/null +++ b/served/words/weeknotes/2024/48.html @@ -0,0 +1,44 @@ +--- +template=post +title=Week 48; Walking +style=/styles/post.css +style=writing.css + +published=2024-11-13 7:24pm CST + +description=My car broke down and I walked some. +art=../../images/nov23-geohash-moss.gif +art_alt=moss growing on a log. The image has only 32 colours. The green of the moss really pops out at you. +--- + +It's been 18 days since the last weeknote. + +This time-period has been pretty alright, minus the car trouble. Thus is +car ownership, I guess. + +I got a nearby geohash (geohashing.site) +on the 23rd. It was in the midst of a forest preserve hiding in brush and grasses +under a grand, old tree. I bet it looks stunning in the summer and fall. Perhaps +there'll be a trek back there in four or five months. + +It was a very nice walk. After I got the point, I walked down an old-and-overgrown +path and came upon an old, now-decommissioned USGS +water level measuring thing. I couldn't find it on their map of water-level-measuring-things +(that's the official name), and it looked like decommissioned sites were mapped, so +I emailed them. + +They provided me with the number identifying the USGS No. 05527910 as well as the time +it was active. Then I went down + +
+ +In 1957 North Mill Creek was dammed by the then property owner creating a large lake +which was named after him: Ramussen Lake. Mister Ramussen passed in 1986 which let +the Lake County Forest Preserve to purchase it in 2001. + +USGS No. 05527910 was active from 2007 until 2019. + +It monitors North Mill Creek, which seems +to be runoff from the Elmwood Farm Lake (called the Ramussen Pond on one GIS map i looked at, + potentially in honour of the farm owner who passed in 1986 at the age of 78). This +lake-pond with a contested name is apparently artificial; it was formed when \ No newline at end of file diff --git a/served/words/weeknotes/what.html b/served/words/weeknotes/what.html index b28a413..7d0f1a4 100755 --- a/served/words/weeknotes/what.html +++ b/served/words/weeknotes/what.html @@ -24,26 +24,4 @@ or about stuff that happened at work: a weeknote can be whatever you want it to a lot of people, myself included, like to use weeknotes to keep track of what they're doing. to keep a record and to remember that, yes, you do do things -no matter how loud your brain is yelling right now. - -

the weird dates in my weeknotes

- -i like weird date formats, a lot!, so i am using the International Fixed Calendar -(IFC) to note my weeks. It's pretty easy to understand, but not too easy to convert -between IFC and the Gregorian Calendar. - -The rundown is:
-Every month is 28 days. There is an extra month after June called Sol. The last -day of the year is extra. It's called the Year Day and it's not part of any week -but it is December 29th. - -During leap years there is a day after June and before Sol: June 29th. It's the -Leap Day and also does not belong to a week. - -\(read about IFC on wikipedia) - -Since I week-a-note every two, I name the first weeknote "early" and the last two -"late". So, in rhythm, it'll be something like: Early June, Late June, Early Sol, -Late Sol, etc. - -That's it for What? Weeknotes.. Go read'm? They're listed in words/ \ No newline at end of file +no matter how loud your brain is yelling right now. \ No newline at end of file diff --git a/served/words/words.css b/served/words/words.css index 90a888b..abe4ee5 100755 --- a/served/words/words.css +++ b/served/words/words.css @@ -14,7 +14,8 @@ div { grid-column: 1 / 2; } -#weeknotes-list { +#weeknotes-list, +.wk-list { padding: 0; margin: 0; display: flex; @@ -31,12 +32,15 @@ div { } #weeknotes-ifc { - padding: 0; - margin: 0.25rem 0 0.75rem 0; + padding: 0.75rem 0; + margin: 0.75rem 0 0.75rem 0; display: grid; grid-template-columns: min-content 1fr 1fr; column-gap: 1rem; list-style: none; + border-style: solid; + border-color: var(--text-dim); + border-width: 1px 0 1px 0; } #weeknotes-early-only { diff --git a/served/words/words.html b/served/words/words.html index 76de6f9..587d021 100755 --- a/served/words/words.html +++ b/served/words/words.html @@ -16,6 +16,14 @@ The writing is part of the website Atom Feed.

weeknotes

what?

+