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

• http://codethat.com/grid/grid_examples.html
• http://www.zapatec.com/website/main/products/grid/demo.jsp
• http://www.nitobi.com/products/grid
• http://www.nitobi.com/products/treegrid/basic
• http://www.treegrid.com/treegrid/www/
• http://www.petala-azul.com/grid/default/site/filters
• http://www.apphp.com/php-datagrid/index.php?page=examples
• http://www.phpgrid.com/grid/ss/
• http://www.activewidgets.com/
• http://dhtmlx.com/docs/products/dhtmlxGrid/
• http://stefangabos.blogspot.com/search/label/Data%20Grid%20PHP%20Class%20Download/
• http://www.eyesis.ca/projects/datagrid.html

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..

MySQL tips

http://souptonuts.sourceforge.net/readme_mysql.htm

Mysql lock tables

Időnként Excel kimutatással érek el MySql táblákat, viszont volt egy olyan problémám, hogy ha épp frissítettem egy táblát (truncate, load into ...), akkor is frissíthettem a kimutatást, de így sajnos rossz (félig kész) adatokat mutatott.

Eme problémát megelőzendő próbálkoztam a lock tables paranccsal.

Elsőre a "lock tables táblanév read;" paranccsal kísérleteztem, de mint kiderült a write a helyes irány:

LOCK TABLES táblanév WRITE;

Ja, tapasztalatom szerint a LOCK TABLES parancsot TRUNCATE parancs után kell kiadni!
Ezen parancs hatása alatt az Excel nem tud kimutatást frissíteni, csak homokórázik.

Amint kiadom a feloldás parancsot, a kimutatás újra frissíthető:

UNLOCK TABLES;


Forrás:
http://hup.hu/node/73927
http://dev.mysql.com/doc/refman/5.0/en/lock-tables.html

Speciális karakterek MySql-ben

\0 An ASCII 0 (NUL) character.
\' A single quote (‘'’) character.
\" A double quote (‘"’) character.
\b A backspace character.
\n A newline character.
\r A carriage return character.
\t A tab character.
\z ASCII(26) (Control-Z).
\\ A backslash (‘\’) character.
\% A ‘%’ character.
\_ A ‘_’ character.

Mysql textimport

MySql import:

load data infile '/var/www/termeles.txt'
into table termek
fields terminated by ' ' optionally enclosed by '"'
ignore 1 lines
(@a,@b,@c,@d,@e,@f,@g,@h,@i,@j,@k,@l,@m,@n,@o,@p,@q,@r,@s)
set esemeny=@a,
gyartasi_idopont=@b,
muszak=SUBSTRING_INDEX(@c,"/",-1),
minosegmegorzesi_ido=concat(substr(@c,1,4),'-',substr(@c,5,2),'-',substr(@c,7,2)),
raktar=@d,
termekkod=@e,
gyartott_mennyiseg=replace(@i,',','.');

Másik féle import:
LOAD DATA INFILE '/var/www/adatok.csv'
  INTO TABLE szemelytorzs_inc
  FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n'