Using PlanetScale for production

Wappler General
1

Hi

My first time posting here on the Wappler community!

As an complete Wappler NEWBY, I need some advise…

We (our dev team) are planning the tech stack for an upcoming project and are keen on Wappler since we need to build a complex website that also needs to be 100% responsive and later possibly be deployed as a PWA or mobile app.

It seems to be a good fit. But the site is data intensive and we are very interested in using PlanetScale as the production MySQL database server. Its performance is excellent and caters well for our needs.

But I am not sure if the platform will play well with Wappler.

Does anyone perhaps have some experience with it or have some insights as to whether this is a viable route?

Any feedback will be greatly appreciated!

Ragards

2

First time I hear about it but it looks nice. I bookmarked it for reference.

For production I usually resort to PostgreSQL but if you really need to use MySQL it seems like a good option to ensure scalability.

If you are going with node as server model you need to know that Wappler uses knex to manage database connections. So you might want to ask in their github.

3

Hi JonL

Many thanks for the reply. Mentioning PostgreSQL, do you have any hosting recommendations?

I’ll look into the knex database management done by Wappler to see if that will work with PlanetScape.

4

I like Heroku(for managed DB) because they only offer PG as a DB for their clients. They are probably managing the biggest PG infrastructure in the world. I am assuming they know a thing or two about it :slight_smile:

I don’t use Heroku’s Computing Cloud though as it’s too expensive. But their PG offer is quite competitive plus you get all their experience on managing it.

5

Many thanks!

Makes a lot of sense.

Will use that as an option if running into issues with PlanetScape.

1 Like
6

If you’re interested in comparisons to PlanetScale but for Postgres, look at:

  • CitusDB
  • YugabyteDB
  • instaclustr
7

Many thanks for the info!

I didn't know about these providers, but they certainly provide a good alternative for the PostgreSQL route.

8

Hey @cloudrendr! Welcome to community!

I never heard of PlanetScale, neither the engine under it (Vitess). Tried to search for Knex for it and came to this:

I don’t think Wappler will support it out of the box, only a guess.

9

Hi @jrvidotti

Many thanks for the insights! Really helpful. It looks like it is going to be an Wappler/PlanetScale is going to be an issue out of the box.

Will perhaps take it up with the team at PlanetScale.

The db offering is very attractive for many reasons. Combined with the dev power of Wappler, apps can have can seriously benefit from the scalability of such a database platform in my opinion.

Once again, thanks for the input!

10

Very interesting. Database in the cloud offerings seems to be arising these days. Which is very good as it offers more development freedom.

As for PlanetScale it seems to be MySQL8 based so you should be able to connect with Wappler by just choosing MySQL8 as database connection type.

1 Like
11

Hi @George

Thanks for the response I’m going to give it a go as the offering seems great.

Will give some feedback on my experience.

2 Likes