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

I know this has been posted before, but I was going through old posts about blogging and at least half the blogs linked in the comments were offline now, so I thought I'd bring this topic back to light.

Do you run your own personal blog, and if so, could you share some details?

• Is it self-hosted, or do you rent server space?

• Do you use Wordpress or another blog platform like that, publish through other means like a flat-file CMS, or did you build it from scratch?

• What topics do you write about?

• How consistently do you post; or alternatively, why don't you post as often as you would like to?

• Do you keep analytics, or do you write regardless of how many clicks you get?

• Is your site monetized with ads or otherwise?

• How popular is your blog on average?

• How do you keep up with other writers' posts?

I'm bringing this up because it seems like most places around the web centered on blogging are more in it for the money rather than for the content. Places like /r/blogging and the like are all talk about how to maximize views, earn revenue, and find your niche. I'd love to see some discussion more geared towards the content and construction of individual blogs, as opposed to people trying the next "get rich quick" scheme on their lists of passive income opportunities.

Personally, I have multiple blogs for the sole purpose of giving me a platform to voice my opinions or share things that interest me without being constrained to a centralized platform like Twitter or Medium. I'd love to hear what you have all made and/or shared online, as well as the process behind making it happen.