9 projects tagged "Database frontend"
The goal of dzo is to treat application database objects the same way the application's source code is treated, with respect to development, revision control, and deployment. Dzo uses a text file that contains native create statements for all database objects and compares them against the actual database-schema. As a result, dzo creates the SQL statements needed to update the database schema (or you can let dzo execute the SQL statements directly). If your application lives in a Tomcat or Java EE application server, dzo has a servlet that controls the deployment process, inspects and executes the necessary database changes, and finally deploys the application. Dzo currently works with HSQLDB, MySQL, Oracle, PostgreSQL, and SQL Server (more to come).
AeroSQL is a Web-based tool for managing MySQL servers. It allows you to control multiple servers, updat the result of a SELECT if it is performed on a single table and the result contains a unique index and view all SQL commands issued by the server side script. It correctly handles NULL values, allows users to select which columns to display while editing a database table, and only fetches visible columns to minimize network traffic. It feature an easy to use Web interface based on the ExtJS framework.
SynApp2 is a development tool that generates database-backed Web applications by processing your MySQL or Oracle schema definition and producing the Web pages used to manage your data. It does more than an admin tool or file manager by considering table relations as a cohesive whole that drives the generation of a complete application that smoothly integrates your entire database design, complete with PDF reports. It is open, compact, efficient, and compatible with the tools and technologies you’re using now.
siqqel is a simple and lightweight framework which allows you to execute MySQL queries directly from your browser (by transforming them into JSON calls to a backend script), displaying the results of your queries within the structure of the calling HTML document. To issue a query and have its results displayed in a table of your HTML document, you simply put an SQL statement into the "sql" attribute of a <table> element and it will be executed when you open the HTML document in your browser. Your browser will wrap the SQL statement into a JSON call, and this call will be issued to a backend script on your server, which in turn issues the statement against your database server and returns the result set back to your browser. Your browser will display the result set in the according table. If you hover your mouse over the table, a "reload" icon will be displayed, allowing you to re-issue the SQL statement without the need to reload the whole page.
DB Relay is a project built around the NGiNX web server platform, providing an HTTP/JSON interface to a variety of database servers. It enables database access without drivers and Web application development without complex middleware. It is designed for operational efficiency and ease of maintenance.