MySQL stored programs: functions

MySQL, SQL, SQL/PSM, stored programs

Since the fifth release of MySQL (5.1 to be exact) programmers have capability to use stored programs (functions, procedures and triggers), a feature well known from other popular databases. According to the result of my small research it's a nameless subset of the ANSI SQL: 2003 SQL/PSM specification, very similar to the SQL PL (based on the same specification) used by DB2 and less similar to the PL/SQL (Oracle, DB2), PL/pgSQL (PostgreSQL) and T-SQL(SQL Server and Sybase).
Read more!

Basic chart with Raphael and a few learning resources

chart, JavaScript, JS framework, Raphael, SVG

Raphael is a much less popular then jQuery or even Mootools. It's harder to find tutorials, help and as far as I know there isn't any book about it. Taking that into account I'm putting chart that I've created during learning basics of Raphael. One day it may become an alternative for g.Raphael (I can hardly imagine that), but at this stage it could be only a starting point or a testing ground. It may help you start your own project based on Raphael.js.
Read more!

JavaScript's and PHP's grid tools

AJAX, dojo toolkit, grid, JavaScript, jQuery, JS framework, PHP, RIA, UI, user interface

Some time ago I was doing a research on grids. I've found not only a couple of grid's plug-ins but also a grids that are part of comprehensive tools for RIA development.
Read more!

PHP jQuery cookbook review

book review, jQuery, PHP

Last week I had an opportunity to read the PHP jQuery cookbook by Vijay Joshi. I love to read and learn from on-line resources but when it comes to books I have to admit that I'm a septic.
Read more!

Attaching an event to a form's elements inside an iframe with a use of jQuery.

AJAX, cross domain policy, curl, event, iframe, JavaScript, jQuery, JSON, PHP, proxy

My job was to create a simple form that led people to subscribe to a newsletter. Actually the form was ready and all I had to do was to place it on the page and make sure it does it's job. I placed the form on the page, styled it and that's where nightmare begun...
Read more!

11 jQuery performance tips

jQuery, JS framework, performance, tips, UI, user interface

Once again I was trying to do a one thing and I've end up with something else. For about month I've wanted to write neat summary of JavaScript tutorial from http://javascript.info. Unfortunately I don't have enough time so I have to do something less ambitious.
Read more!

Time-consuming PHP and JavaScript

design patterns, JavaScript, jQuery, JS framework, PHP, RIA, UI, user interface

I can't believe that more then 2 months have past since my last post. I'll try to show what I've been doing when I wasn't writing. In other words how it's happened that I've started with writing o blog about MySQL problems and end up learning JavaScript. Reading, learning, studding, searching, programming and... no time for writing
Read more!

Difference between JOIN with WHERE condition and JOIN with subquery with WHERE condition

JOIN, LEFT JOIN, MySQL, SQL, subquery

Today I'll say about very useful thing which I've learned lately - a method for filling gaps created by joined tables having no rows meeting some of the conditions or in other words how to change range of WHERE clause and move it from main query to the joined subquery.
Read more!

MySQL EXPLAIN step by step - Part 1

EXPLAIN, MySQL, performance, query tuning, SQL

If you are looking for a good tool that will help make your query faster or you've already known about it but you hadn't been able to understand the result you've got, you are in right place. I'll try to clarify how EXPLAIN statement works.
Read more!

<?php echo Hello World

A short introduction to subjects I'm going to write about and some organizational things. Non original title and non original blog post, but I've to start somehow.
Read more!