diff options
Diffstat (limited to 'served/words')
| -rw-r--r-- | served/words/a-really-long-week.html | 103 | ||||
| -rwxr-xr-x | served/words/alternate-ifc-formatting.html | 28 | ||||
| -rw-r--r-- | served/words/debugging-my-sql-query.html | 82 | ||||
| -rw-r--r-- | served/words/weeknotes/2024/48.html | 44 | ||||
| -rwxr-xr-x | served/words/weeknotes/what.html | 24 | ||||
| -rwxr-xr-x | served/words/words.css | 10 | ||||
| -rwxr-xr-x | served/words/words.html | 11 | ||||
| -rwxr-xr-x | served/words/writing.css | 6 |
8 files changed, 253 insertions, 55 deletions
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. +--- + +<div style="min-height: 25vh; text-align: center; display: flex; justify-content: center;"> + <p style="display: inline-block; align-self: center; font-style: italic;">space intentionally left blank</p> +</div> + +It has been 116 days since I last wrote a weeknote.<br />(<a href="/words/weeknotes/what.html">weeknotes/what.html</a>) + +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. + +<hr /> + +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. + +<hr /> + +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. + +<hr /> + +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 <a href="/cohost">/cohost</a>. I am trying +to do it carefully and with purpose, as I care about these things. + +<hr /> + +<img src="images/a-really-long-week.gif" + alt="A squirrel standing in leaves. The image only has 19 colours and looks slightly unreal." + style="width: 100%;" /> + +<hr style="margin-top: 0;" /> + +I've been working on an old project called NailyDumber back then +<i>(daily number, first letter swapped)</i>, 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. + +<hr /> + +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. + +<hr /> + +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. + +<hr /> + +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:<br /> +<blockquote> + I want to be genuine in the face of the world—confident and happy and beautiful and real. +</blockquote> + +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 <a href="https://wiki.xxiivv.com/site/arvelie.html">Arvelie</a> -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 <code>01</code>. So, with the same start year, -if it was December 31st, 2032, the date would be written was <code>12+01</code>. \ 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 <i>(or just "numbers")</i> and i had an sql problem :( + +i was trying to load a page that ran an sql query. it was this: + +<pre><code>SELECT creation_date, state, game, result +FROM double_dodge +WHERE player_id = ?1 AND state = ?2;</code></pre> + +the error in my terminal read: <code>no such column: creation_date</code>. +so i went and looked at my create table. it looked fine! the relevant bits: + +<pre><code>CREATE TABLE IF NOT EXISTS double_dodge ( + ..., + creation_date TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP, + ..., +);</code></pre> + +so i tried not selecting the <code>creation_date</code> column, but then it got mad at me about +the <code>state</code> column. i can assure you that <code>state</code>, too, was a real column. + +i opened the database in sqlite3. like this, <code>sqlite3 onl.db</code>. after trying to do +<code>\d double_dodge</code> and it telling me that it didn't know what <code>\</code> meant, +i ran <code>.help</code> like it suggested i did. + +haha, no i didn't. i went to google and searched, apparently, "sqlite cli" which pulled up the +<a href="https://sqlite.org/cli.html">Command Line Shell For SQLite</a> page. i scrolled for a +few dozen seconds and saw <code>.schema</code> which looked promising. +<pre><code>sqlite> sqlite> .schema double_dodge +CREATE TABLE double_dodge ( + (lines redacted for brevity) + creation_date TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,</code></pre> + +see, it <i>is</i> 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 <i>(not great probably, the mutex, but)</i>. + +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. +<pre><code>SELECT creation_date, state, game, result FROM awoo;</code></pre> + +<pre><code>Some("no such table: awoo")</code></pre> + +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 +<pre><code>SELECT creation_date, state, game, result FROM double_dodge WHERE player_id = ?1 AND state = ?2</code></pre> + +those are all columns that exist, even if sqlite does not believe me. oh, i'm not selecting +<code>player_id</code>. that's probably not good. + +<pre><code>SELECT player_id, creation_date, state, game, result FROM double_dodge WHERE player_id = ?1 AND state = ?2;</code></pre> + +<b><i>success :)</i></b> + +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 +<code>player_id</code> 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 (<a href="https://geohashing.site">geohashing.site</a>) +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 <abbr title="United States Geological Survey">USGS</abbr> +water level measuring thing. I couldn't find it on their map of water-level-measuring-things +<i>(that's the official name)</i>, 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 + +<hr /> + +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 <i>(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).</i> 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 <i>do</i> do things -no matter how loud your brain is yelling right now. - -<h2>the weird dates in my weeknotes</h2> - -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:<br /> -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 <i>is</i> 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. - -\<i>(read about <a href="https://en.wikipedia.org/wiki/International_Fixed_Calendar">IFC on wikipedia</a>)</i> - -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 <i>What? Weeknotes.</i>. Go read'm? They're listed in <a href="../">words/</a> \ 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 <a href="/atom.xml">Atom Feed</a>. <section id="weeknotes-section"> <h2 id="weeknotes">weeknotes</h2> <h3 id="what-weeknotes"><a href="weeknotes/what.html">what?</a></h3> + <ul class="wk-list"> + <li><a href="weeknotes/48.html">48</a></li> + <li class="miss">47</li> + <li><a href="a-really-long-week.html">a really long week</a></li> + <li class="miss">45</li> + <li class="miss">44</li> + <li>nov</li> + </ul> <ul id="weeknotes-ifc"> <li>sol</li> <li class="month"><a href="weeknotes/2024/sol.html">complete</a></li> @@ -46,6 +54,7 @@ The writing is part of the website <a href="/atom.xml">Atom Feed</a>. <section id="written"> <h2>technical writings;<br>project updates</h2> - <a href="akkoma-postgres-migration.html">Akkoma Postgres Migration</a> + <!--<a href="akkoma-postgres-migration.html">Akkoma Postgres Migration</a>--> + <a href="debugging-my-sql-query.html">Debugging My SQL Query</a> </section> </div> \ No newline at end of file diff --git a/served/words/writing.css b/served/words/writing.css index fbc5050..6983ccc 100755 --- a/served/words/writing.css +++ b/served/words/writing.css @@ -22,6 +22,12 @@ code { background-color: var(--background-dim); } +pre code { + display: block; + background-color: var(--background-dim); + overflow-x: scroll; +} + details.tldr { width: 100%; margin: 1rem auto; |