Re:Ask HN: Kibana like data explorer UI for PostgreSQL?
by brett-za on Thursday December 13, 2018 @01:09AM
(#18670221)
Maybe something like Metabase (https://metabase.com/) would work for you?
[ Parent
| on HN ]
Re:Ask HN: Kibana like data explorer UI for PostgreSQL?
by bosky101 on Friday December 14, 2018 @12:49PM
(#18682789)
+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.
Re:Ask HN: Kibana like data explorer UI for PostgreSQL?
by reacharavindh on Thursday December 13, 2018 @10:31AM
(#18672953)
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?
Re:Ask HN: Kibana like data explorer UI for PostgreSQL?
by vajrapani666 on Friday December 14, 2018 @03:52AM
(#18679429)
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/
Re:Ask HN: Kibana like data explorer UI for PostgreSQL?
by reacharavindh on Friday December 14, 2018 @12:19PM
(#18682528)
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.
Re:Ask HN: Kibana like data explorer UI for PostgreSQL?
by MightySCollins on Friday December 14, 2018 @08:18PM
(#18686391)
We started with redash and moved to Metabase. It's really quite powerful and and teams great too.