Re: [sqlalchemy] SQLlite: enforce a unique constraint on a relation?

2018-03-12 Thread Ryan Holmes
Thanks Mike, While I would rather this be a hard constraint on the database, not enforced in python, I understand that SQLite is pretty limited in this regard, so I'm down to try anything really. I also had the idea of using a custom collection simply because the project already uses them heavi

Re: [sqlalchemy] Model class creation and configure_mapper performance

2018-03-12 Thread stephen
Ah, I see. That makes sense. Thanks for the thorough response! We will look elsewhere to improve our app startup time for now. > 300 classes shouldn't be a 9 second operation. It's 9s running with the profiling overhead. In reality, setup_mapping and configure_mappers are closer to 2.5s each.

Re: [sqlalchemy] MySQL “charset introducer” how-to?

2018-03-12 Thread Mike Bayer
we might have to implement the _binary thing on our end. especially if all the MySQL drivers have the same issue, plus Django went ahead and did the _binary thing already making it less likely the drivers will. that said, here's how to get _binary for now, this might be what we add on our end: