💱 Fast, offline currency converter 💴 💷 💶 💵
💻 Current Software Projects
Lightweight Container Proxy
🔒 Lightweight firefox addon providing socks5 proxy per container
Gohugo Shorturl
🔗 Hugo module to create shorturls (so your shorturl like my.site/short can redirect to asitewithalong.name/andanevenlongerpath)
Rusqlite Migration
↕️ Simple database schema migration library for rusqlite, written with performance in mind.
🗞️ On the blog
SQLite Pragma Cheatsheet for Performance and Consistency
SQL pragma are statements (like SELECT … or CREATE TABLE …) that change the database behaviors or call a special functions. This post is a short list of SQLite pragma I use in my projects built on SQLite, to get better performance and more consistency. TL;DR When Opening the DB PRAGMA journal_mode = wal; -- different implementation of the atomicity properties PRAGMA synchronous = normal; -- synchronise less often to the filesystem PRAGMA foreign_keys = on; -- check foreign key reference, slightly worst performance and check user_version....