Showing seconds in the system tray clock in Windows 10 is accomplished via a registry hack.
It is based a boolean DWORD entry called ShowSecondsInSystemClock
.
The entry doesn't exist by default, so must created by hand,
or you can use the code below to create two convenient registry script files,
one for enabling seconds and another for disabling.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
colorscheme jellybeans | |
filetype plugin indent on " This does though, including ruby. | |
syntax on " turn on syntax hilighting | |
set hidden " allow hidden buffers, i.e. unsaved buffers in background | |
" set mouse +=a " enable mouse support in terminal -> http://stackoverflow.com/questions/2149456/reasons-for-using-command-line-vim-versus-gui-vim | |
" set clipboard=unnamedplus | |
set clipboard=unnamed " enable yanks to go to OS clipboard. | |
set nu " line numbers on | |
set ignorecase " ignore case in searches | |
set smartcase " ignore case if search pattern is all lowercase, case-sensitive otherwise |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
require 'set' | |
require 'digest/md5' | |
# Introducing the concept of the *determistic key* (DK)! | |
# The DK is a deterministic, order-independent (when needed), fixed-length hash | |
# digest of a scalar value or a collection of values. Utilizing hashing | |
# algorithms allows for deterministic key generation in distributed systems, and | |
# thus very parallel-friendly asychronous generation by multiple cores or | |
# machines. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Thanks to: https://stackoverflow.com/questions/58655766/create-trigger-for-update-another-row-automatically-on-same-table-using-postgres | |
/* | |
Features: | |
- DONE Auto-updating xtime. | |
- DONE Insert custom vtime. | |
- DONE Insert custom vtime & xtime. | |
- DONE Idempotency. | |
- DONE Vtime insertion order is independent. | |
- DONE Do-not-insert new row when attrs is identical to previous row. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* NOTES | |
This file contains an efficient, script-ready algorithm to upsert data into a | |
persistent, point-in-time (PIT) staging table (PSA) in PostgreSQL. | |
It is assumed that the PSA will provide a virtually immutable datastore of all | |
ingested data in it's original form, e.g., as it appeared in a source CSV files | |
or source tables at certain points in time. The PSA in turn provides the basis | |
for dynamically deriving useful analytical datasets, such as star/snowflake | |
schemas, which can be blown away and rebuilt as needed to support ever changing |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Adapted from my MySQL SCD2 version here: https://gist.github.com/raven-rock/ff715978ae75fdf67e42f764ed1566c3. | |
-- | |
-- Meant to be a more general https://en.wikipedia.org/wiki/Temporal_database technique, not limited | |
-- to dimensional modeling's SCD2 use case. | |
-- Set up scd | |
drop table if exists scd_widget; | |
create temporary table scd_widget |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
WITH xs as ( | |
select '' as x -- empty string | |
union all select 'a' -- lowercase letter | |
union all select 'A' -- uppercase | |
union all select 'aa' -- two ascii letters | |
union all select 'á' -- 'a' with accent | |
union all select '的' -- one CJK character, stored as multiple bytes | |
union all select 'deadbeef' | |
union all select 'DEADBEEF' | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
In this example, | |
- rowid is simply a rowid for the scd. Perhaps to avoid confusion we actually always name this "rowid". | |
- widget_code is the durable natural key (could be a composite set of columns) | |
- widget_name is the change-tracked attribute (could be set of columns) | |
- widget_color is another the change-tracked attribute (could be set of columns) | |
*/ |
tz_database_name(pk) | country_code | latitude_longitude | portion_of_country_covered | status | utc_offset | utc_dst_offset | notes |
---|---|---|---|---|---|---|---|
Africa/Abidjan | CI | +0519−00402 | Canonical | +00:00 | +00:00 |
NewerOlder