DbSchema



  • DbSchema is a design tool for relational databases, with interactive diagrams, HTML documentation, Relational Data Browse and Editor, SQL Editor, Query Builder, Random Data Generator, Schema Compare and Synchronization, team work and more. Powerful, yet easy-to-use, DbSchema helps you design, document and manage databases without having to be a.
  • Dbschema is a tool to run MySQL or PostgreSQL migrations automatically. Using a table, it keeps a state of previous migrations to avoid duplicates. Features: Support for MySQL and PostgreSQL; Optional pre and post-migration queries (for example to update privileges).
Latest version

DBSchema is a diagram-oriented database software developed by Wise Coders Solutions. You can use it to simplify complex schemas, generate test data, view information from multiple tables. It has a 64-bit installer that is compatible with most Windows devices with a built-in OpenJDK 12.

Released:

Schema migration made easy

Project description

dbschema is a tool to run MySQL or PostgreSQL migrationsautomatically. Using a table, it keeps a state of previous migrations toavoid duplicates.

Features:

  • Support for MySQL and PostgreSQL
  • Optional pre and post-migration queries (for example to updateprivileges)
  • Multiple migrations in multiple databases can be processed as one.
Free

Installation

Create a config file

Create the file ~/.dbschema.yml and add your databasesconfiguration. See example

Create migrations table

dbschema uses a table called migrations_applied to keep track ofmigrations already applied to avoid duplication. See the schema forMySQL or PostgreSQL.

Migrations folder structure

For each database, you need to have a migration path (setting pathin the migration file).

Within that path you need to create one folder per migration. Thisfolder must contain a file called up.sql with the SQL queries andoptionally a file called down.sql for rollbacks.

Moodle packages for Mac OS X These packages contain Moodle plus all the other software needed to make it run on a Mac: Apache, MySQL and PHP. They are built using MAMP. See the documentation Installation Package for OS X for details. Moodle mac download.

Usage

Rollback

Project details


Release historyRelease notifications | RSS feed

1.4.3

1.4.2

1.4

1.3

1.2.5

1.2.4

1.2.3

1.2.2

1.2.1

1.2

1.1.2

Dbschema Download

1.1.1

1.1

1.0.2

1.0.1

Dbschema

Dbschema Review

1.0.0

Teams is available for 32-bit and 64-bit versions of Windows (8.1 or later) and Windows Server (2012 R2 or later), as well as for macOS (10.10 or later) and Linux (in.deb and.rpm formats). In short, search for an answer before turning to Quora for such simple questions. Can i get microsoft teams on my macbook. Download Microsoft Teams now and get connected across devices on Windows, Mac, iOS, and Android. Collaborate better with the Microsoft Teams app.

Download files

Dbschema Tool

Dbschema_tables

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for dbschema, version 1.4.3
Filename, sizeFile typePython versionUpload dateHashes
Filename, size dbschema-1.4.3-py2.py3-none-any.whl (7.2 kB) File type Wheel Python version py2.py3 Upload dateHashes
Filename, size dbschema-1.4.3.tar.gz (6.0 kB) File type Source Python version None Upload dateHashes
CloseDbSchema

Hashes for dbschema-1.4.3-py2.py3-none-any.whl

Hashes for dbschema-1.4.3-py2.py3-none-any.whl
AlgorithmHash digest
SHA256f35333580c28db9cdec26de2696978786974e587c2d261a401549de4303bccd1
MD52726718c6f703d4ec0d024f9b96c05e0
BLAKE2-2568a19ed13c3f12e873f84be54220e57a6890ce3253885a42123c84f5ac4c600a7
Close

Hashes for dbschema-1.4.3.tar.gz

Hashes for dbschema-1.4.3.tar.gz
AlgorithmHash digest
SHA256ee984c4e2dfd56c49b7ac444cc20ca80b38a4f62d5b3117c29b9f45ec46bf761
MD59cbef720ee1ea9f839002a4bc2349787
BLAKE2-25631a9de084490940fb2a532bf9f662a1d31553d92ed532143083e8d74193fa3b5