Data | Splint.rs

Recfiles Extended Example

Create Make a database for your boardgames, specifying only one field and value: 1database=games.rec 2n=Name 3g=Vojvodina 4touch $database 5recins -f $n --value $g $database 6recsel $database Insert a few more, with the estimated playtime: 1recins -f Name -v Saboter -f Playtime -v 30 $database 2recins -f Name -v Chess …

Recfixes

1 min read · data recfiles

Sometimes recsel chokes on a large query, and you need to break the query into chunks with a pipe. This Kickstarter file has 374,853 records. Here's the chonky query: 1recsel kick.rec -e "Category = 'Games'" -p "Subcategory,Avg(Goal)" -G Subcategory It breaks down like this: Chunk Meaning recsel kick.rec Select records …

sc-im

2 min read · TUI data spreadsheet .csv

Sample file Basic Commands See Cells Cells are hard to see. Change this with :set autowrap. Make sc-im always autowrap: 1mkdir .config/sc-im/bash 2echo 'set autowrap' >> .config/sc-im/scimrc Movement Command Key highest part H lowest part L top gg most right. g$ most left. g0 insert middle \ insert left > insert right …

Search System

1 min read · data search locate plocate

You can search every file on the computer instantly by installing plocate. Once installed, run sudo updatedb to create the database of (nearly) every file on the computer. Check how big the database is: 1du -h /var/lib/plocate/plocate.db Once you have the database, you can find nearly any file instantly. Search for …

Search Video Audio

1 min read · data video

Check subtitles available: 1url='https://videos.domainepublic.net/videos/watch/d9567d5b-1add-477c-bce3-a58cef84c28c' 2yt-dlp --list-subs "$url" | grep --max-count=1 '^en' The original language often displays with -orig, e.g. en-orig (Original). 1Language Formats 2ar vtt 3az vtt 4bg vtt 5ca vtt 6cs vtt 7da vtt 8de vtt …

Sharing Secrets

1 min read · data death secrets ssss

You can share parts of a secret with multiple people, so only some of them need to agree to see the secret. Install ssss, then decide on the total number of secrets (N), and the threshold of people who must share their shard of the secret in order to reveal the secret. 1N=5 2T=3 3FILE=secret.txt 4fortune | ssss-split …

Soft Serve Maintenance

1 min read · data git server maintenance

Over time git repositories become bloated with old data, but never get cleaned. I can't find an official way to clean up the crud, so I did this: 1usermod -aG soft-serve $USER 2# Log out and back in for this to take effect. 3 4cd /var/lib/soft-serve/data/repos 5sudo chmod -R g+w * 6git config --global --add …

Soft Serve through https

2 min read · data git server lfs

http Setup In this example, the port used is 23231, but it can be anything. Open /var/lib/soft-serve/data/config.yaml and make sure the http section looks like this: 1# The HTTP server configuration. 2http: 3 # The address on which the HTTP server will listen. 4 listen_addr: ":23232" 5 6 # The path to the TLS private …

Soft-Serve

1 min read · data git server lfs TUI

Soft-Serve with https Maintenance

sqlite

1 min read · data

Work with a database: 1sqlite3 "$FILE".sqlite3 Compress the database: 1pragma vacuum; Optimize the database: 1pragma optimize;