Skip to content

Docker image #12

Description

@herkulano

It would be great to have a docker image with Postgres + TIN available in PlanetScale's docker registry: https://hub.docker.com/u/planetscale

Activity

  1. herkulano commented on Oct 9, 2026

    @herkulano
    Author

    Meanwhile, I hope you're ok with me doing it, for my projects:
    https://github.com/herkulano/postgres-lead/pkgs/container/postgres-lead

  2. piki commented on Oct 9, 2026

    @piki
    Collaborator

    FYI: I'm working on this. #25 merged the workflows for it, and I'm still trying to work with our security guy to get OIDC set up so those workflows can actually publish to Docker Hub.

    Totally fine for you to publish your own images in the meantime.

    I made the images {x86-64,aarch64} for pg{17,18} with debug (slow, with symbols) builds of Lead. Postgres taken straight from core postgres Docker images based on Debian trixie. No extra Postgres extensions or packages, but of course you could add those in a higher Docker layer if you want. If that's not quite what you had in mind, let me know.

  3. piki commented on Oct 9, 2026

    @piki
    Collaborator

    OK, it's live on Docker Hub:

    $ docker run -d --rm --name lead -e POSTGRES_PASSWORD=foo -p 5433:5432 planetscale/lead:latest
    
    $ psql postgresql://postgres:foo@localhost:5433
    
    postgres=# \dx
                                        List of installed extensions
      Name   | Version | Default version |   Schema   |                   Description
    ---------+---------+-----------------+------------+-------------------------------------------------
     plpgsql | 1.0     | 1.0             | pg_catalog | PL/pgSQL procedural language
     tin     | 1.0.6   | 1.0.6           | tin        | Lead: TIN-compatible non-production text search
    
    postgres=# create table t as select generate_series(1,10000)::text as s;
    SELECT 10000
    postgres=# create index tidx on t using tin(s);
    CREATE INDEX
    postgres=# select * from t where s ==> '42';
     s
    ----
     42
    (1 row)
    
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions