SQLite JDBC version 3.6.6.2

Today, I released SQLite JDBC version 3.6.6.2, which fixed a bug involved in the original SQLite 3.6.6 (see http://www.sqlite.org/releaselog/3_6_6_2.html  for the details.)

SQLite JDBC:

http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC

SQLite JDBC version 3.6.6

Today, I released sqlite-jdbc-3.6.6, an upgrade release from the previous version (sqlite-jdbc-3.6.4)

http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC

This release will be synchronized with Maven's central repository within a few days.

Comparison between SQLite and H2 Databases

I found some article that says SQLite JDBC is slower than other DBMS. According to this source, SQLite took more than 11s for 100 insertions. This result is quite strange for me, and I guess no tuning option for SQLite is used in that experiment.

So, I wrote a simple test code to confirm the performance between SQLite and H2 databases. To the best of my knowledge, H2 is the fastest DBMS in the ones purely written in Java. Here is my test code.  In short, this code is optimized for insertions; using no transactions (a set of insertions is wrapped in a single transaction) and no locks. 

Tuning options for disabling lock acquisition:

SQLiteJDBC: pragma synchronous=off

H2: SET LOCK_MODE 0

For 1,000,000 insertions of simple records, I got the following results:

SQLite JDBC: 198.7 sec.

H2:    365.6 sec. 

If the above tuning options are not set in SQLite, each insertion acquires a file lock on the database file and creates an journal (log) file, so the performance will be significantly slower than the above result.

Although I can confirm SQLite is not slow, I have to admit SQLite JDBC driver has some overhead due to the interaction between native C codes and Java through JNI. When I used the command-line client of SQLite, it only took almost 100 sec for the same number of insertions through the import command of SQLite.

Ah, well, ... it's the nature of Java, which cannot beat sophisticated C programs in terms of performance.

Prime Minister Now Scattering Money

Japan's Prime Minister Aso (pronounced as uh-so, not ei-so) are going to distribute tax payers' money to themselves again. Sound strange? But that topic is quite hot every morning in every news channel  in Japan. It seems that every people will get a pay back about 12,000 -20,000 yen, in total the budgets will be 2 trillion yen.

This kind of money scattering is called baramaki in Japanese, in short, a waste of money. This policy looks like an grown-up person giving a 100-yen chocolate to a child who really needs a school to study. Giving a chocolate for distracting our interest from the economic crisis is not the government's task.

What a reaction should we take? Be happy with a tiny present from the government, even if it is our money? The effect is far from the Prime Minister's intention; we got really discouraged.

Here is a list of what we need that cannot afford with our own money:

• Preschool taking care of every child, with no exceptions. Many Japanese people still haven't noticed the following fact; it is highly possible that no one takes care of their children while they are working. If you are a student, your opportunity to learn in universities or colleges will be lost because the government prioritizes working people to students as a criterion to enter the preschool. Even if your children are allowed to enter some preschool, it is usually far from your home, and parents will suffer long commute time between the preschool and their working place.
• No smoking restaurants, parks, etc. for children. It's quite hard to find such a place even in Tokyo, a highly sophisticated city. Many people are smoking in sidewalks even if it is crowded. I really hate that old-fashioned custom.
• Time to spend with families.  Many people work 8 hours a day with additional hours for overtime work (2 to 3 hours?) and commute (some people spends 2 hours to go to the work place.)  What is left is a face of sleeping child. If this working style in Japan continues, we lose the greatest teachers for children, namely, parents.

And a lot more should be here....  Anyway, my conclusion is that the government spend their money (it's our money) for investments to children, our indispensable asset for the future.

Japanese Language on the Verge of Demise

Recently, many japanese people are talking about a book titled '日本語が亡びるとき'. Its English might be 'Japanese Language on the Verge of Demise' or 'Japanese Language in Crisis'. 

Anyway, it shows our fear that English cannot be a true native language for most of the Japanese people, but the world has been changing toward the direction in which everything, that includes business, technologies, and also cultures, will be talked in English. I haven't yet received this book from Amazon, so I'd like to wait for a moment before discussing this problem in detail. 

[Announce] Site Maintenance

Because of a planned power cut in our server room, xerial.org site will be down for a few days from November 7th, 2008. 

A New America

Today, Barack Obama becomes a new president of America. His speech is very impressive, but from the viewpoint of a place far from USA, the effect of this historical moment is quite intangible for us, so I'd like to see how the things will change, as the slogan he mentioned repeatedly. 

I hope American people be proud of their choice, and also think very carefully about their role as a leader of the world. For example, they should change their attitude to the Kyoto Protocol, an agreement to rescue the global warming. Bush government has been ignored this protocol due to some economic reasons we don't know. What an irresponsible stance  as the NO.1 producer of CO2 gas in the world! So, I wish the change proposed by Mr. Obama will let Americans be proud of not only themselves but also their responsibilities to the world. 

This is a comment from a Japanese, who has watched the presidential campaign outside of the USA.

 

Official Blog for Xerial Project

This site is the official Blog for Xerial Project.

About Me

Taro L. Saito (leo)

• An architect of Xerial (XML DBMS) http://www.xerial.org/
• A database researcher
• My CV

• Twitter  http://twitter.com/taroleo