AltME: Databases

Messages

DocKimbel
If it's on Linux servers, try comparing the /etc/hosts files content.

Pekr
Using on1 Photo RAW beta right now, talked to devs, they claim to use LevekDB from Google, claiming it is faster than SQLite (though highly unreliable and not prone to failures). However, reading Wikipedia articles, I found out about Lightning DB - seems nice: https://en.wikipedia.org/wiki/Lightning_Memory-Mapped_Database
Gregg
I remember reading about it some time back. The licensing notes are interesting. Another example of people being surprised at how well simplicity works.

Gregg
It would be interesting to port to Red, maybe first as a wrapper, then a fresh implementation in Red/System. So many DB choices these days.
GiuseppeC
Is SQL Lite usable on REBOL3 ?

Endo
I think Kaj has a SQLite wrapper and it is stable though I didn't use it.
GiuseppeC
Have you a link for it ?

Endo
Sorry, I don't have. Actually not sure if it was for Red or R3.
GiuseppeC
RED3 ? :-)

Arnold

GiuseppeC
...and do we a SQLLite 4 wrapper for REBOL 2 ?

Endo
SQLite 4 released? I checked its web site it still version 3.
GiuseppeC
My mistake
Pekr
Not a mistake. Actually there is an SQLite4, which is a bit different though - kind of a key/value storage engine - https://sqlite.org/src4/doc/trunk/www/index.wiki
It is not supposed to replace SQLite3, it's more a different project ....

GiuseppeC
When the bounty for ODBC red will be rewarderd another one will start for SQLLite 4

Endo
Pekr: As I understand SQLite4 is not *just* a key/value database, "SQLite4 is a complete, relational, transactional, ACID, SQL database database engine ".
That key/alue is just one of its stored engines. So it actually is a new version of SQLite3 which is not backward compatible, but also not a replacement.
Thanks for sharing the link by the way.
Endo
And it uses its key/value storage engine for all indexes in all tables in a database which is different than sqlite3.

Arnold
GiuseppeC
I'll take a look at it
GiuseppeC
Another good starting point: https://github.com/gurzgri/r3/tree/odbc

Last message posted 348 weeks ago.