2009. október 24., szombat

Adatbázis riport

Open-source:
Magallanes
It combines static reports (based on JasperReports), a Swing pivot table for OLAP analysis, and charts (based on JFreeChart). It reads from many data sources as SQL, Excel, XML, and others, and produces many outputs as PDF, XML, and application specific files for later off-line visualization of reports.

Shareware
PHP Report Maker
PHP Report Maker is a powerful reporting tool that can generate dynamic PHP Web reports from MySQL database. You can instantly create live detail and summary reports or crosstabs reports for your Websites. Flash charting (column, bar, line, pie, area, doughnut, multi-series and stacked charts) is also supported. PHP Report Maker is designed for high flexibility, numerous options enable you to generate the reports that best suits your needs. The generated codes are clean and easy-to-customize. PHP Report Maker can save you tons of time and is suitable for both beginners and experienced developers alike.

Grid példák

2009. október 18., vasárnap

Diagramok a weben

Visifire

Visifire is a set of data visualization components powered by Microsoft Silverlight. It lets you create and embed visually stunning animated Silverlight Charts within minutes. Visifire is easy to use and independent of the server side technology. It can be used with ASP, ASP.Net, PHP, JSP, ColdFusion, Ruby on Rails, or just simple HTML. Visifire's unique features are visually stunning animated charts, the ability to be embedded into any Web page in minutes, a tiny footprint (140 KB), and enterprise grade features.

http://freshmeat.net/projects/visifire

FusionCharts

FusionCharts v3 helps you create animated and interactive Flash charts for web and desktop applications. It livens up your applications by converting monotonous data into exciting visuals.

FusionCharts can be integrated with a myriad of web technologies like ASP, ASP.NET, PHP, JSP, ColdFusion, Ruby on Rails, Python or even simple HTML pages. It works with all databases including MS SQL, Oracle, MySQL, PostgreSQL, CSV or even legacy data storage.

FusionCharts offers over 45 types of 2D/3D charts including line, area, bar, column, pie, doughnut (donut), combination, scatter, bubble, scroll charts etc. The functional and cosmetic aspects of each chart can be extensively customized using the XML API exposed by FusionCharts. You do not need to know anything about Flash™ to use FusionCharts.

http://www.fusioncharts.com/

MySql backup script

Egy jó kis MySql backup script:

http://sourceforge.net/projects/automysqlbackup/

A script to take daily, weekly and monthly backups of your MySQL databases using mysqldump. Features - Backup mutiple databases - Single backup file or to a seperate file for each DB - Compress backup files - Backup remote servers - E-mail logs - More..