3 ms·
I have been wondering the same thing. But, I spent the last hour looking for something like Kibana that would work with Postgres. Postgres full text search, an
by reacharavindh 8y ago
I have been wondering the same thing. But, I spent the last hour looking for something like Kibana that would work with Postgres.
Postgres full text search, and Timescale extension would be ideal for logging kind of application. I could just set data retention to something like 2 months to keep the data volume simple and manageable.
But, all "data explorer" like tools for SQL databases obviously focus on having their end users write SQL. I'm hard pressed to find a good search interface that talks to Postgres at the backend..
- cetra3 8y agoWe store our logs in PostgreSQL and use Metabase for visualisations & analysis: https://metabase.com/ https://metabase.com/ It's still focused on SQL but the "Question" flow is quite simple, and doesn't require you to write SQL. You can, of course, write raw SQL if you want to and have those results still visualised.
- reacharavindh 8y agoI am playing with Metabase trying to see if there is any way for me to get a "search" on a column of table. It feels like I'm looking for a different use case. Metabase seems excellent for building a dash board composed of several SQL based questions, and to generally have a searchable list of questions(which are internally SQL queries). But, searching for logs seems to not be one of its use cases...