ROW_NUMBER Updated 2025-07-16sqlite3 ':memory:' 'WITH t (i) AS (VALUES (-1), (-1), (-2)) SELECT *, row_number() over () FROM t'-1|1
-1|2
-2|3With a possible output:
partition by:sqlite3 ':memory:' 'WITH t (i) AS (VALUES (-1), (-1), (-2)) SELECT *, row_number() over ( partition by i ) FROM t'-2|1
-1|1
-1|2 Fish Updated 2025-07-16
Vertebrates minus tetrapods.
Update multiple rows with different values in a single SQL query Updated 2025-07-16
Cherwell (newspaper) Updated 2025-07-16
The Oxford Student Updated 2025-07-16
Ubuntu 22.10 Updated 2025-07-16
Ubuntu 23.04 Updated 2025-07-16
Find GPU information in Ubuntu Updated 2025-07-16
Hide top bar on Ubuntu Updated 2025-07-16
Or likely more generally, on GNOME desktop, which is the default desktop environment as of Ubuntu 22.10.
couldn't save system state: Minimum free space to take a snapshot and preserve ZFS performance is Updated 2025-07-16
This BS started after the move to ZFS. The temporary solution appears to be: askubuntu.com/questions/1293685/out-of-space-on-boot-zpool-and-cant-run-updates-anymore/1374204#1374204
And then this to disable automatic snapshots in the future: askubuntu.com/questions/1233049/disable-automatic-zsys-snapshots-zfs-on-root/1279593#1279593
sudo mv /etc/apt/apt.conf.d/90_zsys_system_autosnapshot /etc/apt/apt.conf.d/90_zsys_system_autosnapshot.disabled torchvision ResNet Updated 2026-08-21
pytorch.org/vision/0.13/models.html has a minimal runnable example adapted to python/pytorch/resnet_demo.py.
That example uses a ResNet pre-trained on the COCO dataset to do some inference, tested on Ubuntu 22.10:This first downloads the model, which is currently 167 MB.
cd python/pytorch
wget -O resnet_demo_in.jpg https://upload.wikimedia.org/wikipedia/commons/thumb/6/60/Rooster_portrait2.jpg/330px-Rooster_portrait2.jpg
./resnet_demo.py resnet_demo_in.jpg resnet_demo_out.jpgWe know it is COCO because of the docs: pytorch.org/vision/0.13/models/generated/torchvision.models.detection.fasterrcnn_resnet50_fpn_v2.html which explains that is an alias for:
FasterRCNN_ResNet50_FPN_V2_Weights.DEFAULTFasterRCNN_ResNet50_FPN_V2_Weights.COCO_V1After it finishes, the program prints the recognized classes:so we get the expected
['bird', 'banana']bird, but also the more intriguing banana.
python/sympy_cheat/logarithm_integral.py Updated 2025-07-16
SQLite C extension Updated 2025-07-16
Example: sqlite/ip.c, adapted from www.sqlite.org/loadext.html, also mentioned explained at: stackoverflow.com/questions/7638238/sqlite-ip-address-storage/76520885#76520885.
Sample usage in the test program: sqlite/test.sh.
SQLite benchmark Updated 2025-07-16
Nested set model in SQL Updated 2025-07-16
How to implement Nested set model in SQL:
- stackoverflow.com/questions/192220/what-is-the-most-efficient-elegant-way-to-parse-a-flat-table-into-a-tree/42781302#42781302 contains the correct left/size representation and update queries, which makes it much easier to maintain the tree without having to worry about the sizes of siblings which are constant
- stackoverflow.com/questions/192220/what-is-the-most-efficient-elegant-way-to-parse-a-flat-table-into-a-tree/194031#194031 amazing ASCII art representations of the structure. Unfortunately uses a wonky left/right representation, rather than the much more natural left/size representation from the other post
Common Table Expression Updated 2025-07-16
Similar to SQL subquery, but with some differences: stackoverflow.com/questions/706972/difference-between-cte-and-subquery
rm -f tmp.sqlite
sqlite3 tmp.sqlite 'create table t(i integer)'
sqlite3 tmp.sqlite 'insert into t values (1), (2)'
sqlite3 tmp.sqlite 'with mycte as ( select * from t ) delete from mycte where i = 1'
sqlite3 tmp.sqlite 'select * from t' SQL PROCEDURE Updated 2025-07-16
SQL FUNCTION keyword Updated 2025-07-16
PostgreSQL spatial index Updated 2025-07-16
SQL
genenerate_series Updated 2025-07-16 There are unlisted articles, also show them or only show them.