Conversion
Conversion
WEBP
To WEBP
cwebp input.jpg -o output.webpFrom WEBP
dwebp input.webp -o output.pngAVIF
To AVIF
avifenc input.jpg output.avifFrom AVIF
avifdec input.avif output.jpgConvert JPG to PNG
magick input.jpg output.pngISO
Convert .bin & .cue files to .iso
bchunk img.bin img.cue imgConvert .nrg to .iso
nrg2iso img.nrg img.isoSQLite
Convert CSV to SQLite DB
Assuming you have a CSV file named data.csv:
shell
$ sqlite3 data.dbIn the SQLite3 interactive session that opens, pass these commands:
sqlite> .mode csv;
sqlite> .import data.csv data; -- Here, "data" stands for the table name.Exit the SQLite3 interactive session with Ctrl+c, and you have an SQLite3 DB.
Convert TSV to SQLite DB
TSV == tab-separated values.
That means the header too is tab-separated! (I guess it’s implied, but I wrote the header comma-separated style.)
Plus if you use Vim and if you have enabled expandtab, run set noexpandtab to disable conversion of tabs to spaces.
Assuming you have a TSV named data.tsv:
shell
$ sqlite3 data.dbIn the SQLite3 interactive session that opens, pass these commands:
sqlite> .mode tabs; -- Notice the tabs mode instead of csv.
sqlite> .import data.csv data; -- Here, "data" stands for the table name.Exit the SQLite3 interactive session with Ctrl+c, and you have an SQLite3 DB.
WOFF2
To WOFF2
woff2_compress input.ttfFrom WOFF2
woff2_decompress input.woff2