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?

At work there's a project that was originally pitched as an automated system we would build for a new client, and now the conversation has shifted towards automating away some data entry tasks for an existing client. If the project is successful I would guess that some or all of the people doing the data entry tasks would be out of a job. And if it's a resounding success I would guess that the powers that be would be eager to apply it in other areas and potentially put more people out of jobs.

This project is in the very early stages of gathering requirements and whatnot so it's not really clear what exactly we're building or what my role in building it would be. But it involves a technology that's new to us (natural language processing) and often times I end up playing some role in a project that involves learning something new, even if it's just in some small way.

So yeah, I know automation replacing low-skill work is nothing new and if these jobs can be automated away, they will be sooner or later, but this is the first time I've been confronted with the idea of using my skills to put people I don't know out of a job and it sticks in my craw. Normally I love automation and interacting with new (to me) tech even if it's nothing groundbreaking and I'm just doing the plumbing to connect system A to interface B, but in the past it's always been in the name of freeing up people from tedious tasks so that they can do more interesting and more important work, rather than "freeing" them of their paycheck. So I'm finding myself adding this to the small but compelling pile of frustrations I have with this job and weighing it against the also-small but also-compelling pile of things I love about it.

Anyway, if you've ever been in a position where you were asked to automate away someone else's job, how did that go? What did you do?

If you haven't, what do you think you would do?

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?

What question have you asked yourself multiple times but have not come to a solid conclusion? Why have you not been able to come up with a answer that satisfies you?

edit: only now do I realize I misspelled quandry

Yeah, so I know there's about a week and a half left in Black History Month (which is in February here, for the non-US and I believe Canada folks who didn't know), and this rec list is therefore super late, but I've been watching some movies that were historically significant in terms of breaking racial barriers at mainstream award shows like the Oscars and in film production at large, were pioneers in getting films from African nations famous and acclaimed worldwide, or just generally covered racial issues of their times in significant or compelling ways, and thought I'd post the watchlist here in case anyone was interested. So I guess either binge all these in the coming week and a half, keep this as a guide for next year, watch any of the ones that interest you past February, or save it for October, which is when I understand Black History Month takes place in the UK.

• Within Our Gates (1920) - The first movie by an African American director to have a still surviving print.
• Eleven P.M. (1928) - A silent era film led by a mostly black cast and directed by enigmatic little known African American director Richard Maurice. An absolutely bizarre surrealist melodrama.
• Cry, The Beloved Country (1951) - This film examining the effects of apartheid in South Africa actually filmed almost entirely in segregated South Africa, possibly making it the first major film to do so.
• The Defiant Ones (1958) - Sidney Poitier was the first black man to be nominated for Best Actor at the Oscars for his role in this film. Details the story of two escaped convicts, a white man and a black man, becoming friends, with more nuance and layering than its premise and time period might suggest.
• One Potato, Two Potato (1964) - One of the first, and possibly the first, films to deal with interracial marriage in a serious manner. Predates Guess Who's Coming to Dinner by 3 years.
• Nothing But a Man (1964) - Realistic depiction of life in a racist society, consisting of a constant soul-crushing barrage of minor aggressions instead of huge explosions of hate. Selected for preservation in the Library of Congress and considered to be an important example of neorealism.
• Black Girl (1966) - One of the first African films by an African filmmaker to receive international attention and acclaim. Shows the lasting damage and effects of colonialism both in the colonized country and the lives of those displaced as a result of it.
• In the Heat of the Night (1967) - Tackled racial tensions in the South in the midst of the Civil Rights Movement of the 1960s. Selected for preservation in the United States National Film Registry by the Library of Congress.
• Guess Who's Coming to Dinner (1967) - One of the few films of the time depicting interracial marriage in a positive light and a serious way. Selected for preservation in the United States National Film Registry by the Library of Congress.
• Black Panthers (1968) - Documents a small but significant moment in the history of the fight against racism in the US, the Free Huey movement championed by the Black Panthers.
• Sweet Sweetback's Baadasssss Song (1971) - Considered an important film in the history of African American cinema, and credited as one of the pioneers of the blaxploitation genre.
• She's Gotta Have It (1986) - The debut film of famed director Spike Lee, an ahead of its time depiction of polyamory and female independence, it showed Brooklyn's black community in a light that drew media attention and focus to its artists and musicians following its release.
• Daughters of the Dust (1991) - The first by an African American woman to gain a general theatrical release (in 1991!). Selected for preservation in the United States National Film Registry by the Library of Congress.
• Malcolm X (1992) - A biopic of civil rights leader Malcolm X, also directed by Spike Lee. Selected for preservation in the United States National Film Registry by the Library of Congress.
• Girlhood (2014) - The film discusses and challenges conceptions of race, gender and class; Sciamma's goal was to capture the stories of black teenagers, characters she claims are generally underdeveloped in French films.
• Moonlight (2016) - Barry Jenkins' meditation on black sense of masculinity and the struggles of LGBT members in the contemporary American black community became the first film with an all-black cast to win Best Picture at the Oscars.
• Get Out (2017) - With this film exploring the exploitative horror of the modern white liberal brand of racism, Jordan Peele became the first black writer to win the Best Original Screenplay category at the Oscars, as well as the first to earn a Best Director nomination and a Best Picture nomination for a debut film.
• The Last Black Man in San Francisco (2019) - A film that explores the gentrification of San Francisco and the struggles in personal identity that arise from it.

I'd love to hear any feedback on the list or if you're gonna watch anything from it, and suggestions for any movies to add to it, especially between the 20s and 50s and the 90s and 00s, since those are especially massive gaps in my knowledge.

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?

