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

Using `@react-pdf/renderer` v3.0.1 with React 18

Introduction

When I tried to use the @react-pdf/renderer package (version 3.0.1) with a React 18 app, two problems arose. In this article, I'll describe those problems and tell you how I solved them.

Update: Here's a video demonstration of the problems and solution described in this article: https://youtu.be/YZP5r7Uy_bU

Problem 1: Dependency Conflict

Go development environment on Windows with MSYS2

Normally, it is sufficient to grab the Go MSI installer from the website in order to set up the toolchain. However, some packages that provide Go wrappers for C libraries rely on cgo tool, which in turn, needs the GCC toolchain in order to build the glue code. Also, 3rd-party dependencies are usually hosted on services like GitHub, thus Git is also needed. This mini-guide illustrates how to setup a convenient development environment on Windows using MSYS2.

Notes:

Application does not consume system proxy configuration -> Solution: Modify /etc/hosts to redirect inbound requests (Burp)
On Android the AOT Compilation option requires an Enterprise license or higher, is available only when the project is configured for Release mode, and it is disabled by default.(Source)

Regarding the interception of HTTP:

https://docs.microsoft.com/en-us/xamarin/android/app-fundamentals/http-stack?tabs=macos

We did it through USB reverse tunneling and iptable rules local to the phone.

As Gecko is moving toward more Rust code, the cases where Rust and C code interoperate will become more common.

This document is an attempt to ease the learning curve for engineers facing it for the first time. It assumes no prior experience with cross-language C interfaces (called FFI).

It also assumes that Rust code is already built into Gecko. If you need help with that, read Introducing Rust code in Firefox.

What can you transfer across the fence

	'use client';

	/*
	This file is adapted from next-themes to work with tanstack start.
	next-themes can be found at https://github.com/pacocoursey/next-themes under the MIT license.
	*/

	import * as React from 'react';

	interface ValueObject {

	// Types for the result object with discriminated union
	type Success<T> = {
	data: T;
	error: null;
	};

	type Failure<E> = {
	data: null;
	error: E;
	};

	version: '3.4'

	services:
	mail:
	image: inbucket/inbucket:latest

	environment:
	NODE_ENV: production
	ports:
	- 9000:9000

	{
	"PX1": "no_script",
	"PX2": "js_bootstrap",
	"PX3": "domready",
	"PX4": "fingerprint",
	"PX6": "nav_timing",
	"PX7": "incognito",
	"PX8": "score_session",
	"PX9": "score_impression",
	"PX10": "ui_interaction",

	package transform

	import (
	"reflect"
	"strings"
	"time"
	)

	const (
	tagName = "firestore"