Jônatas Davi Paganini

Hey folks, I see that we'll have a [hackathon day](https://rubycentral.org/news/a-look-back-at-rubyconf-2023-featuring-the-brand-new-community-day/) and I'd love to work on this one as I'm already a few years on the Timescaledb side and with...

Yay! very good! looking forward to make it happen 🎉

I updated the gist with my latest ideas from this script: https://gist.github.com/jonatas/418f360d45c890e1d86c30547a0cf6a4

From a core TimescaleDB extension developer: > for pg materialized views it is in pg_class.relispopulated but that won't work for caggs I'll try to see if we can make it...

Hi @jamescook10, I think improving this scenario would be amazing! @JamesMasonRC did great contributions on #10 and you can see the following files: SchemaDumper maps the main logic: https://github.com/jonatas/timescaledb/blob/17e2383e613a6a30a136926ec4985c998bb7cacd/lib/timescaledb/schema_dumper.rb#L34-L46 lib/timescale/scenic/adapter.rb...

I never used this before. Maybe that was my fault. I see now some examples that can also be useful here: https://github.com/segiddins/timescaledb-rails/compare/main...crunchloop%3Atimescaledb-rails%3Amain

I was thinking a bit better, maybe the best idea is just detects if the extension is installed and then skip in case it's not.

Hey @jon-sully, thanks for documenting all your efforts here. It can be very useful for upgrading the actual instructions. Also, I can say I face the same as a Mac...

Query example to get the views in the proper order: ```sql WITH RECURSIVE caggs AS ( SELECT mat_hypertable_id, parent_mat_hypertable_id, user_view_name FROM _timescaledb_catalog.continuous_agg WHERE user_view_name = 'metrics_by_week' UNION ALL SELECT continuous_agg.mat_hypertable_id,...

Hi @exterm, have you tried to establish the connection first? ```ruby Timescaledb.establish_connection(ENV['DATABASE_URL']) ``` You can check the `bin/tsdb` with the `--stats` option: https://github.com/timescale/timescaledb-ruby/blob/a78398d782703dd0f142cfdfe24db79c72fb4a91/bin/tsdb#L7