I have two computers (a desktop and a laptop) that broke down just before my city entered a lockdown. Being able to assemble and fix my own computer hardware is something I have always wanted to do, and if I knew that I would probably not be using a borrowed Macbook Air right now.

I have no immediate need to provide any maintenance services, nor do I require a primer in electronics or anything too advanced. Just enough to know how to assemble and disassemble a machine, identify and fix the most obvious issues without breaking anything.

I tend to learn better from sequential and structure learning materials, preferably in text/images form. But videos are also welcomed. I know the names of the things and what they are, but I don't really know how to put things together in practice.

Suggestions? :)

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?

Inspired by @moocow1452 original post on donating computer resources towards the cause of researching coronavirus. This new post is to organize the Folding @ Home information to be at the top of the thread for new users who may be interested in donating their resources to the cause.

• Folding @ home: Coronavirus - What we're doing and how you can help in simple terms
• Folding @ Home Download here
• Tildes Team number: 238330
• Folding@Home Passkey registration
• Folding@Home Points information
• Folding@Home Team stats
• Extreme Overclocking team stats details
• Folding@home Active Projects - Where you can look up what your Work Unit is related to
• Folding@home Server Stats - Server Status, Assignment/hour
• Folding@home Client Stats - OS, CPU and TFLOPS count totals

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?

Hi tilders. I'll keep it brief: I'm looking for people of various technical skills (devs, sysadmins, etc) willing to volunteer their skills at labs, hospitals and other establishments in the fight against COVID-19.

A lot of us are lucky to be some of the least-affected by the virus. Not only is the technical field generally young and low-risk, but it's one of the most compatible with work-from-home professions.

So I'm trying to use some of the free time during this lockdown to set up a volunteer network, focused on tech.

I'm looking for two types of people specifically:

• Anyone with tech experience: programmers, web devs, devops/sysadmins, etc; who has time they want to spend on this.
• Anyone who works in or adjacent-to the medical field, who can help with identifying high-priority and impactful needs (who needs help the most, and how to reach them most efficiently)

Note: The immediate goal is to build up a network of potential volunteers. I've been doing this on my own for a bit and there's clearly lots of needs, but it's hard to convince labs and hospitals to onboard a single person, so I'm hoping to get more people on board before continuing the search.

Stay safe.

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 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 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?

A while back I developed a desktop-based text editor (Scrivenvar) that uses the Chain-of-Responsibility design pattern to help me author fairly involved text documents. The editor's high-level architecture resembles the following diagram:

https://i.imgur.com/8IMpAkN.png

Am I reinventing the wheel here? Are there any modern, cross-platform, liberal open-source (LGPL, MIT, Apache 2), text editor frameworks (such as xi or Visual Studio Code), that would enable (re)development of such a tool?

Scrivenvar is written in Java, but to my chagrin, Java 9+ no longer bundles JavaFX. The text editor was based on MarkdownWriterFX, itself based on JavaFX. This means there's no easy upgrade path, so I'm looking to rebuild the editor either as a cross-platform desktop application or as a web application.

After using Shreddit to delete my Reddit history periodically for some time now, I finally decided to make a cron job to automate it on a weekly basis. I use it to delete every post and comment that isn't whitelisted, which right now is just a tiny subreddit for a musician I like that I solely moderate and a pinned post explaining why I have a bunch of karma but barely any posts.

After setting this up, it got me curious as to what tasks other people automate in their lives in order to streamline their workflows and eliminate minor (or major) routine tasks.

So, what do you automate, and how did you go about doing it?

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?