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?

Have you watched any TV shows recently you want to discuss? Any shows you want to recommend or are hyped about? Feel free to discuss anything here.

Please just try to provide fair warning of spoilers if you can.

I've been trying to learn CSS. I went through the relevant sections of Colt Steele's Web Bootcamp. It is mostly focused on Bootstrap, which disappointed me a bit. So I went through MDN to learn Flexbox and CSS Grid, which seemed like a better alternative. The fundamentals are easy enough, but when I try to make a layout everything gets mixed in my head (even though I have the documentation open at all times). The impression I get is that modern CSS is not one thing, but a bunch of little things that resemble each other in a confusing way. It's hard to infer stuff and there are gotchas everywhere. I know this is not a programming language, but it is at least programming-related. Learning CSS feels more like learning English than a technology: you must accept that it's not a cohesive system, but rather the culmination of a long historical process full of random developments.

I tried getting back to Bootstrap, but then I have to override a bunch of stuff I don't even know is there.

I'm having a lot of trouble trying to put something very simple together. I just wanna leave that behind and go back to my beloved Python.

I did not want this to be a rant, but it is now a rant. So be it :P

This post has now a soundtrack.

So, I'm planning on building yet another browser (based on Firefox, since we already have too much Chromium forks around)

I'm intending to target the people worried about their privacy, but aren't technical enough to dabble with about:config tweaks and deal with any site breakages.

So, for this project, I'm planning on doing the following modifications to Firefox:

• Tweaked by default to get a balance between increased privacy, and less site breakage
  • Tweaks include cutting any "background" communication with Mozilla (while I trust them, some people might not) and Google (safe browsing, geolocation)
  • Maybe, possibly, an "advanced privacy settings" menu for more privacy settings in exchange for site breakage?
• Integrated ad blocker (Decided on uBlock Origin, maybe adding Nano Defender to bypass any nag screens)
• Maybe a way to "pretend" to be a Chromium browser, since some sites require that nowadays (More user agent complexity, yay!)

So, this is where this thread comes in. What would you guys want in a (Gecko-based) browser, that I can provide?

I am definitely not planning any substantial under-the-hood changes, since that would
a) make maintaining it a pain
b) be way out of my skill level.

I am only looking for stuff that can be applied with some simple source code patches, or an integrated extension, as I will not "fork" the entire FF source. This project is essentially a rebranded patchset. (Also allows for faster updates!)

ps: Please be realistic, and remember that this is a one man thing. I can not make any substantial changes, like bringing XUL add-ons back, if you know what those are.

pps: If you can, and are willing to help with anything, let me know and I'll put up a repo online :)

ppps: Please let me know if I've made a mistake while creating this topic.

Today's problem description: https://adventofcode.com/2019/day/10

Join the Tildes private leaderboard! You can do that on this page, by entering join code 730956-de85ce0c.

Please post your solutions in your own top-level comment. Here's a template you can copy-paste into your comment to format it nicely, with the code collapsed by default inside an expandable section with syntax highlighting (you can replace python with any of the "short names" listed in this page of supported languages):

<details>
<summary>Part 1</summary>

```python
Your code here.
```

</details>

Hey everyone,

I noticed accessing Wikipedia today that my old version of the app no longer loaded any pages, so I tried checking with my stock browser and it displayed a warning that Wikipedia is dropping support for anything that can't negotiate TLS 1.2. I haven't seen any articles on it yet online, so just thought I'd holler a mention.

I personally see:

• The enaction of the progressive policies that have been continuosly amplified over the last 5 years during the election of Bernie or Warren (in the US, be it after 2020 or 2024)

• Increasing regulation of the Internet (be it the breakup of tech conglomerates, increased pressure by VC investors for the companies in the red to turn a profit or more surveillance by 3-letter agencies in bad faith)

• Increased tension between the US and China as China becomes increasingly more powerful especially over tech companies

• A recession which throws the item in the top 15 years down the line.

• Automation and AI begin to become more pressing issues during the next depression, leading to people taking candidates like Yang more seriously.

• "Apophis 2029 is gonna hit the earth." "Finally."

Edit: Ok, here's some non-political predictions:

• Mojang runs out of already existing biomes and dimensions to overhaul in minecraft, so they'll shift their development focus to adding more unique biomes, worldgen and mechanical depth and maybe some sort of progression to the game (more complex combat, more dimensions, more bossfights, more mobs like the iron golem with better attacks, more Redstone components, more unique worldgen). By the time this happens, hytale will already be a big competitor and great at al this, causing high controversy that Microsoft is stealing their ideas.

• This also applies to mobile phone makers as they get rid of all notches, bezels and ports and so they either focus on specs and battery life and nirvana is supposedly achieved at 1600$ per phone, in making the phones as cheap as possible , which makes people get mad about the working conditions of the laborers or in even more exclusive wearables like now.

• A new manned moon landing, finally. This time the whole journey will be streamed live on an 8k camera via starlink.

• The (further) normalization of anime, similar to what happened to gaming this decade. More people from more different backgrounds will be watching anime, and they will be less focused on self-depreciation because of it. They will watch anime in public, and will demand more and better anime from the production teams in Japan. The more diverse audience will mean that fanservice will be gradually less effective and non-tanned black characters will appear way more often (and someone will lose their shit over it).

• HN finally comes up with a site redesign, mainly to make it clearer which threads are which. The new design is similar to Tilde's now and HN usage grows 3-fold.

This topic is part of a weekly series. It is meant to be a place for users to discuss their week.

If you have any plans, goals, accomplishments, or even failures, whether they be personal or work related, I'd love to hear about them. This is a place for casual discussion about your week, past, present, and future.

A list of all previous topics in this series can be found here.

So, what (or how) are you doing this week?

I'm looking to get a couple of remote controlled dimmer sockets for a quite specific use case (heat lamps in a tortoise enclosure), and I'd like to control them directly from a Raspberry Pi. I've found a couple of decent looking fairly generic options - examples from Trust and TKB - and there seem to be several appropriate radio modules, either USB or GPIO.

Detecting and pairing with devices seems (hopefully) straightforward. My sticking point is trying to figure out how standardised the actual messaging is; there seem to be several brands of hub and device that can be used interchangeably, but a few that can't. In my case, of course, the RasPi will be taking the position of the hub and speaking to the devices directly.

I'm having trouble finding reliable info on whether a command like "dim to 70%", or "read output power" will be the same across all devices, whether it will follow some kind of standard but it may be one of several competing formats, or whether it's completely proprietary.

Any insight on how easy it is to programatically talk to these things would be very much appreciated!