Most likely January before a beta version would be available since I have a day-job and this ain't it :smileygrin: - this is just promotion-ware). This is partially written but nowhere near beta-testing. This is more than 30 seconds for a query that executes <30ms in SQLite3. A simple Select query on a single table with 16 columns and 200 rows takes approximately 200ms per row (I timed it). It will be followed by a SQLite LIBNAME engine later this year or early next year. I use Excel VBA with SQLite3 ODBC driver obtained from Both are 32 bits version on a Windows 10 computer. This is my introduction to the SQLite API. The Pass-through engine was my first effort because it is relatively simple. The options parser needs work - I thought I would not need so many options but they keep spiraling and my simple state-machine is becoming cumbersome.This will follow three methods: Hints, Declared types, and Guess (sample with type promotion, sample with type TEXT, sample with type MAJORITY). Currently working on data type evaluation which is tricky in SQLite since the engine does not really type columns, at all. I will get around this later by exploiting commented hints in the query. EXECUTE has no facility to return information to SAS (except via LOG or OUTPUT). This is needed because of SQLite's love of PRAGMA commands to retrieve information and the SQL-Pass-Through requirement that information may only be retrieved from the DB via a SELECT query. The EXECUTE () BY also includes an option to return results to the LOG or not.The engine can perform an EXECUTE (sqlite-sql-code) BY command.The engine executes SELECT queries but currently returns everything as a 128 byte character string (see below).The engine opens/closes the file you tell it to with ACCESS=READONLY | READWRITE | CREATE.The engine connects/disconnects with the SQLITE3.DLL.This is an internal SAS pass-through engine (see below for the LIBNAME engine, information).Ĭurrent status on SQLite Pass-Through engine (SQLitePT): The engine does not require SAS/ACCESS for ODBC, etc. I am recruiting anyone interested in beta-testing the engine. I am working on a SQL Pass-through engine for SQLite v3 right now.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |