siara-cc/esp32_arduino_sqlite3_lib issues and pull requests

#104 - DuckDB (An embeddable SQL database like SQLite) for ESP32

Issue - State: closed - Opened by georgevbsantiago 2 months ago - 1 comment

#103 - An empty value in the response

Issue - State: open - Opened by kenobi3 2 months ago - 1 comment

#102 - How do I update SQLite?

Issue - State: open - Opened by georgevbsantiago 4 months ago - 2 comments

#101 - Creating tables on 4MB SPIFFS

Issue - State: closed - Opened by van-deste 5 months ago - 10 comments

#100 - Cannot execute queries with JOIN operator

Issue - State: open - Opened by Bas1950 6 months ago - 3 comments

#99 - SQLite corrupts easily

Issue - State: closed - Opened by muuris 9 months ago - 5 comments

#98 - sqlite3 database stored in Littlefs in esp32 s3 taking too much time in insert and update

Issue - State: open - Opened by ankitmittal1402 9 months ago - 7 comments

#97 - Enable `SQLITE_ENABLE_PREUPDATE_HOOK` Compile-time Option

Issue - State: open - Opened by Zhu-jiatong 12 months ago

#96 - `PRAGMA foreign_keys` still no-op

Issue - State: open - Opened by Zhu-jiatong 12 months ago

#95 - error 14 (SQLITE_CANTOPEN) when open database after do several "SELECT" command

Issue - State: open - Opened by asbs-eng 12 months ago - 2 comments

#94 - How to structure the string to create a trigger?

Issue - State: open - Opened by georgevbsantiago about 1 year ago - 2 comments

#93 - Too many sql statements and it fails

Issue - State: open - Opened by zaplakkies about 1 year ago - 5 comments

#92 - SQL Updates

Issue - State: open - Opened by BackInFiveMinutes about 1 year ago - 10 comments

#91 - New version release to fix ESP32 Arduino Core 3.0.0 compilation error

Issue - State: closed - Opened by Zhu-jiatong about 1 year ago - 1 comment

#90 - Foreign keys and ON DELETE CASCADE not working properly

Issue - State: closed - Opened by tesa-klebeband about 1 year ago - 7 comments

#89 - Crashes while opening database in esp32

Issue - State: closed - Opened by pluzmedia about 1 year ago - 1 comment

#88 - Compile Error on compiler warnings "All"

Issue - State: open - Opened by yagikjp over 1 year ago - 1 comment

#87 - fix type error on comparison

Pull Request - State: closed - Opened by mhaberler over 1 year ago - 1 comment

#86 - Questions Regarding PAGE_SIZE and SQLITE_ESP32VFS_BUFFERSZ

Issue - State: closed - Opened by slowpoison4 over 1 year ago - 2 comments

#85 - Cannot use order by, limit and offset same time.

Issue - State: closed - Opened by nhphuc699 over 1 year ago - 5 comments

#84 - LoadProhibited error in sqlite3_open

Issue - State: closed - Opened by Emile1154 over 1 year ago

#83 - usb vfs support?

Issue - State: closed - Opened by Emile1154 over 1 year ago

#82 - Can not insert more than 1000 row in a table!!!

Issue - State: open - Opened by aliasqardarestani over 1 year ago

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

Issue - State: open - Opened by winkelict over 1 year ago - 10 comments

#80 - Not compiling for ESP32

Issue - State: open - Opened by ohbhatt over 1 year ago - 1 comment

#79 - Regression on table creation between 2.3 and 2.4

Issue - State: open - Opened by chris-accupill over 1 year ago - 1 comment

#78 - no such table

Issue - State: closed - Opened by PTT31 almost 2 years ago

#77 - Fix for compilation errors with esp32-arduino 3.x.x

Pull Request - State: closed - Opened by tobozo almost 2 years ago - 2 comments

#76 - request to pump the last version to PlatformIO registry

Issue - State: open - Opened by hpsaturn almost 2 years ago - 1 comment

#75 - Double execution of query

Issue - State: closed - Opened by jovanadim almost 2 years ago

#74 - Delete Limit issue "parser stack overflow"

