Yes, works with SQLAlchemy. (Like many ORMs there are a couple things to be aware of, but plenty StackOverflow questions about these already :)

And yes, people use it for event sourcing. Often see this in various product analytics use cases.

Although I can't point to a specific application that's currently using TimescaleDB for an event sourcing service (I assume you're talking about the design pattern), it would be a great use case. Change in state over time is perfect time-series scenario.

As for SQLAlchemy, TimescaleDB is fully PostgreSQL compliant, so it will work out of the box. There will be a few nuances that need to be considered, particularly when writing queries that use some of our additional time-series functions like time_bucket.

But day-to-day ORM CRUD patterns should work as you expect!

Thank you (both of you!). Agreed - I mean the design pattern, but I was being a bit vague.

are pg extensions supported?

-j

Yes, TimescaleDB plays friendly with most PG extensions.

And Timescale Cloud comes pre-loaded with many of them - https://kb.timescale.cloud/en/articles/2754991-supported-pos...

Yes. We’ve used Timescale with SQLAlchemy and overall everything works.