Ibator will introspect a database table (or many tables) and will generate iBATIS artifacts that can be used to access the table(s). This lessens the initial nuisance of setting up objects and configuration files to interact with database tables. Ibator seeks to make a major impact on the large percentage of database operations that are simple CRUD (Create, Retrieve, Update, Delete). You will still need to hand code SQL and objects for join queries, or stored procedures.
The Doctrine Project is the home to several PHP libraries primarily focused on database storage and object mapping. The core projects are a Object Relational Mapper (ORM) and the Database Abstraction Layer (DBAL) it is built upon.
DIVA - is a viewer of database physical structure, it can show you any section of DB in several usable forms (2D, 2.5D, 3D). In this way user can easily understand dependency between tables.
Dataclips allow the results of SQL queries on a Heroku Postgres database to be easily shared. Simply create a query on dataclips.heroku.com, and then share the resulting URL with co-workers, colleagues, or the world. The recipients of a dataclip are able to view the data in their browser or download it in JSON, CSV, XML, or Microsoft Excel formats
Expose your database (or any fine grained subset of it) to executives or business analysts (or any other non-technical personnel) for quick browsing and ad-hoc reports.
Sick of ORM and schemas? select gets right to the point!
Supported databases:
MySQL MongoDB Planned: PostgreSQL, SQLite, CouchDB Researching: Riak, Redis, selector language
IndexedDB is a way for you to persistently store data inside a user's browser. Because it lets you create web applications with rich query abilities, your applications can work both online and offline.
The incremental database reverse engineering (DBRE) add-on allows you to create an application tier of JPA 2.0 entities based on the tables in your database. DBRE will also incrementally maintain your application tier if you add or remove tables and columns.
C. Batini, T. Catarci, M. Costabile, and S. Levialdi. Proceedings of the IFIP TC2/WG 2.6 Second Working Conference on Visual Database Systems II, page 153--168. Amsterdam, The Netherlands, The Netherlands, North-Holland Publishing Co., (1992)
M. Trzaska, and K. Subieta. AVI '06: Proceedings of the working conference on Advanced visual interfaces, page 500--503. New York, NY, USA, ACM, (2006)
M. Sampaio, J. Quesado, and S. Barros. Advances in Databases and Information Systems, volume 186 of Advances in Intelligent Systems and Computing, Springer Berlin Heidelberg, (2013)
E. Bakke, D. Karger, and R. Miller. Proceedings of the SIGCHI Conference on Human Factors in Computing Systems, page 2541--2550. New York, NY, USA, ACM, (2011)
