Any Database connect (odbc like) ?

Renato
Posts: 1
Joined: Sat May 27, 2017 6:45 pm

Any Database connect (odbc like) ?

Postby Renato » Sat May 27, 2017 6:49 pm

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

User avatar
kolban
Posts: 1683
Joined: Mon Nov 16, 2015 4:43 pm
Location: Texas, USA

Re: Any Database connect (odbc like) ?

Postby kolban » Mon May 29, 2017 6:30 pm

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

User avatar
rudi ;-)
Posts: 1698
Joined: Fri Nov 13, 2015 3:25 pm

Re: Any Database connect (odbc like) ?

Postby rudi ;-) » Mon May 29, 2017 8:50 pm

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 ;-)
-------------------------------------
love it, change it or leave it.
-------------------------------------
問候飛出去的朋友遍全球魯迪

kurtzweber
Posts: 64
Joined: Tue Jan 10, 2017 1:09 pm

Re: Any Database connect (odbc like) ?

Postby kurtzweber » Tue May 30, 2017 8:10 am

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

Who is online

Users browsing this forum: Bing [Bot] and 107 guests