Update on the status of Mckoi SQL

Discussion:

Antonello Provenzano

2006-12-12 13:27:01 UTC

Hi all,

I'm curious about the current status of the project: in a post dated
26th October 2005 Tobias announced the project was still alive and
near to a new release.
Since then nothing happened and many users continuously comply about
the death of the project (that Tobias has always denied), trying to
find an alternative.

Industrially a stable project that doesn't change large portions of
its code is a good choice, but the lack of improvements, bug fixing or
new features is a bad signal for the 'market'.

Hope this post was not bothering anyone and will find a concrete response.

Cheers.
Antonello

---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com

Tobias Downer

2006-12-15 01:57:52 UTC

Permalink

Hi Antonello,

Unfortunately I have to ask for a little more patience from you and the
community on the next release of Mckoi. I was hoping I'd have the code
to give out by now, but adding the new features we wanted in this
release has been a huge undertaking.

The reason for the lengthy overhaul of the code was the introduction of
a new 64 bit data storage system which I intend will be the final
revision of the data storage system in Mckoi. The new data store system
is a complete rewrite and wraps all the low level database storage/query
functionality into a simple interface which leads to many elegant ways
to implement the higher level database functions. What this means is
the next version of Mckoi will be able to scale up to massive data sets
and will have a very flexible index and list management function.

The data store code is finished. The reason why the release hasn't
happened sooner is because the change has not turned out to be an
incremental revision of the codebase. Most of the code that involves
managing data and indexes has needed to be updated or rewritten and many
of the higher level data management code has been effected in some way
from the changes.

The code is slowly coming together and there will be a new release soon
and it will be considerably more advanced than the current release. I
hope the quality of the code will speak for itself when it's done.

Toby.

Post by Antonello Provenzano
Hi all,
I'm curious about the current status of the project: in a post dated
26th October 2005 Tobias announced the project was still alive and
near to a new release.
Since then nothing happened and many users continuously comply about
the death of the project (that Tobias has always denied), trying to
find an alternative.
Industrially a stable project that doesn't change large portions of
its code is a good choice, but the lack of improvements, bug fixing or
new features is a bad signal for the 'market'.
Hope this post was not bothering anyone and will find a concrete response.
Cheers.
Antonello

---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com

Antonello Provenzano

2006-12-15 08:18:57 UTC

Permalink

Toby,

Post by Tobias Downer
Unfortunately I have to ask for a little more patience from you and the
community on the next release of Mckoi. I was hoping I'd have the code
to give out by now, but adding the new features we wanted in this
release has been a huge undertaking.

Mine was not intended to be a pressure to release the latest code of
the project: the meaning of my post was to better understand the
development stage of Mckoi, since no news about it were published in
recent times and, as I have experienced with some of my open-source
projects, that leads the community to switch (maybe you've seen some
of Mckoi users publicly admit their plan to stop using it) to rival
projects (such as Daffodil or Cloudscape).
I personally believe Mckoi is potentially one of the best RDBMS around
and that it'd be a shame to let it die: I would re-organize the
"marketing campaign" to promote it and make it know to the masses.

Post by Tobias Downer
The reason for the lengthy overhaul of the code was the introduction of
a new 64 bit data storage system which I intend will be the final
revision of the data storage system in Mckoi. The new data store system
is a complete rewrite and wraps all the low level database storage/query
functionality into a simple interface which leads to many elegant ways
to implement the higher level database functions. What this means is
the next version of Mckoi will be able to scale up to massive data sets
and will have a very flexible index and list management function.

That is simply great since the introduction of a stronger data system
will make Mckoi a jump to a new step of its development and that
clarifies the time spent to develop it.
I'm really curious to watch at the results of your hard work.

Post by Tobias Downer
The code is slowly coming together and there will be a new release soon
and it will be considerably more advanced than the current release. I
hope the quality of the code will speak for itself when it's done.

I bet 200$ on it. :)

Good luck again and many compliments.
Antonello

