Usefull Metric/Statics

[hhlp]

I read somewhere here in discourse but now I can’t find it, a post where someone write a usefull metric/static with SQL Query… there are a few, what I would like to use…

Could you point me out…

Regards.,

[Johani]

There are a couple of topics that relate to this:

1. Data explorer queries

What cool data explorer queries have you come up with?

Continuing the discussion from Data Explorer Plugin: Here’s a couple I’m starting with: Users Last Seen Since (Since N Weeks Ago) with intervals as ( select n as start_time, CURRENT_TIMESTAMP as end_time from generate_series(CURRENT_TIMESTAMP - INTERVAL '140 days', CURRENT_TIMESTAMP - INTERVAL '7 days', INTERVAL '7 days') n ) select COUNT(1) as users_seen_since, CURRENT_TIMESTAMP - i.start_time as time_ago FROM USE…

2. Badge queries

What cool badge queries have you come up with?

NOTE: So there are lots of potential badges that we can come up with using SQL queries. I thought I’d start a topic for people to share some of the queries and badges they’ve created. I for one am looking forward to seeing some cool inspiration! This post is a wiki topic. If you have a good badge query to add, please reply to this topic with your query, and then edit this post (pencil icon in the upper right) and include a link to your reply here in the following index. Thanks! Badges for…

[Mittineague]

It is possible to enter the ruby console and run ActiveRecord queries, if you feel more comfortable doing that.

But IMHO, the best way is to use the Data Explorer plugin.

• it provides information about tables, fields, and field datatypes
• it does only SELECT queries so it is inherently safer because it can not do anything destructive
• has built in LIMIT so a poorly crafted query will not bog or crash your site

Some knowledge of the database architecture is still needed, especially for complex queries. But many (IMHO, most) times it is intuitive. eg.
it is clear that the posts table’s posts.topic_id field references the topics table’s topics.id field.

[system]

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.