bekind

bekind

What is it

Just a toy project to add some useful online utilities supported by DNS and HTTPS requests.

Features

caller ip address

try {ip,myip,my}.zif.im e.g.

dig @34.148.107.114  +short ip.zif.im
"46.117.241.248"

random unique id

try {id,key}.zif.im (based on nanoid), e.g.

dig @34.148.107.114  +short key.zif.im
"2y29jkma6bfw"

Default length is 12, but N.id.zif.im will return N lengthed random string (when I implement it).

URL Shortner

Pending

Athletics Database Migration

A utility to perform a one-time migration of athletics data between SQLite databases. This is useful for transferring data, merging databases, or replicating a subset of data.

Usage

bekind athletics-migrate \
  --source-db /path/to/source.db \
  --target-db /path/to/target.db \
  --log-file /path/to/migration.log

• --source-db: Path to the source SQLite database (read-only).
• --target-db: Path to the target SQLite database. Records will be inserted here.
• --log-file: Path to a file where detailed migration logs will be written.

Behavior

• One-way migration: Data flows from source to target.
• All tables: Migrates records from athletes, competitions, results, and sessions tables.
• Insert missing: Records present in the source but missing in the target (identified by ID) are inserted.
• Conflict detection: If a record exists in both databases with the same ID but different data, it is reported in the log as a conflict.
• No overwrite: Conflicting records in the target database are NOT modified.
• Data integrity: Source timestamps (created_at, updated_at) are preserved. All insertions are transactional per table.