Welcome to Codidact Meta!
Codidact Meta is the meta-discussion site for the Codidact community network and the Codidact software. Whether you have bug reports or feature requests, support questions or rule discussions that touch the whole network – this is the site for you.
Post History
I am wondering if we can have a minimal data explorer for Codidact communities: mirror the publicly available tables/columns in a separate database (can be done once per day to minimize the impa...
#2: Post edited
by
Alexei
·
2022-01-01T18:56:44Z (almost 3 years ago)
clarified the last point
- I am wondering if we can have a minimal data explorer for Codidact communities:
- - mirror the publicly available tables/columns in a separate database (can be done once per day to minimize the impact)
- - allow logged-in users (maybe have a privilege for this?) to issue read queries with a pretty small timeout (e.g. 10s)
- no fancy editor is required, just a documentation page that shows the relevant tables schema- This would allow us to have more advanced information about the community.
- Note: this discussion/request is inspired by this [Data Explorer](https://data.stackexchange.com/stackoverflow/query/1183177/absolute-answers-in-1-7-14-all-days-per-week?StartTime=2000%2F01%2F01#graph) query.
- I am wondering if we can have a minimal data explorer for Codidact communities:
- - mirror the publicly available tables/columns in a separate database (can be done once per day to minimize the impact)
- - allow logged-in users (maybe have a privilege for this?) to issue read queries with a pretty small timeout (e.g. 10s)
- - no fancy editor is required, just a simple text area and a documentation page that shows the relevant tables' schema should be enough as a start
- This would allow us to have more advanced information about the community.
- Note: this discussion/request is inspired by this [Data Explorer](https://data.stackexchange.com/stackoverflow/query/1183177/absolute-answers-in-1-7-14-all-days-per-week?StartTime=2000%2F01%2F01#graph) query.
#1: Initial revision
by
Alexei
·
2022-01-01T16:11:41Z (almost 3 years ago)
Minimal data explorer for analytics
I am wondering if we can have a minimal data explorer for Codidact communities: - mirror the publicly available tables/columns in a separate database (can be done once per day to minimize the impact) - allow logged-in users (maybe have a privilege for this?) to issue read queries with a pretty small timeout (e.g. 10s) - no fancy editor is required, just a documentation page that shows the relevant tables schema This would allow us to have more advanced information about the community. Note: this discussion/request is inspired by this [Data Explorer](https://data.stackexchange.com/stackoverflow/query/1183177/absolute-answers-in-1-7-14-all-days-per-week?StartTime=2000%2F01%2F01#graph) query.