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

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>

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?

So, I'm currently working up 2 1 gallon apfelweing batches. For a while I was doing many 6 gallon batches, but took a break for a while, and getting back into it.

Any other homebrewers out there? Anything fermented, even kombucha :)

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

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>

EDIT: We welcome your feedback and would love to hear your thoughts! Please support the creators by commenting on their work!

Introduction

The first Timasomo (Tildes' Make Something Month) has finished! A big thank you to everyone involved, whether you participated or spectated, and whether you finished or not!

Below is the work of the participants who have chosen to feature their Timasomo projects for the showcase. Enjoy!

Procedural Note

When commenting on specific works from the showcase, please ping those users using @username so that they get notifications.

Hope: The Stolen Wish

by @xstresedg

Link, itch.io link

When you pull the camera away, you get to see the world from a different perspective. This was the thought I had when bringing The Sword of Hope 2 from a Dungeon Crawler-like game into the style of a Metroidvania. However, with that came a number of challenges, such as dealing with the JRPG elements and utilizing multiple characters. While not present in this demo, they were idealized as possible, with tweaks. Regardless, while it isn't much more than a technical demo, I hope you enjoy this short jaunt of gameplay as much as I enjoyed making it!

Reusable Christmas Gift Bags

by @Akir

Link

Four Meetings

by @kfwyre

I wanted to make an interactive fiction story in Ren'Py. Four Meetings puts players in the shoes of Ms. Wilson, a high school teacher, as she makes decisions in four different meetings across four different days. It is a short story (10-20 minutes) meant to be played in one sitting.

Fragile Little World

by @Gyrfalcon

Link

Fragile Little World is a personal website, with a focus on sustainability and space. My main creations were the website itself as well as the first article, which covers the environmental impact of a web page and how that impact can be reduced.

Poetry

by @anahata

the city

Untitled I

Untitled II

fire

lost

Sir Curse Band Website

by @0d_billie

Link

I built this website for one of my bands, both to increase our online presence and also to (re)learn web design. It's pretty minimal for now, I'm waiting on things like a photoshoot, confirmation of a few gigs, and updated bios before I can get the rest of the site together.

That said it's been a fun exercise in web development, not least because I've been trying to keep it lean and light, so no JS or JQuery, and only a minimal CSS framework to work within. I've learned a bit of php, how to use github, and how to accept that Minimum Viable Product still has the word "viable" in it.

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!

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?

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.

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

If you have any plans, things you want to get done, things you have done, things you haven't done, or even if you just want to talk about how you're doing this weekend, this is a place for casual discussion about those things.

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

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

I would host a competition that measured strength, speed, agility, endurance, and intelligence. I would measure strength using some strongman and some powerlifting lifts. I would measure speed with 100 meter sprints. I would measure agility with some kind of ropes course, obstacle course, and gymnastics meet. I would measure endurance with a triathalon plus rowing (a quadrathalon?). I would measure intelligence by testing ability to memorize a bit of text in their mother language, teaching them the rules to a made-up game (Calvinball anyone?), and testing them on some trivia game with a format like Jeopardy. What would you measure, and how would you measure it?