Stack Overflow
Stack Overflow

Questions tagged [cleardb]

ClearDB is a reliable, fault tolerant database-as-a-service for MySQL. It is also a heroku addon for mysql databases

ClearDB is a heroku addon for managing databases.

More info here: https://devcenter.heroku.com/articles/cleardb

247 questions
0
votes
0 answers

Cannot display data from ClearDB MySQL through Flask in React

I am using Heroku's add-on ClearDB MySQL to manage database, Python Flask for backend, and React for frontend. I successfully setup the database through MySQL Workbench and connected it to the backend like that: cnx = mysql.connector.connect( host…
AMR
  • 1
  • 2
0
votes
1 answer

Connect to Heroku ClearDB with SpringBoot

I am new to Heroku and I am trying to deploy my spring-boot application which is connecting to a MySQL database, since Heroku does not support native MySQL, I looked for an alternative in the internet for MySQL and I found ClearDB, so I created it…
سجاد أحمد
  • 41
  • 3
0
votes
1 answer

Spring Boot + ClearDB mySQL App deploy Heroku problem

I tried to deploy the application on Heroku, but after connecting ClearDB mySQL I get an error 500. heroku logs: 2022-01-18 18:09:20.331 ERROR 4 --- [io-57013-exec-3] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet…
Aleksandr Kasyuk
  • 1
  • 2
0
votes
0 answers

How to solve clearDb creation issue in heroku

I am new to Heroku ,I want to deploy my springBoot mysql application on heroku ,But when I try to create clearDb using heroku command it will throw an error. I want to deploy my application free on heroku. Below type of issue I found when use the…
JUMBOTURN
  • 69
  • 1
  • 2
  • 11
0
votes
1 answer

How can I resolve a collation error in my DB migration?

I am trying to migrate my db from localhost onto cleardb. Upon importing my db onto cleardb I am getting the error Unknown collation: 'utf8mb4_0900_ai_ci'. I have no idea what a collation is, nor can I find anything online about what collation's…
Sharan Balani
  • 143
  • 1
  • 9
0
votes
0 answers

Why does it keep disconnecting from the database?

So I've uploaded my tutorial website which I made using python flask and mysql onto Heroku. I'm using clear db to connect to the mysql database. But it doesn't always work and gives me this error: 2021-07-09T09:54:07.008053+00:00 app[web.1]:…
cherlloydfan
  • 1
  • 3
0
votes
2 answers

Update React Native page when there is a change in ClearDB database

I am working on this QR code based application which is using a ClearDB MySQL database that is stored on Heroku servers. The frontend communicates with the database by using a REST API built with Node.js and Express Whenever a user scans a QR code,…
astanphaeus
  • 13
  • 2
0
votes
1 answer

How to deploy Angular-Flask-MySQL Project on Heroku which Stored in Github repo

I am currently working on a project that uses Angular as frontend framework, Flask as backend framework and MySQL as database. Furthermore, the developement of the application is completed and the source code is stored in private Github repo. My…
Naveen Fernando
  • 142
  • 7
0
votes
1 answer

Heroku - environment variable for Srping Boot DB connect

I have an app on Spring Boot that running in two environments, local and heroku: Local - connect to DB is configured by app.properties. Heroku - app is working w\o app.properties, using one environment variable: heroku config -a…
PolyMorph
  • 83
  • 2
  • 7
0
votes
1 answer

Cannot find module "mysql" while running on heroku

I have been trying to deploy my app on heroku. I first used the command git push heroku master and then running the node server using heroku run node server.js However I get this error. Can anyone help me with this? enter image description here
Jeel Sukhadiya
  • 1
  • 1
0
votes
1 answer

Difference between where and like in CLEARDB

I'm trying a simple nodejs login system and want to use the following query: "SELECT * FROM admin_cred WHERE username = '?' AND password = '?'", [username], [password] But it simply doesn't return anything so I had to do it like this: 'SELECT *…
user14709104
0
votes
0 answers

heroku symfony clearDB Mysql

so I just deployed my symfony application on heroku + ClearDB Mysql and I have a problem with my images. Once the application is deployed I go to the back office via easyAdmin, and I fill in some "products with images" information, everything works…
Le Berre
  • 1
  • 1
0
votes
1 answer

How can I connect Heroku ClearDB to MySQL Workbench?

The clearDB 'How to Connect' page just says "You can connect with MySQL Workbench". When I open MySQL Workbench and connect I need the following: Connection Method Port Host Name Username Password I assume my username and password is the Heroku…
JeremyRenner2
  • 61
  • 6
0
votes
1 answer

I can't connect to clearDB laravel heroku

I'm trying to connect to clearDB in database.php file, I did this $databaseUrl = parse_url(getenv("CLEARDB_DATABASE_URL")); 'url' => $databaseUrl, 'host' => $databaseUrl['host'], 'port' => $databaseUrl['port'], …
mrwho
  • 67
  • 8
0
votes
1 answer

SQL server loses connection after one minutre

I am using Heroku and a Clear DB for a python script I made. The script seems to work if after the bot is deployed in Discord, it will collect the information of a user and reply back to them after it collects a certain number of entries. However,…
Chase Sariaslani
  • 75
  • 1
  • 6
1 2 3
…
16 17