SQLite on raspberry pi

[psmorris]

Hi,

Is it possible to run the SQLite toolkit on a raspberry pi (connecting using the Linx/hobbyist toolkit)?

I can see examples of people using it on CRIO so it might be possible and SQLite is of course cross platform, but what steps might I need to try to make it work?!

(I have also posted this question in the hobbyist forum...)

Thanks

[psmorris]

Sorry - think I've done it. I had to install sqlite3 within the chroot on the pi that LabVIEW runs in (learning new things every day!).

Basically I did this (in case anyone comes here looking!):

1. Install SQLite3 client to your chroot:
   • sudo schroot -r -c lv
   • opkg update
   • opkg install sqlite3
   • exit

I'm not entirely sure how the file pathing works on the pi - I built a path relative to the VI I was running and passed that into the open connection vi but it said it couldn't open it. I set the path to just "\temp.db" and it worked fine... now I need to see if I can find that in the chroot!

Thanks

Paul