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.

Want us to remind you?

We'll email you before the event with a friendly reminder.

Get involved in the Oso community

Connect on Slack

Get help from our team, and talk with hundreds of like-minded developers.
Join the Slack

Share the love

Show off the problems you're solving with Oso and how you're leading the charge.

Get Oso Swag

We're sending free Oso swag to users anywhere in the world. Seriously.
Get swag

Get updates from Oso.

We won't spam you. Ever.