What to use on the backend of a mobile app

What would be the best source to building a mobile app for the data base part? I am wanting to use React native, Typescript and possibly AWS for the scalability, But watching theos video I see there are much better alterative. It is going to be a fitness tracker app.

Neto•6/16/23, 1:48 PM

you can check t3-turbo for that

Neto•6/16/23, 1:48 PM

https://github.com/t3-oss/create-t3-turbo

GitHub

GitHub - t3-oss/create-t3-turbo: Clean and simple starter repo usin...

Clean and simple starter repo using the T3 Stack along with Expo React Native - GitHub - t3-oss/create-t3-turbo: Clean and simple starter repo using the T3 Stack along with Expo React Native

NNeto https://github.com/t3-oss/create-t3-turbo

billyhoangOP•6/16/23, 1:49 PM

Is this a pre set up starter ?

Neto•6/16/23, 1:50 PM

a starter repo

Neto•6/16/23, 1:50 PM

t3-like experience for a web/mobile app

NNeto t3-like experience for a web/mobile app

billyhoangOP•6/16/23, 1:50 PM

So it uses React native and typescript

Neto•6/16/23, 1:50 PM

you can remove expo if you want

Neto•6/16/23, 1:51 PM

its more in the monorepo experience

Neto•6/16/23, 1:51 PM

the expo setup is just a nice to have there to check

billyhoangOP•6/16/23, 1:51 PM

Okay thank you. Would you happen to know what would be the best place to store users data and hit prodcedures?

billyhoangOP•6/16/23, 1:53 PM

Aws

Neto•6/16/23, 1:53 PM

planetscale is really amazing for database wise

Neto•6/16/23, 1:53 PM

only issue is procedures

billyhoangOP•6/16/23, 1:54 PM

I thought it was only meant to be web app

billyhoangOP•6/16/23, 1:54 PM

or it does not matter

Neto•6/16/23, 1:54 PM

rds (aws database solution) is not fun to handle, neither is the pricing

billyhoangOP•6/16/23, 1:55 PM

So planetscale is capable of retreiving the users data through some sort of there own command?

Neto•6/16/23, 1:55 PM

planetscale is a sql service

billyhoangOP•6/16/23, 1:55 PM

Thank you for your patience by the way

Neto•6/16/23, 1:55 PM

billyhoangOP•6/16/23, 1:56 PM

Thank you

NNeto dw

billyhoangOP•6/16/23, 1:56 PM

Also could you explain what row reads and row writes per month? Is it the callings to the SQL data base?

Neto•6/16/23, 1:58 PM

https://planetscale.com/docs/concepts/billing#planetscale-charges-on-three-factors

Billing — PlanetScale Documentation

PlanetScale pricing was designed for transparency and scalability.

Neto•6/16/23, 1:58 PM

but basically

Neto•6/16/23, 1:58 PM

Reads: Retrieving or inspecting rows during a query or mutation of any kind to your PlanetScale databases.
Writes: Adding new information or changing existing information in your PlanetScale databases.
Storage: Data saved in the form of tables, columns, rows, and their corresponding relationships.

billyhoangOP•6/16/23, 1:58 PM

Makes sense. Would you say this is more cost saving than Aws

billyhoangOP•6/16/23, 1:58 PM

Short term to long term also

Neto•6/16/23, 1:59 PM

aws pricing is per minute of usage

Neto•6/16/23, 1:59 PM

regardless of that is your usage

Neto•6/16/23, 2:00 PM

planetscale you pay for what you use, if you reach a point of having to pay, still cheaper overall than rds

billyhoangOP•6/16/23, 2:01 PM

Thank you

peternovak•6/19/23, 10:04 AM

@nyx (Rustular DevRel), hope you don't mind one more question on this topic since you seam to know Planetscale well? How does it work with tools like PgAdmin etc, given that the relationships are not stored directly?

Neto•6/19/23, 10:24 AM

Fk relationships are just an side effect for vitess (planetscale) speed and reliability

Neto•6/19/23, 10:24 AM

Seems there are some hits that ps discovered how to keep both sides

peternovak•6/19/23, 11:56 AM

Ok! What do you use (instead of PgAdmin) to run your SQL queries with planetscale?

Neto•6/19/23, 12:01 PM

pgadmin is postgres only

Neto•6/19/23, 12:01 PM

you can check almost any "generic sql client"

Neto•6/19/23, 12:01 PM

like dbeaver, datagrip, etc

Neto•6/19/23, 12:02 PM

planetscale is just a sql service offering

Neto•6/19/23, 12:02 PM

you don't need "special tools" for that