Project-Insanity

https://github.com/reuben/pgdump2sql

CREATE TABLE projects (
    id integer NOT NULL,
    name character varying(200) NOT NULL,
    homepage character varying(200) NOT NULL,
    backend character varying(20),
    version_url character varying(200),
    regex character varying(200),
    latest_version character varying(50),
    logs text,
    updated_on timestamp,
    created_on timestamp,
    insecure boolean DEFAULT false NOT NULL,
    version_prefix character varying(200),
    ecosystem_name character varying(200)
);

CREATE TABLE packages (
    id integer NOT NULL,
    distro character varying(200),
    project_id integer,
    package_name character varying(200)
);

select project_id,package_name from packages where package_name="0ad" and distro="Arch Linux";
select latest_version from projects where id="5830";