11-14-2014 05:32 PM
I am seeking beta testers for a SAS SQL Pass-through engine for SQLite v3.
I can test the software for 32-bit Windows. I would be particularly interested in 64-bit Windows users and other O/S users. However, anyone interested is welcome.
This engine does not require SAS/ACCESS for ODBC, etc. or the wonderful SQLite ODBC driver. This is an internal SAS pass-through engine (see below for the LIBNAME engine, information).
Current status on SQLite Pass-Through engine (SQLitePT):
The Pass-through engine was my first effort because it is relatively simple [except for data typing, the SQLitePT engine is almost a direct mapping between the SAS Pass-through API requests and SQLite API fulfiller]. This is my introduction to the SQLite API.
It will be followed by a SQLite LIBNAME engine later this year or early next year. This is partially written but nowhere near beta-testing. Most likely January before a beta version would be available since I have a day-job and this ain't it -- this is just promotion-ware).
I should also mention that I have not worked out the UTF-8, UTF-16le, and UTF-16be encoding/locale stuff yet. This will be an active area during beta so any non-English/non-US locales would be great.
I should clarify. I would love to develop the driver for Unix (where SQLite is available) but I do not have access to a Unix machine with SAS, SAS/Toolkit, or SQLite on the box. So if anyone has these features available, I would love to discuss compiling the engines for that platform. Or of SAS can give me access to these, I would love to do that. I can debug on Windows, SAS 32bit. I can compile the driver on Windows, SAS 64bit. The engine will run under any version of SAS v9. It can be backward compiled to SAS v8. It can be adapted for SQLite v2 (though the API calls would need to be modified...that is relatively simple.
11-14-2014 07:16 PM
I hope to be ready for beta before Thanksgiving. It will take that long to solve the data typing issues. I'll contact you then.