diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/data.sql | 72 | ||||
| -rw-r--r-- | db/db.sql | 11 |
2 files changed, 58 insertions, 25 deletions
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' ) ; @@ -5,9 +5,10 @@ CREATE DATABASE clog; CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; CREATE TABLE posts ( - id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), - title CHARACTER VARYING NOT NULL, - body CHARACTER VARYING NOT NULL, - created_at TIMESTAMP NOT NULL DEFAULT NOW(), - updated_at TIMESTAMP NOT NULL DEFAULT NOW() + id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), + -- draft BOOLEAN NOT NULL DEFAULT TRUE, + title CHARACTER VARYING NOT NULL, + body CHARACTER VARYING NOT NULL, + created_at TIMESTAMP NOT NULL DEFAULT NOW(), + updated_at TIMESTAMP NOT NULL DEFAULT NOW() ); |