From 27e88a9609277e0c76b73b1498d6262927deadf7 Mon Sep 17 00:00:00 2001
From: Michael McVady <femtonaut@gmail.com>
Date: Sat, 8 Jul 2023 13:40:45 -0500
Subject: Update data dump

---
 db/data.sql | 72 ++++++++++++++++++++++++++++++++++++++++++++-----------------
 1 file changed, 52 insertions(+), 20 deletions(-)

(limited to 'db/data.sql')

diff --git a/db/data.sql b/db/data.sql
index b5d711b..b9b0b61 100644
--- a/db/data.sql
+++ b/db/data.sql
@@ -1,5 +1,7 @@
 
 INSERT INTO posts (
+    id,
+    -- draft,
     title,
     body,
     created_at,
@@ -8,6 +10,7 @@ INSERT INTO posts (
 VALUES
 
 (
+    'd1bd1918-4cc3-425f-ad83-13f58300301a',
     'Succinct Description of UTF-8 Encoding',
     'UTF-8 is actually a pretty neat way to encode text. Its clever design leads to several interesting
 properties. Notably of which, at least to me, is that all ASCII files are already UTF-8 encoded.
@@ -18,20 +21,22 @@ properties. Notably of which, at least to me, is that all ASCII files are alread
         0080-07FF (11 bits)  |                   110pqrst 10uvwxyz
         0800-FFFF (16 bits)  |          1110jklm 10npqrst 10uvwxyz
     010000-10FFFF (21 bits)  | 11110efg 10hijklm 10npqrst 10uvwxyz',
-    TO_TIMESTAMP(1303776000)::DATE,
-    TO_TIMESTAMP(1303776000)::DATE
+    '2011-04-26 00:00:00',
+    '2011-04-26 00:00:00'
 )
 ,
 (
+    '6d011855-6b0d-4202-a243-4d9db9807f14',
     'A Solid Breakdown of the Linux Font Rendering Stack',
     '[This](https://freddie.witherden.org/pages/font-rasterisation "A Treatise on Font Rasterisation With an Emphasis on Free Software")
 article saved me. Explains hinting and anti-aliasing quite well, also includes an excellent description of the Linux 
 font rendering stack.',
-    TO_TIMESTAMP(1303776000)::DATE,
-    TO_TIMESTAMP(1303776000)::DATE
+    '2011-04-26 00:00:00',
+    '2011-04-26 00:00:00'
 )
 ,
 (
+    '045b62f8-6763-44e5-9859-976b5783725a',
     'gvim + ibus woes / building gvim from source',
     'My main development machine is running Ubuntu 12.04 and for a while now I''ve had issues with using gvim 7.3.x in 
 conjunction with ibus. Specifically upon starting gvim there''s a long start up latency (30s+) while the ibus daemon
@@ -87,11 +92,12 @@ my development environment much less painful. So I''ll define an alias in my `~/
     alias gvim=''~/working/vim/src/vim -g -p''
 
 やった！',
-    TO_TIMESTAMP(1376179200)::DATE,
-    TO_TIMESTAMP(1376179200)::DATE
+    '2013-08-11 00:00:00',
+    '2013-08-11 00:00:00'
 )
 ,
 (
+    '4cc0c8a1-50a7-4896-9ff7-4bd1e5f93468',
     'Shell Wildcard Channel Attacks',
     'Using wildcards with a shell can open you up to channeling attacks (for example, sql injection is a type of channeling attack).
 When using the `*` wildcard in particular in a directory containing argument-like-filenames (e.g. `-rf`) can lead to wild results.
@@ -122,11 +128,12 @@ Because `rm *` expands to:
     [user@defensecode WILD]$ rm DIR1 DIR2 DIR3 file1.txt file2.txt file3.txt -rf
 
 This type of attack used in conjunction with seemingly innocuous utilities like `tar` can lead to execution of arbitrary commands.',
-    TO_TIMESTAMP(1408579200)::DATE,
-    TO_TIMESTAMP(1408579200)::DATE
+    '2014-08-21 00:00:00',
+    '2014-08-21 00:00:00'
 )
 ,
 (
+    '7b9ab699-5cf6-4f3f-9ac8-b3cece0732a8',
     'Debugging CGI / CGit',
     'I''ve been using CGit as a [git web front-end](http://bunkergate.org/cgit) for a bit now and just recently started
 looking into customizing the root header. Assuming I''d have to hack the code to do so, I decided to pull down the source and build it.
@@ -168,11 +175,12 @@ didn''t seem to have the desired effect. How can we see what''s going on? Simple
 So what was happening? Well after setting a watchpoint on `ctx.cfg.logo` I noticed something peculiar. The variable was getting set to
 the value I expected, but then later it was getting set yet again to the undesired value. Turns out that the problem was that I had set
 `logo` twice in the configuration file. Ugh.',
-    TO_TIMESTAMP(1409011200)::DATE,
-    TO_TIMESTAMP(1409011200)::DATE
+    '2014-08-26 00:00:00',
+    '2014-08-26 00:00:00'
 )
 ,
 (
+    '8f681716-6eed-4f26-868c-f334377dfe12',
     'Sideloading Nexus Devices with the Android SDK',
     'Android 5.0 "Lollipop" was released yesterday and I wanted to check it out on my Nexus 7 2013 WiFi tablet without having to wait for the update to be pushed.
 I''ve done this several times with various Nexus devices now, but so infrequently that I always have to look up how to do it. So this time I''m taking
@@ -307,11 +315,12 @@ Next flash the zip image:
 
 And now it''s finished. If the bootloader was already locked previously, then you can remove the `-w` flag in the last
 command to avoid wiping the device (note: I''ve not tried this yet).',
-    TO_TIMESTAMP(1415836800)::DATE,
-    TO_TIMESTAMP(1415836800)::DATE
+    '2014-11-13 00:00:00',
+    '2014-11-13 00:00:00'
 )
 ,
 (
+    '6e574a3a-b5bd-4457-afa6-9d41a5b4b3bf',
     'Flask Development on a Raspberry Pi',
     'Currently the [`flog`](http://bunkergate.org/git/flog "flog git repo") project requires lxml as a dependency. I had some issues pulling this in.
 
@@ -395,11 +404,12 @@ I was exhausting all 512 MB of memory. As a workaround, I temporarily employed a
     (venv)~/py_toy $
 
 Success!',
-    TO_TIMESTAMP(1426824928)::DATE,
-    TO_TIMESTAMP(1426824928)::DATE
+    '2015-03-20 00:00:00',
+    '2015-03-20 00:00:00'
 )
 ,
 (
+    '7d5c1e2f-f54f-471a-8cd7-e0c05abc3285',
     'SSH Tunneling for Fun and Profit',
     'First, to test, set up temporary Python http server on the remote host:
 
@@ -431,11 +441,12 @@ Test the tunnel with telnet on local machine.
 
     HELLO WORLD
     Connection closed by foreign host.',
-    TO_TIMESTAMP(1428316230)::DATE,
-    TO_TIMESTAMP(1428316230)::DATE
+    '2015-04-06 00:00:00',
+    '2015-04-06 00:00:00'
 )
 ,
 (
+    '2a8620f0-1a88-4732-9386-8515f65ae671',
     'RPM Packaging Environment for an Arbitrary User',
     'Recently I had to roll my own package on CentOS 7. It''s been a while since I''ve done this and so I had to dig around online to remember how to set up an environment for packaging. So this time around I''ll jot down some notes.
 
@@ -631,11 +642,12 @@ And now to test that packaging works by packaging a project:
     -rw-rw-r--. 1 mcvady mcvady 21K May 13 16:00 chunker-0.9.1-1.el7.centos.x86_64.rpm
 
 やった！',
-    TO_TIMESTAMP(1431212057)::DATE,
-    TO_TIMESTAMP(1431212057)::DATE
+    '2015-05-09 00:00:00',
+    '2015-05-09 00:00:00'
 )
 ,
 (
+    'b2fa3458-5457-4ade-8ce4-bd973bce7da5',
     'SQLite Cheat Sheet',
     'Some notes on using SQLite
 
@@ -679,8 +691,28 @@ Dump output into a file
 Run SQL commands from file into a DB
 
     $ sqlite3 sqlite3.db < schema.sql',
-    TO_TIMESTAMP(1444863580)::DATE,
-    TO_TIMESTAMP(1444863580)::DATE
+    '2015-10-14 00:00:00',
+    '2015-10-14 00:00:00'
+)
+,
+(
+    '28110e5f-fba9-47a2-9d0d-4658bb31e5ba',
+    'Hello Markdown + MermaidJS!',
+    '```mermaid
+sequenceDiagram
+    participant Alice
+    participant Bob
+    Alice->>John: Hello John, how are you?
+    loop Healthcheck
+        John->>John: Fight against hypochondria
+    end
+    Note right of John: Rational thoughts<br/>prevail...
+    John-->>Alice: Great!
+    John->>Bob: How about you?
+    Bob-->>John: Jolly good!
+```',
+    '2023-04-12 18:20:35.031413',
+    '2023-04-12 18:20:35.031413'
 )
 
 ;
-- 
cgit v1.2.3

