Open Source Technology

Pachmarhi Trip

2012-01-05T11:46:00.001+05:30

https://plus.google.com/photos/110386800557471112769/albums/5694004808464973937

Mysql: show all grants

2011-10-14T16:20:00.011+05:30

MYSQL PROCEDURE:-------------------------- Mysql Procedure to show all grantsCREATE PROCEDURE `showAllGrants`()BEGINDECLARE done INT DEFAULT 0; DECLARE mUser CHAR(16); DECLARE hostName CHAR(60); DECLARE cur1 CURSOR FOR SELECT user, host FROM mysql.user; DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1; OPEN cur1; REPEAT FETCH cur1 INTO mUser, hostName;

How GOOGLE Works

2010-08-02T10:30:00.001+05:30

Brilliant and nicely explained.http://www.portfolio.com/images/site/editorial/Flash/google/google.swf

How to get Domain/IP related information

2010-07-28T18:49:00.000+05:30

Linux Commands: $ mtr domainname-- MTR is computer software which combines the functionality of the traceroute and ping programs in a single network diagnostic tool.MTR probes routers on the route path by limiting the number of hops individual packets may traverse, and listening to responses of their expiry. It will regularly repeat this process, usually once per second, and keep track of the

Add Rupee Font in Fedora 10

2010-07-28T11:32:00.000+05:30

Download the font :From here:http://www.woofiles.com/dl-201362-SNrji0t3-RupeeForadian.ttfor http://blog.foradian.com/rupee-font-version-20Open konqueror and type fonts:/ in address bar and paste ttf file in folder named "Personel"Open the leafpad (editor) to write, set font option to Rupee Foradian and type "` you will get new rupee symbol.i.e.

Follow Me @ Twitter

2010-07-27T13:05:00.000+05:30

Hey Follow me @amolkulkarni82 (twitter)....and i'll follow back to you if i could find something interesting in your tweets.Visit: http://twitter.com/amolkulkarni82

ERGONOMIC GUIDELINES FOR USER-INTERFACE DESIGN

2010-07-16T14:45:00.000+05:30

The following points are guidelines to good software interface design, not an absolute set of rules to be blindly followed. These guidelines apply to the content of screens. In addition to following these guidelines, effective software also necessitates using techniques, such as 'storyboarding', to ensure that the flow of information from screen to screen is logical, follows user expectations,

Special Characters in HTML And Their Names

2010-07-08T14:15:00.001+05:30

To make special characters and accented letters show up on your pages, use a special set of codes called character entities, which you insert into your HTML code and which your browser will display as the corresponding symbols or characters you want. The most common character entities have been collected by the International Organization for Standardization and compiled in the ISO Latin

Latest Rumour

2010-04-22T11:55:00.000+05:30

Great article on the next generation of database.

The Anatomy Of The Google Architecture 2009

2010-03-08T16:39:00.001+05:30

Check out this SlideShare Presentation: November 2009The Anatomy Of The Google Architecture Final v1.1View more presentations

JQuery Tips and Optimization

2010-02-18T15:26:00.000+05:30

JQuery Tips For Developers Load the framework from Google CodeUse data method and avoid storing data inside the DOM. Some developers have a habit of storing data in the HTML attributesUse Cheat SheetsCompress Javascript filesUse FirebugUse ID as Selector whenever possibleUse Tags Before ClassesCache jQuery ObjectsBind certain jQuery functions to $(window).load eventUse Chaining to limit selectors

Firefox/Mozilla Keyboard Shortcuts

2009-02-24T20:55:00.000+05:30

As you start spending more and more time on Internet and Web Browsers, you will soon realise that you got to surf faster and faster. This is where Mozilla Shortcuts will help.This is a list of keyboard shortcuts in Mozilla Firefox. If you have enabled Emacs-style text

9 JavaScript Tips You May Not Know

2009-02-05T20:02:00.000+05:30

9 JavaScript Tips You May Not KnowExcellent javascript tips every javascript developer should know. Very well explained and a very pleasing website.JavaScript is a fully-featured Object-Oriented programming language, on the surface, it shares syntactical similarities with Java and C, but the mentality is quite different, at its core, JavaScript is more similar to functional languages. Inside is

Make Firefox Faster.

2009-02-05T18:23:00.000+05:30

This is a very simple trick , No software required.* Mozilla uses more memory space.* It becomes slow when i open more tabs* Page cannot be found error makes the whole browser hang* It crashes sometimes and restore session is the only resort to regainThe above complaints are very common about mozilla. But still i like mozilla :)But there are some hidden truths regarding mozilla’s configuration.

