siara-cc/esp32_arduino_sqlite3_lib

Issues

• DuckDB (An embeddable SQL database like SQLite) for ESP32

  #104 opened 6 months ago by georgevbsantiago
  1

• SQL Updates

  #92 opened a year ago by BackInFiveMinutes
  10

• An empty value in the response

  #103 opened 6 months ago by kenobi3
  1

• How do I update SQLite?

  #102 opened 7 months ago by georgevbsantiago
  2

• Creating tables on 4MB SPIFFS

  #101 opened 9 months ago by van-deste
  10

• Cannot execute queries with JOIN operator

  #100 opened 9 months ago by Bas1950
  3

• SQLite corrupts easily

  #99 opened a year ago by muuris
  5

• sqlite3 database stored in Littlefs in esp32 s3 taking too much time in insert and update

  #98 opened a year ago by ankitmittal1402
  7

• Enable `SQLITE_ENABLE_PREUPDATE_HOOK` Compile-time Option

  #97 opened a year ago by Zhu-jiatong
  0

• `PRAGMA foreign_keys` still no-op

  #96 opened a year ago by Zhu-jiatong
  0

• error 14 (SQLITE_CANTOPEN) when open database after do several "SELECT" command

  #95 opened a year ago by asbs-eng
  2

• Cannot create a new table in an existing database file on SD card

  #58 opened 4 years ago by jojo2357
  6

• How to structure the string to create a trigger?

  #94 opened a year ago by georgevbsantiago
  2

• Too many sql statements and it fails

  #93 opened a year ago by zaplakkies
  5

• New version release to fix ESP32 Arduino Core 3.0.0 compilation error

  #91 opened a year ago by Zhu-jiatong
  1

• Foreign keys and ON DELETE CASCADE not working properly

  #90 opened a year ago by tesa-klebeband
  7

• LoadProhibited error in sqlite3_open

  #84 opened a year ago by Emile1154
  0

• Crashes while opening database in esp32

  #89 opened 2 years ago by pluzmedia
  1

• Compile Error on compiler warnings "All"

  #88 opened 2 years ago by yagikjp
  1

• Cannot use order by, limit and offset same time.

  #85 opened 2 years ago by nhphuc699
  5

• Questions Regarding PAGE_SIZE and SQLITE_ESP32VFS_BUFFERSZ

  #86 opened 2 years ago by slowpoison4
  2

• Compile problem

  #70 opened 3 years ago by Hsuan2510
  2

• Disk I/O Error when creating database table inline with AUTOINCREMENT

  #66 opened 3 years ago by davidtheITguy
  8

• solution to SQL error: disk I/O / SQLITE_IOERR (10): temp file support

  #81 opened 2 years ago by winkelict
  10

• usb vfs support?

  #83 opened 2 years ago by Emile1154
  0

• Can not insert more than 1000 row in a table!!!

  #82 opened 2 years ago by aliasqardarestani
  0

• Disk I/O error with GROUP BY clause

  #67 opened 3 years ago by biospank
  5

• VACUUM result disk I/O error

  #55 opened 4 years ago by manouhihalid
  10

• Not compiling for ESP32

  #80 opened 2 years ago by ohbhatt
  1

• Regression on table creation between 2.3 and 2.4

  #79 opened 2 years ago by chris-accupill
  1

• Delete Limit issue "parser stack overflow"

  #74 opened 2 years ago by 41linea45
  1

• no such table

  #78 opened 2 years ago by PTT31
  0

• Feature Request : Update SQLite Core to at least v3.39.x to take in charge "RIGHT and FULL OUTER JOIN"

  #72 opened 2 years ago by MantaRayDeeJay
  3

• request to pump the last version to PlatformIO registry

  #76 opened 2 years ago by hpsaturn
  1

• Double execution of query

  #75 opened 2 years ago by jovanadim
  0

• Slow execution (sqlite3_step(res) == SQLITE_ROW)

  #73 opened 2 years ago by pyrotechnik
  2

• Fixes and Improvements

  #71 opened 2 years ago by savejeff
  2

• Working with simultaneous actions

  #68 opened 3 years ago by Zhu-jiatong
  2

• SD doesn't begins

  #69 opened 3 years ago by jnegrete2005
  7

• 800 inserts/updates per second versus 22 inserts per second when adding "ON CONFLICT DO UPDATE"

  #54 opened 4 years ago by Fischkopppp
  11

• sqlite3_prepare_v2 breaks client.connect()

  #65 opened 3 years ago by sharkyenergy
  5

• Get database tables list

  #64 opened 3 years ago by GeorgeSikora
  1

• SD Card mount failure

  #63 opened 3 years ago by bcookew
  2

• Can i use it with IDF instead of arduino?

  #62 opened 3 years ago by jacsamg
  2

• Faster sqlite by using sdFat

  #61 opened 3 years ago by williamesp2015
  0

• set server time using ntp servers

  #60 opened 3 years ago by yashram96
  0

• multiple DELETE in transaction occasionally cause disk I/O error

  #59 opened 3 years ago by albertlt
  0

• gcc8_4 and arduino-esp32 v2.0 (error: 'nPage' undeclared)

  #56 opened 4 years ago by lbernstone
  1

• Creating empty DB file from ESP32 itself

  #53 opened 4 years ago by simkard69
  3

• Select * from ... query results

  #52 opened 4 years ago by ChaitanyaYeole02
  3