Altair slc language8 powershell read write text files summarize and looping with sqlite
Too long to post on a list, see github
https://github.com/rogerjdeangelis/utl-altair-slc-language8-powershell-read-write-text-files-summarize-and-looping-with-sqlite
CONTENTS
1 regression using sqlite table
2 summarize slite table
select group_concat(name), sex, mean(age), mean(height) from have group by sex
3 write and read text files in sqlite
4 sqlite looping
find the median of numbers 1-10 (5.5)
5 sqlite tables back to slc
Note: I was unable to use the powershell module PSSQLite, which can simplify sqlite processing,
because I was unable to add windows extensions.
I don't think PSSQlite supports sqlite windows extensions?
SOAPBOX ON
I am not a fan of microsoft powershell and .NET because, whos to say, that
microsoft will turn your future perfectly working workstation into a brick(no security updates) and
make you install a terrible win 11 operating system to run those apps, and under certain conditions
make you pay for it.
Who knows what ms will do in the future?
If it had not been for one line is a contract with IBM and the bundling of office,
IBM 32bit OS2 would have eliminated 16bit windows 31 amd we all would be better off today.
SOAPBOX OFF
Note: Most of the sqlite queries below can NOT be done in 'proc sql' in sas or the slc
Note sqlite has csv read and write commands, however I want to present general txt processing in sql.
Keep in mind that I am demonstrating that the exact sqlite queries work in the 8 languages below.
In addition you can use the exact same queries in any language or operating system that supports odbc.
OBJECTIVE
I am trying to make sql programmers, expert programmers in
8 languages using exactly the same sql queries.
Use packages and procedures for analysis and sql for data wrangling and interfacing.
Add very powerfull sql processing to the open source spss
Posgresql has windows extensions.
I hope to add repos with drop downs to sql with windows extensions in many languages
*language 1 open source spss
*language 2 open source matlab
*language 3 r
*language 4 python
*language 5 altair odbc sqlite
*language 6 excel
*language 7 perl
*language 8 powershell
RELATED REPOS (SEE FOR INFORMATION OF INSTALLING ODBC AND SQLITE
https://github.com/rogerjdeangelis/utl-altair-slc-sqlite-cheat-sheet
https://github.com/rogerjdeangelis/utl-altair-slc-language1-drop-down-to-open-source-spss-and-execute-postgresql-query
https://github.com/rogerjdeangelis/utl-altair-slc-language2-drop-down-to-open-source-matlab-and-execute-sqlite-with-extensions
https://github.com/rogerjdeangelis/utl-altair-slc-language3-proc-r-read-write-csv-files-and-summarize-and-looping-with-sqlite
https://github.com/rogerjdeangelis/utl-altair-slc-language4-proc-python-read-write-csv-files-and-summarize-and-looping-with-sqlite
https://github.com/rogerjdeangelis/utl-altair-slc-native-language5-odbc-read-write-text-files-summarize-and-looping-with-sqlite
https://github.com/rogerjdeangelis/utl-altair-slc-language6-rexcel-read-write-text-files-summarize-and-looping-with-sqlite
https://github.com/rogerjdeangelis/utl-altair-slc-language7-perl-read-write-text-files-summarize-and-looping-with-sqlite
https://github.com/rogerjdeangelis/utl-altair-slc-language8-powershell-read-write-text-files-summarize-and-looping-with-sqlite
