Search
66 results for “psycopg”
-
We're heading to Vancouver! 🇨🇦
Our maintainer Daniele Varrazzo will be speaking at @pgconfdev next week, giving a talk on libpq - the PostgreSQL client library at the heart of Psycopg - and how we can help clients get even more out of PostgreSQL
If you're attending, don't miss it. And if you're around, come say hello! 👋
#pgconfdev #PostgreSQL #Python #Psycopg #libpq #OpenSource #DatabaseEngineering #PythonDeveloper #PostgreSQLCommunity #DevConference
-
We’re happy to share that Daniele Varrazzo, maintainer of psycopg, will be attending @fosdempgday this Friday and @fosdem on the weekend.
If you’re around, feel free to come say hi and ask him any questions you may have about Psycopg, PostgreSQL or Python database drivers. Drop us a message here if you wish.
See you soon! 👋
Photo from PyCon Italia 2022
#FOSDEM #PostgreSQL #Python #psycopg #OpenSource #fosdempgday
-
@psycopg I am honored to have participated in the resolution of issue #999 :)
https://github.com/psycopg/psycopg/issues/999
#Django #Psycopg #PostgreSQL #Memcached #PyLibMC #Python #Cache
-
Psycopg 3.2 has been released 🚀
https://www.psycopg.org/articles/2024/06/30/psycopg-32-released/I can't wait to test it with Django 5.1b1 😬
#PsycoPG #Python #PostgreSQL #Postgres #Django #ORM
CC @psycopg
-
How does #Psycopg benefit from #PostgreSQL 17?
Read the last article of @dlax to find out => https://dali.bo/202404_psycopg3-2 -
Yesterday, on Django 4.2, we bumped #psycopg from v2 to the v3 but suffered an increase in locks & connection waiting during some periods of heavy work on the same hardware (Heroku pg with server-side pgBouncer).
Operational reasons (shipping!) stop us investigating this in more depth right now but thought this warning may be of help to someone.
-
@djangochat @carlton @wsvincent Continuing to talk about Django and PostgreSQL, a Django Chat episode on the recent merge of the Psycopg 3.1+ backend with @felixxm , @apollo13 and @psycopg would be interesting. 🎙️
As an anticipation we had a great keynote from Daniele Varrazzo at PyCon Italia 2022 @pycon 🇮🇹
https://youtu.be/w41jxB37n8M#psycopg #psycopg3 #django #djangochat #python #postgresql #orm
-
RT @psycopg
Psycopg 3.1.5 released. A few bug fixes and *big* speedup improvements: networking, namedtuples, arrays...
Try it out now! 😄🚀
https://github.com/psycopg/psycopg/blob/master/docs/news.rst#psycopg-315
-
@Crocmagnon @psycopg has a lot of new features, you can read about them directly in its website 👇
https://www.psycopg.org/ -
#psycopg est un connecteur #Python à un serveur #PostgreSQL. L'un de nos développeurs, Denis, vous parle plus spécifiquement des #rowFactories => https://dali.bo/202206_psycopg
-
A small donation to the author of #psycopg today. 🎉 #PostgreSQL #Python #xp
-
Any #python #psycopg people know why this works
```
#results = conn.execute('SELECT (embedding <=> %s) as distance, abstract FROM documents ORDER BY embedding <=> %s LIMIT 5', (query_embedding, query_embedding, )).fetchall()
```But this throws an error
```
results = conn.execute(f'SELECT (embedding <=> {query_embedding}) as distance, abstract FROM documents ORDER BY embedding <=> {query_embedding} LIMIT 5').fetchall()
```error in the thread
-
#Tryton has been updated to #psycopg 3 using server-side binding https://foss.heptapod.net/tryton/tryton/-/merge_requests/2408
-
AWS CloudShell内のpsqlとPython(Psycopg)からAurora DSQLに接続してみた
https://dev.classmethod.jp/articles/connect-aurora-dsql-from-aws-cli-and-python-psycopg-on-aws-cloudshell/#dev_classmethod #Amazon_Aurora_DSQL #AWS_CloudShell #AWS_CLI #Python #uv #PostgreSQL
-
AWS CloudShell内のpsqlとPython(Psycopg)からAurora DSQLに接続してみた
https://dev.classmethod.jp/articles/connect-aurora-dsql-from-aws-cli-and-python-psycopg-on-aws-cloudshell/#dev_classmethod #Amazon_Aurora_DSQL #AWS_CloudShell #AWS_CLI #Python #uv #PostgreSQL
-
AWS CloudShell内のpsqlとPython(Psycopg)からAurora DSQLに接続してみた
https://dev.classmethod.jp/articles/connect-aurora-dsql-from-aws-cli-and-python-psycopg-on-aws-cloudshell/#dev_classmethod #Amazon_Aurora_DSQL #AWS_CloudShell #AWS_CLI #Python #uv #PostgreSQL
-
AWS CloudShell内のpsqlとPython(Psycopg)からAurora DSQLに接続してみた
https://dev.classmethod.jp/articles/connect-aurora-dsql-from-aws-cli-and-python-psycopg-on-aws-cloudshell/#dev_classmethod #Amazon_Aurora_DSQL #AWS_CloudShell #AWS_CLI #Python #uv #PostgreSQL
-
AWS CloudShell内のpsqlとPython(Psycopg)からAurora DSQLに接続してみた
https://dev.classmethod.jp/articles/connect-aurora-dsql-from-aws-cli-and-python-psycopg-on-aws-cloudshell/#dev_classmethod #Amazon_Aurora_DSQL #AWS_CloudShell #AWS_CLI #Python #uv #PostgreSQL
-
This morning @felixxm merged the branch for @psycopg 3 support in Django 🎉
I opened the related issue 13 months ago and since then many developers have worked on the PR based on the work of Daniele Varrazzo 👏
I thank everyone who made this achievement possible starting from @apollo13 to @felixxm but also Simon Charette, Tim Graham, @adamchainz, @carlton and @davidsmith 🙏
I'm sure that both Django and Psycopg will benefit from this success ✨
-
Möp:
```sql
-- works, true
select 1 :: smallint = 1 :: bigint;
-- does not work
select 1 :: smallint <@ int8range(1,2);
-- ERROR: operator does not exist: smallint <@ int8range
```Guess what psycopg passes in when giving it a python int param...
-
Sans contribution, pas d'#openSource ! Nous avons choisi de vous parler de #psycopg et de son mainteneur Daniele, libriste convaincu et contributeur à #PostgreSQL. Et de comment nous avons décidé collectivement de soutenir son projet => https://dali.bo/202106_psycopg
-
Hah, got uv to build psycopg2. For some reason it didn't check for all needed libraries and headers, but instead just failed.
So now my environment and uv.lock contains the newest versions of my dependencies. I assume I have to manually copy the new minimum versions from uv.lock to pyproject.toml, as nothing I've found seems to update the versions in that file.
This is all quite complex, but I assume there's some deeper reason that I'm just too dumb to grok.
-
[Перевод] Самый быстрый способ загрузить 32 000 строк в PostgreSQL с помощью Python
Команда Python for Devs подготовила перевод статьи о том, как найти самый быстрый способ загрузки данных в PostgreSQL с помощью Python. Автор пошагово сравнил разные методы — от построчных вставок до COPY с потоковой генерацией CSV — и показал, как ускорить процесс более чем в 250 раз при нулевом потреблении памяти.
https://habr.com/ru/articles/948854/
#postgresql #python #psycopg #загрузка_данных #импорт_данных #csv #copy #execute_batch #execute_values #оптимизация_производительности
-
Estic reprogramant de dalt a baix el codi del servidor #appy per a que faci servir #asyncpg enlloc de psycopg2.
Amb psycopg2 hi tinc un coll d'ampolla perquè tota la gestió de la base de dades és síncrona. asyncpg és asincrona, com diu el seu nom, i farà que appy sigui molt ràpid. En els gràfics asyncpg és a la dreta de tot. -
Dziś trafiłem na kolejny błąd, wynikający z tego, że `ctypes.util.find_library("c")` nie działa na systemach z #musl libc. Problem zgłoszono do CPythona w połowie roku 2014, i do dziś go nie poprawiono (choć przyznaję, że łatka jest ciut skomplikowana). Moje obejście tego problemu polega na wykorzystaniu `libc.so`, kiedy funkcja nic nie zwraca, np. poprzez:
```
ctypes.util.find_library("c") or "libc.so"
```https://github.com/python/cpython/issues/65821
https://github.com/psycopg/psycopg/pull/725
https://bugs.gentoo.org/923003 -
Parlons d'amour, avec Daniele qui nous expliquera la relation entre #Python et #PostgreSQL ! 😍
RDV le 17/11 à Paris, inscrivez-vous avant le 9 novembre => https://dali.bo/pgsession14_conferences_inscription
#conférence #opensource #psycopg #SGBD #chabalabala -
Be specific. Instead of “We use a database,” write “PostgreSQL 15 with pgvector extension, hosted on Google Cloud SQL, connection via psycopg2.”
https://shellypalmer.com/2026/01/how-to-install-claude-code/
-
Be specific. Instead of “We use a database,” write “PostgreSQL 15 with pgvector extension, hosted on Google Cloud SQL, connection via psycopg2.”
https://shellypalmer.com/2026/01/how-to-install-claude-code/