Heroku - Managed Database target - creating schema?

1

wappler 3.7.3
microsoft windows 10
nodejs
mysql backend
Heroku - cleardb Managed mysql db - community edition with predefined 1 schema (cant add schemas or change name)
local mysql - with schema, static data and early test data

Can wappler create the copy of the local mysql schema to Heroku cleardb?

Not sure if i need to use mysql workbench? the challenge there has been that the heroku/cleardb schema is a fixed name and is different to the schema i created on the local mysql and the migration wizard fails. I can do it by exporting each table from the local mysql version and importing the table into Heroku/cleardb but i have 55 tables and i want to fully utilise wappler and avoid manual steps … seems like it should be able to be done but i’m struggling to see how to do it?
thanks

2

Hi Teodor, would appreciate your thoughts? I’m not sure if
a) Wappler will create the tables in the target databases and make sure the schemas are consistent across all targets? or
b) Wappler doesnt do this and relies on the user to setup the schemas on each target
c) whether the observation that my schema is called enien on my local mysql and the development and production targets are heroku cleardb with a database name of Heroku… which cant be changed.
thanks

3

Database Manager will migrate your schema changes to any target.

I have a project in Heroku and 0 problems with the database. Although I use Heroku PG and not cleardb addon.

It should be the same though.

4

Thanks, is your schema/database name the same on each target?

(on cleardb the database name is fixed for shared db - and so i think??? wappler might be trying to create tne new tables in the source database name/schema and cleardb says No… but I’m just guessing and trying to figure it out)

5

Heroku fixes the postgresql database name to a string of random chars and the schema name is always “public”.

Unfortunately I don’t know how cleardb handles that.

6

Thanks I’m using mysql basic functions - and see you can convert to postgreSQL - you havent by any chance tried this ???

Maybe i should switch to all inhouse heroku solution

7

Let me open again pandora’s box.

PostgreSQL is a far superior database than Mysql.

Don’t tell anyone I told you :joy:

Heroku has a pretty cheap managed postgresql option starting at 0€
I think it’s the best choice when using Heroku.

8

:grinning: thanks for your thoughts … will give it a go

1 Like
9

If at some point you need to scale your app make sure you read this and consider adding his load balancer.

Heroku is not cheap when you need to scale.

10

Thanks