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?
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.
I think either could work. Python may give you more flexibility if you want to get fancy. Piping the files into a PowerShell function might be easier if you keep it less fancy.
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!
Thanks a lot, you make it very easy!
Loved your video... please make the follow up videos on this subject. I am a visual learner and this was very helpful.
Thanks. I've been trying to figure out what follow ups to this would be useful. What do you think?
Love this. I love both PowerShell and SQLite, but never used them together.
Yeah. It's a powerful combination.
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
I'll have to take a look at where I left off on that one. Thanks
So helpful !
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?
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.
I think either could work. Python may give you more flexibility if you want to get fancy. Piping the files into a PowerShell function might be easier if you keep it less fancy.
Thanks Love to See more videos from you
I'm doing lots of videos just not many on PowerShell lately. Thanks.
Great video! What is the main benefits of using this module instead of using the sqlite3 binary?
I suppose being integrated in powershell is more performant and also makes your scripts better readable and testable?
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!
YW!