- "opkg install command is not working on my yocto os..." - how do you mean? what's the output? have you set up the repositories at all?
- mysql is mariadb on Yocto (as on most distros nowadays). There are recipes but it's not in i586/ - maybe arfoll could add it?
- sqlite is included however; maybe it's already fine for your purposes
The packages for the image you are using are in the repository for the IoT image
Or you can use the SD-Card Linux Image. With this image you can add packages from this repository where the mysql is. The instructions for adding packages from this repository are in here: Galileo Package Repo Configuration Instructions
sqlite is enough for my purpose..
but where it is installed?
how to access it ?
where are the configuration files stored?
how to send data to sqlite database ?
how to retrive data from it ?
You can start using it with:
root@galileo:/# sqlite3 SQLite version 220.127.116.11 2014-02-11 14:52:19 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .help .backup ?DB? FILE Backup DB (default "main") to FILE .bail ON|OFF Stop after hitting an error. Default OFF .databases List names and files of attached databases .....
You can find more information here:
When you install a package with opkg it creates dependencies in your board regarding the package you are installing. You can find some of the files with:
root@galileo:/# find / -name sqlite3