Proposal for GSoC : ADJ dashboard (Administration related software) - Mailing list pgsql-hackers

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