Discussion on "Connect Your Django Projects to PlanetScale Databases"

Sadra Yahyapour · 2022-08-13T14:01:54.024Z

TL;DR PlanetScale is a MySQL-compatible serverless database platform. Since its database service is a bit different from the actual MySQL, there are some limitations that you can't ignore and must resolve to be able to work with their services. This ...

Hi Sadra Yahyapour,

Thanks for writing this guide how to get started with PlanetScale and Python!

One quick comment on this part:

Since the MySQL engine uses utf8bm3 charset and it’s not supported by PlanetScale’s engine yet, you may need to add {'charset': 'utf8bm4'} to OPTIONS in order to migrate your changes with no problem.

PlanetScale supports the utf8, utf8mb4 and utf8mb3 character sets. Though, per the MySQL documentation utf8mb3 is deprecated and utf8mb4 should be used instead. The alias (or reference) utf8 still points to utf8mb3, but it's expected to change to utf8mb4 with a future release.

Hi Mike, thank you so much for mentioning that miss-understanding. That's so true. I'll update both the package README and this blog post as well. I just need some time. Hope this utility helps developers use PlanetScale in a simpler way.

Great idea Sadra! Thank you for this one, I've tested your engine, and it works perfectly fine.

One quick note here: Planet scale uses os module to read .env file data, I recommend using python-decouple for that (os module fails at importing the settings).

You're welcome. It's kinda personal-preference.

Search Hashnode

Connect Your Django Projects to PlanetScale Databases

Responses2