Qiita - 人気の記事djangoでUniqueViolationの例外エラーを取得する
https://qiita.com/naito_neegi/items/d29bfbcea8cbb71f41bf?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items
Wolf@veronica #sqlalchemy has been nothing but trouble in our team. Lazy loading makes you have more transactions that last longer and also leads to the n+1 query problem. And I hate the query constructor to me it’s harder to understand than plain old SQL. We’re stripping it off to get back down to the #psycopg2 layer.
@scy no it doesn’t help with migrations, so it probably doesn’t solve your problem. I knew that when I responded. I should have said more, especially that. The reason I answered, and the reason I answered with this is that we were on #sqlalchemy and it’s done nothing but get in the way. #psycopg2 was underneath and now we’re using that and life is much better. So that’s what I *prefer* though I’m sorry it’s not what you need.
不正アクセスしてきたホストの国コードを知ってセキュリティ対策に活用する
https://qiita.com/pipito-yukio/items/147f7b2f42ad9fc1dbd0?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items
TOVTo 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
GripNews🌗 Psycopg3 與 Psycopg2 的差異
➤ Psycopg3 與 Psycopg2 的差異及解決方案
✤ https://www.psycopg.org/psycopg3/docs/basic/from_pg2.html
Psycopg3 與 Psycopg2 在使用上有幾個差異，例如伺服器端綁定、同一查詢中多個結果的返回、不同的類型轉換規則等。本文將介紹這些差異以及如何解決相關問題。
+ 很有用的文章，謝謝分享！
+ Psycopg3 真的很好用，但需要注意一些差異，這篇文章很詳細地介紹了這些差異及解決方案。
#Python #PostgreSQL #Psycopg3 #Psycopg2
➤ Psycopg3 與 Psycopg2 的差異及解決方案
✤ https://www.psycopg.org/psycopg3/docs/basic/from_pg2.html
Psycopg3 與 Psycopg2 在使用上有幾個差異，例如伺服器端綁定、同一查詢中多個結果的返回、不同的類型轉換規則等。本文將介紹這些差異以及如何解決相關問題。
+ 很有用的文章，謝謝分享！
+ Psycopg3 真的很好用，但需要注意一些差異，這篇文章很詳細地介紹了這些差異及解決方案。
#Python #PostgreSQL #Psycopg3 #Psycopg2
Ryuno-KiDear #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.
うおかわ(on manaita)#python #psycopg2
psycopg2 インストールエラー - Qiita https://qiita.com/b2bmakers/items/d1b0db5966ac145b0e29
> sudo apt install libpq-dev
これでいけた