Altair slc sqlite odbc reading and writing tables using passthru processing

Question

Too long to post here, see github

github

https://github.com/rogerjdeangelis/utl-altair-slc-sqlite-odbc-reading-and-writing-tables-using-passthru-processing

SQLite's load_extension() uniquely allows dynamic loading of over 200 specialized

functions not available in PostgreSQL, MySQL, SQL Server, or Oracle ...:

Sqlite is a simple file database, no need for userid, password, connections strings or

all the overhead of typical databases. This makes it especially useful to

mimic 'proc sql' adding substantial new functionality to sql. Especially

sql clauses like 'partition by'.

This post allows you to use the exact same very advanced sqlite scripts in

any language that supports odbc.

Eliminates the ankle biters created by slight differences in sql dialects.

SQLITE CAN BE USED WITH

Altair SLC

Pyhton

R

Excel

Octave (Matlab clone)

PSPP (SPSS clone)

Stata

MS Access

....

CONTENTS

* sqlite create csv
* sqlite get extensions
* get odbc driver
* create sqlite db & table
* sqlite passthru
* output
* log
* extensions list