4 ms·

Maybe something like Metabase (https://metabase.com/ https://metabase.com/) would work for you?

• reacharavindh 8y ago
  Thanks the suggestion. I played with Metabase a bit today. It is great for custom dashboards, searchable query links etc. but, I could not find a interface element that would let me "full text search" a column in Postgres table.. Do you have ideas?
  • vajrapani666 8y ago
    You can use custom queries in metabase and parameterize them, for any parameter you can expose the parameter with a text field available when you embed the "question" anywhere. https://hevodata.com/blog/postgresql-full-text-search-setup/ https://hevodata.com/blog/postgresql-full-text-search-setup/
    • reacharavindh 8y ago
      The link was very helpful to learn about making use of FTS in Postgres. Thanks! I still could not figure out how to expose a filter as a user modifiable dynamic search box/text field with Metabase. I could not find such a facility in their documentation, nor in their forums. I'm giving up on Metabase for this need.
• bosky101 8y ago
  +1 for metabase. had to turn off autoscanning though because it starting slowing down other queries when scanning a large table frequently. we also use pgweb linked elsewhere here for engineers. btw, we built a sql statement to spreadsheet + charts interface. DM if interested. intuitively - i think others may find it useful.
• MightySCollins 8y ago
  We started with redash and moved to Metabase. It's really quite powerful and and teams great too.