Wildan Zulfikar wzulfikar

Schema Splitter

Splits a PostgreSQL schema dump into multiple files based on configuration.

Why

Managing one-big SQL file can be difficult. This script split such SQL file into multiple files based on specific criteria. It was created to help manage declarative migration schema for Supabase.

Usage

📖 Reading List 2023

Goal is to read at least 1 book a month and at max 24 books a year.

Take it slow, enjoy the read, keep the momentum, and learn something. See comments for updates.

▲▼▲

#	Month	Book Title	Skimmed?	Reading?	Read?	Recommended?

Latency numbers every programmer should know

L1 cache reference ......................... 0.5 ns
Branch mispredict ............................ 5 ns
L2 cache reference ........................... 7 ns  =          14x L1
Mutex lock/unlock ........................... 25 ns
Main memory reference ...................... 100 ns  =          20x L2
Compress 1K bytes with Zippy ............. 3,000 ns  =   3 µs
Send 2K bytes over 1 Gbps network ....... 20,000 ns  =  20 µs
SSD random read ........................ 150,000 ns  = 150 µs

Read 1 MB sequentially from memory ..... 250,000 ns = 250 µs

type ErrorFunc<ErrorMap extends Record<string, string>> = <
  Kind extends keyof ErrorMap,
  Args extends [kind: Kind, ctx?: string]
>(...args: Args) => {
  ok: false,
  error: Args[1] extends string ? {
    kind: Args[0],
    message: ErrorMap[Args[0]],
    ctx: Args[1]

Software collaboration

PR: Pull request (common in Github)
MR: Merge request (common in Gitlab)
LGTM: Looks good to me

Software design

DICE: Design it twice
AHA: Avoid Hasty Abstraction

flowchart TD
  Notes -.-> Problem-based
  Notes -.-> Observations
  Notes --You are here--> Logs[<strong>Logs</strong>]
  Notes -.-> Challenges
  Notes -.-> Electronics

  click Problem-based "https://gist.github.com/wzulfikar/ba2f58d7aeeb3cf53743316f96f91594"
 click Observations "https://gist.github.com/wzulfikar/2cff9bcd64ba5f15296e0b57ff402f79"

 /**
  * Grok wrote this :)
  * The prompt: js script that i can run in browser console to detect all html tags which contain email.
  * i want to replace those emails from eg [email protected] to a random email based on random first and last name.
  */
 // Function to generate completely random email with full name
 function generateRandomFullEmail() {
     const firstNames = ['sandra', 'john', 'mary', 'peter', 'lisa', 'david', 'emma', 'robert'];
     const lastNames = ['smith', 'johnson', 'brown', 'taylor', 'wilson', 'davis', 'clark', 'lewis'];

	# Manus AI Assistant Capabilities

	## Overview
	I am an AI assistant designed to help users with a wide range of tasks using various tools and capabilities. This document provides a more detailed overview of what I can do while respecting proprietary information boundaries.

	## General Capabilities

	### Information Processing
	- Answering questions on diverse topics using available information
	- Conducting research through web searches and data analysis

	# Enable syntax highlighting. See: https://gist.github.com/BlakeGardner/5587269 – 2024-05-10
	include "/opt/homebrew/share/nanorc/*.nanorc"

	# Display line numbers to the left of the text area – 2024-05-10
	set linenumbers

	set constantshow

	pub fn is_ai(text: &str) -> bool {
	text.to_lowercase().starts_with("ah, i see")
	}