This topic is part of a series. It is meant to be a place for users to discuss creative projects they have been working on.

Projects can be personal, professional, physical, digital, or even just ideas.

If you have any creative projects that you have been working on or want to eventually work on, this is a place for discussing those.

A friend shared a troubling website with me. I'm not 100% sure why I found the site so troubling, but one thing that stands out is its slick sophistication. There are two primary facets to this sophistication: the organization and the presentation. https://defeatthemandatesdc.com.

The presentation is, at very first glance, about what I would expect from a leftist or progressive group. It didn't take long for me to detect something was off, and an a quick reading of what they are after confirms it's neither leftist nor progressive. But that very first impression, which was followed by a sense of confusion as part of my subconscious detected the true message, was unique for me, I can usually detect political bias instantaneously. (This is a curse more than anything else, a symptom born from trauma, but that's another discussion.)

Regarding the organization, it seems focussed and professional. There's some real effort and intellegince both behind the design and messaging at least. If that is representative of a larger effort, that indicates significant funding and effective organization skills at play. I can't quite articulate what's differnt from previous and ongoing, similar efforts. There's something, fundamentally different here that projects real power, depth, and sophistication, and that is deeply disturbing. Efforts like whatever was behind Jan 6 seem chaotic and angry. This effort feels more collected, dispassionate, focussed, and expansive.

What have you been doing lately for your own fitness? Try out any new programs or exercises? Have any questions for others about your training? Want to vent about poor behavior in the gym? Started a new diet or have a new recipe you want to share? Anything else health and wellness related?

Define “major platforms” and “noteworthy” however you like, but I’m thinking of this as stuff you can’t find on Steam/Origin/GOG, etc.

I’m interested in people surfacing things like small itch.io projects or standalone downloads from the creator’s website or abandonware that’s never seen the light of day in digital distribution or cool romhacks — anything that’s worth a look but that someone would really have to go digging in order to find.

Hey all, I'm transitioning from a plain old software engineer at my company to tech lead (first in responsibility, then eventually in title)!

I'm very excited about the opportunity, but the role is new, both for my company and personally. Would anyone have recommended reading I could peruse? I'd love to get a solid footing for what I should be doing as a tech lead, and how I can do it well!

On and off throughout the years, I have attempted to make my online footprint as small as possible, taking steps such as:

• using pseudonyms on social media
• creating a new account every year or so
• overwriting old posts with a new message blanking out my original post
• "deleting" posts after a few days if the account has a higher probability to be tied to my real life

The last point, I put quotations around deleted because I understand that once I post something, it is not ever really deleted but it adds a barrier of entry to trying to dig into my personal life. Pushshift comes up because, try as I might, I seem to have difficulty getting accounts removed from their searches. Additionally, I think they allow you to download reddit data in bulk so even if I were able to get my name removed from the search results, the data could still exist on someone's hard drive, somewhere.

From your perspective, are services like Pushshift, that archive people's information without their explicit knowledge, ethical? On the one hand, I think of detestable content that users might post then delete later to avoid accountability. On the other hand, I think of people like me who want to keep their data footprint as small as possible because of the crazies who might utilize this information to do harm.

What have you been watching and reading this week? You don't need to give us a whole essay if you don't want to, but please write something! Feel free to talk about something you saw that was cool, something that was bad, ask for recommendations, or anything else you can think of.

If you want to, feel free to find the thing you're talking about and link to its pages on Anilist, MAL, or any other database you use!

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?

Have you watched any TV shows recently you want to discuss? Any shows you want to recommend or are hyped about? Feel free to discuss anything here.

Please just try to provide fair warning of spoilers if you can.