djangoでUniqueViolationの例外エラーを取得する
https://qiita.com/naito_neegi/items/d29bfbcea8cbb71f41bf?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

不正アクセスしてきたホストの国コードを知ってセキュリティ対策に活用する
https://qiita.com/pipito-yukio/items/147f7b2f42ad9fc1dbd0?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

To connect to a database in Python, use a database-specific library such as Pyodbc for Microsoft Access and SQL Server, Psycopg2 for PostgreSQL, mysql-connector-python for MySQL, or sqlite3 for SQLite. You will need to execute a database query to retrieve the data after establishing the connection.

#python #Pyodbc #Psycopg2 #PostgreSQL #mysql-connector-python #MySQL #sqlite3 #SQLite #database #db #sql

Psycopg3 與 Psycopg2 的差異
➤ Psycopg3 與 Psycopg2 的差異及解決方案
✤ https://www.psycopg.org/psycopg3/docs/basic/from_pg2.html
Psycopg3 與 Psycopg2 在使用上有幾個差異，例如伺服器端綁定、同一查詢中多個結果的返回、不同的類型轉換規則等。本文將介紹這些差異以及如何解決相關問題。
+ 很有用的文章，謝謝分享！
+ Psycopg3 真的很好用，但需要注意一些差異，這篇文章很詳細地介紹了這些差異及解決方案。
#Python #PostgreSQL #Psycopg3 #Psycopg2

Are you a #Django developer using a #celery job queue and #psycopg2-binary on #applesilicon ?

I'm deploying to Heroku which requires the binary, hence using it also in development.

Have you moved to psycopg2-binary v2.9.6?

If so, do you also have the problem where the celery worker falls over on the first interaction with the Django ORM? I get it on 2 different computers, but not on Intel.

My problem report: https://github.com/psycopg/psycopg2/issues/1593

Any thoughts on what might be going on?

@felixxm @carlton

Dear #Python community,

what is the recommended library to interact with #PostgreSQL?
I've heard of #psycopg2 and #SQLAlchemy in context of web applications but want to build a desktop app.
Tried #PonyORM with mixed results.

I'd prefer not to go raw #SQL if possible.