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?

This may seem an obvious question, but not as much as it seems. She uses Windows, I’m currently using Linux/macOS. How to instruct her to install her Python environment? Should I use Zoom, Skype, Google Hangouts, or another solution? Is there and easy way for live-drawing (online blackboard) to explain things to her visually? And, perhaps most importantly, how can I do that for free?

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?

Following up on @freddy's query about self-hosting ...

I am trying to set up a self-hosted VPS running Synapse (the server-side component of Matrix), Riot-web, and bundled in Jitsi. I've twice gotten it up and running successfully for internal accounts/users, but federation keeps throwing weird authentication errors when trying to connect with user accounts from other server instances (a week later, my regular Matrix account still has 3 outstanding broken Invites from the new server-account which I can neither accept nor reject ... ).

I'm basically following along with this youtube setup tutorial (except I am using Apache rather than nginx).

Before I start to drill into the nitty-gritty of my issue(s), does anyone here have experience setting this up? Anyone care to dedicate a bit of time and energy to helping me figure out what I'm doing wrong?

Additionally, I saw commentary from @smores that Jitsi isn't performing well for him on his self-hosted server ... any further details you can share?

Edited to add:

Sorry all, I didn't think through the timing. I am still motivated to get a self-hosted Matrix instance up and running; however, right at the moment, I have a couple of other, higher priorities I need to attend to first. If I'd thought about it, I would have held off on starting this thread for a couple of days.

I will get back to this thread ... let's say, Wed or Thurs ... take another crack at the Matrix set-up then, and provide details here, as I do.

Thanks,
EtC

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?

I have a few weeks left before I finish my MBA and I turn 26. I decided to spend the free time I have since my cancelled finance internship learning how to program. I enjoy it a lot and could easily see myself working as a Software Engineer. Prior to my MBA and the finance internships I did, I was a video editor and colorist with a film production bachelors.

I started with App Academy's Introduction to Ruby I and II courses but I quickly realized that even if a boot camp would work out for me, that specific one would not work out due to geographic location. There is a Hack Reactor branch close to my parents house in Los Angeles, however I feel like if I choose to enroll in a boot camp I should learn as much as I can on my own first; doing it now seems like I would be subjecting myself to financial peril, especially in light of COVID-19.

I am now taking the edX MIT 6.00.1 Introduction to Computer Science and Programming Using Python course. One of my friends gave me access to a udemy MTA Networking Fundamentals course and I was considering working through that alongside the MIT one. The MIT course only takes around 15 hours per week, so I need more classes/projects to help fill what is ideally a 50 hour work week in order for me to really grasp these concepts. I know at some point I have to begin to build projects, but I do not believe my fundamentals are quite there. If I'm wrong, I would love some pointers as to how to begin.

If anyone is able, I would really appreciate some guidance in three main areas. First, is my timetable realistic? I have enough overhead and family help to last me to December before I start looking for work OR enroll in a boot camp, the latter of which would require some additional help. I feel that if I diligently study from now until then my family would be willing to help me out a little bit.

Second, would a boot camp actually be worth it? I realize that a solid portfolio is the #1 thing that will get my foot in the door somewhere but I'm not sure if I would have one that is as fleshed out as I might need by December. Some alumni from my school went through Hack Reactor, but the amount of CS students currently working as SWE far outnumbers the two folks I have found so far that pivoted from Economics and Film Production into SWE. I see the boot camp as serving two purposes: demonstrating that I have what it takes to commit to something and see it through (similar to my two degrees, just for programming) and helping add a few items to my body of work. The financial obligation is a bit concerning, but if I truly was able to find a job at the end of it the ISA would feel worth it.

Finally, how can my lesson plan be improved? I intend to finish this MITx course over the next six weeks (I'm working through week 2 right now). Is the MTA Networking Fundamentals course a good compliment? Are there other courses that might be better? I own the book Programming Principles and Practice using C++ by Bjarne Stroustrup and have read that it is a solid introduction to both C++ and programming fundamentals, similar to the MITx course. I intend on starting and finishing a Version Control with Git coursera class this coming week. What more could I add, are these the right things to focus on, and is this even a realistic endeavor for me?

My interests are web development, app development, and data analytics. I feel each of these would be its own path, but if someone could help me narrow this list down to one that best suits my past experience, has complimentary skills, and seems like it would be a good fit it would be much appreciated.

Any advice helps!