About the SQLite Extender

 

The SQLite extender provides WinBatch scripts access to SQLite databases. The extender's functions provide full support for the SQLite dialect of SQL and seamless conversion of SQLite data types to equivalent WIL variable types without the overhead of COM or .Net.

 

The extender has both the FTS5 and CSV SQLite extensions built in into the extender so no additional loadable extensions are required to use the extensions. The FTS5 extension uses VIRTUAL tables to provide very fast full text search functionality. The CSV extension uses VIRTUAL tables to allows you to query Comma Separated Value (CSV) files using SQL statements without having to convert the entire file into an SQLite database.

 

The also extender supports all built in SQLite SQL dialect functions including the JSON data functions.

 

Visit and search the SQLite.org Website for detailed information about the SQLite dialect of SQL and SQLite functions and extensions.

 

To access the functions in this extender, add the following to your script:

 

32-bit Extender

 

AddExtender('ILCSL44I.DLL')

 

Requires:Windows Vista/2008 or newer.

 

64-bit Extender

 

AddExtender('ILCSL64I.DLL')

 

Requires:Windows Vista/2008 or newer.

 

32-bit and 64-bit Extender

 

AddExtender('ILCSL44I.DLL',0,'ILCSL64I.DLL')

 

Requires:Windows Vista/2008 or newer.

 

Note: The SQLite extender requires Windows Vista/2008 or newer. Using this extender on older versions of Windows may result in a kernel exceptions and abrupt script termination.

 

 

 

 

 

Acknowledgments:

 

  • Extender developed by Anonymous.

  • Help file by Anonymous.

  • SQLite libraries provided by SQLite.org with support from The SQLite Consortium.

  • The NorthWind.sql example SQL script is covered by the following MIT license and copyright:

     

    The MIT License (MIT)

    Copyright (c) 2016 JP White

    Permission is hereby granted, free of charge, to any person
    obtaining a copy of this software and associated
    documentation files (the "Software"), to deal in
    the Software without restriction, including without limitation
    the rights to use, copy, modify, merge, publish, distribute,
    sublicense, and/or sell copies of the Software, and to permit
    persons to whom the Software is furnished to do so, subject
    to the following conditions: The above copyright notice and
    this permission notice shall be included in all copies or
    substantial portions of the Software.

    THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
    EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES
    OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
    NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT
    HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY,
    WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING
    FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
    OTHER DEALINGS IN THE SOFTWARE.

 

 

Island Lake Consulting LLC is grateful to the groups and individuals above for their contributions.