Issue - State: open - Opened by 41linea45 about 2 years ago - 1 comment

#73 - Slow execution (sqlite3_step(res) == SQLITE_ROW)

Issue - State: closed - Opened by pyrotechnik about 2 years ago - 2 comments

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

Issue - State: open - Opened by MantaRayDeeJay about 2 years ago - 3 comments

#71 - Fixes and Improvements

Issue - State: open - Opened by savejeff about 2 years ago - 2 comments

#70 - Compile problem

Issue - State: open - Opened by Hsuan2510 about 2 years ago - 2 comments

#69 - SD doesn't begins

Issue - State: closed - Opened by jnegrete2005 over 2 years ago - 7 comments

#68 - Working with simultaneous actions

Issue - State: open - Opened by Zhu-jiatong over 2 years ago - 2 comments

#67 - Disk I/O error with GROUP BY clause

Issue - State: closed - Opened by biospank over 2 years ago - 5 comments

#66 - Disk I/O Error when creating database table inline with AUTOINCREMENT

Issue - State: open - Opened by davidtheITguy over 2 years ago - 8 comments

#65 - sqlite3_prepare_v2 breaks client.connect()

Issue - State: open - Opened by sharkyenergy over 2 years ago - 5 comments

#64 - Get database tables list

Issue - State: closed - Opened by GeorgeSikora almost 3 years ago - 1 comment

#63 - SD Card mount failure

Issue - State: closed - Opened by bcookew almost 3 years ago - 2 comments

#62 - Can i use it with IDF instead of arduino?

Issue - State: closed - Opened by jacsamg almost 3 years ago - 2 comments

#61 - Faster sqlite by using sdFat

Issue - State: open - Opened by williamesp2015 about 3 years ago

#60 - set server time using ntp servers

Issue - State: open - Opened by yashram96 about 3 years ago

#59 - multiple DELETE in transaction occasionally cause disk I/O error

Issue - State: closed - Opened by albertlt about 3 years ago

#58 - Cannot create a new table in an existing database file on SD card

Issue - State: open - Opened by jojo2357 about 3 years ago - 6 comments

#57 - Create CMakeLists.txt

Pull Request - State: closed - Opened by jojo2357 about 3 years ago - 2 comments

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

Issue - State: closed - Opened by lbernstone over 3 years ago - 1 comment

#55 - VACUUM result disk I/O error

Issue - State: open - Opened by manouhihalid over 3 years ago - 10 comments

#54 - 800 inserts/updates per second versus 22 inserts per second when adding "ON CONFLICT DO UPDATE"

Issue - State: open - Opened by Fischkopppp over 3 years ago - 11 comments

#53 - Creating empty DB file from ESP32 itself

Issue - State: open - Opened by simkard69 over 3 years ago - 3 comments

#52 - Select * from ... query results

Issue - State: open - Opened by ChaitanyaYeole02 almost 4 years ago - 3 comments

#51 - E (1027) SPIFFS: mount failed, -10025

Issue - State: closed - Opened by ChaitanyaYeole02 almost 4 years ago

#50 - SQLite Database Disk Image is Malformed

Issue - State: open - Opened by reshma26994 almost 4 years ago - 2 comments

#49 - PRAGMA not being processed?

Issue - State: open - Opened by mr-wiggle about 4 years ago - 1 comment

#48 - How to prepare query response String to be written to .jason file

Issue - State: open - Opened by happytm about 4 years ago - 5 comments

#47 - [Resolved] ESP32 panics with certain code.

Issue - State: open - Opened by happytm about 4 years ago - 8 comments

#46 - Need help with insert statement

Issue - State: closed - Opened by happytm about 4 years ago - 2 comments

#45 - esp32 SPIRAM replacement for malloc

Issue - State: open - Opened by majorninth about 4 years ago - 1 comment

#44 - LittleFS support ?

Issue - State: open - Opened by tobozo over 4 years ago - 33 comments

#43 - SQLite 2.3.0 - DELETE FROM [tablename] with many records results in I/O Error

Issue - State: closed - Opened by genotix over 4 years ago - 11 comments

#42 - SQLite 2.3.0 - DELETE with Subquery returns [SQL error: parser stack overflow]

