{"repo":"VVVi/clickhouse-migrations","free":true,"listed":false,"github":"https://github.com/VVVi/clickhouse-migrations","clone":"git clone https://github.com/VVVi/clickhouse-migrations.git","description":"ClickHouse Migrations NodeJS CLI","language":"TypeScript","stars":69,"topics":["clickhouse","clickhouse-migrations","nodejs","npm","migration","migrations"],"license":"MIT","category":"cli-tools","readme_excerpt":"clickhouse-migrations ClickHouse Migrations CLI Install Usage Create a directory, where migrations will be stored. It will be used as the value for the --migrations-home option (or for environment variable CH MIGRATIONS HOME ). In the directory, create migration files, which should be named like this: 1 some text.sql , 2 other text.sql , 10 more test.sql . What's important here is that the migration version number should come first, followed by an underscore ( ), and then any text can follow. The version number should increase for every next migration. Please note that once a migration file has been applied to the database, it cannot be modified or removed. For migrations' content should be used correct SQL ClickHouse queries. Multiple queries can be used in a single migration file, and each query should be terminated with a semicolon (;). The queries could be idempotent - for example: CREATE TABLE IF NOT EXISTS table ...; Clickhouse settings, that can be included at the query level, can be added like SET allow experimental object type = 1; . For adding comments should be used -- , # , #! . If the database provided in the --db option (or in CH MIGRATIONS DB ) doesn't exist, it will be created automatically. To disable this behavior (for example, when the user has no privileges to create databases), use the --skip-db-creation option (or set CH MIGRATIONS SKIP DB CREATION to 'true' ); in that case the database must already exist. For TLS/HTTPS connections, you can provide a cus","default_branch":null,"files":null,"tree":[],"storefront":"/r/VVVi","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/VVVi/clickhouse-migrations/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}