Out of memory error - Githubissues

siara-cc / esp_arduino_sqlite3_lib

Sqlite3 library for ESP8266 Arduino core

Apache License 2.0

91 stars 19 forks source link

Out of memory error #8

Closed its-me-vicky closed 5 years ago

its-me-vicky commented 5 years ago

Hello, I am using sqlite3 library in my program to store data on SD card using wemos D1 R1. When I compile the code it shows 60%of program storage space is used and the program throughs out of memory error. When I searched the web it lead to add PRAGMA page_size 512. I have no idea about where to add it. Please help. Thankyou

siara-cc commented 5 years ago

To change page size follow http://sqlite.1065341.n5.nabble.com/How-to-modify-page-size-td87692.html

its-me-vicky commented 5 years ago

program pragma I uploaded this program and below is my output any suggestions please pragma error

siara-cc commented 5 years ago

Support of PRAGMA is disabled in the library. Page size is 512 default when you create using this library. So need not set it explicitly. Even then need to set it before opening the DB. Please check:

Are all the examples running without error.
Have you changed stack size in cont.h to 6144
Send code giving error if possible.