Using Python to query Postgres

Показать описание

Blog:

Some quick and easy ways to extract data from Postgres and to import data from a file.

Follow me on Twitter:

pyscopg2 documentation:

Рекомендации по теме

Комментарии

Seriously the best video I've seen on this, sound quality is great, topic depth is perfect, and pace is spot on.

VanFlicke

Thank you for this!! This is exactly what I needed!! Something quick and simple for someone who's not too lazy to learn SQL, rather than the 50 million overblown/bloated "packages" all python devs seem to depend on to interact w/databases. I got more out of this 6 minute video than 1/2 a day of digging through the vaguely written "documentation" for useless things like SqlAlchemy, and Pony ORM... You rock!!

squish

So simple and to the point! Thank you for your video! I love how concise it is.

SerottaPDX

Very helpful. A lot of practical information in a short video. Thanks!

johnflood

I don't understand how you can get r["firstname"], because r is not a dict but a tuple (and the varible rows is a list whose elements are those tuples).

RagHelen

It is 2017 now, we have real ORM to deal with databases in a more pythonic way. SqlAlchemy, Peewee, Pony ORM and Django ORM are the ways to go. Pony ORM offers you the ability to query your connected database with generator expression, which is really cool and truly pythonic ;)

Just saying psycopg2 is also used in these ORMs, at least in sqlalchemy as a low level connection layer, but as user you don't need to deal with it.

Pterryreal

cur.execute('SELECT * FROM table')
cur.fetchone()

I am sure i have no typos but above commands return nothing in python

looploop

Great tutorial but the db = user = 'postgres' password = 'localhost'") gives an error psycopg2.OperationalError: fe_sendauth: no password supplied

bobbymidha

this is very helpful. but how about installing psycopg2 in windows tutorial? need help here. thanks

ivytorremonia

Using Python to query Postgres

Using Python to query Postgres

Connect to PostgreSQL from Python (Using SQL in Python) | Python to PostgreSQL

How to build an ETL pipeline with Python | Data pipeline | Export from SQL Server to PostgreSQL

SQL Databases with Pandas and Python - A Complete Guide

How to connect to Postgres using Python | Query SQL Database | Pandas | Postgres

PostgreSQL (2) Database Connection With Python Using 'Psycopg2' Module

Quick Python Hacks: Fetch Data from PostgreSQL in 60 Seconds! #python #postgresql #database

Step-by-Step Python and Postgres Tutorial with psycopg2

Introduction to Databases and SQL For Data Analytics

Using Python to query a SQL database in less than 60 seconds! #python #datascience #pandas #sql

'How to optimize Postgres queries for Python developers' - Lukas Fittl (Nbpy2024)

Postgres SQL to Python

Postgres pgvector Extension - Vector Database with PostgreSQL / Langchain Integration

I replaced my entire tech stack with Postgres...

SQLAlchemy Turns Python Objects Into Database Entries

5 Best SQL Websites to Practice n Learn Interview Questions for FREE

PostgreSQL vs MySQL

#python #database #postgresql #studying

Connect to PostgreSQL Using SQLAlchemy & Python

Python with PostGres SQL Database - Read and Write data to a relational Database #python #postgres

Python Pandas Tutorial 14: Read Write Data From Database (read_sql, to_sql)

Efficient Database Queries with SQLAlchemy and Postgres in Python | Python Code Nemesis

How to Safely Take WHERE Query Input in Postgres Using Python

Using Postgres Cloud Database With Tkinter - Python Tkinter GUI Tutorial 187