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?

Hi folks, I hope this is ok to post.

Flow (also known as 'the zone', and others) is a mental state of profound task-absorption that makes a person feel one with the activity in which they are involved - I'm sure many of you have experienced it.

I'm on a team of people doing research on flow theory, and we focus on people employed in software development. Our goal is to help make the office a better place for employees, by understanding when and why people enter flow. We prepared a survey for some work- and flow related topics, and it would be of great help if you could take and maybe even share it.

Completing the survey only takes 2-5 minutes of your time, and we will handle your anonymous entries with utmost care.

Link: https://forms.gle/efqTMk2oVDVEGcgT6

Thank you!

I am a fullstack developer that spends a good portion of my time building out complex User Interfaces, and the rest building out back-ends for that software. In my opinion the current method that my company uses for a designer to developer hand off is a bit lacking in efficiency.

The current method is usually a designer will provide a developer with a Photoshop (or very occasionally an Illustrator) file containing the entire applications design. It is then up to the developer to export assets (both quick exporting things as pngs, going through and separating shadows from assets, or creating assets from the layers provided) and dig through the file to determine fonts and placement of items.

Is it a common expectation that a developer should be spending a good chunk of time in Adobe on asset manipulation?

Additionally does anyone have any process or program suggestions that may make life easier?

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?

Hi. AVG's been bugging me with reminders to renew my subscription recently, but I don't have the money for that. I've been using AVG Free for years, but each time I trial the full edition it seems to install as a separate program, and then I have to manually revert back to the free version once the trial's up. The only other anti-malware I use is MalwareBytes (free again).

I'm not too worried about using a VPN, and have been advised to avoid the free ones anyway. I'd really just like a decent alternative to AVG Free that won't mess with my Steam games or pester me to upgrade several times a day. I have almost no experience with other anti-malware programs, so I'd rather ask people in the know for advice than just install something straight away and find out that it does one of the aforementioned annoying things.

...Should I use a free VPN? I'm trying to save as much of my scant moolah as I can, and I do occasionally torrent things, but the free ones are allegedly a little shady.

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 read the AskReddit thread on "What costs less than $100 that changed your life?" (link unavailable since I'm at work) but someone responded "SQL" - jobs just open up that make a ton of money.

I did a cursory search on Indeed and holy moly they were right -- SQL jobs get easily 2x what I make now. I'm pretty good at Excel and that sort of thinking, so I was thinking I'd try taking a class.

Do yall have any recommendations as to a good course to take in SQL, preferably online, preferably free or cheap? I'm willing to pay a bit if it'll mean I can make a lot more, but I'm currently not making a ton, haha.

Any responses welcome, including ideas as to how to break into like, tech-oriented fields as well.

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