Great work! I'm trying to compare the speed of SQLite vs just reading through CSV and I expected SQLite to be a lot quicker than reading through the CSV. Investigating a little more, is it because the SQLite is going through an intermediary DLL to access the database?
Hello James. I've been trying to make my own kind of "write to database" from the templates shown in the video. Is there any way to "drop table if exist" - kind of command? I want to place it as a subVI inside a while loop, and i can't seem to figure out how not to have to save a new database everytime. Is that possible?
Oh i'm sorry James. I guess i was tired yesterday when i wrote to you. I did not mean drop the table, but drop the database. So say i just want to create and save my database only once, and afterwards just keep writing to it, without the need to define the path everytime. Is that possible?
XML? No. But if you can convert your XML to JSON, then you can use the JSON1 extension to SQLite to input the JSON directly (sqlite.org/json1.html). You can then run SQL queries on the JSON.
Thanks James!! I tried to deply the code in RT Targe(Pharlap OS in PXI with LV 2015)t, I am getting a error code:7 File not found. But the code works fine in Host(Windows PC with LV 2015). Any solution?.
The LabVIEW package comes with a Windows-compiled dll. It will also run on LinuxRT if you install SQLite separately using opkg. But I don’t know of anyone who has run it on Pharlap. You would need to compile SQLite for Pharlap.
Amazing, thank you for creating this library!
Great introductory video to get started with SQLite. Thanks!
Great library, thank you!
Great demo.
SIR , Please upload oops from scratch in labview....thanks in advance
What is the black magic you used to re-size the For loop at 3:20? I have never seen that before!
That’s just mouse-drag while holding the ctrl key. In the latest LabVIEW versions you can also shrink things by holding ctrl and alt.
Great work! I'm trying to compare the speed of SQLite vs just reading through CSV and I expected SQLite to be a lot quicker than reading through the CSV. Investigating a little more, is it because the SQLite is going through an intermediary DLL to access the database?
Speed advantages come in through rapid lookup, rather than straight reading of everything.
@@drjdpowell thanks for the reply! one more question - does the library support a call to "Export to CSV" programatically?
Hello James. I've been trying to make my own kind of "write to database" from the templates shown in the video. Is there any way to "drop table if exist" - kind of command? I want to place it as a subVI inside a while loop, and i can't seem to figure out how not to have to save a new database everytime. Is that possible?
Yes, see www.sqlite.org/lang_droptable.html
Thank you for the answer. I will give it a try.
Oh i'm sorry James. I guess i was tired yesterday when i wrote to you. I did not mean drop the table, but drop the database. So say i just want to create and save my database only once, and afterwards just keep writing to it, without the need to define the path everytime. Is that possible?
Great job!! Doubt : Can we convert XML files into SQL file using this library?
XML? No. But if you can convert your XML to JSON, then you can use the JSON1 extension to SQLite to input the JSON directly (sqlite.org/json1.html). You can then run SQL queries on the JSON.
Thanks James!! I tried to deply the code in RT Targe(Pharlap OS in PXI with LV 2015)t, I am getting a error code:7 File not found. But the code works fine in Host(Windows PC with LV 2015). Any solution?.
The LabVIEW package comes with a Windows-compiled dll. It will also run on LinuxRT if you install SQLite separately using opkg. But I don’t know of anyone who has run it on Pharlap. You would need to compile SQLite for Pharlap.