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?

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?

I’m currently studying Python Object Oriented programming and got to a point where logic and syntax are the least of my problems. I always get to a stage where I’m completely lost between modules, classes, objects and a sea of “selfs”.

I’m not doing anything too complicated, just small projects for practice, but I think I would benefit from planning. My mental processes are highly disorganized (ADHD) and I need all the help I can get with that.

I don’t need an automated tool (even though it might come in handy) -- sketching things out on paper is probably enough.

I only know about UML, which seems fine. Can anyone recommend a tutorial about this and other tools?

Edit to link my last attempt at following a tutorial:

This is the last tutorial I tried to follow, a Pygame project from the book Python Crash Course 2ed. Following tutorials is frequently mostly typing, so what I achieved there is not a real representation of my abilities -- I would not be able to do something like that on my own. In fact, I failed to answer the latest exercises, which were basically smaller versions of this project.

My problem is not with syntax and the basics of how OOP works, but rather with memory and organization of information.

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?

Sorry if this is a silly question, but I keep running into situations where a small CLI or GUI tool that could be handed a single file and hand me back an encrypted version would be useful. I've done some googling, but all I typically turn up is blogspam about random Windows-only tools that seem to be of dubious quality.

Anyone know of a good tool for this type of thing?

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?

In the DC canon, The Mobius Chair is a time-space/dimensional vehicle operated by the New God Metron. It allows him to travel and observe the universe, but the one I'm making is nowhere near as functional.

I've come into a recliner chair with a cupholder on each armrest, and I already had a split keyboard. My plan is to use the cupholders as a mount for both ends of the split keyboard, so that I could use the entire run of armrest and have my hands lay naturally on the keys. Goals are to minimize weird stretching and be able to comfortably type for long stretches of time, to put off stuff building this that I planned to work on this weekend, and to look super boss, though not necessarily in that order.

If I want ultimate angulation and the best range of motion, I was thinking about something like a cupholder with a phone or a tablet mount, like this one, but if anyone has recommendations for what would be best to work with, or have done something like this before, I'm all ears.

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?

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?