Re: Proposal for GSoC : ADJ dashboard (Administration related software)

*

Project Title*: ADJ Dashboard
Name : Erdinc AKKAYA
Email: erdinc(dot)akkaya(at)gmail(dot)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

On Wed, Apr 6, 2011 at 11:06 AM, Erdinc Akkaya <hz(dot)root(at)gmail(dot)com> wrote:
> Project Title: ADJ Dashboard
> Name : Erdinc AKKAYA
> Email: erdinc(dot)akkaya(at)gmail(dot)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.

I think it would be a lot more useful to pick one of the existing
adminstration tools for PostgreSQL and work on improving it, rather
than trying to create a whole new one.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Apr 14, 2011, at 1:45 PM, Robert Haas wrote:
> On Wed, Apr 6, 2011 at 11:06 AM, Erdinc Akkaya <hz(dot)root(at)gmail(dot)com> wrote:
>> Project Title: ADJ Dashboard
>> Name : Erdinc AKKAYA
>> Email: erdinc(dot)akkaya(at)gmail(dot)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.
>
> I think it would be a lot more useful to pick one of the existing
> adminstration tools for PostgreSQL and work on improving it, rather
> than trying to create a whole new one.

It doesn't sound like he's creating a new tool, just adding support for an existing one. And any shops that run more than one RDBMS would certainly be interested in a tool that can monitor more than one brand of RDBMS.

I think a better question is: just how large is the ADJ community, or how many folks would actually use PG support in ADJ?
--
Jim C. Nasby, Database Architect jim(at)nasby(dot)net
512.569.9461 (cell) http://jim.nasby.net