Release: sqlalchemy-oso 0.7.0 and Oso Roles 0.0.4 are out, including support for SQLAlchemy 1.4 and better performance

The latest version of the Oso Roles library (sqlalchemy-oso-preview 0.0.4) is out, including improved query performance with data filtering! This library is in early access while we continue to add features and improve performance. Check it out here.

And sqlalchemy-oso 0.7.0 is out with support for SQLAlchemy 1.4!

Support for SQLAlchemy 1.4 in sqlalchemy-oso 0.7.0

If you’re already using sqlalchemy-oso with SQLAlchemy 1.3, upgrading to SQLAlchemy 1.4 requires zero code changes (for sqlalchemy-oso, that is — you might have to update some SQLAlchemy code).

If you run into any issues with SQLAlchemy 1.4, please don’t hesitate to reach out on Slack.

Happy SQLAlchemy-ing!

Better performance in Oso Roles 0.0.4

Data filtering authorization queries that use Roles.role_allows execute more quickly using queries that are supported by database indexes. To help support this, we added a requirement that all resource models must have the same primary key type.

SQLAlchemy 1.4 is not yet supported in sqlalchemy-oso-preview, but we're adding support for it soon.

For more details on these and other changes, read the changelog.

Set up a 1x1 with an Oso engineer

Our team is happy to help you get started with the Oso Roles library. If you'd like to try out the new library, or if you're interested in learning how to use it in your app, schedule a 1x1 with one of our engineers.

Our team is also available to help with these and other questions about authorization on Slack.