So, my background is in software, mostly but not exclusively web development. I used to do both front and back end stuff, as well as sysadmin things. I worked with graphic designers a lot, some amazingly skilled people from whom I learned the importance of getting things exactly right, visually. Exactly right. Every pixel has to be perfect, every aspect of a design thought through carefully and then polished to perfection. I'm eternally grateful for the things I learned from those people. Programming and systems admin adds a different dimension to the art of "Doing Stuff Right", that of every case being accounted for and every exception or problem caught before it happens. Beauty takes many forms, both in terms of visual design and in software too.

This focus on detail, on perfection, has carried over into my current work in the physical realm. Making stuff that is machine-perfect isn't so hard. Especially when using machines (although I don't have as many machines as I'd like). Near-perfect radiused curves or dead-square edges are do-able by hand, and ultra-high mirror finishes leave exactly nowhere to hide on the finishing front. A single tiny scratch will show up on a mirrored ring like a beacon, a slightly mis-soldered joint will be visible from metres away. That's fine, and I'm getting much better at it. I like that I don't consider something finished until it's as perfect as I can make it.

What I find hard, perhaps ironically, is wonkiness. Imperfection. It's partly due to my background via commercial design, partly due to my experience in programming - and I'm sure it's partly due to me just being rather uptight about getting things "right" (I don't see this as being too terrible a character flaw, if I'm honest..) I'm not saying everything I make is perfect, not at all - but it's what I aim for a lot of the time - everything smooth and square and tidy and "right."

Japan has the idea of wabi-sabi, the concept of beauty in imperfection. It's a very hard concept to translate into words, yet strangely it's very obvious when you see it. "wabi-sabi nurtures all that is authentic by acknowledging three simple realities: nothing lasts, nothing is finished, and nothing is perfect."

So I'm trying to be more wonky. This is the kind of thing I mean. (more, another example)

These were formed by hand from modelling clay, then cast in pure silver. At first glance I'm not 100% happy with some of the textures and tool marks on the surface, nor with the not-mirror-smooth interior, but making myself uncomfortable is part of the point of this. Without stepping outside where I'm comfortable, how will I ever progress?

But then, it turns out that the more I see it, the more I touch it's soft organic curves and see how the light reflects and scatters off it's slightly orange-peel-like surface, the more I like it. It's human, relaxing: it has a gentle, quiet serenity. Being made of pure silver rather than the harder sterling silver, it will pick up it's own textures and marks with wear, making each piece as unique as the person wearing it. Sometimes that isn't desirable in a piece of jewellery, sometimes it is. There's enough metal in these rings to not risk their structural integrity in wear (a standard wire-style ring in pure silver will bend and break very easily), so why not let it do it's own thing?

"if an object or expression can bring about, within us, a sense of serene melancholy and a spiritual longing, then that object could be said to be wabi-sabi."]

It looks a bit lumpy and perhaps a bit sharp and pointy in bits but it's polished to feel soft and gentle. It's comfortable to wear, it's everything that machine-perfect is not - not that machine-perfect is bad, but there's more ways to beauty than perfect accuracy.

Another aspect to wonkiness that I'm trying to explore is that of lack of control. Making things the outcome of which is determined by factors other than me. With the clay-to-silver ring it's my fingers forming the clay, me (consciously or otherwise) guiding the shape. So I tried to find a way to take some of that control away.

Obviously just throwing a load of precious metal into a vice or a crucible or whatever isn't going to work, so I tried to set up a system where I could allow randomness to be present, but still having someone attractive come out the other side. With some heavy copper wire wrapped at intervals in fine silver wire, I let the blowtorch do the work, let the silver flow where it would. Obviously I still have some control over the output - I can choose where to apply heat or where not to, but it's a start at least.

With this technique, I made some bangles, seeing as I have a new bangle-mandrel (hey, I still need some machined help, right?). Here's how they came out

Again, like the rings before - the result is soft, unique, unpredictable. No two bangles are identical and never can be even if I wanted them to be, yet they all share common features. Just like nature, like trees or waves, clouds or even people.

I've noticed that I keep using the word soft. Metal isn't soft. Even polished metal isn't soft. It's solid, hard stuff. Why, then, do I keep going back to that word? It's because of the feeling these pieces evoke - machines are hard, people are soft. Emotionally, hard things are bad things, but soft things are nice. Nobody ever said "I can't wait to curl up in my lovely hard bed", and that's the kind of softness I think of when I look at these things. It's embracable, it's comfortable, it's like people or nature, not machines.

Have I found wabi-sabi? Do I even understand it to be able to know if I have? I don't know. I do know I've made some beautiful things using techniques and styles I haven't used before, and I've learned some things along the way, and for now at least, I think that's enough to be going on with.

Yeah, I guess this was a bit of a pretentious post. But I make jewellery. Some people even call it art (not me, but I am flattered and mildly confused when people say that about my work). I can be pretentious occasionally, surely?

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 list of all previous topics in this series can be found here.

@deimos has expressed before his dislike for alt-accounts, a position I happen to share. Alt-accounts makes users less accountable and more prone to misbehavior.

At the same time, deeply personal threads frequently require anonymity to be of any value.

To avoid alt-accounts altogether, I propose an anonymity with caveats:

1. Only accounts older than 60 days can comment and create threads anonymously.
2. Mods and admins can take action against the account that posted anonymously just like with any account
3. For the most part, the identity of the poster will remain a secret even from mods and admins.
4. For practical reasons, in the case of banning a user from the entire website, the identity of the user would have to be revealed to the admin that banned him/her. But that will only happen after the action is taken. This seems like a bad idea.

EDIT: PLUS FEATURES

1. The creator of the thread must tick a box to allow anonymous posts (they are opt-in).
2. Moderators and admins have the power of disabling this permission if deemed necessary.