rokoder

Programming

csv to sqlite conversion [csv2sqlite sqliteloader]

by on Jul.01, 2015, under Programming

During one of my personal projects, I had to use ‘.import’ command of the sqlite3 shell. The .import command is very limited in functionality. It also always binds column data as text. This has performance hit as well as disk usage hit. I also need some very basic conversion support like store numbers as numbers in db files as well as some way to parse date related data.

All these needs leads for the development of sqliteloader which csv files to sqlite easy.

Leave a Comment :, , , , more...

10 Open Source Rights

by on Dec.26, 2012, under Programming

Right No. 1: Free Redistribution
Right No. 2: Source Code Available
Right No. 3: Derived Works Permitted
Right No. 4: Integrity of the Author’s Source Code
Right No. 5: No Discrimination Against Persons or Groups
Right No. 6: No Discrimination Against Fields of Endeavor
Right No. 7: Distribution of License
Right No. 8: License Must Not be Specific to a Product
Right No. 9: License Must Not Contaminate Other Software
Right No. 10: License Must Be Technology-Neutral

Source: http://opensource.org/osd-annotated

Leave a Comment : more...

C++ Templates, not so generic

by on Mar.19, 2012, under Programming

Lets start with basic ideology of .h and .cpp files. When building libraries, the idea is to share only your header files and not your implementation (mean .cpp files). This is also the basics OOP’s encapsulation, abstraction etc, to hide the implementation details.

Now templates in C++ violates this encapsulation principle, bcoz C++ is a compiled language. And compiler generates all the needed (generic) code during compilation (it is different from Java as in Java this code can be generated in Java Run Time during execution and not at compilation. As Java compiled .class files contains enough info to generate a specific implementation later). Now to adhere to OOP we end up with fragile templates which are not 100% generic in nature.

Now there are two ways to implement templates.
(continue reading…)

Leave a Comment :, , , , more...

Get N matches using grep

by on Feb.11, 2012, under Programming

Here is the test data that we gonna use:

>grep create *.log
1.log:create1
1.log:create2
10.log:create1
10.log:create2
2.log:create1
2.log:create2
3.log:create1
3.log:create2
4.log:create1
4.log:create2
5.log:create1
5.log:create2
6.log:create1
6.log:create2
7.log:create1
7.log:create2
8.log:create1
8.log:create2
9.log:create1
9.log:create2
>

Finding the First N matches
(continue reading…)

Leave a Comment :, , more...

Android missing MENU button

by on Jan.13, 2012, under Programming

Well since ICS, h/w MENU button is having a life of uncertainty on a phone. It may or may not be present. I learnt that the hard way, so thought of sharing this with everyone who is in the same boat. And some times (which sometimes becomes often) Android sdk docs are not very thorough (but yeah they are on the right track and doing better now). Here we ll consider two scenarios:

Scenario 1: App does not use standard title bar but have menu options
(continue reading…)

Leave a Comment :, more...

Faster way to extract file name

by on Dec.29, 2011, under Programming

Working with unix shell and no way you wont end up extracting file names from paths. Well there is a usual way to do it.

>basename /my/big/long/path/to/a/little/bitty/file
file

Here is another way:

(continue reading…)

1 Comment :, , , , , , more...

Java to C++

by on Dec.29, 2011, under Programming

Many times people from Java endup writing C++ code and vice versa (for vice versa check notes below). This is the beauty of working in such a dynamic/vast programming eco-system. This blog is to help them create an analogy between the two.

Below we have a sample Java code which we like to convert to C++.

interface MyInterface {
  void func1();
  int func2(int x, int y);
}

interface MyAnotherInterface {
  void func3();
  int func4(int x, int y);
}

abstract class MyAbstract implements MyInterface {
  void func1() {
    System.out.print("In func1");
  }
}

class MyConcreteClass extends MyAbstract
  implements MyAnotherInterface {
  int func2(int x, int y) {
    System.out.print("func2 x=" + x + ",y=" + y);
  }

  void func3() {
    System.out.print("in func3");
  }

  int func4(int x, int y) {
    System.out.print("func4  x=" + x + ",y=" + y);
  }
}

(continue reading…)

Leave a Comment :, , , , , more...

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!

Blogroll

A few highly recommended websites...

Archives

All entries, chronologically...