Sleeyax sleeyax

Drizzle ORM PostgreSQL Best Practices Guide (2025)

Latest Drizzle ORM features and optimal schema patterns

Major 2025 Update: PostgreSQL now recommends identity columns over serial types. Drizzle has fully embraced this change.

import { pgTable, integer, text, timestamp, varchar } from 'drizzle-orm/pg-core';

You need spice-vdagent

Debian or Kali Linux installed to as KVM (libvirtd) guests do not automatically have qemu-guest-agent or spice-vdagent installed. This will prevent seamless movement of the mouse cursor between the guest and host desktop in Virtual Machine Manager (requiring the use of a Ctrl-Alt to release the cursor from the guest window).

To cure this, install both qemu-guest-agent and spice-vdagent on each guest and reboot (the guests).

$ sudo apt install qemu-guest-agent
$ sudo apt install spice-vdagent

Conventional Commit Messages

See how a minor change to your commit message style can make a difference.

Tip

Have a look at git-conventional-commits , a CLI util to ensure these conventions, determine version and generate changelogs

Commit Message Formats

Default

Step by step guide on how to generate and import a custom certificate into the Packet Capture Android app. Useful when the "generate certificate" feature doens't work for you either.

Generate certificate using openssl on your (linux) computer. You can also do this right on your Android device with a terminal/Termux/openssl app.
- openssl req -x509 -newkey rsa:4096 -keyout key-private.pem -out key-public.pem -days 3650
Export certificate to PKCS12 format
- openssl pkcs12 -export -out keyBundle.p12 -inkey key-private.pem -in key-public.pem -name alias -legacy
- Choose any password and alias name, make sure you remember it for the next few steps.
Transfer keyBundle.p12 and key-public.pem to the android device
- e.g. adb push keyBundle.p12 /sdcard/Download etc.
In android settings, go to Biometrics and Security (note I have a Samsung device, it might be different for you) > Other Security Settings >

Alerts

Alerts are an extension of Markdown used to emphasize critical information. On GitHub, they are displayed with distinctive colors and icons to indicate the importance of the content.

An example of all five types:

Note

Highlights information that users should take into account, even when skimming.

Tip

Optional information to help a user be more successful.

Stremio and Discord integration

	{
	"id": "com.example.addon3",
	"version": "1.0.0",
	"name": "Example addon 3",
	"catalogs": [],
	"resources": [
	"stream"
	],
	"types": [
	"movie"

	1. Create a folder called Payload
	2. Place the .app folder inside of that
	3. Zip up the Payload folder using normal compression
	4. Then rename the file with a .ipa extension


	import os
	import shutil
	import patoolib

	input_directory = '/path/to/input/direcotry'

	# List of filenames
	filenames = [
	'01 - Example comic 1 (2020)',

	mkdir ~/chromium && cd ~/chromium
	fetch --nohooks --no-history chromium
	cd src
	git fetch https://chromium.googlesource.com/chromium/src.git +refs/tags/118.0.5993.71:chromium_118.0.5993.71 --depth 1
	git checkout tags/118.0.5993.71
	gclient sync -D --force --reset --with_branch_heads