Skip to content

Instantly share code, notes, and snippets.

@ackinc
ackinc / tune.md
Created August 7, 2026 21:37 — forked from phiresky/tune.md
SQLite performance tuning

You can scale a SQLite database to multiple GByte in size and many concurrent readers by applying the below optimizations.

Run these every time you connect to the db

(some are applied permanently, but others are reset on new connection)

pragma journal_mode = WAL;

Instead of writing directly to the db file, write to a write-ahead-log instead and regularily commit the changes. Allows multiple concurrent readers, and can significantly improve performance.

@ackinc
ackinc / sieve_privacy_policy.md
Created July 29, 2024 13:28
[Privacy Policy] Sieve: IMDB ratings on Indian OTT platforms

PRIVACY POLICY

What informaton does this extension collect?

  • As a user is browsing movies / shows on an OTT platform's website, this extension scrapes the web page to identify the movies / shows being shown to the user

How is this information used?

  • Once the movies / shows on the web page have been identified, their IMDB rating and related information is retrieved via a web request to a third-party, and the ratings are displayed to the user next to the movie tile.
@ackinc
ackinc / vscode-launch.json
Created January 26, 2022 06:37
Base VSCode launch conf for projects created with @ack_inc/create-node-proj
{
// Use IntelliSense to learn about possible attributes.
// Hover to view descriptions of existing attributes.
// For more information, visit: https://go.microsoft.com/fwlink/?linkid=830387
"version": "0.2.0",
"configurations": [
{
"type": "pwa-node",
"request": "launch",
"name": "Run Current File",
# git shortcuts
alias gits='git status'
alias gitb='git branch'
alias glog='git log --graph --oneline --decorate'
alias gco='git checkout'
alias gcd='git checkout dev'
alias gcdev='git checkout dev'
alias gcs='git checkout staging'
alias gcm='git checkout master'
alias gcmn='git checkout main'