# Basic Tutorial for python-sql

**URL:** <https://discuss.tryton.org/t/basic-tutorial-for-python-sql/3999>\
**Category:** Developer\
**Tags:** python-sql\
**Created:** [April 2, 2021, 5:43pm UTC](https://discuss.tryton.org/t/basic-tutorial-for-python-sql/3999 "2021-04-02T17:43:09Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![suvo](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/s/4bbf92/32.png) [@suvo](https://discuss.tryton.org/u/suvo)\
**Post date:** [April 2, 2021, 5:43pm UTC](https://discuss.tryton.org/t/basic-tutorial-for-python-sql/3999/1 "2021-04-02T17:43:09Z")

</div>

I am startng python-sql today. Where are the basic guides which I ca use? Looking for fool-proof tutorial with example and output

---

<div class="post-metadata">

**Author:** ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)\
**Post date:** [April 2, 2021, 6:13pm UTC](https://discuss.tryton.org/t/basic-tutorial-for-python-sql/3999/2 "2021-04-02T18:13:45Z")

</div>

There are many examples on the homepage: [python-sql · PyPI](https://pypi.org/project/python-sql/)

---

<div class="post-metadata">

**Author:** ![suvo](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/s/4bbf92/32.png) [@suvo](https://discuss.tryton.org/u/suvo)\
**Post date:** [April 3, 2021, 2:46am UTC](https://discuss.tryton.org/t/basic-tutorial-for-python-sql/3999/3 "2021-04-03T02:46:10Z")

</div>

Thanks for the reply.

I M looking for these specific area.

1. How to connect database?

2. How to execute query to get result?

---

<div class="post-metadata">

**Author:** ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)\
**Post date:** [April 3, 2021, 7:36am UTC](https://discuss.tryton.org/t/basic-tutorial-for-python-sql/3999/4 "2021-04-03T07:36:16Z")

</div>

> [@suvo](#):
>
> - How to connect database?
> - How to execute query to get result?

That is not part of python-sql. Check the documentation of the library you use to connect to your database. But python-sql is designed to work with [PEP 249](https://www.python.org/dev/peps/pep-0249/) complying library.

---

<div class="post-metadata">

**Author:** ![suvo](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/s/4bbf92/32.png) [@suvo](https://discuss.tryton.org/u/suvo)\
**Post date:** [April 4, 2021, 9:55am UTC](https://discuss.tryton.org/t/basic-tutorial-for-python-sql/3999/5 "2021-04-04T09:55:53Z")

</div>

Thanks. Any pointer to python-sql + alchemy/psycopg2 documentation?

---

<div class="post-metadata">

**Author:** ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)\
**Post date:** [April 4, 2021, 11:48am UTC](https://discuss.tryton.org/t/basic-tutorial-for-python-sql/3999/6 "2021-04-04T11:48:42Z")

</div>

Well there is mainly no point to use python-sql with SQLAlchemy as they do mainly the same thing.  
For psycopg2 the documentation is good enough: [Psycopg – PostgreSQL database adapter for Python — Psycopg 2.9.10 documentation](https://www.psycopg.org/docs/)  
You just pass the python-sql query to the `cursor.execute` method like this:

```auto
>>> cursor.execute(*table.select())

```