ERD software that is manageable by git

Need help with an engine or coding not on the list? Need help with a game or the website and forums here? Direct all questions here.

ERD software that is manageable by git

Postby Chris » Tue Nov 28, 2017 5:40 pm

Does anyone know of a good way of maintaining a database structure alongside a diagram, that can be maintained easily across a team using git, subversion or mercurial? Currently my team uses Navicat, which has great structure and data synchronization utilities. But I would love it if we could maintain a nicely laid out diagram rather than having to reverse engineer the database every time. As a simple diagram can sometime help a huge headache of trying to figure out which column relates to which key.
Fighting for peace is declaring war on war. If you want peace be peaceful.
User avatar
Chris
 
Posts: 1573
Joined: Wed Sep 30, 2009 2:22 pm
Has thanked: 4 times
Been thanked: 5 times
Blog: View Blog (2)

Re: ERD software that is manageable by git

Postby Jackolantern » Sat Dec 02, 2017 5:30 pm

Oh man, someone on my team was talking about a tool that did something like this a few weeks back. Maybe not 100%, but I will ask him about it on Monday.
The indelible lord of tl;dr
User avatar
Jackolantern
 
Posts: 10850
Joined: Wed Jul 01, 2009 6:00 pm
Location: Houston, TX
Has thanked: 22 times
Been thanked: 88 times
Blog: View Blog (1)

Re: ERD software that is manageable by git

Postby Chris » Mon Dec 11, 2017 12:57 pm

Jackolantern wrote:Oh man, someone on my team was talking about a tool that did something like this a few weeks back. Maybe not 100%, but I will ask him about it on Monday.

Any news? I would really appreciate it.
Fighting for peace is declaring war on war. If you want peace be peaceful.
User avatar
Chris
 
Posts: 1573
Joined: Wed Sep 30, 2009 2:22 pm
Has thanked: 4 times
Been thanked: 5 times
Blog: View Blog (2)

Re: ERD software that is manageable by git

Postby Jackolantern » Mon Dec 11, 2017 8:42 pm

Oh sorry I had forgotten about this. Alright I will ask tomorrow.
The indelible lord of tl;dr
User avatar
Jackolantern
 
Posts: 10850
Joined: Wed Jul 01, 2009 6:00 pm
Location: Houston, TX
Has thanked: 22 times
Been thanked: 88 times
Blog: View Blog (1)

Re: ERD software that is manageable by git

Postby Chris » Tue Dec 12, 2017 4:18 pm

Any luck Jack?
Fighting for peace is declaring war on war. If you want peace be peaceful.
User avatar
Chris
 
Posts: 1573
Joined: Wed Sep 30, 2009 2:22 pm
Has thanked: 4 times
Been thanked: 5 times
Blog: View Blog (2)

Re: ERD software that is manageable by git

Postby Jackolantern » Tue Dec 26, 2017 11:31 pm

I spoke with them, but we weren't quite sure what you meant by "can be maintained alongside a diagram"? Do you just mean that the diagrams of the DB structure continue to change as the database is altered? Because I do believe I had misunderstood what you had meant when I thought someone had talked about it (I was thinking you meant more of a way to persist and share DB migrations). However, my team does have 3 really good DB people that know about a lot of different products so I can see if they know of anything.

EDIT: Also, what RDBMS are you using? My team's experience is mostly centered on SQL Server, but most of them have worked with others as well.
The indelible lord of tl;dr
User avatar
Jackolantern
 
Posts: 10850
Joined: Wed Jul 01, 2009 6:00 pm
Location: Houston, TX
Has thanked: 22 times
Been thanked: 88 times
Blog: View Blog (1)

Re: ERD software that is manageable by git

Postby Chris » Wed Jan 03, 2018 5:05 am

RDBMS primarily spread sheets, doesn't really matter, at the end of the day it's all rows and columns. We work with all different types of SQL.

I want to be able to manage an ERD which I can engineer into a database, and be able to share changes to the diagram with git. We currently do it the other way round, every time we reverse engineer the database into a diagram, we loose the diagram structure.

Navicat, mysql workbench, I don't care about the tool at the end of the day it's all the same thing.
Fighting for peace is declaring war on war. If you want peace be peaceful.
User avatar
Chris
 
Posts: 1573
Joined: Wed Sep 30, 2009 2:22 pm
Has thanked: 4 times
Been thanked: 5 times
Blog: View Blog (2)

Re: ERD software that is manageable by git

Postby Jackolantern » Fri Jan 05, 2018 8:36 pm

So by being git-compatible, you are looking for something that would be text (perhaps JSON) format? And also, what do you mean by "reverse engineer the database into a diagram"? You mean generate a diagram from the database?

I still feel like I am missing something. Many systems like SQL Server can generate ERDs on demand.
The indelible lord of tl;dr
User avatar
Jackolantern
 
Posts: 10850
Joined: Wed Jul 01, 2009 6:00 pm
Location: Houston, TX
Has thanked: 22 times
Been thanked: 88 times
Blog: View Blog (1)

Re: ERD software that is manageable by git

Postby Chris » Sun Jan 07, 2018 5:01 am

I want the opposite way round, engineer the diagram into the database structure. I know there are loads of systems that will allow you to do so, but the diagram layout is never saved. It could be any format, JSON, XML or whatever, as long as a vcs can manage and merge changes to the diagram between team members. That way we can put the database diagram into our projects and if you want to make changes you simply commit them to the rest of the team.

Currently we use Navicat which has great structure and data sync features which is very usefull, but generating the diagram everytime we loose the layout, and it isn't obvious at a glance which columns relate to other columns, which you see instantly in a diagram, saving a lot of hastle.

I find it very handy to make a simple diagram and engineer it straight into model logic so I can instantly program my views and controllers, saving a lot of time. I prefer this method to things such as redbean where the database structure is generated on the fly, simply because of the diagram.

If you're familiar with MySQL workbench you can forward engineer a diagram straight into a database with the whole shebang such as mock data, the constraints are generated for you simply by connecting one table to the other. You can also add comments to the columns etc. The only disadvantage to workbench is that it goes pretty slow on a lot of slower PC's and crashes a lot for no apparent reason.

I will ask the question again. Is there a way to manage an ERD with git? I know you can't do this with a workbench diagram as it's saved in a binary format, not XML or something of the sort.
Fighting for peace is declaring war on war. If you want peace be peaceful.
User avatar
Chris
 
Posts: 1573
Joined: Wed Sep 30, 2009 2:22 pm
Has thanked: 4 times
Been thanked: 5 times
Blog: View Blog (2)

Re: ERD software that is manageable by git

Postby Jackolantern » Sun Jan 07, 2018 12:02 pm

Okay, I have got it now. I will see what I can find out.
The indelible lord of tl;dr
User avatar
Jackolantern
 
Posts: 10850
Joined: Wed Jul 01, 2009 6:00 pm
Location: Houston, TX
Has thanked: 22 times
Been thanked: 88 times
Blog: View Blog (1)

Next

Return to Advanced Help and Support

Who is online

Users browsing this forum: No registered users and 1 guest

cron

x