going through my server & shutting down a few services I stopped using to reduce a bit of server strain
also need to work on the mongodb situation on a few services
- Akabot is being rewritten using sqlalchemy with support for more than just Postgres
- a few other Discord bots I just shut down […]
also need to work on the mongodb situation on a few services
- Akabot is being rewritten using sqlalchemy with support for more than just Postgres
- a few other Discord bots I just shut down […]
Original post on fedi.lunya.pet
fedi.lunya.pet
October 18, 2025 at 8:55 PM
going through my server & shutting down a few services I stopped using to reduce a bit of server strain
also need to work on the mongodb situation on a few services
- Akabot is being rewritten using sqlalchemy with support for more than just Postgres
- a few other Discord bots I just shut down […]
also need to work on the mongodb situation on a few services
- Akabot is being rewritten using sqlalchemy with support for more than just Postgres
- a few other Discord bots I just shut down […]
Also, I was using logfire just for a few minutes and instantly catched two N+1 SQL queries (it was my first time using SQLAlchemy, so got some lessons from that). It is just great when you do a simpler thing, and get a way better experience.
October 16, 2025 at 7:35 AM
Also, I was using logfire just for a few minutes and instantly catched two N+1 SQL queries (it was my first time using SQLAlchemy, so got some lessons from that). It is just great when you do a simpler thing, and get a way better experience.
TIL about banned import rules for ruff. You can use them to make sure that nobody uses a specific submodule.
TIAL that there's a SQLAlchemy use-case for it!
koaning.io/posts/ruff-...
TIAL that there's a SQLAlchemy use-case for it!
koaning.io/posts/ruff-...
ruff banned imports
I was thinking about SQLAlchemy and how it has specific features for different backends. PostgresSQL has JSON support, for example, but Sqlite doesn't.
koaning.io
September 17, 2025 at 7:00 AM
TIL about banned import rules for ruff. You can use them to make sure that nobody uses a specific submodule.
TIAL that there's a SQLAlchemy use-case for it!
koaning.io/posts/ruff-...
TIAL that there's a SQLAlchemy use-case for it!
koaning.io/posts/ruff-...
brushing up on flask and learning sqlalchemy because i hate modern websites and i actually can make them myself lol
September 13, 2025 at 11:18 PM
brushing up on flask and learning sqlalchemy because i hate modern websites and i actually can make them myself lol
I'm thinking sqlglot is a really important project. sqlalchemy + sqlalchemy is a potent combo that seems like it lets you abstract over DBs without an ORM.
And with data lake, SQL proxies/routers even are more important. sqlglot is in the middle of that.
https://github.com/tobymao/sqlglot
And with data lake, SQL proxies/routers even are more important. sqlglot is in the middle of that.
https://github.com/tobymao/sqlglot
February 2, 2023 at 5:31 PM
I'm thinking sqlglot is a really important project. sqlalchemy + sqlalchemy is a potent combo that seems like it lets you abstract over DBs without an ORM.
And with data lake, SQL proxies/routers even are more important. sqlglot is in the middle of that.
https://github.com/tobymao/sqlglot
And with data lake, SQL proxies/routers even are more important. sqlglot is in the middle of that.
https://github.com/tobymao/sqlglot
[seeking advice on tech stack for a web app]
@palomakop for the backend if you already know python then flask plus the sqlite module in the python standard library (or sqlalchemy if you don't want to write sql) is probably the most painless option
@palomakop for the backend if you already know python then flask plus the sqlite module in the python standard library (or sqlalchemy if you don't want to write sql) is probably the most painless option
February 27, 2025 at 1:19 AM
[seeking advice on tech stack for a web app]
@palomakop for the backend if you already know python then flask plus the sqlite module in the python standard library (or sqlalchemy if you don't want to write sql) is probably the most painless option
@palomakop for the backend if you already know python then flask plus the sqlite module in the python standard library (or sqlalchemy if you don't want to write sql) is probably the most painless option
通过SQLAlchemy与FastAPI优化实现性能飞跃：ZenML数据库与API的深度提升
https://qian.cx/posts/8EAAFDDB-B52D-435F-A0DF-84A8E6FC2283
https://qian.cx/posts/8EAAFDDB-B52D-435F-A0DF-84A8E6FC2283
July 24, 2025 at 2:20 AM
通过SQLAlchemy与FastAPI优化实现性能飞跃：ZenML数据库与API的深度提升
https://qian.cx/posts/8EAAFDDB-B52D-435F-A0DF-84A8E6FC2283
https://qian.cx/posts/8EAAFDDB-B52D-435F-A0DF-84A8E6FC2283
abc-graphene-sqlalchemy - 2.2.4
Custom Extension of the original Graphene SQLAlchemy integration
Author: Mark Aquino
🏠Homepage
Custom Extension of the original Graphene SQLAlchemy integration
Author: Mark Aquino
🏠Homepage
September 27, 2024 at 8:00 PM
abc-graphene-sqlalchemy - 2.2.4
Custom Extension of the original Graphene SQLAlchemy integration
Author: Mark Aquino
🏠Homepage
Custom Extension of the original Graphene SQLAlchemy integration
Author: Mark Aquino
🏠Homepage
Python and SQLAlchemy gotcha: ORM's RowMapping walks like a dict and quacks like a dict, yet isn't one. Spent hours debugging why a Polars DataFrame test failed. The culprit? Duck typing: a sequence of RowMapping differs from a dictionary sequence when evaluated in Polars, causing the bug.
January 16, 2025 at 1:47 PM
Python and SQLAlchemy gotcha: ORM's RowMapping walks like a dict and quacks like a dict, yet isn't one. Spent hours debugging why a Polars DataFrame test failed. The culprit? Duck typing: a sequence of RowMapping differs from a dictionary sequence when evaluated in Polars, causing the bug.
pythonからPostgreSQLに接続する方法について、記録。
色々な方法が出てたので、整理する必要があるっぽい。
◯方法
１：データベース接続を設定し、SQL構文を書く
※読み込みはともかく、書き込みは難しい？
２：SQLAlchemyを使って、データをPythonオブジェクトに変換する
※可能なら、Cythonパッケージを導入する事が好ましい
３：PL/Python関数を使う？
※調べた所、信頼されない為に、出来る事に制限があるらしい
４：pandasのSQLを編集するメソッドを使うらしい？
DataFrameとデータを直接やり取り出来るらしいけど、確認中
色々な方法が出てたので、整理する必要があるっぽい。
◯方法
１：データベース接続を設定し、SQL構文を書く
※読み込みはともかく、書き込みは難しい？
２：SQLAlchemyを使って、データをPythonオブジェクトに変換する
※可能なら、Cythonパッケージを導入する事が好ましい
３：PL/Python関数を使う？
※調べた所、信頼されない為に、出来る事に制限があるらしい
４：pandasのSQLを編集するメソッドを使うらしい？
DataFrameとデータを直接やり取り出来るらしいけど、確認中
February 7, 2025 at 8:22 AM
pythonからPostgreSQLに接続する方法について、記録。
色々な方法が出てたので、整理する必要があるっぽい。
◯方法
１：データベース接続を設定し、SQL構文を書く
※読み込みはともかく、書き込みは難しい？
２：SQLAlchemyを使って、データをPythonオブジェクトに変換する
※可能なら、Cythonパッケージを導入する事が好ましい
３：PL/Python関数を使う？
※調べた所、信頼されない為に、出来る事に制限があるらしい
４：pandasのSQLを編集するメソッドを使うらしい？
DataFrameとデータを直接やり取り出来るらしいけど、確認中
色々な方法が出てたので、整理する必要があるっぽい。
◯方法
１：データベース接続を設定し、SQL構文を書く
※読み込みはともかく、書き込みは難しい？
２：SQLAlchemyを使って、データをPythonオブジェクトに変換する
※可能なら、Cythonパッケージを導入する事が好ましい
３：PL/Python関数を使う？
※調べた所、信頼されない為に、出来る事に制限があるらしい
４：pandasのSQLを編集するメソッドを使うらしい？
DataFrameとデータを直接やり取り出来るらしいけど、確認中
SELECT A,B, COUNT(*) total FROM table GROUP BY A,B;
i think this is what i want... trying to translate into SQLAlchemy and failing
i think this is what i want... trying to translate into SQLAlchemy and failing
November 24, 2024 at 1:52 PM
SELECT A,B, COUNT(*) total FROM table GROUP BY A,B;
i think this is what i want... trying to translate into SQLAlchemy and failing
i think this is what i want... trying to translate into SQLAlchemy and failing
Prochain meetup #python à #Lyon : mercredi 29 janvier !
Carmen nous parlera d’optimisation des requêtes SQL dans Django et SQLAlchemy 🐍
Rendez-vous dès 19h dans les locaux de Malt.
Pour s’inscrire ⬇️
www.meetup.com/python-afpy-...
Carmen nous parlera d’optimisation des requêtes SQL dans Django et SQLAlchemy 🐍
Rendez-vous dès 19h dans les locaux de Malt.
Pour s’inscrire ⬇️
www.meetup.com/python-afpy-...
Optimisation des requêtes SQL dans Django et SQLAlchemy : le problème N+1, Wed, Jan 29, 2025, 7:00 PM | Meetup
Au cours de cette présentation, nous parlerons du problème des requêtes N+1, un piège commun rencontré lors de l'utilisation d'ORM (Object-Relational Mappers) comme l'ORM d
www.meetup.com
January 20, 2025 at 11:01 AM
Prochain meetup #python à #Lyon : mercredi 29 janvier !
Carmen nous parlera d’optimisation des requêtes SQL dans Django et SQLAlchemy 🐍
Rendez-vous dès 19h dans les locaux de Malt.
Pour s’inscrire ⬇️
www.meetup.com/python-afpy-...
Carmen nous parlera d’optimisation des requêtes SQL dans Django et SQLAlchemy 🐍
Rendez-vous dès 19h dans les locaux de Malt.
Pour s’inscrire ⬇️
www.meetup.com/python-afpy-...
https://www.b-list.org/weblog/2025/aug/06/litestar/
Litestarは、async-first、タイプヒント駆動のPython Webフレームワークです。
他のフレームワークとは異なり、過剰な宣伝に頼らず、堅牢な機能を提供します。
コードベースのスケーリング、Pydanticとの連携、SQLAlchemyとの統合が特徴です。#python
Litestarは、async-first、タイプヒント駆動のPython Webフレームワークです。
他のフレームワークとは異なり、過剰な宣伝に頼らず、堅牢な機能を提供します。
コードベースのスケーリング、Pydanticとの連携、SQLAlchemyとの統合が特徴です。#python
Litestar is worth a look
www.b-list.org
August 7, 2025 at 7:57 AM
https://www.b-list.org/weblog/2025/aug/06/litestar/
Litestarは、async-first、タイプヒント駆動のPython Webフレームワークです。
他のフレームワークとは異なり、過剰な宣伝に頼らず、堅牢な機能を提供します。
コードベースのスケーリング、Pydanticとの連携、SQLAlchemyとの統合が特徴です。#python
Litestarは、async-first、タイプヒント駆動のPython Webフレームワークです。
他のフレームワークとは異なり、過剰な宣伝に頼らず、堅牢な機能を提供します。
コードベースのスケーリング、Pydanticとの連携、SQLAlchemyとの統合が特徴です。#python
sqlalchemyは(殺意を覚えるくらいに)親切なリザルトキャッシングやコネクションプーリングがデフォルトでオンになってるのだけど、公式ドキュメントでそれを読み取るのがかちゃかちゃ難しくて気が狂いそうになるかちゃね
ORMフレームワークつかうとRDBMSの知識とORMの知識両方が必要になってただただ無駄が多いという気持ちを新ちゃにしちゃ(5000兆回目)
ORMフレームワークつかうとRDBMSの知識とORMの知識両方が必要になってただただ無駄が多いという気持ちを新ちゃにしちゃ(5000兆回目)
August 14, 2025 at 10:28 AM
sqlalchemyは(殺意を覚えるくらいに)親切なリザルトキャッシングやコネクションプーリングがデフォルトでオンになってるのだけど、公式ドキュメントでそれを読み取るのがかちゃかちゃ難しくて気が狂いそうになるかちゃね
ORMフレームワークつかうとRDBMSの知識とORMの知識両方が必要になってただただ無駄が多いという気持ちを新ちゃにしちゃ(5000兆回目)
ORMフレームワークつかうとRDBMSの知識とORMの知識両方が必要になってただただ無駄が多いという気持ちを新ちゃにしちゃ(5000兆回目)
And I feel like the difference between projects with well written, searchable docs (SQLalchemy, Postgres, tailscale, Python itself), which are all mostly ok, and anything commercial, which is not, is just getting worse.
September 1, 2025 at 12:34 PM
And I feel like the difference between projects with well written, searchable docs (SQLalchemy, Postgres, tailscale, Python itself), which are all mostly ok, and anything commercial, which is not, is just getting worse.
are people still using sqlalchemy and stuff
September 13, 2025 at 10:33 PM
are people still using sqlalchemy and stuff
R2D16 One of the things that I love about Java is how JPA turns database access into magic.
Now that I've been working with Python for a bit - it's time to start studying ORM to see if it's as magical. Starting with SQLAlchemy...
#100DaysOfCode
Now that I've been working with Python for a bit - it's time to start studying ORM to see if it's as magical. Starting with SQLAlchemy...
#100DaysOfCode
November 7, 2024 at 4:15 PM
R2D16 One of the things that I love about Java is how JPA turns database access into magic.
Now that I've been working with Python for a bit - it's time to start studying ORM to see if it's as magical. Starting with SQLAlchemy...
#100DaysOfCode
Now that I've been working with Python for a bit - it's time to start studying ORM to see if it's as magical. Starting with SQLAlchemy...
#100DaysOfCode
SQLAlchemy、覚えることが多くてめんどくさくなってきた。
December 10, 2023 at 8:16 AM
SQLAlchemy、覚えることが多くてめんどくさくなってきた。
"Connecting to Azure SQL Database using SQLAlchemy and Microsoft Entra authentication" https://buff.ly/3A7Ml5h #Microsoft #techcommunity
Connecting to Azure SQL Database using SQLAlchemy and Microsoft Entra authentication
Unlock secure, password-free connections to Azure SQL Database using Microsoft Entra Authentication and SQLAlchemy with this in-depth guide. Learn to configure..
buff.ly
October 29, 2024 at 3:50 PM
"Connecting to Azure SQL Database using SQLAlchemy and Microsoft Entra authentication" https://buff.ly/3A7Ml5h #Microsoft #techcommunity