Running vpub-plus from a binary, using Supabase as Postgres provider

Author	Topic
mysh	Posted on 2025-03-02 16:08:23 Latest vpub-plus releases are precompiled to 7 operating systems for amd64 and arm64 platforms. Supabase is a cloud Postgres provider which also have a free plan, handy for testing! Let's say we want to run vpub-plus version 1.11. Downloading a precompiled vpub-plus Go to https://github.com/hugmouse/vpub-plus/releases/tag/1.11 and download an archive for your operating system + your platform. For example, to run it on Windows 11 that uses AMD/Intel processor, download vpub-plus-1.11-windows-amd64.zip. If you are running a MacOS on a M1 chip, then download [vpub-plus-1.11-darwin-arm64.tar.gz ](https://github.com/hugmouse/vpub-plus/releases/download/1.11/vpub-plus-1.11-darwin-arm64.tar.gz). Open it up and extract its content somewhere where you want to run your vpub-plus from. Setting up Supabase Sign up to Supabase and create a new project. Then click on "Connect" button in the top bar and copy "Session pooler" connection string. It looks something like this: postgresql://postgres.itgscczwkahvlfhkddde:[YOUR-PASSWORD]@aws-0-us-west-1.pooler.supabase.com:5432/postgres Connecting Supabase to vpub-plus You need to run vpub-plus in a terminal since it does not have any GUI. On Unix systems you can run it this way: DATABASE_URL=postgresql://postgres.itgscczwkahvlfhkddde:[YOUR-PASSWORD]@aws-0-us-west-1.pooler.supabase.com:5432/postgres ./vpub-plus On Windows 11, ensure that you have installed windows terminal, then you can use the same command above. If you did everything correctly, then you will see the following log: 2025/03/02 16:44:46 [Migrate] schema_version table doesn't exist, treating current version as 0 2025/03/02 16:44:46 Current schema version: 0 2025/03/02 16:44:46 Latest schema version: 10 Migrating to version: 1 Migrating to version: 2 Migrating to version: 3 Migrating to version: 4 Migrating to version: 5 Migrating to version: 6 Migrating to version: 7 Migrating to version: 8 Migrating to version: 9 Migrating to version: 10 2025/03/02 16:45:01 Starting HTTP server on localhost:8080 2025/03/02 16:45:01 [Warning] CSRF: Secure cookie is disabled. Set CSRF_SECURE=true environment variable to enable it. Last edited on 2025-03-02 16:10:53

Author

Topic

mysh

Posted on 2025-03-02 16:08:23

Latest vpub-plus releases are precompiled to 7 operating systems for amd64 and arm64 platforms. Supabase is a cloud Postgres provider which also have a free plan, handy for testing!

Let's say we want to run vpub-plus version 1.11.

Downloading a precompiled vpub-plus

Go to https://github.com/hugmouse/vpub-plus/releases/tag/1.11 and download an archive for your operating system + your platform.

For example, to run it on Windows 11 that uses AMD/Intel processor, download vpub-plus-1.11-windows-amd64.zip. If you are running a MacOS on a M1 chip, then download [vpub-plus-1.11-darwin-arm64.tar.gz

](https://github.com/hugmouse/vpub-plus/releases/download/1.11/vpub-plus-1.11-darwin-arm64.tar.gz).

Open it up and extract its content somewhere where you want to run your vpub-plus from.

Setting up Supabase

Sign up to Supabase and create a new project. Then click on "Connect" button in the top bar and copy "Session pooler" connection string. It looks something like this:


postgresql://postgres.itgscczwkahvlfhkddde:[YOUR-PASSWORD]@aws-0-us-west-1.pooler.supabase.com:5432/postgres

Connecting Supabase to vpub-plus

You need to run vpub-plus in a terminal since it does not have any GUI. On Unix systems you can run it this way:


DATABASE_URL=postgresql://postgres.itgscczwkahvlfhkddde:[YOUR-PASSWORD]@aws-0-us-west-1.pooler.supabase.com:5432/postgres ./vpub-plus

On Windows 11, ensure that you have installed windows terminal, then you can use the same command above.

If you did everything correctly, then you will see the following log:

2025/03/02 16:44:46 [Migrate] schema_version table doesn't exist, treating current version as 0
2025/03/02 16:44:46 Current schema version: 0
2025/03/02 16:44:46 Latest schema version: 10
Migrating to version: 1
Migrating to version: 2
Migrating to version: 3
Migrating to version: 4
Migrating to version: 5
Migrating to version: 6
Migrating to version: 7
Migrating to version: 8
Migrating to version: 9
Migrating to version: 10
2025/03/02 16:45:01 Starting HTTP server on localhost:8080
2025/03/02 16:45:01 [Warning] CSRF: Secure cookie is disabled. Set CSRF_SECURE=true environment variable to enable it.

Last edited on 2025-03-02 16:10:53