gobin-migrate: use tr to cut off quotes and space
Mention key=value connection strings
Simple self-hosted service for sharing text snippets
Two basic requirements are Go compiler (unless you grab built binaries) and PostgreSQL database running.
config.toml (or whatever you want) and
edit to your liking. All fields are required.
# Postgres database URI to connect to # # Formats: https://www.postgresql.org/docs/13/libpq-connect.html#LIBPQ-CONNSTRING # # Using a URI: databaseUri = "postgres://postgres:qqqq@localhost/gobin" # The same with keyword=value connection strings: #databaseUri = "host=localhost user=postgres password=qqqq dbname=gobin" # On which port the application runs # # If the port is <1024, you need to run gobin as root because such ports # are priviliged port = 4000 # Directories for static assets and templates, relative to where you're # launching gobin from templateRoot = "./templates" staticRoot = "./static" # Assume http:// on permalinks, setting this to true is not recommended # in production environments #insecure = true insecure = false
git clone https://git.sr.ht/~yerinalexey/gobin cd gobin go build
./gobin-migrate -c /etc/whatever.toml up
Warning: TOML parser in
gobin-migrate is too simple and will not
handle all cases.
If something goes wrong, you can apply migrations manually by running
up.sql files in subdirectories of
./gobin -config /etc/whatever.toml # if you have a config file in different place
It's also a good idea to run
gobin binary as a system service.