Is there some ESP32 available API, similar to Windows ODBC, to access any databases ?
Tks
Any Database connect (odbc like) ?
Re: Any Database connect (odbc like) ?
You can use a REST API to access some no-sql databases. I use REST requests to access CouchDB in some of my projects.
Free book on ESP32 available here: https://leanpub.com/kolban-ESP32
Re: Any Database connect (odbc like) ?
this question sound is not full clear to me - and can have many possible answers.Renato wrote:Is there some ESP32 available API, similar to Windows ODBC, to access any databases ?
Tks
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
-------------------------------------
love it, change it or leave it.
-------------------------------------
問候飛出去的朋友遍全球魯迪
love it, change it or leave it.
-------------------------------------
問候飛出去的朋友遍全球魯迪
-
- Posts: 64
- Joined: Tue Jan 10, 2017 1:09 pm
Re: Any Database connect (odbc like) ?
Hi RenatoRenato wrote:Is there some ESP32 available API, similar to Windows ODBC, to access any databases ?
Tks
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
Who is online
Users browsing this forum: No registered users and 56 guests