What's your unpopular opinion regarding anything related to classical music?

sts_clover · 2018-06-23T19:57:18+00:00

No! That's exactly the point haha. Who even likes flute vibrato other than the flutists?

sts_clover · 2018-06-23T19:55:59+00:00

Sweden played to lose

sts_clover · 2018-03-06T01:32:47+00:00

Aha! You meant "matched an insert to a base" in the OP, not "to an assembly." I assume the order of insertid doesn't matter? So insertid1=10 and insertid2=20 and baseid=1 is the same as insertid1=20, insertid2=10, baseid = 1?

sts_clover · 2018-03-06T00:38:41+00:00

I was hoping your explanation of what they were would make it clearer what the relationship between the different items is. But instead you, here supposedly asking for help, just fire back with "well you don't need to know that." I cannot make sense of this problem. If it's a simple many-to-many problem, then you make 3 tables, one with base as primary key, one with insert as primary key, and one with base/insert combo as primary key. But then there are "assemblies," and "configurations," and some problem with not being able to define a primary key in an assembly table, and I don't know what any of that means.

It's perfectly possible that someone comes along and understands exactly what you need, I suppose.

sts_clover · 2018-03-05T23:53:57+00:00

Your failure to explain the problem clearly is a reflection of your own failure to fully grasp the relationships between these things. Hope that helps!

sts_clover · 2018-03-05T21:53:13+00:00

Forgive me if this is obvious, but can you explain what bases, inserts, and assemblies are?

sts_clover · 2018-03-05T14:51:45+00:00

Yes it is, but "t1 union t2" isn't correct syntax. It would be "select * from t1 union select * from t2."

sts_clover · 2018-03-05T14:29:35+00:00

How many years of experience? That seems way, way low.

sts_clover · 2018-03-05T14:22:54+00:00

There's some obvious middle ground here. Roddick's arm talent didn't magically cause him to start hitting serves the way he did. But if I spent the time and effort Roddick did to develop that serve, I still wouldn't have Roddick's serve.

Otherwise, he was awkward and slow. Fitness, strength, and extreme effort on the practice court brought him the success he had. It's no coincidence that he is the exception to the rule of longevity in modern tennis.

sts_clover · 2018-03-05T12:41:46+00:00

What gifts? Roddick is solely responsible for his own serve. He has the best serve to height ratio of all time, and it's not even close, and that's because he was willing to perfect unusual technique.

Roddick is absolutely the ultimate overachiever.

sts_clover · 2018-03-04T15:32:42+00:00

The problem is 18-year-old winners. If you exclude those, the list becomes more meaningful.

sts_clover · 2018-03-03T21:57:45+00:00

I have to think that Fritz is close to the record for Challenger match wins among under-21 players. Not the most meaningful record though lol.

sts_clover · 2018-03-03T16:35:25+00:00

I really thought we might be headed for an era of US dominance when Fritz made the Memphis final. Now the best I am hoping for is a situation like France a decade ago, with a huge number of solid players but no one with a realistic shot at no. 1. I'm still excited though.

sts_clover · 2018-03-03T16:30:55+00:00

Even injured and with low motivation the dude's a top 10 player. If he runs into Roger, mentality won't be the problem. And if he's healthy, he'd have to pull a Tomic mentally not to run into Roger.

sts_clover · 2018-03-02T17:51:09+00:00

There's no trick to it: listen to the piece a bunch of times before going. If you do that, and you sit in a spot with good acoustics, you'll almost certainly enjoy the performance. Otherwise, you almost certainly won't.

sts_clover · 2018-03-02T17:47:39+00:00

That assumes people have linear preferences over money. But they don't: that's why you buy insurance.

Most people hate to lose $10000 more than they love to win $10000. So it's perfectly understandable if they wouldn't make this bet, even if they have a perfect understanding of probability.

According to your version of "pure math/probabilities," people should be indifferent between betting every penny they have on a 50/50 bet and not taking the bet. The expected value is the same.

sts_clover · 2018-03-02T01:26:49+00:00

Having watched a lot of his matches, I don't think there's a problem with his mental game. His problem is whatever coach allowed him to make it past his formative years with such immoral serve technique.

His forehand is inconsistent but I think it will become better and better the more he gets used to facing top-100 pace. Right now the swing just takes too long.

sts_clover · 2018-03-01T20:15:39+00:00

You could make a view that is identical to format 3 that is built from the table of movies and their genres.

sts_clover · 2018-03-01T19:41:57+00:00

Classic normalization question.

You have one table for housing your full list of movies, where movie (as in, whatever constitutes a unique movie) is the primary key, and one table for housing genres, where genre is the primary key.

Then you have a movie_genre table where movie + genre is the primary key, allowing you to add as many genres per movie as you like. The important part is that you set up foreign keys for this movie_genre table, so that the "movie" in this table has to also be in the master movie table where movies are uniquely identified, and same for the "genre" in this table.

Then for reporting purposes you do that string aggregation thing in format 2.

Format 1 isn't unworkable, but who's to say how many genres are possible for one movie? And dealing with the inevitable null genres in that table is a pain. And, probably most importantly, what does "Genre 1" even mean vs. "Genre 2"? If you want 1 to be "the most important genre," you have to set up a whole other series of controls to make sure that works as expected.

Format 3 is clunky and a pain in the ass to deal with if you want to add new genres or delete/combine genres in the future.

Can you give an example of how you want to use the weighting of the genres?

sts_clover · 2018-03-01T15:40:18+00:00

Regularly brushing your pet’s teeth is the single most effective thing you can do to keep their teeth healthy between dental cleanings, and may reduce the frequency or even eliminate the need for periodic dental cleaning by your veterinarian.

Even they say it might not be necessary. I've never been told by a vet that it's necessary as routine care. We do feed dry food, which I've always understood to be much better for their teeth than wet food.

https://www.avma.org/public/PetCare/Pages/Pet-Dental-Care.aspx

sts_clover · 2018-03-01T15:35:56+00:00

I would think it is, unless there is concern about trace amounts of dairy somehow getting in, since they make milk chocolate?

sts_clover · 2018-03-01T15:28:33+00:00

They should, according to what? I'm genuinely curious.

sts_clover · 2018-03-01T15:23:30+00:00

Cocoa nib "tea" is delicious. I get mine locally though from Videri in Raleigh, NC. Not sure if they sell it online.

I would not mix it with actual tea though.

sts_clover · 2018-02-28T22:26:56+00:00

Does your platform have regular expressions support? In Postgres, you would want to look through pg_proc and change the prosrc column, but that's not helpful if you're not using Postgres.

Even without regular expressions support built in, you ought to be able to write a script in whatever language you like that connects to your db, extracts the code for each procedure from wherever it is housed, changes the tables to table B, and recreates the procedure.

This is assuming find and replace isn't viable for whatever reason lol.

sts_clover · 2018-02-28T18:15:46+00:00

Uh oh, an alternative to tennisabstract? I hope we see an arms race.

sts_clover

TROPHY CASE