# SQLAlchemy 2.0
[PostgreSQL](/Gkvv3QZlRjGc7t8skrfG3Q)

Installation
---
- `pip3 install sqlalchemy`

> with Python3

Use it!
---
- import: `import sqlalchemy as db`
- version: `sqlalchemy.__version__`
- Sample:

    import sqlalchemy as db
    
    engine = db.create_engine('sqlite:///census.sqlite')
    connection = engine.connect()
    metadata = db.MetaData()
    census = db.Table('census', metadata, autoload=True, autoload_with=engine)

- Store to SQL: `data.to_sql('tableName',engine)`
- Read SQL: `pd.read_sql(sql, con)`
- `pandas.read_sql(sql, con, index_col=None, coerce_float=True, params=None, parse_dates=None, columns=None, chunksize=None)`
-`https://pandas.pydata.org/docs/reference/api/pandas.read_sql.html
- Read SQL Table: `pd.read_sql_table(table_name, con)`
- `pandas.read_sql_table(table_name, con, schema=None, index_col=None, coerce_float=True, parse_dates=None, columns=None, chunksize=None)`