Menu
This is related to running Craig Walls Spring Social Showcase on Heroku. This application runs fine locally using an H2 in memory database. When I deploy to Heroku, however, the database no longer works. Is there something else that needs to be configured on the Heroku server to get the in memory database to run?
475
Applications on Heroku can use a variety of relational database services including the Postgres database offered by Heroku. Databases are provisioned using the add-on system. Some applications will have a small, free postgres database provisioned by default. You can check this by running
When you map objects, Heroku Connect will create or update the database tables used to store data for the mapped object. Mapping tables use a lowercase version of the Salesforce object name, for example the Account Salesforce object is mapped to the account database table.
Before you get deploy your application to Heroku, you'll need to enable the JawsDB Add-On. JawsDB Add-On is a Heroku add-on that provides a fully functional MySQL database server for use with your Heroku application.
“Heroku Postgres allows us to manage some of our most complex data use cases at scale, including partitioning large tables and parallelizing advanced queries. This allowed our developers to stay focused on working with the data instead of building the infrastructure to support it.” Scott Meves Chief Technology Officer, Quikly
To my knowledge there is no H2 support on the Heroku server. So you can't use H2 as an in memory database.
You can get a list of supported databases here
I would recommend you to use Postgres as a database. This is a good starting point.
196
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