Post by Tobias Downer
Hi Antonello,
Unfortunately I have to ask for a little more patience from you and the
community on the next release of Mckoi. I was hoping I'd have the code
to give out by now, but adding the new features we wanted in this
release has been a huge undertaking.
The reason for the lengthy overhaul of the code was the introduction of
a new 64 bit data storage system which I intend will be the final
revision of the data storage system in Mckoi. The new data store system
is a complete rewrite and wraps all the low level database storage/query
functionality into a simple interface which leads to many elegant ways
to implement the higher level database functions. What this means is
the next version of Mckoi will be able to scale up to massive data sets
and will have a very flexible index and list management function.
The data store code is finished. The reason why the release hasn't
happened sooner is because the change has not turned out to be an
incremental revision of the codebase. Most of the code that involves
managing data and indexes has needed to be updated or rewritten and many
of the higher level data management code has been effected in some way
from the changes.
The code is slowly coming together and there will be a new release soon
and it will be considerably more advanced than the current release. I
hope the quality of the code will speak for itself when it's done.
Toby.

---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/

---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com

M. A. Sridhar

2006-12-15 02:10:27 UTC

Permalink

Hi Toby,

I'm very happy to hear that the development is making progress.

There is one aspect that I would like to mention. The current Mckoi implementation seems to keep lots of files open, and in large deployments, it causes the JVM to fail with a "too many open files" error. My database uses about 250 tables, and I create a separate database instance for each customer in hosted mode. This seems to imply (I'm guessing here) that Mckoi opens n*250 files when there are n instances, and that causes problems with the JVM. This is unfortunately a show-stopper for me.

I am hoping that you will have addressed this problem with the new version.

Mckoi has proven to be an extremely reliable, easy-to-use piece of software. Thanks for the great work.

Best regards.

M. A. Sridhar
m_a_sridhar at yahoo dot com

----- Original Message ----
From: Tobias Downer <***@mckoi.com>
To: ***@mckoi.com
Sent: Thursday, December 14, 2006 5:57:52 PM
Subject: Re: Update on the status of Mckoi SQL

Hi Antonello,

Unfortunately I have to ask for a little more patience from you and the
community on the next release of Mckoi. I was hoping I'd have the code
to give out by now, but adding the new features we wanted in this
release has been a huge undertaking.

The reason for the lengthy overhaul of the code was the introduction of
a new 64 bit data storage system which I intend will be the final
revision of the data storage system in Mckoi. The new data store system
is a complete rewrite and wraps all the low level database storage/query
functionality into a simple interface which leads to many elegant ways
to implement the higher level database functions. What this means is
the next version of Mckoi will be able to scale up to massive data sets
and will have a very flexible index and list management function.

The data store code is finished. The reason why the release hasn't
happened sooner is because the change has not turned out to be an
incremental revision of the codebase. Most of the code that involves
managing data and indexes has needed to be updated or rewritten and many
of the higher level data management code has been effected in some way
from the changes.

The code is slowly coming together and there will be a new release soon
and it will be considerably more advanced than the current release. I
hope the quality of the code will speak for itself when it's done.

Toby.

---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com

____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com

Tobias Downer

2006-12-17 21:35:58 UTC

Permalink

This will not be an issue in the next release. The new data store
system can manage many tables without having to create a new file handle
for each table.

Toby.

Post by M. A. Sridhar
Hi Toby,
I'm very happy to hear that the development is making progress.
There is one aspect that I would like to mention. The current Mckoi
implementation seems to keep lots of files open, and in large
deployments, it causes the JVM to fail with a "too many open files"
error. My database uses about 250 tables, and I create a separate
database instance for each customer in hosted mode. This seems to imply
(I'm guessing here) that Mckoi opens n*250 files when there are n
instances, and that causes problems with the JVM. This is unfortunately
a show-stopper for me.
I am hoping that you will have addressed this problem with the new version.
Mckoi has proven to be an extremely reliable, easy-to-use piece of
software. Thanks for the great work.
Best regards.
M. A. Sridhar
|m_a_sridhar at yahoo dot com|

---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com

Hendrik Schwachenwalde

2006-12-20 18:11:02 UTC

Permalink

Hi Toby,

I am glad to hear there will be another release of
McKoi!

Recently I've stumbled over a little "feature" for
which there is an easy workaround. I would like to
bring this to your attention now in the hope you can
include a fix in your next release.

Please try the following:

CREATE TABLE nums (a INT, b INT, c INT)
INSERT INTO nums VALUES ( 5, 3, 2 )
SELECT *,a+b-c-1,a+(b-c)-1 FROM nums

If I am not mistaken the result for "a+b-c-1" should
be identical to "a+(b-c)-1" but isn't.

Secondly, about two years ago I inquired about scalar
subqueries in McKoi. I still find them a very useful
feature that I would love to have available in
McKoi;-) Maybe you could add that also, if not in
the upcoming release then maybe in a later one?

Thanks alot for all the work you have put into McKoi.

Hendrik

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com