Using SQLite with PowerShell

In this video, you learn how to use the SQLite databases from PowerShell via the PSSQLite module. You'll see how to load data into tables quickly and do some basic queries. There are many applications to storing data in SQLite in Admin, DBA, and systems maintenance programming. Bring your skills and power to a new level.

Code and Slides

PSSQLite on PowerShell Gallery (Caution: Very slow to load)

GitHub Repo for PSSQLite

Additional links to help you learn SQLite

SQLite Introduction (Some Python too but mostly SQLite features)

Installing and Using SQLite Studio

[shanewilliams]

Loved your video... please make the follow up videos on this subject. I am a visual learner and this was very helpful.

[LukeAvedon]

Love this. I love both PowerShell and SQLite, but never used them together.

[pratiksarani]

Thanks Love to See more videos from you

[romanhar]

Thank you very much.
I think about doing a regularly analyse about the files on our server, create a sqlite3 with Hashes and data about the files. I want to ckeck afterwords if a lot of file has changed or hafe been deleted to detect if there is something fishy going on... The question is what is the fastest way. Maybe powershell is faster in accessing file information, then python.

[BrandCJC]

GREAT video, ok so I'll be the one to ask please where is the follow up videos??? I would love to learn more form you on this subject

[emerelle]

Does every Invoke-SqliteQuery open and new connection and closes it when it's done, or is it one session I can open at the begin of the script and close at the end?

[Baba-rjkf]

Thank you for this, this is a big help. I'm running into trouble where I need multiple scripts to access data values and textfiles on the computer is just not working out! THANK YOU!

[zeus]

Great video! What is the main benefits of using this module instead of using the sqlite3 binary?