4 ms·
Sorry for detracting from the release news but SQLAlchemy has to have the least helpful website of any major library I can think of. I'm trying to find basic 10
by trevor-e 4y ago
Sorry for detracting from the release news but SQLAlchemy has to have the least helpful website of any major library I can think of. I'm trying to find basic 101 code examples and it's just one wall of text after another. I found how to cite SQLAlchemy in a research paper and have yet to find a single code example.
- airocker 4y agoI generally try StackOverflow/Google, then documentation and then discussion issues on SQLAlchemy. IT has worked well for me.
- akprasad 4y agoUnder the Current Releases section, click the docs link then ORM Quick Start. But it's tough to find at a glance.
- epgui 4y agoCheck out pugsql, we switched from SQLAlchemy to that because the former was overkill, and way too complex.
- b1ue64 4y agopeewee is also pretty good
- artemisart 4y agoI find ORM models useful for type checking and migrations, what is your experience for this with pugsql?
- v3ss0n 4y agoIt's unmaintained..
- wendyshu 4y agoYes, that's probably my biggest complaint about the library. The docs are there but hard to navigate. Sometimes crucial tips are buried in an aside on one of the many pages that talk about the same topic. It's difficult to get started and it's also difficult to find the ultimate explanation of what's going on.
- v3ss0n 4y agoToo much repetition in docs . The framework might be good but the doc is lacking simplicity. I still can't get a grasp of what going on while reading.
- NegativeLatency 4y agoI miss ActiveModel and ActiveRecord so much (after recently switching jobs to a python shop), docs, api etc were just so polished and battle hardened (yes they have their problems, but I was pretty proficient in using them well)
- throwme_123 4y agoWhen I see such a poor website, I also expect the codebase to be clunky and cluttered. Better alternative: - https://pugsql.org/ https://pugsql.org/
- mattbillenstein 4y agoThis is neat - I'd never heard of it. I've been using psycopg2 directly with a thin layer for managing connections and transactions using thread-locals for a long time - RealDictRow and some adapters for jsonb and a few other types make it really easy to work with.
- livre 4y agoI've worked for close to a decade with Django's ORM and recently with TypeORM, both have been simple to use and generally (minus some weird things I tried to do) a pleasure. I recently started working with a not so important project at my current job with sqlalchemy because I had to use Flask, I cannot describe the pain I've felt working with this, I dread having to write yet another query with sqlalchemy. The docs are terrible, some of the worst I've ever seen, an obscure and undocumented government library I'm also using at work has been easier to learn by reading its code than sqlalchemy. Someone above mentioned that the new 2.0 docs are better, I seriously hope they are, they will make my suffering more tolerable. However, even if the docs are good the API is still the worst and least intuitive I've ever seen, it honestly feels like I'm writing raw sql code shaped like python code. But it is weird, non standard and difficult to follow, unlike the official python sql interface. I recently had to write an upset and it felt like I was trying to summon a forgotten demon. It would have honestly been much easier to just write it in raw sql. I'm sorry for the wall of text, I wanted to let you know that I'm very grateful for you suggesting that library. I hope I can migrate this (still) relatively small codebase away from sqlalchemy. I'm going to give pugsql and peewee a try, both have been mentioned in this thread as good alternatives. I can summarize my basic complain here: the abstraction layer that sqlalchemy provides is more complex than SQL itself. It's almost not worth it, add to that the docs are a huge mess and you get something only diehards and people who have been using it for decades want to use.