ESP32 Forum

Is there some ESP32 available API, similar to Windows ODBC, to access any databases ?
Tks

You can use a REST API to access some no-sql databases. I use REST requests to access CouchDB in some of my projects.

Renato wrote:Is there some ESP32 available API, similar to Windows ODBC, to access any databases ?
Tks

this question sound is not full clear to me - and can have many possible answers.

so first:
where is the database
- on esp32
--> SD Card
--> wear leveling / SPI Flash

-on a local PC HOST

-on Internet Host

who is the client?
-> ESP32
-> PC

you plan a database on an esp32?
you plan a client on an esp32?

which way you want go connect? ( WIFI, LAN, Uart..)
which protocol you want use? (HTTP(S), ...)

..

best wishes
rudi

Renato wrote:Is there some ESP32 available API, similar to Windows ODBC, to access any databases ?
Tks

Hi Renato

ODBC is an interface that allows a programmer to connect to a DBMS without learning its specific protocol. It works because of the DBMS vendor provides a client "driver" that implements the protocol.

What you probably want for esp32 is a library that can "talk" to a specific DBMS... from my experience it's easier to implement something in the middle (for example a php page), running on the same server/machine that also runs your DB:

esp32 ---(http/https)--> PHP ---(specific protocol)--> MySQL