Hi, Is it possible to use sqlite or anything similar to sqlite db ? Thanks

I think it would be possible to use sqlite. If all you are trying to do is store data and you don’t need relational database features, you might want to look at a Legato feature called configTree. http://legato.io/legato-docs/latest/c_config.html

I have built a VOIP [linphone] stack and sqlite3 was a requirement easily built and implemented as a dependency for linphone. I build it and install it into the sysroot then install it into a build directory that i copy to the app tree and include in the adef files. run ./configure with CC=$(CC) CXX=$(CXX) --host=arm-poky-linux-gnueabi CC/CXX ${WP85_TOOLCHAIN_DIR}/arm-poky-linux-gnueabi-[gcc|g++]

[image] Compile 3rd library (libcurl, etc ...) for Legato sur MangOH Follow up here for this question: https://forum.sierrawireless.com/viewtopic.php?f=177&t=9821&sid=aae664744be9aa1164228f03eaec0208 See the make file bits i pasted for a better idea

Hi David, In my application i have to store minimum 10,000 data point and each datapoint size is 512 bytes and want to store in binary format. is there any other way to write and read the data in flash memory efficiently rather than using configTree? Thanks

I think you’re right that configTree won’t meet your needs. What is the data like? Is it a 512 byte binary blob with a key or is it a complex record with many fields that you may want to perform queries based on?

Hi David, Thanks for your response. Yes it is 512 byte binary data frame (in HEX) and each frame have unique ID in the header. Query based not very necessary. Is there any api available to read / write into internal flash memory? Thanks Niladri

If you are writing a sandboxed app, then that app should be able to read and write files. Since the app is sandboxed, then only the app that wrote the files will really have access to them. Another option would be to try to get a nosql style data store running on the mangOH. I know very little about those systems though, so I can’t really help you out. Which option is best really depends on how you will be using the data.

@niladridm, how often do you want to write these binary data frames? Be careful of flash wear. You don’t want to burn out your flash device. You can use the regular POSIX file system APIs (open/lseek/read/write/close or fopen/fseek/fread/fwrite/fclose) to store your data frames in a file in your flash file system. But, remember to set your process’s maximum file size limit (maxFileBytes in the “processes:” section of your .adef file) http://legato.io/legato-docs/latest/defFilesAdef.html#defFilesAdef_processMaxFileBytes

Hi Jen, Thank you for your input. Yes currently I am using POSIX file system but the problem I am facing is, after power restart my data file is getting deleted. I am creating the file in tmp directory(may be this the reason). May be I should use sandboxed to create the file in app dir. And data writing frequency is 1 sec and it should override after 10,000 record. Thanks

Yes, /tmp is a RAM file system (tmpfs), so anything in there will be lost if the device is rebooted.

Database Support

Uncategorized

gregnietsky July 14, 2016, 9:01am 4

See the make file bits i pasted for a better idea

Topic		Replies	Views
Test Application Uncategorized	3	1466	September 19, 2016
How to run shell script after boot Uncategorized	46	2716	August 24, 2023
Mksys can't bind to non-existent server app 'wifiService' mangOH Red	45	1988	October 12, 2021
Mkapp: command not found mangOH Yellow	21	810	December 8, 2022
Error while loading shared libraries: Internal Error mangOH Green	29	717	May 24, 2023

Database Support

Related topics