Tokyto Cabinet Table engine?

[nanook]

I'm currently researching Tokyo Cabinet, Tyrant and Lightcloud and I'm
very intrigued by what I'm seeing so far. I noticed that Tokyo Cabinet
has a table engine (http://www.igvita.com/2009/02/13/tokyo-cabinet-
beyond-key-value-store/) that looks to be very useful to do SQL-type
of queries. Does Lightcloud have the ability to make use of these?

[spacelee]

lightcloud can also do this if the tyrant has provided the table API.
maybe next time i will add some features for the table in lightcloud-
php.

[nanook]

Wow, that would be really neat! I would certainly be interested in
seeing that feature in lightcloud-php! Is that a difficult thing to
implement?

[amix]

I would discourage this usage, as a real relational database (e.g.
MySQL/PostgreSQL) are much better fits than LC/TT.

Amir

2009/8/30 spacelee <fjc...@gmail.com>:

[nanook]

Could you elaborate on why you would discourage this? I understand
that no key-value database is designed to be a complete replacement
for RDMS databases and that it's recommended to use MySQL/PostgreSQL
alongside these systems. But at the same time it would seem to me that
the table engine is one of the main advantages that Tokyo Cabinet has
over other solutions, so why not make use of it?

On Aug 30, 3:27 am, amix <ami...@gmail.com> wrote:
> I would discourage this usage, as a real relational database (e.g.
> MySQL/PostgreSQL) are much better fits than LC/TT.
>
> Amir
>

> 2009/8/30 spacelee <fjct...@gmail.com>:

[amix]

The table support in Tokyo Cabinet is one of the recent additions and
_not_ one of the main reasons why one would use Tokyo Cabinet. One
should use Tokyo Cabinet because of such things like _great_
performance, battle tested key-value store and good tool support
(e.g. Tokyo Tyrant).

Anyhow, I follow the philosophy of using the best tool for the job and
Tokyo Cabinet isn't the best tool for storing and manging relational
data. If you need this, then pick MySQL or Postgre - you are likely to
hit a lot less problems than using a recent feature of Tokyo Cabinet.

Regards,
amix

2009/8/30 nanook <asn...@hostonfiber.com>:

[Spacelee]

i agree with amix...

2009/8/30 amix <ami...@gmail.com>

--
Spacelee