Free db based software for linux

DB based NetFLow Collector aims to collect Cisco NetFlow data and store it to a database.
DB based NetFlow Collector has a plugin interface, which makes it flexible for fitting in particular tasks.
Enhancements:
- First release. post your comments/bug reports.

Know Base project consists of knowledge, document, and project management tool.

Know Base is a Web-based knowledge management system. It allows users to share files and projects across multiple business divisions.

A unique notification system alerts users when projects are modified, or when new projects are added that match their search terms.

DB::Appgen is a Perl interface which includes both function oriented and object oriented interfaces to manipulate data in APPGEN Custom Suite databases.

All this was made in about four hours including reading perlxstut manpage, so do not expect something pretty. Although it appears to be working OK in my tests.

Ill be doing some bigger data manipulations using this extension in the next couple of days and I will probably build some kind of higher level interface. If you dont see it on CPAN yet feel free to ask me about it.

Buster is a Model-view-controller Engine for PHP5-based systems.
Main features:
- full object oriented,
- config management,
- session management,
- logging support,
- dispatcher and controller,
- dao fundamental objects,
- db based SecurityManager,
- Smarty based ViewController,
- Smarty extension for multilanguage support.
When Buster is usefull?
When you need secured by login and password pages.
When you need user and users group permissins to access to content.
When you need interaction with database.
When you building multi-layouted web.
When you building multilanguage web.
When you need store user informations in session.
When you not need Buster?
When you have unsecured static pages.
When you have not interaction with database.
When you have to 5 different php pages without session needs.

DBFW is a PHP-based database framework for rapid application development and rapid prototyping.
DBFW project allows the creation of almost complete Web/database-based applications in no more than few hours, as well as faster development cycles.
It uses automatic DB schema discovery with XML configuration files to automatically implement a basic user interface that can be extended through the use of ad-hoc PHP code.
This framework aims to provide the developer with a tool that can be used first to iron out the database structure through as many iterations as required, but without forcing the developer to rewrite everything at every iteration.
It provides many features aimed to reduce this round-trip in the requirement and specification analisys phase, thanks to its ability to provide an auto-updating and working prototype of the user interface that can be used to access data from the DB under construction.
Main features:
- autodetection of the entire DB schema. The framework engine will retrieve all required informations from the DB itself (like all user visible tables, foreign keys, column types, and so on). It will cache the discovered infos in a file under the directory cache/ of the application. If you change the schema, the tables, add/remove columns and so on, you will just need to remove the cache file and the framework will redo the discovery process.
- XML-based User Interface specification. The user interface of the application is specified through a set of XML files, which will contain the templates for the application forms and browsers as well as the application menus, the reports and so on....
- automatic handling of CRUD functionality. By default, it is able to provide support for creation, read, update and delete of records from all your tables.
- automatic handling of Foreign Keys. The framework knows all foreign keys defined among tables, and it will allow its automatic handling whenever you will say so. The automatic handling means navigable html links during the browsing of records from a given table as well as search or select widgets in the editing forms.
- multi database support. The framework uses a driver based interface for DB access, which means that new databases backend may be added later, by simply creating the related driver. The framework currently supports the following DB:
- PostgreSQL 7.3.X and later (The 8.X needs more tests, thought)
- MySQL 4.1.X and later (Check the driver specifications for known limitations)
- Oracle 9i and later (it should work, even if it hasnt been used by few years)
- The framework uses the PEAR library for DB access, so the its internal driver will add only the functionality required by the discovery process and few others not directly provided by the PEAR driver.
- simple creation of Reports. You can create a Report (or a group of Reports) simply by specifying the SQL query which generate the data and by choose the output, be it a textual one using a template, or a graphical one, using the GD library or a SVG generator. It supports the following output formats: HTML, PDF (still under development, thought), TSV (tab Separated Values) and XLS (Excel Spreadsheets);
- DHTML forms: hierarchical forms are implemented using DHTML so they are handled by the web client for the most part, avoiding unnecessary round-trips. (It should work with almost all recently web browsers).
- form nesting. This allows you to create nested forms for editing of related sets of records. All modifications to the set will be committed as a unique transaction, so they will fail or success as a whole.
- form validation and error handling: all forms will be validated before their use, and all errors will be notified to the user. The framework uses the exernal JavaScript library overlib to handle tooltips as well as error notifications ( you may find more info at http://www.bosrup.com/web/overlib/ )
- support for record history. You may create two additional columns in your tables (a start-of-validity one and a end-of-validity one), tell the framework of them and then it will handle all modifications as storicized modifications (i.e. the records will not be really deleted, just marked as expired).
- integrated support for PDF generation, through the external library html2ps based on FPDF
- javascript calendar for web client date handling (a really wonderful JavaScript library. Check it out at http://students.infoiasi.ro/~mishoo/site/calendar.epl
- dynamically generated menus: you can generate menus dinamically using SQL queries.
- internationalization: it supports full internationalization for both framework and applications using Gettext. They may be handled separately, so you can maintain your application messages indipendently from those of the framework.
- privileges: the framework will respect all privileges defined on the DB tables, as well as it will enforce additional privileges, like record based ones (yes, really record based... I need to document how they work, though... )
- automatic generation of user documentation: (Work In Progress) Since the application behaviour is specified for the most part in the XML configuration files, its possible to process those files to generate automatically the core of the User Documentation. Of course, it still need to be completed and edited by hand, but this time you may concentrate on its content. BTW, the generated document will be in DocBook XML format.
- support for pop-up based details views.
- many more feature, like the handlers (PHP code which can be hooked to specific engine events like the decode event or the post_retrieve and so on), triggers (to allow the use of special triggers on DB that doesnt support triggers that access the tables under modifications, like Oracle and MySQL), foreign key and browser filtering, order-by handling, externally linked pages, and so on...
Enhancements:
- A new online help subsystem, a code cleanup, more work on the documentation, more support for data exports, and many bugfixes.

JamDB (Just another music DB) is a fast PHP-based music database that can be used with many different databases. (JamDB is well tested with MySQL and PostgreSQL). All MP3s can easily be searched for artists, albums, and songs.

A user can choose to download a song or add a single song, an album, all songs of an artist, or his search result directly to the playlist of XMMS/Winamp/etc. This can be done via the Web, NFS, Samba, or any other possibilty to access the MP3 files. JamDB has a simple session-based user management and other neat features.

Nixs Web-based SSH client has a backend written in C/glib and a frontend written in PHP. The project talks to the backend via a Unix socket.
The backend maintains a number of SSH processes in TTYs, reads their TTYs, and sends the contents to PHP for formatting. PHP accepts input and passes it to the correct TTY for processing.
Enhancements:
- CR/LF interpretation was improved.
- Escape sequences were added.
- GOption command line parsing was added.

p0f-db project is a modified version of p0f that puts its data into a database.
Usage:
All the standard p0f options applies. To get p0f to log data into DB you need:
- Get modified p0f files (see links at the end of this page).
- Extract them from the tarball.
- Compile and install p0f with modified "mk/Linux" (this is a Makefile) according to your DB type, include paths, library paths and any other compiler options.
- Create DB and tables for p0f (see "create_..." files in downloaded tarball).
- Modify your "/etc/p0f/p0f-db.conf" to reflect your DB setup.
- Run p0f and see tables populating.