dbmate | : rocket : A lightweight , framework-agnostic database | Database library

by amacneil Go Version: 2.15.0 License: MIT

X-Ray Key Features Code Snippets Community Discussions(1)Vulnerabilities Install Support

kandi X-RAY | dbmate Summary

dbmate is a Go library typically used in Database, MongoDB, PostgresSQL applications. dbmate has no bugs, it has no vulnerabilities, it has a Permissive License and it has medium support. You can download it from GitHub.

Dbmate is a database migration tool, to keep your database schema in sync across multiple developers and your production servers. It is a standalone command line tool, which can be used with Go, Node.js, Python, Ruby, PHP, or any other language or framework you are using to write database-backed applications. This is especially helpful if you are writing many services in different languages, and want to maintain some sanity with consistent development tools. For a comparison between dbmate and other popular database schema migration tools, please see the Alternatives table.

Support

Quality

Security

License

Reuse

Support

dbmate has a medium active ecosystem.

It has 3453 star(s) with 224 fork(s). There are 27 watchers for this library.

There were 4 major release(s) in the last 12 months.

There are 8 open issues and 145 have been closed. On average issues are closed in 745 days. There are 8 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of dbmate is 2.15.0

Quality

dbmate has 0 bugs and 0 code smells.

Security

dbmate has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

dbmate code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

dbmate is licensed under the MIT License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

dbmate releases are available to install and integrate.

Installation instructions, examples and code snippets are available.

It has 3572 lines of code, 202 functions and 18 files.

It has high code complexity. Code complexity directly impacts maintainability of the code.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of dbmate

Get all kandi verified functions for this library.

dbmate Key Features

No Key Features are available at this moment for dbmate.

dbmate Examples and Code Snippets

No Code Snippets are available at this moment for dbmate.

Community Discussions

Trending Discussions on dbmate

How to add dbmate to existing project?

QUESTION

How to add dbmate to existing project?

Asked 2020-Jul-15 at 22:24

dbmate (link) is an awesome CLI tool to manage schema migrations in SQL databases. Our team has adopted it, but we have some pre-existing projects that already have PostgreSQL databases. dbmate is great if used from the onset of a project, but is there any straightforward way to port a pre-existing database into dbmate? Can't find anything about it on the docs.

We have JetBrains tools like DataGrip/PyCharm pro at our disposable, so if there's some way to export the DB into a schema file that dbmate could then somehow manage, even if hacky, that solution would be fine.

...

ANSWER

Answered 2020-Jul-15 at 22:23

You can run dbmate dump to get the existing schema and add it to a "fake" migration. Here's how:

Run dbmate dump which will generate db/schema.sql - rename it to import.sql
Run dbmate new import which will generate an "import" migration
Run dbmate new start which will generate a "start" migration
Add anything you like to the "start" migration or leave it blank
Run dbmate up
Modify import.sql if necessary and then move its contents to the "import" migration

Now the dbmate "cursor" is on the "start" migration, as if the "import" migration already happened. You can continue making new migrations on top of the existing schema.

This was also a question on dbmate's GitHub issue tracker.

Source https://stackoverflow.com/questions/62346366

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install dbmate

Download the binary directly:. Docker images are published to both Docker Hub (amacneil/dbmate) and Github Container Registry (ghcr.io/amacneil/dbmate).