Re: [sqlalchemy] Supporting Function Indexes on a Minimum Sqlite Version

2021-03-09 Thread 'Jonathan Vanasco' via sqlalchemy
Thank you so much, Mike! I roughly had that same @compiles in my tests, but I didn't trust myself... and the .dbapi looked like what I wanted, but I really wasn't sure! On Monday, March 8, 2021 at 4:36:03 PM UTC-5 Mike Bayer wrote: > > > On Mon, Mar 8, 2021, at 12:06 PM, 'Jonathan Vanasco' via

Re: [sqlalchemy] Supporting Function Indexes on a Minimum Sqlite Version

2021-03-08 Thread Mike Bayer
On Mon, Mar 8, 2021, at 12:06 PM, 'Jonathan Vanasco' via sqlalchemy wrote: > I have a project that, in a few rare situations, may run on a version of > sqlite that does not support function indexes, and "need" to run a unique > index on `lower(name)`. For simplicity, I'll just use a normal

[sqlalchemy] Supporting Function Indexes on a Minimum Sqlite Version

2021-03-08 Thread 'Jonathan Vanasco' via sqlalchemy
I have a project that, in a few rare situations, may run on a version of sqlite that does not support function indexes, and "need" to run a unique index on `lower(name)`. For simplicity, I'll just use a normal index on correct systems, I'm trying to figure out the best way to implement this.