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?

Looking to pick up a domain name for a personal site and was wondering if anyone could recommend a good registrar. The whole domain name industry always feels more than a bit shady, so I'm wary of most of the providers.

Hey everyone, just watching a very interesting history of Terry A Davis (creator of TempleOS) and around the 30 minute mark there is a list of questions Terry asked to God and the answers he believed he received. I took a look online but was unable to find anything. I don't suppose anyone out there has a link? I'd be very interested to read it. Thanks in advance.

EDIT: I'm also interested in any links to the art he created (hymns, visual art etc).

Some of my favorites are:

git add -p *

This will go through your unstaged changes in chunks and allow you to stage each chunk individually in an interactive shell.

git checkout -p *

Similar to the above, this will go through your unstaged changes and allow you to undo each chunk. I almost never use Ctrl+Z anymore and go straight for this. Want to remove all of those print-debugging statements? Use this command to pluck them out one-by-one.

git commit -a --amend --no-edit && git push --force-with-lease

I alias this one to whoops in my bash profile. It will add all unstaged changes, add them to your last commit and then (safely) force-push the local branch to the tracked remote branch. This is especially useful when working with CI and you need to make constant configuration changes to get it to work. Yes, you could squash those commits afterwards as an alternative. But this is easier.

git rebase -i HEAD~5

(Change 5 to the number of previous commits you want to see)

Interactive rebases are a core part of my git flow when working on feature branches. If a co-worker gives me feedback on a code review that requires a change to a previous commit I'll go back and edit that commit using this command. You can remove individual commits, squash commits, reorder commits, and so much more.

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 recently came across an article about setting up automated builds (installation, code quality check, running tests) using Github Actions. I've since found a few more articles excitedly promoting the feature and, from my personal testing, it seems to work quite well.

I was wondering if others had begun using this feature for their own projects, or had tried it and disliked it and used something else. Is there any broader community consensus towards which tasks it's best-suited for and when to use something more robust?

In terms of

1. Utility: It is useful!
2. Reliability: It will always work when you need it to!
3. Uniqueness: It gives you the option of doing things that would never have been necessary before it came along.
4. Aesthetic: It satisfies your sense of beauty: It gives you the same kind of feeling a painting or a poem would.
5. Transcendence: It transcends the zeitgeist and is the simplest it can and thus ought to be.

Mine are:

1. Vim
2. mutt
3. The Lucas Arts point and click adventure games
4. A Lisp interpreter
5. grep

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 like reading about the development process of technology products (software and otherwise), even when I don't understand the tech bits.

Maybe due to their open nature, it is not hard to find detailed articles, mailing list answers, and interviews that go deep about FOSS. But I also have an interest in massively successful/unsuccessful products with large, rich and sometimes convoluted creation process. So things link Linux, Windows (all versions), Mac OS, the iPhone, iOS, Android, etc.

My interest is not necessarily in biographies or accounts that deify so-called technology geniuses, but rather in narratives that don't shy from the nitty-gritty details of the technical/creative processes while also addressing the human/personal side of things.

It also doesn't need to be educational at all, I just realized these stories are enjoyable reads.

Any suggestions? ;)

I have basic notions of HTML and CSS, but nearly zero JS knowledge. I can perform simple customizations and I know how to follow instructions.

It is not my intention to create anything from scratch (so the platform should have plenty of free themes), nor do I want to become a webdev or webdesigner. This is not a technical project for me, my main concern is the content.

I currently have a blog that uses Wordpress with a purchased theme. It's good enough, but a bit slow to load. Besides, simpler platforms might be easier to understand and manipulate.

This alternative would also need to be FOSS and easy to self-host.

As a plus, it would be awesome if I could manage the blog/website from within Emacs/Org Mode.

Any ideas?

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?