dbmate
dbmate copied to clipboard
amacneil
:rocket: A lightweight, framework-agnostic database migration tool.
greetings! context: - `ClickHouse server version 22.3.3 revision 54455.` - `dbmate status` fails at `1.15.0` but works at `1.13.0` ```sh $ dbmate --url status Error: sql: expected 0 arguments, got...
My migrations look like this ```sql CREATE TABLE company_db.events ON CLUSTER 'company_cluster' ( time DateTime, uid Int64, type LowCardinality(String) ) ENGINE = ReplicatedMergeTree('/clickhouse/tables/{cluster}/{shard}/table', '{replica}') PARTITION BY toDate(time) ORDER BY (uid);...
dbmate does not support additional `.env` files, e.g. `.env.local` or `.env.development.local` due to https://github.com/joho/godotenv/issues/10 Possible solutions of varying completeness: - Have [`loadDotEnv`](https://github.com/amacneil/dbmate/blob/519f186c8a3daec086608b2c21677c672eda56db/main.go#L215) also load `.env.local` - Add `--envfile` option which...
Hi there, it would be cool if the dbmate.DB type supported an FS field, so it can be used with go 1.16 file embedding. My use case is that I...
Hi, We are using dbmate for migrations, we are running into an issue where we want to run following ``` -- migrate:up transaction:false CREATE INDEX CONCURRENTLY index_name ON table(new_id); ```...
Hi everyone, As you can see, I haven't had a lot of time to work on dbmate lately. It is stable and works great for most use cases, so doesn't...
``` $ dbmate dump Error: pg_dump: error: query failed: ERROR: column "x.tableoid" does not exist pg_dump: error: query was: SELECT x.tableoid, x.oid, x.extname, n.nspname, x.extrelocatable, x.extversion, x.extconfig, x.extcondition FROM pg_extension...
Firstly, thank-you for an awesome tool! For the ultra paranoid of us, who prefer not to leave the MySQL password in an env file (even on a well secured Bastion...
I want to make a table with the fts5 sqlite extension like so: ```sql CREATE VIRTUAL TABLE mytable_fts using fts5(content="mytable", mycolumn); ``` this works in sqlite3 but not in a...
