An experiment I've been thinking about lately: a (recurring?) Q&A thread! Ask any questions about programming, answer other users' questions, 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?

Meta questions:

• Should I turn this into a recurring thread?
• If yes, should it be a weekly or a monthly thing?
• Should DBA and SysAdmin questions be allowed or should someone else make a separate recurring thread for these?

Introduction

I hate medium and I think it should die a slow death. I tried to get some information on the subject to substantiate my belief.

What Medium Does Bad

Medium is slow

On Gmetrix, medium.com has a F PageSpeed Score, with a 11.8MB Total Page Size and a Fully Loaded Time of 12.4s . A random article got a little better, with a D score

Pingdom gives Medium a B score, with a page size of Page size 12.4 MB and Load time 2.15s (much better). This is from San Francisco, USA.

Probably because I’m closer, the results for São Paulo, Brazil, are marginally better. The B score remains, but Load time dropped to 1.68s.

Tildes gotta a C on GTmetrix and an A on Pingdom. On Google, Tildes got a 98 and medium.com got a 48.

What is probably more concerning is that builtwith.com’s lists 106 different technologies at use on a single Medium page, ranging from AngularJS to Subversion, Wordpress Grid (aren’t they competitors?), Microsoft Azure and AliExpress. Tildes list only 13 technologies.

Medium is annoying

I’m sick and tired of opening a random Medium article and being bombarded with an immediate call to action for me to subscribe or to sign into a useless mailing-list. No: I do not pardon the interruption.

It’s 2019: I don't wanna sign-in just to read a free fucking article.

Medium weakens your brand

On Medium, you’re not a content maker. Your a Medium contributor. There’s a great difference. There are little customization options, but you’re encouraged to strengthen the Medium brand instead of your own.

Medium does not support Markdown

In 2019, this is utterly ridiculous. I should be able to write my posts in Emacs, Vim, VS Code, whatever. Markdown is a universal format that simply works and not supporting it natively is unacceptable.

The Default Editor Sucks

It forces you to write in a certain (clunky) way and it doesn't work at all.

Too Much White Space

Medium uses space poorly.

Not FOSS

Wanna host your own? No can do amigo.

Your content is not (really) yours

Wanna export your Medium posts? Should be easy, like a single button, right? NOPE. And it can stop working at any time.

Most Content is Shit

I don’t wanna generalize, there are some good things on Medium. But most Medium articles are bellow 300-words, full of unnecessary subtitles with nothing more than obvious statements I could easily get from Google. Most Medium articles are from developers trying to leverage their status by showing knowledge of trivial technologies.

What Medium Does Right

A Social Network With Content Instead of Content With Social Networking

This is something no amount of Wordpress widgets will ever top. Medium is a social network. It gets views, it gets you “applauses”, it gets you validation. It’s the Instagram of text content. Medium makes you feel good about yourself, and give you the shot (illusion?) of exposure. Maybe you can be in a publication, which is just an assortment of posts within Medium itself! See, you’re growing! You’re reaching a larger audience! They might even read your stuff!

The Alternative

It is obvious that Medium does a lot of things right. It is an actual social network that engages people like no other current blogging tool. People that know better use Medium to their advantage. People use Medium to talk trash about Medium. So we need another Medium. One that is just as social, but that is faster, less annoying, less of walled-garden and respects your content. I’m not in a position to do such a thing yet. But I certainly wish it existed.

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?

Please.
Please-

Not like this,
no- hell no- no- No!

That's not what I want, I want
to grow:
up;
out,
somewhere nice.

Where? I dunno; not here, not here, over th--not here, somewhere--
else.

Please.

'Cause if I'm right here I can't grow, I can't do what--
i cant breath!
--can't do what I CANT BREATH!

can't breathe? where? here? no? there? yes? yes? Yes,
please. Can you take me there? Please?

No?

It's alright, I understand:
You take what you want and you don't even ask--no:
You can't even ask. That's alright
if you can't, I'll just
try;
you're--

You're pinning me down and i'm running away but i'm running away and you're--and i'm--

No!

mm

oh

My question is exactly what it says on the title. For the past 12 years I've lived in a downtown area and all my workplaces have been metro accessible. I've gotten by with car shares and rentals and borrowing other people's cars when I really needed them. but I'm applying for a job that would have about 45min to 1 hour commutes each way and will need a car to get by. I'm also just looking forward to having one, both because I have a dog now and my wife and I will start trying for a kid soon and it just seems more convenient to get around than relying on lyfts.

Yet having been out of needing to care about cars for 12 years, the modern world of everything being electronic is new and scary to me. Apparently transmissions don't need to shift gears anymore, there are alerts and alarms and sensors everywhere. . . I'm lost. I need help folks.

So here's what I'm looking for, ordered by priority:

• Visibility! I live in a city with busy streets and am terrified of accidentally killing a cyclist or scooter. So visibility is important to me, both blind-spot visibility and visibility on turns. Every rental or car share I've used has had shit for rear visibility. This includes the Ford Fiesta, the Mercedes GLC, and the Mercedes GLA. The Chevy Cruze has been okay, but still pales in comparison to the faithful 1999 Sentra of my youth.
• Fun! I haven't owned a car in forever. I want to enjoy driving it. A manual is out as my wife will need to drive it too, but something that feels peppy and has a good drive feel is important to me. I really like to "feel" like I'm driving and want something with really responsive steering and an okay amount of pick-up. We don't need to be getting into racer level, but I also don't want it to feel like I'm struggling to merge onto the highway (as I often do in a rental Fiesta or Cruze).
• Easy to park. Again, I'm in a city and parallel parking can be a giant pain and I always feel guilty holding up the people behind me when I'm doing it. Some of these features to alert when you're close to the car behind you or the simulated overhead view that some cars can give you seem great. I'd probably just settle for a backup camera and proximity sensors though.
• Cost of ownership
• Roomy and easy to get in and out of, including loading dogs and car seats for kids. I want to be able to drive around 5 people comfortably, with decent shoulder room and not make people feel cramped on long drives.
• Not too "basic." As in, I value some level of novelty and originality and would prefer something unique that not everyone else has. This is the most childish of my requests, so I don't rank it too highly.

Price-wise I'm leaning towards around $30,000 and could maybe be persuaded to get to around $40,000 for something that's REALLY perfect and cheap to own long-term. I'm currently considering a Prius, the Mazda3, a VW Golf, and a Toyota Rav4. I generally prefer sedans because of the responsiveness and drive-feel.

My logical brain is leaning Prius, but my inner teenager is saying "DO NOT GO GENTLE INTO BEING A LAME OLD MAN!!" The Golf and the Rav4 Hybrid are kind of tied. The Rav4 is bigger and harder to park, but it is roomier and has a lower cost of ownership. The Golf seems easier to park and would be more fun to drive, but it's also kind of expensive if I opt for a GTI or sport version. Plus it has less room, seems less luxe, and. . .I don't know it just looks kinda bland. I'm definitely leaning towards a low-mileage certified pre-owned whichever way I go just to not have to pay for depreciation.

So, any advice? Any other suggestions? Anything, feature-wise, I should be paying particular attention to?

The Mazda3 hatch seems really nice, but I'm worried I will 100% kill a cyclist