thursday, 17 april 2025
Vegepod Vegepod arrived and built… Code in Place Application successful! Course starts Monday! TIL Windows NT used 01/01/1601 as the Epoch for it's 64bit FILETIME which will roll over on 14 September 30828, so not something I will have to worry about! Google Chrome History From stackoverflow the date of visit_time can be shown in human readable form using the following sql : select datetime(visit_time / 10000000 + (strftime('%s','1601-01-01')), 'unixepoch', 'localtime') from visits; If the dates look off you missed a zero… vegepod cip sqlite epoch sql

wednesday, 5 june 2024
sqlite . headers on . mode csv . output bp Jun24 . csv select sys as Systolic , dia as Diastolic , pulse as Pulse , strftime ( '%d-%m-%Y,%H:%M' , dt ) as 'Date,Time' , replace ( replace ( lorr , 'l' , 'Left' ), 'r' , 'Right' ) as Arm from bp ; sqlite

wednesday, 14 february 2024
TIL yt-dlp: can be used to download zoom recordings sqlite> .headers on : to output column names select strftime('%d-%m-%Y %H:%M',dt) as 'Date', replace(replace(lorr, 'l', 'Left'), 'r', 'Right') as 'Arm', sys, dia, pulse from bp where id>175 order by dt desc; sqlite3 sql

tuesday, 13 june 2023
... , from PyCon US . Touch Typing SQLite Pyton ...

wednesday, 13 july 2022
awk Using awk to split files: awk '/%%%%/{x="F"++i;next}{print > x;}' test.html This is part of my preparation for moving this to a searchable sqlite database. awk

monday, 27 june 2022
Niklas Lumann Niklas Luhmann was the inventor of the Zettlekasten, which is a note taking and knowledge management system. Zettlekasten has a good Introduction to Zettelkasten. There is a useful blog by Sean Lawson on the why's and how's of using a Zettelkasten. How to take smart notes by Sönke Ahrens is a booklet on the Zettelkasten. Using sqlite3 as a notekeeping document graph with automatic reference indexing is a great article on developing a Zettelkasten system using sqlite3 database. zettelkasten note taking index

wednesday, 30 june 2021
Links Design Truth Afterpedia Tips on writing a qualitative dissertation: Part 1 Note Keeping using sqlite3 : zettlekasten See 27 June 2022 . Luhmann card index

sunday, 19 november 2017
Bookmarks sqlite tutorial learn regex GTD bookmarks

thursday, 22 june 2017
BCHS write permissions for sqlite3 on directory -lpthread

sunday, 31 may 2015
... essence of SQL in: PostgreSQL SQLite AirPrint Needed to build pycups ...

monday, 19 may 2014
... and so you can query the tables: SQLite version 3.8.4.3 OpenBSD Enter ...