Database Deployment Manager

Developer Tools

Source (link to git-repo or to original if based on someone elses unmodified work): Add the source-code for this project on git.opendesktop.org

1
Score 48%
Description:

Database Deployment Manager is a unique tool for getting into control in the database creation and initial setup process by helping professionals to have consistent database layouts and delivery between projects, sites and versions. It provides an easy way of creating the initial database layout, also featuring a diagram editor to visualize the relationship between tables. It also has a unique object oriented modelling feature allowing the user to model the database using well known OOP pronciples, version management and documentation generator. The release 0.1k adds support for CUBRID and sqltie databases.
Last changelog:

5 years ago

* 0.1a - Initial release
* 0.1b - Fixed a small bug in the foreign key handling
* 0.1c - Fixed another bug in the table deletion mechanism when the table was
part of a diagram
* 0.1d - Fixed some small bugs
- Implemented copy/paste for tables and columns
- Implemented the grouping of the data types in color coded folders
- Minor GUI redesign for some windows
* 0.1e - Fixed more bugs
- Some GUI redesign
- More documentation written
- Implemented the database reverse engineering feature
- Implemented a database validation
* 0.1f - Even more bugs were fixed. Some more were introduced
- Visual Query builder for VIEW queries
- Connection manager
- Parallel deployment
- Changed to inno installer
* 0.1g - Code completion for the SQL editor
- Some bugs fixed, some more bugs introduced
- Database browsing and query execution
* 0.1h - Tracker issues 3477408, 3477376, 3474266, 3473043, 3470040, 3468464,
3466097, 3463529 were resolved
- Implemented data validation for the table instances
- Lots of small annyoing issues were fixed
- Worked on the SQL editor
- Procedures implemented
* 0.1i - more database object supported for deployment
- triggers implemented
- database specific properties implemented
- database browsing enhanced supporting more objects
- some fine tuning of GUI elements
- tracker issues 348283 and 3482824 fixed
- a new Help system
* 0.1j - version management implemented
- bind to deployment implemented
- documentation generator implemented
- fixed issues with the renamed table instances - other objects now support
the renamed table instances
- some gui refinements
- some bugs fixed
* 0.1k - Sqlite and CUBRID support implemented
- fixed the query editor to be more faster and less error prone
- implemented a guided stored method creation GUI
- modified the Version Update screen to disallow downgrades
- repository for database definitions
- some bug fixes in the version management
- create a table in the database itself with GUI support

bitcrazy

5 years ago

And the link to the source code is restricted!

Report

C

fritzone

5 years ago

Thank you for attracting my attention towards this, I have added an extra link to the source code package.

Report

bitcrazy

5 years ago

Apart from the issue that the source code can't be directly downloaded form here and that you only provide packages for sh**buntu. This is no KDE app. It doesn't rely in any way on the KDE libraries. Please post it at qt-apps.org.

Report

C

fritzone

5 years ago

You're right about the KDE libraries, but for this application there was no real need to introduce an extra layer of complexity... it is complicated enoguh without these too.

Regarding packaging: I am really sorry, but I simply don't have the resources to support all the various linux distros out there. They use several different package management systems, which is not only difficult for the users, but it can be really a ngihtmare for the developer if they want to support more than one of them. So I took the brave decision to support the one which is the most simple for the end user. This is Ubuntu and its derivatives.

Report

bitcrazy

5 years ago

Unfortunately your app has some hardcoded paths, so packaging for other distros is only possible by patching your source code.
Your app will be installed to /opt/ddm, where only large applications/program packages should go. Apart from that, all subdirs are installed inside of "/opt/ddm/bin", which is a no-go. I've patched your source to install into /usr as prefix. The help doesn't work, because the /doc/ directory is somewhat hardcoded in src/gui/gui_HelpWindow.cpp, I guess. It is under /usr/share/doc/ddm now.
I can't imagine, that even Ubuntu will accept this.
-DCMAKE_INSTALL_PREFIX is ignored completely.
Nevertheless no KDE libs, no KDE app, so wrong place here.
I really appreciate the hard work you've done until now, but please move this app to qt-apps.

Report

C

fritzone

5 years ago

Hi again,

Regarding paths: The application is supposed to be installed in one directory, because it accesses all its resources (DB repository, DB defaults, help) in a common way for all the platforms, using relative paths from the application's executable directory. If I would have had scattered theses around the system the entire codebase would be full with #ifdefs depending on the operating system... These are the deuces when preparing something for multiplatform compatibility :( I find KDE to be the most common sense desktop environment out there so I made a few extra steps to provide better integration of the application into it. Unless explicitly required by someone I have no plans of providing packages for any other linux distro / nor better desktop integration due to lack of time and resources.

Regarding /opt/ddm: According to http://www.pathname.com/fhs/pub/fhs-2.3.html#OPTADDONAPPLICATIONSOFTWAREPACKAGES this seemed to be a good location to install the App. It's pretty big, with several files packaged in a non standard way ... The only files that do not go in this place are the ones KDE (and gnome) uses for integrating the app into the desktop and the menu (/usr/share/applications & icons according to http://standards.freedesktop.org/icon-theme-spec/icon-theme-spec-latest.html) ...

