https://stackoverflow.com/questions/79407535/pandas-dataframe-to-sql-randomly-and-silently-failes-without-error-message
#python #pandas #postgresql #sqlalchemy #psycopg3
Event Attributes
Psycopg3 與 Psycopg2 的差異
➤ Psycopg3 與 Psycopg2 的差異及解決方案
✤ https://www.psycopg.org/psycopg3/docs/basic/from_pg2.html
Psycopg3 與 Psycopg2 在使用上有幾個差異,例如伺服器端綁定、同一查詢中多個結果的返回、不同的類型轉換規則等。本文將介紹這些差異以及如何解決相關問題。
+ 很有用的文章,謝謝分享!
+ Psycopg3 真的很好用,但需要注意一些差異,這篇文章很詳細地介紹了這些差異及解決方案。
#Python #PostgreSQL #Psycopg3 #Psycopg2
I've completed my basic migration to #psycopg3 for my projects that don't use ORMs. It's all gone very smoothly and in fact with first class support for UUIDs I have actually been removing code and complexity.
What is interesting now is that the new Row Factory functionality means that much of the reason I used the ORMs so simplify query coding may have gone away. I think I can do much of what I need with the base library.
@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
#Django has gained support for #psycopg3
https://twitter.com/pauloxnet/status/1603483569808363521
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
Django 4.2 supports Psycopg 3
Thanks to Daniele Varrazzo, @apollo13 and Simon Charette for their humongous work
@Crocmagnon @psycopg has a lot of new features, you can read about them directly in its website
https://www.psycopg.org/