Community & Support

Using Drupal to create a database frontend

Hi there,

Being relatively new to Drupal i need a push in the right direction. I just migrated a companies' website from plain HTML to a Drupal installation which went quite well. Now i have to create a frontend for an external database such that all entities in that database can be managed. I believe that requires me building a module, but although i have read trough a fair amount of virtual paper i do not quite get it yet.

I would love to achieve a situation in which database entities act like nodes to which comments can be added or on which the taxonomy system can be used, but without the need for redundant data or the merging of the external database with the Drupal database. The database contains about fifteen tables which could be represented by around ten 'nodes'. (Some nodes contain lists). My main question is, what would be the action plan i would have to follow in order to create a flexible GUI which can manage entities in the other database. I.e. listing, creating, altering and removal of entries or for example providing statistics over the content or any other thing you can possibly do with a relational database. It is a PostgreSQL database and i know i can use the database abstraction layer and connect to multiple databases with it, i already know how to do such a thing using PHP without using the Drupal API. But do i need to create new content types or are there modules that will help me with some of the work upon inclusion?

Thank you in advance.

Comments

Might want to check out the "DBA" module

http://drupal.org/project/dba

It's got some problems, but it already does a lot of what you're talking about... might be a good starting point.

Good luck,
-Derek

__________________________________________________________________
My professional services are available through 3281d Consulting

Thank you for your comment,

Thank you for your comment, but i really need to make a custom web application containing functionality that no general database frontend can provide. This is a more phpmyadmin-like module. It is therefore clear to me that i need to program it myself (duh, since i need loads of custom functionality). The only question is; how do i start in the way i supposed to be and how can i integrate drupal functionality into my own "nodes"?

Buy the Pro Drupal Development Book ...

... and work the examples. Then go tell your client you'll need a team of four or five people and at least a year to get anywhere approaching a workable site.

Are you kidding me? ;) So

Are you kidding me? ;) So when i create the entire application from scratch by myself, i can do it within two months. But if i use Drupal as a framework to take work like theming, database abstraction and role management out of my hands, then i will suddenly need a team for a full year?! Wasn't a framework supposed to decrease development time? But for a start, i will get the book, thank you for the tip.

Elaborate please?

Hi Elise,

I am hoping that the above remark is not completely serious....

Care to explain further?

Regards,

Gerrit

nobody click here