postgresql-schema alternatives and similar packages
Based on the "postgresql" category.
Alternatively, view postgresql-schema alternatives based on common mentions on social networks and blogs.
-
postgresql-simple-named
:question: Implementation of named parameters for `postgresql-simple` library -
postgresql-placeholder-converter
Converter for question mark style and dollar sign style of PostgreSQL SQL.
InfluxDB - Purpose built for real-time analytics at any scale.
* Code Quality Rankings and insights are calculated and provided by Lumnify.
They vary from L1 to L5 with "L5" being the highest.
Do you think we are missing an alternative of postgresql-schema or a related project?
README
PostgreSQL Schema
PostgreSQL Schema is a database migration tool. Based on Schema Evolution Manager.
Installation
The tools can be installed through cabal or stack.
Cabal:
$ cabal install postgresql-schema
Stack:
$ git clone [email protected]:mfine/postgresql-schema.git
$ cd postgresql-schema
$ stack install
Adding Migrations
Add a migration file. The tool schema-add
takes as parameters a file
and a directory containing migrations. By default, the directory
migrations
in the current working directory is used. These
parameters can be overridden on the command line:
$ schema-add --file new.sql --name add-users --dir scripts
Applying Migrations
Apply migrations to a database. The tool schema-apply
takes as
parameters a database and a directory containing migrations. By
default, the directory migrations
in the current working directory
is used, and the database specified in DATABASE_URL
environment
variable is used. These parameters can be overridden on the command
line:
$ schema-apply --url postgres://user@localhost/database --dir scripts
Clearing Migrations
Remove public and migrations schema from a database - USE
CAREFULLY. The tool schema-clear
takes as paramaters a
database. By default, the database specified in DATABASE_URL
environment variable is used. This parameter can be overriden on the
command line:
$ schema-clear --url postgres://user@localhost/database