SQL and Python 3

Question

Dear Professionals,

I appreciate it if you provide me a best way to pursue my goal. I am a big fans of data science and I want to develop my experience and knowledge on the data analysis tools.

I have learned the SQL and became familiar with most its functions and clauses. Since I am doing my analyses with Python 3, I want to ask you what is the best integration DBMS with Python 3. What about PostgreSQL? Is it could be integrated with Python 3?
Thanks

Answer 1

Not sure of any video tutorials, the documentation is a pretty good place to start and the postgresql wiki has a pretty good rundown.

Answer 2

Postgres can absolutely be used with python, the package you want is called psycopg2. That said if you will be the only one accessing the data SQlite is a good starting point too.

Answer 3

Thanks, Jason. I just checked psycopg2. Do you have a tutorial to start with this package?