Skip to main content

Flask extension for psycopg2-pgevents, using SQLAlchemy.

Project description

Flask-SQLAlchemy-PGEvents provides PostGreSQL eventing for Flask. It handles setting up the underlying database, registering triggers, and polling for events.

Why Do I Care?

I have SQLAlchemy, which supports event listeners. Why do I care about this extension?

SQLAlchemy’s event listening framework is great for listening to database changes made through SQLAlchemy. However, in the real world, not every data event that affects a database takes place through SQLAlchemy; an application may be created from any number of packages, libraries, and modules written in different languages and with different frameworks. If any of these non-SQLAlchemy items modify a database, SQLAlchemy will not know, and will therefore not notify event listeners of these changes.

With this extension, an application may be notified of events at the database layer. This means that any changes made to a table are caught by this extension and registered event listeners (for the affected table) are called.

Why Use SQLAlchemy?

You just said that SQLAlchemy has nothing to do with the eventing aspect of this extension…So why are you using SQLAlchemy?

Great question! SQLAlchemy is primarily used as a convenience mechanism for creating a consistent connection to the database.

Additionally, many Flask applications use SQLAlchemy as their ORM. As such, this extension will integrate seamlessly with any Flask applications that use Flask-SQLAlchemy. To provide a consistent SQLAlchemy experience, this extension’s event listener decorator is designed to closely resemble SQLAlchemy event listener decorators.

While this extension may appear to integrate with SQLAlchemy’s event listeners, it actually sits alongside that eventing structure. Registering a PGEvents event listener does not register the event listener with SQLAlchemy’s event registrar.


See the examples directory for example use cases for this package.

Future Plans

  • With a little bit of work, it should be possible to completely integrate this extension’s event listeners into SQLAlchemy.event, so that event listeners are functionally identical to SQLAlchemy’s event listeners.
  • Currently, the only supported events are after-insert and after-update. The psycopg2-pgevent package could be updated in coordination with this extension to support other SQLAlchemy mapper events.

Authorship and License

Written by Shawn Wallis and distributed under the MIT license.

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
Flask_SQLAlchemy_PGEvents-0.1.0-py3-none-any.whl (5.8 kB) Copy SHA256 hash SHA256 Wheel py3 Sep 16, 2018
Flask-SQLAlchemy-PGEvents-0.1.0.tar.gz (6.3 kB) Copy SHA256 hash SHA256 Source None Sep 16, 2018

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page