hartraft

PostgreSQL is Enough

• Simplify: move code into database functions
• Just Use Postgres for Everything
• PostgreSQL is the worlds’ best database
• Postgres is eating the database world
• Hacker News discussion

Background and Cron Jobs

hartraft

Creating mysqld link
[100%] Built target mariadbd
Creating mariabackup link
[100%] Built target mariadb-backup
make -j$(nproc)

5106.18s user
613.70s system
726% cpu

hartraft

Tips

• https://vimtricks.com/p/confirm-replacements/ ⭐⭐
• https://vimtricks.com/p/change-character-case/ ⭐ (toggle case in IntelliJ)
• Multiple copy/paste history registers (IntelliJ Ctrl+Shift+V)
• https://vimtricks.com/p/edit-multiple-lines-at-once-in-vim/

Plugins

• https://github.com/tpope/vim-surround ⭐
• https://github.com/mechatroner/rainbow_csv (vim alternative to https://github.com/andmarti1424/sc-im)

hartraft

• Rectangle - Windows+Left/Right equivalent
• Clippy - Windows+Shift+V for copy/paste history
• Alt tab - Standard windows switching behaviour instead of stupid switch by "Application"

hartraft

#!/bin/bash

user_input="; rm -rf /"

# This is dangerous!
eval "echo Hello $user_input World"

hartraft

CRiU

Using the simple example from the website. https://criu.org/Simple_loop

Install CRiU

sudo apt update
sudo apt install criu

# Check criu is installed with the correct kernel

hartraft

See also:

• Free database hosting
• https://free-for.dev/#/?id=iaas
• https://free-for.dev/#/?id=paas

Service	Type	RAM	Storage	Limitations
👉 Adaptable	PaaS	256 MB	Non-persistent? (1 GB database storage available)
AWS EC2	IaaS	1 GB		⚠️ Only free for 1 year

hartraft

Postgres

• Index Json data in Postgres (Scalegrid)
• JSON in PostgreSQL (Cybertec)
• Postgres FTS (Crunchydata)
• When to avoid JSONB in a Postgres schema
• PostgreSQL JSON (Instaclustr)
• Oleg's FOSDEM 2021 speeding up JSONB in Postgres talk
• [Oleg's PGConfEU 2012 talk FTS in

hartraft

-- Cache and table hit rates for Postgres
SELECT
  'index hit rate' AS name,
  (sum(idx_blks_hit)) / nullif(sum(idx_blks_hit + idx_blks_read),0) AS ratio
FROM pg_statio_user_indexes
UNION ALL
SELECT
 'table hit rate' AS name,
  sum(heap_blks_hit) / nullif(sum(heap_blks_hit) + sum(heap_blks_read),0) AS ratio
FROM pg_statio_user_tables;

hartraft

# This file contains fixed global exclude patterns

*~
~$*
.~lock.*
~*.tmp
]*.~*
]Icon\r*
].DS_Store
].ds_store