* Project Title*: ADJ Dashboard Name : Erdinc AKKAYA Email: erdinc.akk...@gmail.com
*Synopsis* AnyDBJSP is a database monitoring and reporting solution with a browser based interface. ADJ dashboard mainly will be written for database admins(DBA). This tool will have pre-defined sql queries. In addition to these, DBA can write his/her own sql query and report structure easy. Similar projects are, EnterpiseDB's dashboard, cybertec's pgwatch (www.cybertec.at). *Benefits to the PostgreSQL Community* All the sql queries are stored in xml files. these xml files can be updated easy, with contribution of community this xml file can grow easyly and at the end community will have a strong database monitoring tool. Query xml files will be published on web(like wiki pages) and everyone can easy design his/her own monitoring tool easyly. Other adventage is, after a time, community will have a strong sql queries that monitors databases so if someone wants to study on postgresql database administration ADJ dashboard will be a good tool to start. *Quantifiable results* Easy,understandable and growing sql monitoring tool. *Project Details* Project will be written in JAVA and will run on apache tomcat application server. ADJ dashboard don't need any alternative database to store data. All the statistics will be created on the fly. If someone wants to store it to anywhere, dashboard will export results in XML, PDF, XLS formats(these can be more). Also Dashboard can work as a webservice that exporting XML outputs. So tool can be used on any webpage to show statistics about database. Dashboard will create flash charts also. There are common database statistics like, unused indexes, total transactions(commiteds,rollbacks...) this dashboard should create more and more statistics about database (like database bloats..). On start I will prepare more than 30 statistics and charts. After project getting its shape everyone on the comminity can add more by him/her self. Project have a nice interface with small css,javascripts, easy, understandable,tidy and clean. *Inch-Stones* Collecting the information from community. What DBA's needs? What they prefer to see? First implementation with amount of queries. Prepare tool for concurrent connections to more than one database. Scheduled mail configuration. Documentation, Testing, Commit. *Project Schedule* before 1st of June Collect sqls and ideas from DBA's at community 1-15 June Start coding for first prototype 15-17 Test first prototype. Ask feedback from community 17 June - 1st July Develope 2. prototype with scheduled mail system included. 1-20 July Prepare data outputs.(adj should work also as a web-service) 20 July-1 August Prepare FrontEnd and get feedback from community. 1-15 August Refactoring, add or remove features according to feedbacks. Test and commit project. *Completeness Criteria* ADJ dashboard is ready. Tested on all common linux distributions. Committed and installation guide is ready. *Bio* Birth:1986-July-01 4th Year Computer systems and information technologies student at Bilkent University / Turkey. Working as a software developer on a private firm for 4 years. Github: hzroot Twitter: hzroot FreenodeIrc: hzroot