Lev Lazinskiy

DO $$
BEGIN
    IF NOT EXISTS (SELECT 1 FROM pg_type WHERE typname = 'task_status') THEN
        CREATE TYPE task_status AS ENUM ('todo', 'doing', 'blocked', 'done');
    END IF;
END
$$;

CREATE TABLE IF NOT EXISTS
tasks (
  id           integer PRIMARY KEY,
  title        varchar(200), 
  status       task_status NOT NULL DEFAULT 'todo',
  created_date timestamp
);

DO $$
BEGIN
    IF NOT EXISTS (SELECT 1 FROM pg_roles WHERE rolname = 'reader') THEN
        CREATE ROLE reader;
    END IF;
END
$$;
GRANT SELECT ON tasks TO reader;

Thank you for reading! Share your thoughts with me on bluesky, mastodon, or via email.

Check out some more stuff to read down below.

Most popular posts this month

• 2024
• Reinstalling Windows at 1am
• SQLite DB Migrations with PRAGMA user_version
• My Custom Miniflux CSS Theme
• How to Disable Wayland in Debian Testing

Recent Favorite Blog Posts

This is a collection of the last 8 posts that I bookmarked.

• The Software Essays that Shaped Me from Refactoring English
• Give Your Spouse the Gift of a Couple's Email Domain from mtlynch.io
• Skip the Next iPhone from Articles on Jose M.
• Have smart glasses finally hit an inflection point? from The Torment Nexus
• The McPhee method from the jsomers.net blog
• Pluralistic: LLMs are slot-machines (16 Aug 2025) from Pluralistic: Daily links from Cory Doctorow
• Pluralistic: Bluesky creates the world's weirdest, hardest-to-understand binding arbitration clause (15 Aug 2025) from Pluralistic: Daily links from Cory Doctorow
• Just a Little More Context Bro, I Promise, and It’ll Fix Everything from Jim Nielsen’s Blog