I'm sure this a dim question, but I'm struggling to understand the limitation on connections to your sql database(s). I have an smartphone app that could make hundreds of queries to a db at the same time, but I thought the limit was somewhere in the thousands, so I wasn't worried. However, when I was testing something (and had maybe 6 sql consoles open) when I tried to connect again it said the max number of connections was exceeded. Am I missing something?
I will add a line to close the connection after each query, but is it the case that the max number of remote connections is around 6? or is it just a limit on the sql consoles?
I am using the create.engine function to send raw sql queries from a route if that makes any difference:-
from sqlalchemy import create_engine
engine = create_engine("mysql://paulalsmxxxxxxxxxxxxxxxthonanywhere-services.com/paulalsmith1000$shusic")
with engine.connect() as connection: query = "CREATE TABLE test_table (id INTEGER UNSIGNED AUTO_INCREMENT PRIMARY KEY, member_name varchar(20), push_device_key varchar(150))" result = connection.execute(query)
Sorry, while I'm here, could I ask just one quick general question (to general to answer really, but there we are)?
When I use flask / sqlalchemy to query the database, it all works fine, ie for example the above table is created, but when you test it on Postman it returns an internal server error (to clarify, the webapp is just used to run scripts / query databases, there is no associated website/html.
Sorry for the waffle, but any help would be vvvv much appreciated.