How compatible is TimescaleDB with JSON or other data formats generated by Playwright? Are there recommended ways to structure and store complex test result data in TimescaleDB?

TimescaleDB and PostgreSQL
,
1

I’m learning Playwright online, and they mentioned using TimescaleDB for storing test data in formats like JSON. Can the community provide guidance on the best ways to structure and store complex test results in TimescaleDB?

2

Hi @Mangai_Ram, welcome!

You can use jsonb column to save the data. Example here: Timescale Documentation | JSONB support for semi-structured data

Also, this blog post can help with a few ideas how to be able to build statistics generically if necessary: Adapting JSON Structures for Real-Time Aggregates in Postgres