Nliviu sdcard library qith a sqlite3

General
1

My goal is get sqlite3 library working with nliviu sdcard library

I car read from tables of db file, but I can`t write there.
When I use simple example from site it working well with all functions
How to make it working with nliviu sdcard library
@nliviu

2

this is my simple test project
https://github.com/siara-cc/esp32_arduino_sqlite3_lib/files/4095674/sd_sqlite.zip

3

Your example fails to build with a lot of errors (mos 2.16.0)

/data/fwbuild-volumes/2.16.0/apps/en_project/esp32/build_contexts/build_ctx_113428496/deps/ads7843-spi/include/mgos_ads7843.h:53:26: error: unknown type name 'uint16_t'
/data/fwbuild-volumes/2.16.0/apps/en_project/esp32/build_contexts/build_ctx_113428496/deps/ads7843-spi/src/mgos_ads7843.c:221:6: error: conflicting types for 'mgos_ads7843_spi_init'
/data/fwbuild-volumes/2.16.0/apps/en_project/esp32/build_contexts/build_ctx_113428496/deps/ads7843-spi/src/mgos_ads7843.c:257:6: error: conflicting types for 'mgos_ads7843_is_touching'

mos latest gives

panic: runtime error: invalid memory address or nil pointer dereference
[signal SIGSEGV: segmentation violation code=0x1 addr=0x0 pc=0xb0886f]

goroutine 82 [running]:
github.com/mongoose-os/mos/cli/manifest_parser.prepareLib(0x1019024, 0x3, 0xc4204faa80, 0xc420206900, 0xc4203940f0, 0xc420492060, 0xc420490790)
	/src/go/src/github.com/mongoose-os/mos/cli/manifest_parser/manifest_parser.go:750 +0xe3f
created by github.com/mongoose-os/mos/cli/manifest_parser.prepareLibs
	/src/go/src/github.com/mongoose-os/mos/cli/manifest_parser/manifest_parser.go:689 +0x118
Error: /Users/rojer9/mos/go/src/github.com/mongoose-os/mos/mos/build_remote.go:326: build failed
/Users/rojer9/mos/go/src/github.com/mongoose-os/mos/mos/build.go:220: 
/Users/rojer9/mos/go/src/github.com/mongoose-os/mos/mos/build.go:163: 
/Users/rojer9/mos/go/src/github.com/mongoose-os/mos/mos/main.go:196: build failed

Your “simple” example is not really simple and it’s not using my sdlib.
Could you create a really simple example without a lot of dependencies, please?
Something like initialize the sdcard, create a database, create table/tables, select/insert with some rpc functions, etc.

4

You library is working well. The problem was in SQLITE library, it trying to open db-journal file, which not exist.

5

@namoaton could you share a small example / tutorial on how you got this to work with mongoose os Thanks :slight_smile: