Archive: January, 2008

The bombshell of the day…Nokia buys Trolltech

January 28th, 2008 · Ton · Diari, English Linux, Programació No comments

This is the month of the acquisitions (the first one was Sun buying MySQL).

UPDATE: The news from trolltech

Ruby / SQLite

January 18th, 2008 · Ton · Diari, English Linux, Ruby No comments

Hi

I have decided to give SQLite a go and I have coded an example using Ruby (my preferred object oriented scripting language). This is the test I did

  #!/usr/bin/env ruby

  require 'sqlite3'

  db = SQLite3::Database.new('test.db')
  db.execute("SELECT col1, col2 FROM tbl1") do |row|
	  puts("#{row[0]} - #{row[1]}")
  end

Isn’t it amazing how simple it is? I know I said that I hated the one-file databases for multi-user applications but it is perfect for one-user apps (and in addition to this SQLite is open-source) :-D .

I will keep on checking SQLite.

Do we have to use PostgreSQL instead of MySQL now?

January 17th, 2008 · Ton · Diari, English Linux, Programació 2 comments

This morning I read (I supose this is the bombshell of the day) the news that Sun has bought MySQL (I am still astonished).

Sun changed the Java’s license from propietary to open-source and now the MySQL thing, do they want to become an open-source company? Are they buying open-source software to win open-source software engineers to their products and then change the license to a propietary one again?

I used to code using Java some years ago at work and I am thinking about come back to it because I like it and at last it’s free but, I am disconcerted about Sun’s intentions.

What should I do (about MySQL not about Java)?

SQLite

January 15th, 2008 · Ton · Diari, English Linux, Programació 2 comments

Hi there

Some days ago I was speaking with a friend of mine about M$ Access and I was telling him that I hate this kind of “RDBMS” for multi-user apps. He said that it was useful if the hosting used doesn’t provide a real RDBMS (mysql, postgresql, etc.).

After that conversation, I decided to try a free one-file “RBDMS” called SQLite using the C# programming language. There is a wrapper for it here (an installer is downloaded) and it can be used easily using SharpDevelop.

This is a chunk of code to use it in applications which can’t use a real RDBMS.

__ds = new DataSet();
__ds.Tables.Add(“test”);
__ds.Tables["test"].Columns.Add(“ident”);
__ds.Tables["test"].Columns.Add(“name”);

_adapter = new SQLiteDataAdapter();
_adapter.SelectCommand = new SQLiteCommand();
_adapter.SelectCommand.Connection = new SQLiteConnection(@”data source=SQLite_test.db”);

_adapter.SelectCommand.CommandText = “Select ident, name From test”;
_adapter.SelectCommand.CommandType = CommandType.Text;

_adapter.SelectCommand.Connection.Open();
_adapter.Fill(__ds, “test”);
_adapter.SelectCommand.Connection.Close();

It can be useful for instance if you are coding an app and you don’t have a mysql connection. A wrapper can be written in order to encapsule your provider for checking the SQL sentences and then rewrite the wrapper to query your real RDBMS (but I still hate the one-file “RDBMS” for multi-user apps).