CODEWITHSUNDEEP
pythondatabasesqlalchemyflask-sqlalchemy
Pushpak Ruhil
Pushpak Ruhil

Reputation: 176

what are pool and dialect in SQLAlchemy

A simple question, as stated in the title.

General structure of connection that happens in SQLAlchemy

This is the general structure of how a connection is established in the SQLAlchemy.

But I don't understand what is this Pool and Dialect. Could anyone help me with a simple explanation of it?

(I am new to learning SQLAlchemy, but I know DBMS)

Upvotes: 1

Views: 826

Answers (1)

Syed zeeshan haider
Syed zeeshan haider

Reputation: 56

  1. Pool:

    simply means collection of active database connection objects. Instead of creating new connections objects that is costly operation, we mostly reuse already created connection objects in pool, to send queries to database.

  2. Dialect:

    Actually Sqlalchemy makes it possible for your code to communicate with multiple databases (like Postgres,Mysql,MS,Oracal etc.).Dialect is like a personal secretary to Sqlalchemy that makes Sqlalchemy aware of specific database it has to communicate with.

Upvotes: 4

Related Questions