Gokul's Blog

Better Than Grep



Leave a comment

SQL Lite Tools

I came to know about an interesting product to export the data from SQL to SQL Lite or any other DBMS to SQL-Lite. (SQLite Data Wizard)

Check it out at : http://www.sqlmaestro.com/products/sqlite/datawizard/

They have a 30 day trial version of the product.


Leave a comment

Create Quick Mockups – Balsamiq

I was looking at making quick mock-ups. Came across this interesting little tool

Balsamiq Mockups http://www.balsamiq.com/

I tried to create a simple mockup to explain my friend about creating a simple web-page layout. It just took me 5 minutes to do it and send the screenshot to him. (No more paper drawings, scanning it and emailing.)

No need of installing any new toolset, not high on memory, no need of expensive toolset like visio, etc.

What Visual Basic did for GUI programming will be what Balsamiq is for rapid prototyping.. I simply love this awesome tool. The below example just took me 2 minutes. Check this out for you to know to more about this tool.



Leave a comment

MS Time Zone (Multiple Time Zone Time display)

I have the issue of looking at many time zones, I query google at times as "TIME IN INDIA" to get the time there. But when I am not connected this is a neat little that is of great use.

MS Time Zone:  I have added this for my personal use. You can get it downloaded from MS Site. Download Link

If the balloon feature is disable use the below key to enable it.

Windows Registry Editor Version 5.00


Download from my blog.


Leave a comment

Xpath: Get Distinct node values in Xpath

Xpath to select nodes with distinct attribute value 

Getting a list of nodes with distinct value in an attribute using xpath . The key is to use the preceding keyword.

The Xpath query will return only the distinct nodes. I used sketchpath to learn/arrive at the this example Xpath Query. This is is similar to the Regex editor we use for Regular Expressions.

Example Xpath Query: //Schedule[not(./@SourceID=preceding::Schedule/@SourceID)]

Sample Xml:

<ns0:Listings xmlns:ns0="http://myTest.Namespace">
        <Program ProgramTitle="Program - 1025">
            <Schedules xmlns:ns0="http://Mytest.Namespace2">
                <Schedule SourceID="123"></Schedule>
        <Program ProgramTitle="Program - 1225">
            <Schedules xmlns:ns0="http://Mytest.Namespace2">
                <Schedule SourceID="123" ></Schedule>
        <Program ProgramTitle="Program - 1405">
            <Schedules xmlns:ns0="http://Mytest.Namespace2">
                <Schedule SourceID="124"></Schedule>
        <Program ProgramTitle="Program - 1505">
            <Schedules xmlns:ns0="http://Mytest.Namespace2">
                <Schedule SourceID="145"></Schedule>
                <Schedule SourceID="146"></Schedule>
        <Program ProgramTitle="Program - 2005">
            <Schedules xmlns:ns0="http://Mytest.Namespace2">
                <Schedule SourceID="225"></Schedule>
Tool: Sketchpath Link & download sketchpath utility from my blog
Another good tool is xmlviewer from bizbert.com. From my blog
Some gotchas and refernce links for Xpath:
Disclaimer: I host these tools on my site for quick access. As I had experience with some other tools, either the sites go 
missing or down for maintenance when needed. So please goto the respective sites for download as mentioned. If you don't get
them, get it from here.

.csharpcode, .csharpcode pre
font-size: small;
color: black;
font-family: consolas, “Courier New”, courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
background-color: #f4f4f4;
width: 100%;
margin: 0em;
.csharpcode .lnum { color: #606060; }