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?

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?