Discover and read the best of Twitter Threads about #psycopg3

Most recents (1)

Gave the #psycopg3 connection pool to #PostgreSQL an initial test run...

Spoiler: Loving it! Thank you @psycopg!!

A thread. 1/?

Created a Flask app to use pgbench tables/queries for easy setup/scaling.

Currently 2 routes: account balance and update balance. Update intentionally uses 1 transaction/query to amplify the effect of many short connections (not a real bank app!)

github.com/rustprooflabs/…

2/?
db.py was pulled/updated from another project to use psycopg3. Seems to be drop-in replacement! 👍

db_pool.py is reworked version to use conn pool instead of creating/destroying connections per query. The docs were helpful: psycopg.org/psycopg3/docs/…

3/?
Read 16 tweets

Related hashtags

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3.00/month or $30.00/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal Become our Patreon

Thank you for your support!