2 ms·
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
by mfreed 6y ago
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.
- ryanbooz 6y agoAlthough 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!
- robertlagrant 6y agoThank you (both of you!). Agreed - I mean the design pattern, but I was being a bit vague.
- johnthescott 6y agoare pg extensions supported? -j
- mfreed 6y agoYes, 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-postgresql-extensions https://kb.timescale.cloud/en/articles/2754991-supported-pos...