Lay it on the line in our March club posting! This time, let's submit short stories, chapters, essays.

@eve suggests that the optional theme be "liminality/liminal spaces. It could be about them, the creation of one, a dissection, the destruction of one, or just take place there. Anything and everything liminal."

Liminal is a sort of between. The definition is: relating to a transitional or initial stage of a process. occupying a position at, or on both sides of, a boundary or threshold.

You can also look into liminal spaces. These can be real places (like a train station that's simply a point people transfer to other trains to) or even the emotional betweens; coming to realizations or on a precipice of something. Like, summer vacation could be a liminal space even!

If you're not into borders and transitional spaces, or if you've been incubating a polemic all pandemic long, you are still encouraged to share your writing! You may draw inspiration from any theme (fictional or real).

Just follow these easy guidelines:

1. Produce a short story, essay, or chapter of a longer work. Your submission should not exceed 7,000 words. Let's aim for pieces 350-3500 words.

2. Watch for the March 14 submissions thread to appear... on March 14! Reply to it with a link to your work, which may be housed anywhere you like, including on Tildes. Prioritize venues that are not known to be aggressively anti-privacy (e.g., Google Docs). You may provide questions for readers in hidden expandable text, if you like.

3. You must provide feedback on 3 submissions if you are posting a submission. Only one needs to be a substantial critique. Our first outing was a trial run, and the offerings were extremely short. I anticipate proportionally longer responses to come easily this time. If you see a post without feedback, consider giving it preference in the order of your responses. No one likes to be left hanging.

Feel free to post questions in this topic. We had a stimulating and moderately edgy trial run. I'm excited for the longer prose to come!

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

General Programming Q&A thread! Ask any questions about programming, answer the questions of other users, or post suggestions for future threads.

Don't forget to format your code using the triple backticks or tildes:

Here is my schema:

```sql
CREATE TABLE article_to_warehouse (
  article_id   INTEGER
, warehouse_id INTEGER
)
;
```

How do I add a `UNIQUE` constraint?

It might sound silly to most, but I have had one for years now.

I started to really listen to music on my own volition in the early 2010s when I was in my early 10s, and I was really big into EDM at the time (big room house, brostep, electro house, progressive house, etc).

At some point in 2014 I wanted to expand my tastes so I ended up on rateyourmusic.com which is the kinda place you always end up on at some point if you go down this path the way I see it, and at first I just checked the overall charts and shrugged since it wasn't my kind of music at all (The Beatles, The Beach Boys, Miles Davis, Pink Floyd, The Rolling Stones, Radiohead, etc), but at some point it started bothering me; "why is all that crappy old music so highly regarded?" and I started giving the stuff a try. Didn't like it at all, but I somehow starting feeling compelled to try and understand/appreciate it.

Eventually, I fell down a sort of rabbit hole when I started reading discussions on how some music is "objectively better" than others and I completely believed it. Pushed around by the extremely harsh disdain towards the EDM I loved and godly praise of the type of thing I just mentioned, I just kinda felt like I was supposed to move on and basically listened to a lot of stuff like that.

Another while later I eventually realized that the whole "objectively good/bad" thing is one ugly sack of false shit, but I've been really burned out since then, and now I don't even really feel the music I used to like. Problem is, at this point the act of crawling through the charts looking for new music, constantly listening to new stuff, thinking about genres, etc, is so deeply ingrained in my behavior that I can't seem to stop. I have music on at nearly all times, and I force myself to listen to everything in full despite not feeling it at all.

Something that's also gotten me is the whole repeated listening thing, I've always really loved the idea of being able to enjoy something you initially didn't care for or were lukewarm towards by simply repeatedly listening to it. That also caused me to disregard my own impressions and force myself to repeatedly listen to almost everything. I'm mostly out of that phase now, but I sometimes still find myself digging through random stuff I've given low ratings and listening to it again purely to see if I suddenly like it, but it has literally never even worked once. I also think this has been a contributor to me being burned out on music.

At this point I kinda feel like I'll never truly enjoy music again like I used to and it's really sad. Sometimes it does return a little, but if have to explain it with a rating, I can't say I've ever really felt anything above a 7/10 again, most of the time it's between a 3/10 and 6/10. I totally realize I just need to take a break, but I simply can't seem to stop (through a lot of effort I have actually managed to take a full break last month, but I immediately relapsed when I resumed this month, and even without that it doesn't seem like it helped all that much). What a lot of people have with things like gaming and food, I basically have with music.

Does anyone else have anything like this?

Let me preface that I'm well aware that if given the choice between frequent, untargeted ads or fewer targeted ads, the average Tilderino's response would be "Neither."

However, given that social media at scale has yet to establish a sustainable business model that doesn't rely on advertising (people like free content, after all), it seems advertising has become a necessary evil (and has pervaded nearly all forms of media for the past century regardless).

With that in mind, I think coming up with creative solutions to deliver relevant advertising while preserving user privacy and avoiding destructive feedback loops (i.e. where the search for ad revenue compromises the user base and content generation) is an interesting thought exercise. This is one of social media's largest problems, imho, but it might be easier to analyze just Reddit as a platform due to its similarities (and notable differences) to Tildes.

A couple thoughts of my own:

• Whitelist "safe" subreddits - A massive problem for Reddit is identifying content that brands want to avoid association with (e.g. porn, violence, drugs). While new subreddits crop up every day, the large ones do not change so fast and could be classified as safe content spaces (e.g. /r/aww)
• User subreddit subscriptions - Rather than target ads based on the subreddit currently being viewed, why not use the subs people have voluntarily indicated they are interested in?
• Allow users to tag content - While people can report content to the mods today, there is no ability to tag content (like Tildes has) from a user level. Content that's inappropriate for advertising may not necessarily be a reportable offense. By allowing users to classify content, better models for determining "good" content vs. "bad" could be developed using ML.
• Use Mods to determine content appropriateness - User supplied data may introduce too much noise into any given dataset, and perhaps mods are a better subjective filter to rely on. Certain subreddits can have biased mods for sure, but without trying to overhaul content moderation entirely, could mod bans/flair be used to indicate suitable content for ads?
• Use computer vision to classify content - While this wouldn't work at scale, an up-and-coming post could have a nebulous title and difficult-to-decipher sarcastic comments. The post itself could be an image macro or annotated video that could be used to determine the subject matter much more effectively.

To be clear, the spirit of my initial prompt isn't "how can Reddit make more money?" per se, but how can it find a sustainable business model without destroying itself/impacting society at large. Facebook and Twitter seem to have optimized for "engagement" metrics which leads to prioritization of outrage porn and political divisiveness. Snapchat and Instagram seem to have succumb to being mostly an ad delivery engine with some overly-filtered content of "real life" influencers (read: marketers) strewn in between. None of these seem like a net-good for society.

What are all your thoughts? Perhaps Big Tech social media is irredeemable at this point, but I'm trying not to take such a defeatist attitude and instead explore any positive solutions.