productdevbook

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';

copyleftdev

🚀 GNU Parallel Mastery: The Ultimate Cheat Sheet

📊 Basic Usage

Command	Description	Example
parallel echo ::: A B C	🔤 Process items in parallel	Output: A, B, C (in any order)
parallel echo {} ::: *.txt	🔍 Use {} as placeholder	Echoes names of all .txt files
cat file.txt | parallel echo	📥 Read input from stdin	Processes each line of file.txt
parallel -j4 command ::: item1 item2 item3	🔢 Limit to 4 jobs at a time	Runs 'command' on items, max 4 parallel

gurki

logmojis

A collection of useful emojis for logging and debugging. Cheerio 🙃.

status

✔️	success, done
❌	failure, error

mihow

# The initial version
if [ ! -f .env ]
then
  export $(cat .env | xargs)
fi

# My favorite from the comments. Thanks @richarddewit & others!
set -a && source .env && set +a

eyecatchup

git commit stats

Commands to get commit statistics for a Git repository from the command line -
using git log, git shortlog and friends.

---

rmehner

#!/usr/bin/env bash

# This is based on this excellent gist https://gist.github.com/jvenator/9672772a631c117da151
# Nothing of this is my original work, except that I made the download link an argument
# to this script, so it installs on OSX 10.11
#
# Thank you jvenator & sethetter
set -e

error() { info "$1"; exit 1; }

Integralist

• Install
• Shell exports
• Directory explanations
• Automatic Imports
• Private repo access
• Guard (automatic go run)
• Godo
• Spurious
• AWS SDK with Go (inc. some old possibly broken examples)
• Build and Compilation

bastianallgeier

# block content
location ~ ^/content/(.*).(txt|md|mdown)$ {
    rewrite ^/content/(.*).(txt|md|mdown)$ /error redirect;
}

# block all files in the site folder from being accessed directly
location ~ ^/site/(.*)$ {
    rewrite ^/site/(.*)$ /error redirect;
}

petemcw

Mac OS X LEMP Configuration

This Gist is a collection of configuration files that can be used to easily setup a Homebrew-based LEMP stack on Mac OS X.

Files in this repository are numbered and named for ordering purposes only. At the top of each file is a section of metadata that denote what component the file belongs to and the default name & location of the file. Feel free to implement it however you want.

Note: some configuration files have hard-coded paths to my user directory -- fix it for your setup

Setup

chatman-media

title	author	layout	categories
Using grunt and angular with pushstate support	Blackjid	post	grunt angularjs yeoman