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.

• Underused Techniques for Effective Emails from Refactoring English
• Death by a thousand slops from daniel.haxx.se
• The AGI economy is coming faster than you think from Freethink
• Rolling the ladder up behind us from Xe Iaso's blog
• In Praise of “Normal” Engineers from charity.wtf
• Reports of Bluesky's death have been greatly exaggerated from The Torment Nexus
• What Would a Kubernetes 2.0 Look Like from matduggan.com
• We Can Just Measure Things from Armin Ronacher's Thoughts and Writings