Regarding Ubuntu: possibly not, the application is waiting in their review system for the last 8 months (when I have released the previous version), so I think I'll give up ever having this in the basic Ubuntu system and I use the .DEBs for distributing. Before the .DEBs there were binary installers but they didn't handle the dependencies very well, so I had to learn how to DEB (well, at least with CMake ... )

Regarding KDE & KDE libs: when I have added the application to kde-apps I could select the dependency of only Qt, and I did not find any mention on the site that the application should be linked to any of the KDE libs. I thought the site name means application which can be run on your KDE (Applications for your KDE desktop - does this mean you should link to KDE libs?). If there would be a gnome-apps.org I would post it there too (since the application also runs nicely on gnome 2 & 3 ...). My goal is to tell the world outside that there is a free app which they can use to ease their daily lives with databases and it seemed normal to have it posted to as many places as possible.

However to comply with your request please point me on the site where it is explicitly mentioned that it is mandatory to link to any of the KDE libraries in order to have your app on the kde-apps site, and if it is written convincingly enough I will remove the application from here, and leave only the one at qt-apps.org

Report

bitcrazy

5 years ago

Not a KDE app: Ask the people who run this site. It was often enough explained to the developers.
There is a reason, why there are different sites for different toolkits.
And yes, I am aware that there are a lot of other QT apps here
Paths: When you are not willing to solve the hardcoded paths and want your app to live in /opt, it is your decision.
I would have been able to build packages for other distros, but ok, it's your app.
If you really follow the FHS, all files will be where they are expected.
Sorry, but even in /opt, you can't mix text files with binaries.

Report

C

fritzone

5 years ago

Paths: You have a valid point here, in the next release for Linux I will fix this issue. It should have a proper integration into Linux systems too, regardless of other operating systems.

KDE app: before the next release is out (at that time noone really should download the old release) I will remove the app from this site since indeed it does not need KDE to function. However it would be great to attract the attention of the app developers to not to post any KDE unrelated applications here when they are posting a new app.

cheers, f.

Report

XandarKablandar

5 years ago

This would be great to have in the Kubuntu package repositories.

Report

C

fritzone

5 years ago

It is waiting approval in the "plain" ubuntu repositories (for some time)... https://myapps.developer.ubuntu.com/dev/apps/2086/ Do you know how can I add to the kubuntu repos?

Report

XandarKablandar

5 years ago

The Kubuntu repositories are the Ubuntu repositories ; they share it all :)

Report

C

fritzone

5 years ago

Great... Then let's hope one day they will arrive there too...

Report

ksolsim

5 years ago

where is source code?

Report

C

fritzone

5 years ago

Here: https://sourceforge.net/p/dbm-project/code/ci/default/tree/

Report

5 years ago

* 0.1a - Initial release
* 0.1b - Fixed a small bug in the foreign key handling
* 0.1c - Fixed another bug in the table deletion mechanism when the table was
part of a diagram
* 0.1d - Fixed some small bugs
- Implemented copy/paste for tables and columns
- Implemented the grouping of the data types in color coded folders
- Minor GUI redesign for some windows
* 0.1e - Fixed more bugs
- Some GUI redesign
- More documentation written
- Implemented the database reverse engineering feature
- Implemented a database validation
* 0.1f - Even more bugs were fixed. Some more were introduced
- Visual Query builder for VIEW queries
- Connection manager
- Parallel deployment
- Changed to inno installer
* 0.1g - Code completion for the SQL editor
- Some bugs fixed, some more bugs introduced
- Database browsing and query execution
* 0.1h - Tracker issues 3477408, 3477376, 3474266, 3473043, 3470040, 3468464,
3466097, 3463529 were resolved
- Implemented data validation for the table instances
- Lots of small annyoing issues were fixed
- Worked on the SQL editor
- Procedures implemented
* 0.1i - more database object supported for deployment
- triggers implemented
- database specific properties implemented
- database browsing enhanced supporting more objects
- some fine tuning of GUI elements
- tracker issues 348283 and 3482824 fixed
- a new Help system
* 0.1j - version management implemented
- bind to deployment implemented
- documentation generator implemented
- fixed issues with the renamed table instances - other objects now support
the renamed table instances
- some gui refinements
- some bugs fixed
* 0.1k - Sqlite and CUBRID support implemented
- fixed the query editor to be more faster and less error prone
- implemented a guided stored method creation GUI
- modified the Version Update screen to disallow downgrades
- repository for database definitions
- some bug fixes in the version management
- create a table in the database itself with GUI support

File (click to download) Version Description Packagetype Architecture Downloads Date Filesize DL OCS-Install
Pling
Details
license
version
0.1k
updated Sep 24 2013
added May 24 2013
downloads today
0
page views today 3
System Tags app software