The Database Facade library offers a way to access miltiple vendor databases with code that does not need to change from vendor to vendor.
The library offers a set of java classes and methods that
... [More] allow the user to define create, select, update, insert and delete statements that will function on different databases.
The facade when initialized decided weather it needs an MySQL, MSSQL, Oracle, Informix or generic AnsiSQL-92 translator and performs the staments in native form.
For example IsNull() is a function in MSSQL that has a counter part in Oracle. The nullDefaultReplacement() method will produce the proper SQL for both databases. [Less]
Database Swing Forms offers a framework for rapidly creating applications to edit the content of database tables. The Database Swing Forms framework allows for a definition of database tables differs
... [More] from the limited standard SQL DDL by using metadata to specify relationship definitions and entry options for each field.
Each table can be attached to a menu option and, when the menu appears to the user, it provides the user entry, editing, deletion, and reporting capabilities. These capabilities are defined, generated, and displayed to the user based on the metadata definitions for the table.
The framework provides interfaces for adding custom buttons with custom functionality, such as custom reports and actions. The framework also provides an interface that lets you specify additional validation checks beyond those provided by the table definition's grammar. [Less]
Tie::Table is a perl module, which is written to achieve transparent object-persistance. It supports DBI data-sources and foreign-key relations.
See the README file of the module for more
... [More] information:
.gadget-title {
margin-bottom: 2px;
}
function resizeIframeHandler(opt_height) {
var elem = document.getElementById(this.f);
if (!elem) return;
if (!opt_height) {
elem.style.height = undefined;
}
else {
opt_height = Math.max(10, opt_height);
elem.style.height = opt_height + 'px';
}
}
gadgets.rpc.register("resize_iframe", resizeIframeHandler);
gadgets.rpc.register('set_title', function(title) {
var elem = document.getElementById(this.f + '_title');
if (elem) {
elem.innerHTML = gadgets.util.escape(title);
}
}); [Less]
Database MySQLDumpA MySQL to PHP Dump Class and Control script..
Database MySQLDump is a script written in PHP for dumping entire database's into a MySQL import friendly format. This script is based
... [More] off my own ideas as well as looking at others scripts that do similar tasks. The generalized aim of this project is to create an all in one light-weight script that does all of the tasks other scripts do plus more. To read more about the aim, read below.
Project Aim:This project is aimed at developing a simple, XHTML 1.0 Strict Markup valid PHP MySQLDump Class and control page. Eventual goals are to support dumping data into a .sql and .sql.gz file, having a control script that requires user input to select the Server, Database Name, User Name, Password, and if to include DROP statements in the drop.
It's aimed that the script remains XHTML 1.0 Strict friendly according to W3C (World Wide Web Consortium) Markup standards. It's also aimed that the script itself remains completely light weight as to prevent problems with the dump itself, as many databases can be quite large.
Other possible additions once time goes on is on server backups to .sql or .sql.gz files, as well as the addition to creating customized cronjob backup scripts for your website automatically (user would have to direct their web server to the cronjob script).
Additional goal is to maintain a relatively easy to use control file that anyone can edit. Keeping the inner workings of the script stored in the class file is the main method of ensuring this. Anyone can make their own control file, as long as they print the Copyright line for the Class Script (included in the sample Control file). [Less]
PHP Database Browser (PHPDBB) is a lightweight PHP class that takes a regular SELECT query and outputs results in an HTML table with pagination, sorting, and filtering. Other features include column
... [More] mappings and callbacks to manipulate the output data.
Screenshots
http://sourceforge.net/dbimage.php?id=160558
http://sourceforge.net/dbimage.php?id=160560 [Less]
The aim of dataweb project is to create a rapid development tool for applications oriented to the manipulations of database. The applications created with this tool are immediately usable in net. The
... [More] main features of dataweb are:
Client/Server architectureDataweb project is composed from a server side that manages mainly the access to the database and from a client side that manages mainly the user interface. The two parts communicate with each other through tcp-ip protocol with the possibility to encrypt the communication
Multi platformThe client and the server, can work on all operating systems compatible with java runtime:
Apple Linux Solaris Windows Multi databaseDataweb project thanks to a interface implementation can support more database. Now it can use the following database engine:
HSQLDB PostgresSQL Multi userDataweb project has a multiuser management having the following characteristics:
Set permissions on several the objects (Tables, Views,Forms, Reports, etc..). Logging of user operations. Manage records competition. Multi languageDataweb project manages the multilanguage support because it gives to the user the possibility of being able to set up, through his profile, the language with which operating on several the objects (Tables, Views, Forms, Reports, etc..). if the translation for the chosen language is not present then it comes used the default language.
Client is small dimension and self-installer and self-updaterThe client is of small dimensions (around 900 KB), it's installation happens downloading one file by browser that, once executed, it also provides the verification and possible installation of Java runtime. The client update happens automatically when it connects it's to the server. To the connection in fact it comes made a comparison between the two versions (of the Client and of the Server), if they are different the system provides automatically to download and installation of the correct version.
Management of the applications to packagesDataweb project groups all the objects (Tables, Views, Forms, Reports, etc..), used by a specific application, in an only package, consequently there will be so many packages as the applications.
Development, administration and use of the packages from remoteInstalling the client it is possible to enter to an any server remote or local specifying the name or the ip. Subsequently, having the necessary permissions, it's possible to develop packages ( to create Tables, Views, Forms, Reports, etc..) ,to administer the server (users, services..etc) or to use the application created.
Management of the packages' versionWith Dataweb project it is possible to update software packages, already installed to the customers, automatically. When making modifications on existing packages, Dataweb creates update script with the relative version automatically.
Management of the packages' installation and updateDataweb project creates installation/update packages with a procedure that writes necessary objects for the functioning software in a file. Subsequently to install this file it is necessary to be connected to server in administrator modality and to select the installation procedure that install the package or, if it already exists, update it.
Integration of external modulesDataweb project is an applications oriented to the manipulations of database, but thanks to the possibility to add external modules (jar), practically it allows to build any application.
Creation and use of webserviceThe webservice is a good tool to make to communicate trasparently between them software. With Dataweb it is possible to create some functions that can be recalled from any other programming language that support the SOAP protocoll (.net, php, java, etc..) . It's olso possible to recall from dataweb the webservices created from other applications. [Less]
it's a PHP project that allow user to modify easily data from mysql tables. it works such as phpmyadmin but the it's implemented with ajax so can edit quickly. will be a powerfull editor for mysql
... [More] clients with many features for searching, filtering and powerfull tools for managind a lot of data in mass. includes also backup features and history system [Less]