carlos carl0smat3us

🎯

focusing

carl0smat3us / auto_update_updated_at_triggers.sql

Last active June 14, 2025 13:01

Create a trigger to update the updated_at field for every table that has it.

	SET TIME ZONE 'America/New_York';

	create extension if not exists moddatetime schema extensions;

	DO $$
	DECLARE
	r RECORD;
	trigger_name text;
	BEGIN
	FOR r IN

carl0smat3us / postDate.js

Last active May 19, 2024 12:50

Publication date

	import { formatDistanceToNowStrict } from 'date-fns'
	import { enUs } from 'date-fns/locale'

	function formatPublishedSince(date) {
	try {
	const publishedSince = formatDistanceToNowStrict(new Date(date), {
	locale: enUs,
	})
	return `${publishedSince} ago`
	} catch (e) {