This thread is posted weekly - please try to post all relevant US political content in here, such as news, updates, opinion articles, etc. Extremely significant events may warrant a separate topic, but almost all should be posted in here.

This is an inherently political thread; please try to avoid antagonistic arguments and bickering matches. Comment threads that devolve into unproductive arguments may be removed so that the overall topic is able to continue.

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 don't know if my question makes any sense, and it's okay to say "No, sorry, it doesn't work like that".

I have a (pirated) dictionary that has the words and definitions in an sqlite3 database format.

I want to convert this into something that can be used by either Fora, GoldenDict, or StarDict.

Fora can use StarDict, DSL, XDXF, Dictd, and TSV/Plain dictionaries

GoldenDict can use Babylon .BGL, StarDict .ifo/.dict./.idx/.syn, Dictd .index/.dict(.dz), and ABBYY Lingvo .dsl source files.

I've found lots of software that goes the other way - it'll take a dictionary and dump it into an sqlite database. But it doesn't go the otherway.

Is what I'm asking for coherent, does it make any sense?

(I'd prefer Windows, or FreeBSD, but at this point I'd install Linux to get it done).

I just saw eggs at $3.06 for a 36 pack at my local Walmart. Not too long ago a 12 pack was pushing close to $7.00 in my area.

What’s up with that? Is the greedy egg price gouging catching up with the farms or something?

Wasn’t sure where to put this one.

What have you been doing lately for your own fitness? Try out any new programs or exercises? Have any questions for others about your training? Want to vent about poor behavior in the gym? Started a new diet or have a new recipe you want to share? Anything else health and wellness related?

Anyone metal detect or coin roll hunt? Or magnet fish?

I do both, ive coin roll hunted for a year, and I just started metal detecting a month ago

I'm in canada, which has pros and cons for metal detecting, a con would be all our modern coins are made of plated steel, so they both sound bad when you swing over them, and the rot beyond use in not that long time

A pro though is we have 1 and 2 dollar coins, in the states you might go a year before swinging over a Sacajawea dollar, but in canada you might find multiple loonies on the first time out

In a bit over a month, of metal detecting I found 2 sterling rings, a silver dime(it was a fresh drop not ancient) and a sterling earring, the earring was gold plated, I was hoping I found gold till I saw the 925 and makers mark, looked on the makers website and it was all gold plated sterling

Coin roll hunting I recently hit the jackpot of the year most definitly, four whole rolls of silver dimes, thats $380 and only cost me $20 to aquire

There're maybe 2 aspects to the question: what makes you prefer a certain genre over another? and within that genre, what criteria makes you think one piece performs better than another?

I get that this is a very subjective and probably subconscious thing. Just curious to see how everyone would describe their own tastes.

For me I'm not much of a music person, most music I found were just soundtracks from films or videogames. So I guess the music is good if the film/game is good. Listening is a way to put me back into the moods of the scenes it came from.

Edit: I also listen to meme songs a lot so I guess I like them for just being funny, which is not a very musically relevant criteria I suppose

Roughly knowing how many times each tag has been used would provide users actionable information if they would like to search or filter by tags.

It might improve UX when applying tags, but might have undesirable side effects in user behavior.

I can think of three places this might be implemented, and I don't know which, if any, we want:

When filtering topics by tags:

• informs users how large or small their scope is
• this view should probably be kept somewhat up to date

When looking at a topic's tags:

• informs users where to start searching/filtering
• passively builds a frame of reference for how tags are used?
• this view could be allowed to become outdated and stale without issue

When applying tags

• a more common tag might be less accurate, but it might be more helpful?
• in the auto fill issue weight by frequency was proposed, which is somewhat similar but more opaque
• this should probably use pretty recent counts as well

Official Announcement

NYTimes Article

Apollo Apollo (well known iOS client) developer talking about the specifics. Sounds like the API will now be paid based on usage.

It's a bit easier to have an opinion after the Apollo developer revealed the specifics Reddit gave him. Other than the NSFW part, which seems odd considering the API will be one of the revenue streams that isn't advertiser supported, it seems reasonable, of course waiting on the final price per usage.

It was never going to be sustainable for Reddit's API to be fully free. It was just silly - you could use the whole site, which certainly costs money in both AWS fees and developers doing KTLO, and not see any advertisements via the API.

App developers will pass the costs along to the user, many will likely fold because it won't be commercially viable with the additional cost, but, well, that's the way of things.

Do any of you have mini computers in your home?

My roommate recently bought a plex server and has stated self hosting. I also wanted to get a mini computer to do my own self hosting but was wondering if there were any Linux based computers on the market.

I currently don't know anything about programming so am considering picking this up on the side in case I loose my current job and need a backup plan. Anyone knows any good books or online courses or anything else for self-learning?

My friends said programming is too broad a subject and what you need to learn depends heavily on what fields you want to go in, which I'm ashamed to admit also know nothing about. So I guess I need some career advice too if possible.