My Personal Blog

ACDSee Online Beta1 launched!

ACDSeeAlmost a year (half a year for me) of hard work, bug fixing, improvements and optimization and here we are!
Let me introduce ACDSee online Beta1

This is a project of my pride. I hope that it will have a great future!
Receiving congratulations for all our team! :)

Welcome to my blog

Here you'll be able to find useful links (to my mind), interesting code tricks and all my other thoughts on any subject that will be in my head while I'm in administration area of my site :)
Feel free to expose your thoughts on any subject you like. The only limitation is for damn spammers - I'll fight with them with all ugly methods I know.
Hope to update this site frequently.

Routines/procedures: queries with conditions

Assume that you have incoming parameter "ModerationStatus" that is responsible for filtering results.
Depending on this parameter you need to show either all rows or limited number of rows. Here's the example of the routine how this can be made with the least effort:

CREATE PROCEDURE `Photo_Get_List`(ModerationStatus tinyint(1))
BEGIN
SET @query = 'SELECT * FROM Photos';
IF ModerationStatus IS NOT NULL THEN
SET @query = CONCAT(@query, ' WHERE ModerationStatus = ', ModerationStatus);
END IF;
PREPARE statement FROM @query;
EXECUTE statement;
DEALLOCATE PREPARE statement;

I just wanted a javascript "Add to Favorites" link!

It's strange... but when I searched for the js snippet for this functionality I either got out-of-date javascript snippets that don't work anywhere else except IE 5 (I guess) or strange monsters that allow to save current page anywhere except browser itself!

Input box hints

Here's the solution for the case when you want to create nice input hints when there's no focus in the input or on lose focus action.
Example:

jQuery pagination

Very useful for the cases when you don't want to reload the page and don't want to use ajax either.
Here's an example of how it works:

Snooker

I definitely like this game! :)
Today played it for the third time, difficult but very interesting! Highest break is 16 points, how about you? ))

The list of books I've been recently suggested to read

Addison.Wesley.The.Software.Project.Managers.Bridge.to.Agility.May.2008
Management - Tasks, Responsibilities, Practices by Peter Drucker
Addison.Wesley.Implementing.Lean.Software.Development.Sep.2006
Auerbach.Publications.Software.Testing.and.Continuous.Quality.Improvement.2nd.Edition
Radical Project Management

Well, not sure if this article is interesting for you, but definitely needed for me :) Now reading second book from the list, pretty interesting beginning :)
If you have something else to suggest - you are always welcome.

Flash Video Player

Small and pretty simple but powerful in the same way - JW FLV Media Player
Very easy to use, supports playback of any format the Adobe Flash Player can handle (FLV, MP4, MP3, AAC, JPG, PNG and GIF). It also supports RTMP, HTTP, live streaming, various playlists formats, a wide range of settings and an extensive javascript API.
Must have tool if you want to play online video on your site.

Photographer Alina Reynbakh

Kharkov photographer Not only a friend but my wife also. :)
She is a great photographer. Her best side is kids photography. If you want to have awesome pictures of your kids from any kind of celebrations - she is the best choice for you.
Also, her ability to be in the right place at the right time makes her wedding photos outstanding :) (I'm sure that our wedding helped that a lot).

Syndicate content
© 2008-2009. Konstantin Artemov