popagent

Latest change 6edc7e928c57dab23c0973ed3f7ee70b3ebb72d5 - Initial popagent baseline by AkurAI Build

CREATE TABLE IF NOT EXISTS popagent_memory_settings (
  singleton BOOLEAN PRIMARY KEY DEFAULT TRUE CHECK (singleton),
  auto_compact BOOLEAN NOT NULL,
  observation_tokens INTEGER NOT NULL CHECK (observation_tokens BETWEEN 4000 AND 200000),
  reflection_tokens INTEGER NOT NULL CHECK (reflection_tokens BETWEEN 4000 AND 400000),
  recent_message_percent INTEGER NOT NULL CHECK (recent_message_percent BETWEEN 5 AND 75),
  buffer_on_idle BOOLEAN NOT NULL,
  updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

CREATE TABLE IF NOT EXISTS popagent_data_migrations (
  id TEXT PRIMARY KEY,
  applied_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

DO $migration$
BEGIN
  IF NOT EXISTS (
    SELECT 1 FROM popagent_data_migrations
    WHERE id = '2026-08-14-memory-settings-v1'
  ) THEN
    INSERT INTO popagent_memory_settings (
      singleton, auto_compact, observation_tokens, reflection_tokens,
      recent_message_percent, buffer_on_idle
    )
    VALUES (TRUE, TRUE, 30000, 40000, 20, TRUE)
    ON CONFLICT (singleton) DO NOTHING;
    INSERT INTO popagent_data_migrations (id)
    VALUES ('2026-08-14-memory-settings-v1')
    ON CONFLICT DO NOTHING;
  END IF;
END
$migration$;

ALTER TABLE popagent_memory_settings ALTER COLUMN auto_compact DROP DEFAULT;
ALTER TABLE popagent_memory_settings ALTER COLUMN observation_tokens DROP DEFAULT;
ALTER TABLE popagent_memory_settings ALTER COLUMN reflection_tokens DROP DEFAULT;
ALTER TABLE popagent_memory_settings ALTER COLUMN recent_message_percent DROP DEFAULT;
ALTER TABLE popagent_memory_settings ALTER COLUMN buffer_on_idle DROP DEFAULT;