You are here: TWiki > Gna Web > DBedit r4 - 17 Jul 2002 - 20:18 - TWikiGuest


Start of topic | Skip to actions

DBedit

Welcome to the DBedit page!. You can edit these pages to leave comments or ask questions about DBedit.

dbedit is a system for integrating development web database applications. It is been developed and used by the Globewide Network Academy to create and edit database tables over the web.

dbedit is unique among web database products because it abstracts the display of the information from the storage. In order to display a database, you create a straight HTML form, and then run a perl script on it which generates a CGI wrapper to the script. The advantages to this are:

  • You can add arbitrary perl code to your database applications
  • You can integrate your application with any database by writing a driver routine. Because display and storage are separated, you can then change the database implementation without rewriting your forms, or change your forms without rewriting your database.
  • It runs with DBI so switching between databases should be easy.

dbedit is distributed under the GPL (General Public License) of the Free Software Foundation.

Right now there is a driver for DBI which has been tested with PostgreSQL. It should also work with Oracle, MySQL, but I have tried them yet. There is also a driver for flat ASCII texts files using the file format for the Revolutionary Software's /rdb commercial database system. You can also use the freeware RDB (ftp://ftp.rand.org/pub/RDB-hobbs) database system, which was developed by Walt Hobbs from Rand Corporation.

RDB and DBedit are both sets of Perl scripts and the only requirement is that Perl (Perl5.004) must be installed on the system. Both software systems run on Windos95, NT and Unix based machines.

Since the database parts of the code are modularized, it should be a very simple matter to interface the system with other text formats and database systems.

There are also technical design notes for dbedit.

Support

Please e-mail me at joe@confucius.gnacademy.org if you download this. I'm in the process of putting together a mailing list.

What's new

  • DBI driver
  • new OO design

System requirements

dbedit runs on anything with perl5.

Source

There are two versions of dbedit which can available for download.

The new improved unstable 1.95 is available at http://www.gnacademy.org/tech/dbedit/dbedit-1.95.tgz. It features a new OO design, a DBI driver, and Mason integration.

The old depreciated of dbedit is 0.9.13 and is available at: http://www.gnacademy.org/tech/dbedit/dbedit-0.9.13.tar.gz.

License

These programs are distributed in the hope that they will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GPL (General Public License) of the Free Software Foundation for more details.

Edit | Attach | Printable | Raw View | Backlinks: Web, All Webs | History: r4 < r3 < r2 < r1 | More topic actions
Labs.DBedit moved from Gna.DBedit on 13 Jun 2002 - 20:16 by TWikiGuest
This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors and is licensed under the terms of the GNU Free Documentation License.
Ideas, requests, problems regarding TWiki? Send feedback