Network database client

General discussions and questions abound development of code with MicroPython that is not hardware specific.
Target audience: MicroPython Users.
Post Reply
User avatar
rdagger
Posts: 143
Joined: Tue Feb 28, 2017 6:16 pm
Contact:

Network database client

Post by rdagger » Tue Jun 19, 2018 11:34 pm

Can anyone recommend a good MicroPython database client? I'd like to run queries on an ESP32 over the network against databases such as MySQL running on different machines.

SpotlightKid
Posts: 463
Joined: Wed Apr 08, 2015 5:19 am

Re: Network database client

Post by SpotlightKid » Thu Jul 19, 2018 3:29 pm

I wrote a very minimal Redis client: https://github.com/SpotlightKid/picoredis

There's also a more fully featured upy Redis client, though using of course comes at the cost of higher memory usage; https://github.com/dwighthubbard/micropython-redis

There's also a micropython MySQL client, but the author describes it as "hacky" and people have reported problems using it here, so I don't know if it really works: viewtopic.php?f=15&t=3552&p=20645

User avatar
rdagger
Posts: 143
Joined: Tue Feb 28, 2017 6:16 pm
Contact:

Re: Network database client

Post by rdagger » Fri Jul 20, 2018 4:06 pm

Thanks I will take a look at your client.

I already tried the MySQL client and was able to get it working with some effort.

There is also a MongoDB client. It is functional for CPython but has some limitations for MicroPython such as authentication due to missing implementations in the Hashlib library.

Post Reply