GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → amatsuda → Erd

amatsuda / Erd

Licence: mit
A Rails engine for drawing your app's ER diagram

Programming Languages

ruby
36898 projects - #4 most used programming language

Labels

databaserailsenginedatabase-managementdatabase-migrationsdatabase-schema

Projects that are alternatives of or similar to Erd

Obevo
Obevo is a database deployment tool that handles enterprise scale schemas and complexity
Stars: ✭ 192 (-35.14%)
Mutual labels:  database-schema, database-management, database-migrations, database
upscheme
Database migrations and schema updates made easy
Stars: ✭ 737 (+148.99%)
Mutual labels:  database-migrations, database-management, database-schema
Express Knex Objection
A simple API system on a pg database, using knex and objection to simplify connection and management
Stars: ✭ 20 (-93.24%)
Mutual labels:  database-schema, database-migrations, database
Compalex
Lightweight script to compare two database
Stars: ✭ 318 (+7.43%)
Mutual labels:  database-schema, database-management, database-migrations
cl-migratum
Database Schema Migration System for Common Lisp
Stars: ✭ 29 (-90.2%)
Mutual labels:  database-migrations, database-management, database-schema
Lol dba
lol_dba is a small package of rake tasks that scan your application models and displays a list of columns that probably should be indexed. Also, it can generate .sql migration scripts.
Stars: ✭ 1,363 (+360.47%)
Mutual labels:  database-migrations, database, rails
Liquibase
Main Liquibase Source
Stars: ✭ 2,910 (+883.11%)
Mutual labels:  database-management, database-migrations, database
Sql Database Management System
SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.
Stars: ✭ 83 (-71.96%)
Mutual labels:  database-schema, database-management
Postguard
🐛 Statically validate Postgres SQL queries in JS / TS code and derive schemas.
Stars: ✭ 104 (-64.86%)
Mutual labels:  database-schema, database
Dbmate
🚀 A lightweight, framework-agnostic database migration tool.
Stars: ✭ 2,228 (+652.7%)
Mutual labels:  database-schema, database-migrations
r2dbc-migrate
R2DBC database migration tool & library
Stars: ✭ 83 (-71.96%)
Mutual labels:  database-migrations, database-management
Fluentmigrator
Fluent migrations framework for .NET
Stars: ✭ 2,636 (+790.54%)
Mutual labels:  database-schema, database
maricutodb
PHP Flat File Database Manager
Stars: ✭ 23 (-92.23%)
Mutual labels:  database-management, database-schema
Migrate
Issues for Prisma Migrate are now tracked at prisma/prisma. This repo was used to track issues for Prisma Migrate Experimental and is now deprecated.
Stars: ✭ 780 (+163.51%)
Mutual labels:  database-schema, database-migrations
Gnorm
A database-first code generator for any language
Stars: ✭ 415 (+40.2%)
Mutual labels:  database-schema, database
mongo-migrate
Versioned migrations for MongoDB.
Stars: ✭ 79 (-73.31%)
Mutual labels:  database-migrations, database-management
Query track
Find time-consuming database queries for ActiveRecord-based Rails Apps
Stars: ✭ 258 (-12.84%)
Mutual labels:  database, rails
Schemahero
A Kubernetes operator for declarative database schema management (gitops for database schemas)
Stars: ✭ 265 (-10.47%)
Mutual labels:  database-schema, database-management
React Agent
Client and server-side state management library
Stars: ✭ 235 (-20.61%)
Mutual labels:  database-management, database
Pg insights
A collection of convenient SQL for monitoring Postgres database health.
Stars: ✭ 253 (-14.53%)
Mutual labels:  database-management, database
View All Similar Projects ➔

Erd

A Rails engine for drawing your app's ER diagram and operating migrations

Requirements

  • Rails 5.2, 5.1, 5.0, 4.2, 4.1, 4.0, 3.2, or 3.1

  • Graphviz

Installation

Bundle 'erd' gem to your existing Rails app's Gemfile:

gem 'erd', group: :development

Usage

Browse at your http://localhost:3000/erd

Features

Show Mode

  • Erd draws an ER diagram based on your app's database and models.

  • You can drag and arrange the positions of each model.

    • Then you can save the positions to a local file db/erd_positions.json, so you can share the diagram between the team members.

Edit Mode

  • You can operate DB schema manipulations such as add column, rename column, alter column, create model (as well as table), and drop table.

  • Then, Erd generates migration files on the server.

  • And you can run each migration on your browser super quickly.

TODO

  • Fix buggy JS

  • drop column (need to think of the UI)

  • stop depending on Graphviz

  • tests

  • cleaner code (the code is horrible. Please don't read the code, though of course your patches welcome)

Contributing to Erd

  • Send me your pull requests!

Team

  • [Akira Matsuda][https://github.com/amatsuda]
  • [Teppei Machida][http://github.com/machida] (design)

Copyright

Copyright (c) 2012 Akira Matsuda. See MIT-LICENSE for further details.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].