How to set connection timeout in SQLAlchemy

by

The right way is this one (connect_timeout instead of connection_timeout):

create_engine(db_url, connect_args={'connect_timeout': 10})

…and it works with both Postgres and MySQL

docs sqlalchemy connect-args

ps: (the timeout is defined in seconds)

More Related Contents:

  1. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  2. psycopg2: insert multiple rows with one query
  3. How to write DataFrame to postgres table
  4. Parameterized queries with psycopg2 / Python DB-API and PostgreSQL
  5. Passing table name as a parameter in psycopg2
  6. CS50: LIKE operator, variable substitution with % expansion
  7. DatabaseError: current transaction is aborted, commands ignored until end of transaction block?
  8. Executing multiple statements with Postgresql via SQLAlchemy does not persist changes
  9. error installing psycopg2, library not found for -lssl
  10. How to create an SQL View with SQLAlchemy?
  11. How to set up a PostgreSQL database in Django
  12. How can I use psycopg2.extras in sqlalchemy?
  13. Updates to JSON field don’t persist to DB
  14. psycopg2.OperationalError: FATAL: unsupported frontend protocol 1234.5679: server supports 2.0 to 3.0
  15. Psycopg2 image not found
  16. How to upsert pandas DataFrame to PostgreSQL table?
  17. SQLAlchemy multiple foreign keys in one mapped class to the same primary key
  18. Create a Postgres database using python
  19. SQLAlchemy – performing a bulk upsert (if exists, update, else insert) in postgresql
  20. Strange SQLAlchemy error message: TypeError: ‘dict’ object does not support indexing
  21. Creating partial unique index with sqlalchemy on Postgres
  22. SQLAlchemy func.count on boolean column
  23. Python/postgres/psycopg2: getting ID of row just inserted
  24. Escape SQL “LIKE” value for Postgres with psycopg2
  25. SQLAlchemy: filtering on values stored in nested list of the JSONB field
  26. How to prevent UUID primary key for new SQLAlchemy objects being created with the same value
  27. Mac + virtualenv + pip + postgresql = Error: pg_config executable not found
  28. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip
  29. Use binary COPY table FROM with psycopg2
  30. How Postgresql COPY TO STDIN With CSV do on conflic do update?

Leave a Comment