Example usage:

 undefined

    
-- Register with default settings (41 timestamp bits, 10 type bits, 12 counter bits)
CALL snowflake.register('user_id');

-- Generate a user ID
SELECT snowflake.generate_user_id(now(), 1, 1);

-- Register with custom bit allocation
CALL snowflake.register('order_id', 42, 8, 13);

-- Generate an order ID with specific type and counter
SELECT snowflake.generate_order_id('2023-12-01 10:30:00 UTC', 5, 1000);

  

Crawlio is a simple C tool that slows down I/O operations by adding a specified amount of time to each I/O call. It uses LD_PRELOAD.

• Test application behaviour under slow I/O conditions
• Bring back the dial-up nostalgia
• Learn how to use LD_PRELOAD

I'm doing an extension that creates a pool of named background workers. Happy to hear any feedback on this.

 undefined

    
CREATE EXTENSION pg_worker_pool;
CALL worker_pool.submit('foo', 'create index myindex_1 on my_big_table (id)');
CALL worker_pool.submit('foo', 'create index myindex_1 on my_big_table (name)');
CALL worker_pool.submit('bar', 'create index otherindex_2 on other_big_table (author)');
CALL worker_pool.submit('bar', 'create index otherindex_2 on other_big_table (title)');

  

This will start two background workers, foo and bar. foo will create an indices on table my_big_table and bar on table other_big_table. foo and bar will run independently of each other, but all indices submitted to the same worker will be created in order.

I wrote a blog post comparing several range libraries for a case that is doing filter with non-trivial lambda and then reverse.

A blog post shows an example usage of hyperfine CLI tool to measure and plot time of startup and shutdown of several code interpreters.

A Programming Language Learner's Resource. Contains descriptions of many ineresting programming languages, like APL, ABC, FP, Factor with examples and further links.

I did a code that uses custom literals to allow indexing arrays with ordinals (1st, 2nd, 3rd), all at compile time. Additionally _st works only with 1, _nd only with 2, _rd only with 3. Zero and negative numbers are also not supported and fail compilation.

https://github.com/serpent7776/bits/blob/master/th.cpp/th.cpp

I created a very simple script that shows the history usage of your shell. Should work with bash and fish shells.

This basically goes through the history and counts the command names. So all of git push, git pull, etc will count as just git.

Example output:

 undefined

    
    847 pacman
    296 cd
    206 git
    203 time
    180 vim
    172 awk
    166 aur
    142 strace
    141 cat
    125 ls
Total commands:  7008
Unique commands: 753