Make AdSense For Revenue

2008-09-10T17:54:00.000+05:30

AdSense Tip #1: Find your keywords Make a research the best keywords. AdSense Tip #2: Improve your keywords Make sure your keyword density between 3% to 10 %. AdSense Tip #3: Keep your website focused on a theme Do not mix you content.Focus on your main theme and content. AdSense Tip #4: Write a new page every day Always update your site or blog. If you can,updated daily. AdSense Tip #5: Choose

Trace - Debug ( Profiling ) PHP script by xdebug & kcachegrind

2008-09-10T17:39:00.000+05:30

Step 1 : Install XDebugxdebug is an open source debugger available for PHP. xdebug can be used to display more information in error traces. It can also be used to collect detailed code coverage & profiling information.InstallationYou need to install following packages to prepare environment for installation of pecl module xdebug.sudo apt-get -y install php-pear php5-dev build-essentialNow we

SQL Joins by venn diagram

2008-08-04T23:05:00.000+05:30

If you have tried to understand how joins work and constantly get confused about what join to use, you just need to keep a simple picture in mind ( I like pictures). I will be explaining joins by referencing a Venn diagram. Have no fear - I won’t get into any of the set theory/math involved. This is just a basic overview to give you an idea the data a particular join will return to you. This is

Define: HTTP_LOAD in details

2008-07-31T13:31:00.000+05:30

Http_load is another cool webserver performance tester that gives simple stats on how your webapp is performing.How to install in OS X1. Download from http://www.acme.com/software/http_load/2. Open terminal, cd to the directory where the archive is and unzip$ tar -zxvf http_load-12mar2006.tar.gz3. Move to that directory$ cd http_load-12mar20064. Run$ make5. Run$ make installOnce installed, using

ALTER TABLE, SELECT AND INNODB

2008-07-24T15:54:00.000+05:30

Let's assume you have a 512MB table, and you decide to alter the table to add an index to make queries faster.How long would you expect this alter to take? Hours? Days?Even with 7200 RPM-slow disks the alter should of finished in less then 1/2 hour.I ran across an alter that was running for 4 days-on 512MB datasize. The reason why it ran so long is because there was a SELECT that was running

Basic SVN Commands

2008-07-16T15:12:00.000+05:30

Lets get it started….How to get help with svn?svn helpThis will make svn list all the available functions, to get the function reference, let say checkoutsvn help checkoutThe same thing goes to other svn related commands, such as svnadminsvnadmin helpHow to create a svn repository?First of all what is repository? It is a core file for svn, or you can call it a centralized svn backup

Prevent form post request from another domain in PHP

2008-06-24T19:40:00.000+05:30

HTTP POST request from outside domain is one of the way of attacking your website. A intruder can use JavaScript in other domain or localhost to send the repetitive POST request to your web page containing PHP script. We must prevent this kind of cross domain form posting which might be harmful of our website. Example of form post a spam Let’s suppose that, we have a contact form in our

Articles for optimizing MySQL queries

2008-06-24T18:47:00.000+05:30

Optimization is a complex task because ultimately it requires understanding of the entire system to be optimized. Although it may be possible to perform some local optimizations with little knowledge of your system or application, the mo Optimization is a complex task because ultimately it requires understanding of the entire system to be optimized. Although it may be possible to

Create User Account Example for MySQL

2008-05-13T17:11:00.000+05:30

There are three different methods that can be used to create user accounts and they are fairly straightforward.mysql> use mysql;Database changedMethod 1: (create user, password - no privileges)mysql> CREATE USER 'esoft'@'localhost' IDENTIFIED BY '12wer56hi';Query OK, 0 rows affected (0.16 sec)--grant certain privilegesmysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON *.* TO 'esoft'@'

Auto Reconnect In Mysql

2008-05-07T16:11:00.000+05:30

What is auto reconnect in MySQL?The MySQL client library can perform an automatic reconnect to the server if it finds that the connection is down when you attempt to send a statement to the server to be executed. In this case, the library tries once to reconnect to the server and send the statement again.Automatic reconnection can be convenient because you need not implement your own reconnect

Optimising MYSQL

2008-05-06T16:07:00.000+05:30

DO NOT CHANGE your setting without understanding what you do.Make a backup of your my.cnf before editing the /etc/my.cnfDO THESE CHANGES AT YOUR OWN RISKS.My thread is only to help you to more well understand how tuning mysql.Optimising mysql is very well commented on the net, and you’ll find huge information on how to do this. There is never “best parameters”, the best parameters is those fits