Profile picture

Hi, it’s Clément! 👋

I’m a software engineer at Cloudflare and an open-source enthusiast.

💻 Current Software Projects

Sesters

💱 Fast, offline currency converter 💴 💷 💶 💵

🏷️ rust 🏷️ cli 🏷️ money 🏷️ finance 🏷️ rust-lang 🏷️ rustlang 🏷️ command-line-tool 🏷️ currency-converter 🏷️ hacktoberfest 🏷️ sesters

Into ledger

🔮 AI-powered expenses classifier for ledger. The original project seems not to be maintained anymore, hence this fork to continue improving it.

🏷️ golang 🏷️ productivity 🏷️ money 🏷️ finance 🏷️ ai 🏷️ ledger 🏷️ bayesian-inference 🏷️ ledger-cli 🏷️ maintained-fork

Rusqlite migration

↕️ Simple database schema migration library for rusqlite, written with performance in mind.

🏷️ rust 🏷️ library 🏷️ schema 🏷️ sqlite3 🏷️ rusqlite

Gohugo shorturl

🔗 Hugo module to create shorturls (so your shorturl like my.site/short can redirect to asitewithalong.name/andanevenlongerpath)

🏷️ static-site-generator 🏷️ hugo 🏷️ static-site 🏷️ gohugo 🏷️ gohugoio 🏷️ hugo-module

More ➡️

🗞️ 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....

May 7, 2021 · 5 min
Browse by tag 🏷️ RSS feed 🔔