ODS V3 Pre-Release: Public testing and refinement ahead of the official V3 launch. Turn your PC, Mac, or Linux box into a private AI server.
Python ai-agentsamdcomfyuidockerllama-cppllmlocal-ain8nnvidiaopen-webuiragself-hostedspeech-to-textstrix-halotext-to-speechworkflow-automation
\set ON_ERROR_STOP on
\getenv app_password PGVECTOR_APP_PASSWORD
CREATE EXTENSION IF NOT EXISTS vector;
CREATE ROLE ods_app LOGIN NOSUPERUSER NOCREATEDB NOCREATEROLE NOREPLICATION PASSWORD :'app_password';
\unset app_password
REVOKE ALL ON DATABASE vectors FROM PUBLIC;
GRANT CONNECT ON DATABASE vectors TO ods_app;
REVOKE CREATE ON SCHEMA public FROM PUBLIC;
GRANT USAGE ON SCHEMA public TO ods_app;
CREATE SCHEMA project AUTHORIZATION ods_app;
ALTER ROLE ods_app IN DATABASE vectors SET search_path TO project, public;