AltME: Databases

Messages

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

Arnold: 07:52For Red it is here: http://red.esperconsultancy.nl/Red-SQLite/dir?ci=tip

07:53Red integration with R3 http://red.esperconsultancy.nl/Red-REBOL-3/dir?ci=tip

Endo: 15:51SQLite 4 released? I checked its web site it still version 3.
GiuseppeC: 20:48My mistake
Pekr: 21:19Not 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: 11:04When the bounty for ODBC red will be rewarderd another one will start for SQLLite 4

Endo: 15:58Pekr: 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: 16:15And it uses its key/value storage engine for all indexes in all tables in a database which is different than sqlite3.

Arnold: 20:31Is this a good place to start for ODBC for Red?
https://docs.microsoft.com/en-us/sql/odbc/reference/odbc-programmer-s-reference
GiuseppeC: 21:01I'll take a look at it
GiuseppeC: 23:38Another good starting point: https://github.com/gurzgri/r3/tree/odbc

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

amacleod: 16:54Anyone 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: 23:23Use read/custom to send cookies