Issue - State: open - Opened by genotix over 4 years ago - 3 comments

#41 - Temporary sort file, Watch dog

Issue - State: open - Opened by vvvait over 4 years ago - 4 comments

#40 - ESP rebooting on insert record and issue in inserting values to fields

Issue - State: closed - Opened by ChazSingh over 4 years ago - 1 comment

#39 - ESP32 - Sqlite & RTClib (DS3231) Error

Issue - State: open - Opened by hectorx2x over 4 years ago - 1 comment

#38 - Callback not called after searching non existent record

Issue - State: open - Opened by albertlt over 4 years ago - 4 comments

#37 - UNION or JOINS in views

Issue - State: open - Opened by tomthemod over 4 years ago - 3 comments

#36 - PRAGMA ?

Issue - State: closed - Opened by AVDeveloppement over 4 years ago - 5 comments

#35 - Database does not contain the information entered after a close and a reset.

Issue - State: closed - Opened by riquebrenner almost 5 years ago - 1 comment

#34 - Slow work of insert data

Issue - State: open - Opened by Rita858 almost 5 years ago - 7 comments

#33 - slow execution of sqlite3_step() function?!

Issue - State: open - Opened by GithubPatrick91 almost 5 years ago - 1 comment

#32 - Can i host a webpage from spiffs if i use sqlite3_lib?

Issue - State: closed - Opened by zekageri almost 5 years ago - 2 comments

#31 - implementing JSON as reference in callback function

Issue - State: closed - Opened by kiwi85 about 5 years ago - 1 comment

#30 - get error on index

Issue - State: closed - Opened by Rita858 about 5 years ago - 1 comment

#29 - Problem with bluetooth.serial

Issue - State: open - Opened by illosan about 5 years ago

#28 - vfs, unable to open database file

Issue - State: closed - Opened by michelpa about 5 years ago - 8 comments

#27 - slow insertion - how to improve speed if need to insert large amount of rows ?

Issue - State: open - Opened by our30K over 5 years ago - 4 comments

#26 - Can I use Sqlite3 in ESPAsyncWebServer

Issue - State: open - Opened by Meekdai over 5 years ago

#25 - [Question] How to properly escape quoted strings to avoid SQL errors and/or injections ?

Issue - State: closed - Opened by tobozo over 5 years ago - 4 comments

#24 - can write on custom spiffs partitions

Issue - State: closed - Opened by phamminhkhac over 5 years ago

#23 - disk I/O error on transaction with two tables on release 2.3

Issue - State: open - Opened by deividi21 over 5 years ago - 2 comments

#22 - Sync with remote server

Issue - State: open - Opened by thbl over 5 years ago - 2 comments

#21 - disk I/O error on transaction with two tables

Issue - State: closed - Opened by deividi21 over 5 years ago - 3 comments

#20 - Can`t insert data in table. SQL error: unable to open database file

Issue - State: open - Opened by namoaton over 5 years ago

#19 - Mongoose os and nliviu`s sdlib crashed

Issue - State: closed - Opened by namoaton over 5 years ago - 6 comments

#18 - (778) SQLITE_IOERR_WRITE when adding a table using UNIQUE or PRIMARY KEY on spiffs

Issue - State: open - Opened by mr-wiggle over 5 years ago - 21 comments

#17 - Unable to Compile Example Sketch on Arduino IDE

Issue - State: closed - Opened by fmanzoor over 5 years ago - 15 comments

#16 - Multiple rows in a single query

Issue - State: closed - Opened by vanBassum over 5 years ago - 4 comments

#15 - Documentation?

Issue - State: closed - Opened by julianullrich99 over 5 years ago - 2 comments

#14 - SQL error: file is not a database.

Issue - State: closed - Opened by aguilard07 almost 6 years ago - 10 comments

#13 - Disk I/O issues on SPIFFS

Issue - State: closed - Opened by txf- about 6 years ago - 3 comments

#12 - How use Vacuum on sqlite3?

Issue - State: closed - Opened by programonauta about 6 years ago - 5 comments

GitHub / siara-cc/esp32_arduino_sqlite3_lib issues and pull requests