Linux.com

Basebuilder plug

Posted by: Anonymous Coward on May 21, 2005 09:44 PM
Another option for an MS Access alternative is <A HREF="http://basebuilder.sourceforge.net/" title="sourceforge.net">Basebuilder</a sourceforge.net>, a PHP/MySQL program and a database framework, like Microsoft Access or Filemaker, designed to help you build custom, web-based databases. I haven't tried it to it's potential but it looks pretty flexible.

Basebuilder will automatically create html-based layouts based on your existing database tables, providing you with an easy to use web-based interface to your database in minutes.

Some of the features:

  • Three ways to search:

    1. Simple search - allows you to enter a single word or phrase which is searched against one or several fields (as specified by you) in a single table

    2. Search by layout - allows you to search any field in a given table - boolean and/or is allowed

    3. Advanced search - allows you to enter a SQL statement or build one using a visual SQL statement builder

  • Saved searches - all searches can be saved for later use

  • Automatically generated and sroll-able results - search or browse results are displayed 20 per page (customizable by you) with the number of returned results is displayed along with forward and backward arrows to scroll through the pages.

  • Ability to add relationships between tables with automatic cascading deletes.

  • Ability to add as many users as you want. Each user is assigned to a database username, allowing you to give different users different levels of access to the database.

  • Ability to create full database backups on the server and download them to your desktop.

#

Return to One small business's year without Windows