Creating tables on 4MB SPIFFS

[van-deste]

No description provided.

[van-deste]

Apologize for creating and closing the issue. I have an error and I cannot understand what was happening.

I have a new error. In my ESP32, I have 4MB of SPIFFS created using a custom partition.
I need to create 3 tables, however I get a Disk I/O error.

Here is my sql to create the tables:

CREATE TABLE IF NOT EXISTS table1 ( field1 INTEGER, field2 TEXT, field3 TEXT, field4 TEXT, field5 INTEGER, field6 INTEGER, field7 TEXT, field8 TEXT, field9 TEXT, field10 BOOLEAN, field11 TEXT, field12 BOOLEAN, field13 TEXT, field14 BOOLEAN, field15 TEXT, field16 BOOLEAN, field17 TEXT, field18 BOOLEAN, field19 TEXT, field20 BOOLEAN, field21 TEXT, field22 BOOLEAN, field23 TEXT );

CREATE TABLE IF NOT EXISTS table2 ( field1 INTEGER, field2 INTEGER, field3 TEXT, field4 TEXT, field5 TEXT );

CREATE TABLE IF NOT EXISTS table3 ( field1 INTEGER, field2 INTEGER, field3 INTEGER, field4 TEXT );

I do not understand, why I get this error. Could anyone help me, please?
Thank you.

[HankLloydRight]

I have a new error. In my ESP32, I have 4MB of SPIFFS created using a custom partition. I need to create 3 tables, however I get a Disk I/O error.

Just a longshot here, but SPIFFS has been deprecated for ages.
Have you tried using a LittleFS partition instead?

Are you sure your partition has free space?

[van-deste]

Well, I did not know that...
I did not try to use LitleFS... is it simple to implement?

Yes my partition has space:
When creating the tables I do the follow:

Serial.printf("Total space: %d bytes\n", SPIFFS.totalBytes()); Serial.printf("Used space: %d bytes\n", SPIFFS.usedBytes());

And my serial monitor outputs the follow:
Total space: 3848081 bytes
Used space: 6502 bytes

[HankLloydRight]

Well, I did not know that...
I did not try to use LitleFS... is it simple to implement?

What IDE are you using? I'd just goggle or AI help on how to upgrade. It's almost plug-and-play but your code will need some minor changes.

[van-deste]

I am using CLion IDE using the PlatformIO framework.
I will do the changes to implement LittleFS instead of SPIFFS and see if it resolves the problem

[HankLloydRight]

I'm not familiar with CLion IDE, but I am using VSC with PlatformIO, so you shouldn't have any issues.

You can always revert back to SPIFFS if you need to.
Good luck!

[van-deste]

It is just a preference. I used to work with VSCode and PlatformIO, but I find CLion better for me. It is almost the same.
I will update you when I finish doing the changes.
Thank you for the fast response and your help.

[van-deste]

@HankLloydRight problem solved. Thank you so much for your help!

[siara-cc]

@HankLloydRight Thanks!
Yeah there have been issues using this repo with SPIFFS
#50

[van-deste]

I think we can close this issue. Thank you both!