CapeSoft Clarion Driver Kit Launched

1

The CapeSoft Clarion Driver Kit has been announced.

This new kit enables the creation of new Clarion File Drivers. New DOS, SQLite and InMemory drivers are already available. More drivers (specifically lots of native SQL drivers) will follow soon.

The release webinar is available here (https://www.youtube.com/watch?v=64uGPcs5J6Q)

The code for the kit is free (For now the GitHib link is GitHub - Bruce511/DriverKit: CapeSoft Clarion File Driver Kit ) - but that may change in the near future.

Commercial builds of the kit are available from CapeSoft;
https://capesoft.com/accessories/filedriverkitsp.htm

Documentation is online here (Clarion Object Based Database Drivers Documentation)

I’ll post more information here as it becomes available.

Cheers
Bruce

11 Likes
2

Fabulous!.. we will download the driver kit and load it into anthropic.. compare it to the info we have in there already and see if AI can use it to create a struct builder pattern…

We have ordered the entry level kit and will see if AI can generate a UBS bindable for it… should be very interesting…many thanks!

3

we have some in memory stuff already using the C Include files for sql lite…to clarify we are using the C headers compiled in our linux UBS projects for SQL… not clarion runtime file control blocks. the driver kit we are assuming are the official specs from SV and therefore now public..

typedef int (sqlite3_callback)(void,int,char**, char**);

/*
** CAPI3REF: One-Step Query Execution Interface
**
** The sqlite3_exec() interface is a convenience wrapper around
** [sqlite3_prepare_v2()], [sqlite3_step()], and [sqlite3_finalize()],
** that allows an application to run multiple statements of SQL
** without having to use a lot of C code.
**

4

While you can add a callback into sqlite3_exec, the SQLite2 driver does not use sqlite3_exec because it is not parameterized. This makes it unsafe for generic use, and opens the door to SQL Injection attacks.

5

Documentation looks fabulous…

Sure the clarion community will support what looks like a comprehension solution.

6

Link to the GitHub Repo with the CapeSoft Clarion File Driver Kit

1 Like
7

There were examples of using the Topspeed Driver Kit in either help or the compiler PDF’s but these are no longer in our document manager other wise we would have posted them up on a thread here. If we ever come across them we will do so.

In the Capesoft driver kit Diver.inc has the info…

In the Dos days this info was published in Bulletin #117 along with its binary dump.. Being a humble Accounting Clerk one keeps these documents in the filing room of course.

re: Clarion Technical Bulletins.

re: Linux SQl port.. its looks like the linux UBS data runtime is using rc = sqlite3_prepare_v2..and in Clarion we will upgrade ST 1 to ST 3 and use it for handling the row result set date and time fields.

Many Thanks to Cape Soft.