4 ms·
[edit] despite negative expectations, I still upvoted OA cause even "wrong" innovation is better than stagnation. pyscopg2 is pretty great. Every lib I've seen
by njharman 11y ago
[edit] despite negative expectations, I still upvoted OA cause even "wrong" innovation is better than stagnation.
pyscopg2 is pretty great. Every lib I've seen is based on it. Many apps use it directly. It is the lowest, comfortable layer you'd want. What you need on top of that is Either;
1) So minor, most just write a few helper functions/classes
2) So elaborate and opinionated it needs years of use/work to get right. SQLAlchmey, Django ORM.
3) So specific, customized to your requirements that general purpose libs/frameworks don't fit.
Some people get tired of redoing #1 or don't like #2's opinions or think there should be something lighter. So, they build something they hope to be middle ground. I don't think there is a middle ground. As you use it you realize the complexity (dbs/SQL are much, much more complicated/powerful than you think, the impedance between relations and objects) and middle ground projects remain "toys" or grow into SQLAlchemy.