site banner
naraburns  nihil supernum  1yr ago (text post)   5640 thread views

Small-Scale Question Sunday for March 12, 2023

Do you have a dumb question that you're kind of embarrassed to ask in the main thread? Is there something you're just not sure about?

This is your opportunity to ask questions. No question too simple or too silly.

Culture war topics are accepted, and proposals for a better intro post are appreciated.

6
Top Bottom New Controversial Comments
Jump in the discussion.

No email address required.

Too early to say. The early months of themotte.org were dominated by USA election season, which has always spurred heavy traffic in the CWR, and the early months of 2023 have been big dry spell for the culture war. (Of course, 2020-2022 was probably the most intense culture war period of my life, so maybe we're settling into a new equilibrium.)

I expect us to whither and die but I'm not sure I'm seeing that yet.

I think there’s a lot more demand for niche internet communities now than in the mid 2010s when everyone was allowed to have their own subreddit.

I think there’s a lot more demand for niche internet communities now than in the mid 2010s when everyone was allowed to have their own subreddit.

Oh, I believe there's a demo that wants us. But our discoverability is toilet tier compared to being a subreddit.

Some communities sustain themselves through pure word of mouth, like Kiwifarms. (Hey! They're alive!) But most... don't. They shrink as their initial seed members drift away without being replaced.

I'd be interested if there are any commenters, (or lurkers, what the heck you're in this thing too), who joined after the jump.

I'll report in as a datapoint.

How did you get here? Anything we can do to funnel your kind into the net?

My response to your first question.

As for your second, I really couldn't tell you - I can't think of a place off the top of my head I would feel comfortable exposing to this place.

OK, you were already caught ages ago, you just got reeled in recently . The search for new fish continues.

I lurked but I started posting after the jump.

Same story here.

Same here

Same.

I'd also like to know this. Any numbers @ZorbaTHut ?

I don't actually know how we could have numbers for that, honestly - there's no consistent way for us to associate pre-Reddit and post-Reddit people, I know a bunch of people changed nicknames.

I guess I meant how many new members since the initial influx. I think we were at 2,000 last time someone asked?

We were, although that was long past the initial influx. Looks like we're at 2259 now, although I don't know how many of those are attempts at spambots and so forth.

How often do new members go on to be productive posters? Do you know (including older people) roughly how many people regularly post or vote on things?

I admit I haven't attempted to quantify that. It's an interesting question, and I'd like an answer except I do not have time to do the work required to create an appropriate database query >_<

The following will get you, segmented by month,

  • Number of signups in that month

  • Number of those signups who have ever commented

  • Average number of comments by those signups (total and per day)

  • Average number of comment words written by those signups (total and per day)

  • Average number of upvotes on comments by those signups (total and per day)

  • Average number of downvotes on comments by those signups (total and per day)

  • Average score (up - down) on comments by those signups (total and per day)


with user_comment_stats as (

    select

        u.id as user_id,

        min(to_timestamp(u.created_utc)::date) as signup_date,

        count(c.id) as n_comments,

        sum(array_length(regexp_split_to_array(trim(c.body), E'\\W+'), 1)) as total_words_written,

        sum(c.upvotes) as total_upvotes,

        sum(c.downvotes) as total_downvotes,

        sum(c.upvotes - c.downvotes) as total_score,

        min(now()::date - to_timestamp(u.created_utc)::date) as days_since_signup

    from users u

        left join comments c on c.author_id = u.id

    group by user_id

)
select

    left(signup_date::text, 7) as signup_month,

    count(distinct user_id) as n_users,

    sum((n_comments > 0)::int) as n_commented,

    avg(n_comments) as avg_comments_per_user,

    avg(total_words_written) as avg_commentwords_per_user,

    avg(total_upvotes) as avg_upvotes_per_user,

    avg(total_downvotes) as avg_downvotes_per_user,

    avg(total_score) as avg_score_per_user,

    avg(n_comments / days_since_signup) as avg_daily_comments_per_user,

    avg(total_words_written / days_since_signup) as avg_daily_commentwords_per_user,

    avg(total_upvotes / days_since_signup) as avg_daily_upvotes_per_user,

    avg(total_downvotes / days_since_signup) as avg_daily_downvotes_per_user,

    avg(total_score / days_since_signup) as avg_daily_score_per_user

from user_comment_stats

group by signup_month

You can do a similar thing with votes and posts if you care about such things.

Though honestly there are fewer than 2500 users and 100000 comments on the motte -- fancy analytics approaches are unlikely to tell you anything you don't already know from regularly reading the motte.

More comments

What is this place?

This website is a place for people who want to move past shady thinking and test their ideas in a court of people who don't all share the same biases. Our goal is to optimize for light, not heat; this is a group effort, and all commentators are asked to do their part.

The weekly Culture War threads host the most controversial topics and are the most visible aspect of The Motte. However, many other topics are appropriate here. We encourage people to post anything related to science, politics, or philosophy; if in doubt, post!

Check out The Vault for an archive of old quality posts. You are encouraged to crosspost these elsewhere.


Why are you called The Motte?

A motte is a stone keep on a raised earthwork common in early medieval fortifications. More pertinently, it's an element in a rhetorical move called a "Motte-and-Bailey", originally identified by philosopher Nicholas Shackel. It describes the tendency in discourse for people to move from a controversial but high value claim to a defensible but less exciting one upon any resistance to the former. He likens this to the medieval fortification, where a desirable land (the bailey) is abandoned when in danger for the more easily defended motte. In Shackel's words, "The Motte represents the defensible but undesired propositions to which one retreats when hard pressed."

On The Motte, always attempt to remain inside your defensible territory, even if you are not being pressed.


New post guidelines

If you're posting something that isn't related to the culture war, we encourage you to post a thread for it. A submission statement is highly appreciated, but isn't necessary for text posts or links to largely-text posts such as blogs or news articles; if we're unsure of the value of your post, we might remove it until you add a submission statement. A submission statement is required for non-text sources (videos, podcasts, images).

Culture war posts go in the culture war thread; all links must either include a submission statement or significant commentary. Bare links without those will be removed.

If in doubt, please post it!


Rules


Recommended Posts And Communities

Recommended Realtime Chats