AltME: Databases

Messages

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

GrahamC
Yes, that's the code being used to port this ODBC extension to a rebol 3 module

amacleod
Anyone of  experience with RETS (Real Estate Transaction Standard)? Its a gateway to access an SQL database. It seems staight forward but it deals with cookies and I'm not sure how that is done with rebol.
GrahamC
Use read/custom to send cookies

Last message posted 115 weeks ago.