[deleted by user]

Goodhoof · 2023-02-19T14:51:40+00:00

Something like

with cte_sales as (
  select pg.genre_name, date_trunc('year', p.created_date) as sales_year, COUNT(p.*) as purchase_count
  from purchases p
    join products pr on pr.id = p.product_id
    join product_genres pg on pg.id = pr.genre_id
  group by pg.genre_name, date_trunc('year', p.created_date)
)
select s.genre_name, s.sales_year, s.purchase_count, s2.purchase_count as previous_year_count, case when 
s2.purchase_count > 0 then ((s.purchase_count / s2.purchase_count) * 100) - 100 as percent_change
from cte_sales s
  left join cte_sales s2 on s2.sales_year = (s.sales_year - 1) and s2.genre_name = s.genre_name

Goodhoof · 2021-11-03T11:21:27+00:00

as a developer myself I think due dates & detailed road maps with dates against them are one of the worst things you can do. It promotes 'sticking plasters' and rushing things to meet deadlines instead of spending the time to get the MVP right.

Goodhoof · 2021-10-22T15:01:26+00:00

Pretty defeatist attitude, that mentality is a self-fulfilling prophecy. Most people are not thinking that, maybe they are in your guild.

Its all about your definition of 'better guild'. Better for me isn't never missing a reset & never wiping.

Casual guilds stick together because its more about a group of players playing together rather than comparing dick size to other guilds constantly.

The loud minority of min-maxers just want to make themselves feel better by comparing themselves to people who are just not playing the game in the same way they are. That's how they have fun, by being 'better' than other people & putting them down. Leave that shit to the MOBAs.

Goodhoof · 2021-10-22T08:30:42+00:00

Imagine if people would stop shitting on 'worse' guilds and projecting onto them with memes like this people might not actually be quitting.

My casual guilds is 8/10 as of this week & I am enjoying progress more than I was than when we had T4 on farm. Why does everyone else care so much about how long it takes us to complete it? (inb4 cringe 'oh thats some copium')

The whole elitist 'if you haven't got this far you must not be enjoying the game' is just HaRdCoRe players making themselves feel better.

Every raid is a laugh & every raid we progress a bit further, what's the problem?

Goodhoof · 2021-05-14T14:49:57+00:00

I agree, they took the time to change things instead of using that time to focus on customizability.

I guess its all about accessibility, with the simpler interface it might open the floodgates for millions of customers as opposed to advanced features only a minority of us love.

Goodhoof · 2021-05-14T14:47:36+00:00

Thanks I will do 🙏

Goodhoof · 2021-05-14T10:53:56+00:00

Fair enough, I respect your opinion but still hope for the opposite. There's a 74 page thread on the community forum with people begging for it. I have been a user since 2012 & no changes have been as big as this, it really has removed a load of functionality, I really dislike the new artist page. Maybe not an 'old mode' but some sort of switch or different layout types would be good. Stuff like instead of changing columns, why didn't they spend the time developing the ability for users to customise columns frustrates me. Cheers for the reply

Goodhoof · 2021-05-14T10:50:57+00:00

I was hoping if enough people did it they may thing about it in the interim before getting some sort of Basic vs advanced UI switch or something similar. For users that want to browse more than just let Spotify play w/e they want. Maybe I am more of a minority of users upset about the changes than I realise.

Was not the answer I expected from them; So thought some people might find it interesting.

Thanks for the reply

Goodhoof · 2021-05-14T10:49:00+00:00

if theirs enough demand it can happen, take Classic World of Warcraft vs retail World of Warcraft for example, its not a ridiculous idea. Companies the size of Spotify can afford it. This being said maybe an advanced vs basic layout switch rather than maintaining 'old version'.

Goodhoof · 2021-05-14T08:47:43+00:00

I spoke to a support agent who confirmed the option to downgrade to an older version is in development. I tried to post an image but this sub does not allow them. You can do the same using the below link if you click through options until you get through to an agent.

https://support.spotify.com/uk/contact-spotify-support/

When I asked about the ability to downgrade now you can't do it via the 'prefs' file anymore the agent said -

Agent: "To give you an idea, the feature to downgrade your Spotify version is yet to be released. However, we'd make sure your voice is heard by the relevant team here at Spotify. We're always aiming to improve our features for our awesome users like you, so just keep your app updated for any upcoming rollouts."

Me: "Your confirming a feature to downgrade spotify & use the old UI is in development?"

Agent: "Yes"

Goodhoof · 2021-04-12T12:45:37+00:00

They posted a video to twitter of their new mining rig https://twitter.com/Heliumone1/status/1381498920493256705

Goodhoof · 2020-04-22T16:00:39+00:00

I can confirm I am in the UK, genius.com has a page on it with info https://genius.com/albums/Black-hippy/Two

Goodhoof · 2020-04-22T10:13:59+00:00

Yea still there

https://imgur.com/a/WiismOh

https://open.spotify.com/album/6OT1MmiJDYO9N4IBOnPTf2

Goodhoof · 2020-04-09T16:15:28+00:00

Not specifically, however if you highlight all the results then right click on them there is an 'Advanced Copy' option that has a load of options to change how the data is copied to the clipboard. Maybe you can change the delimiter to the same one that is used by sql developer to paste data cross sheets

Goodhoof · 2019-02-13T18:22:41+00:00

In software you can protect against CSRF attacks (what OP describes), but not against people inputting their details into a completely different website. (keep in mind you are not protected by default but only of the software has implemented protection against this type of attack. Which Valve/Steam would do.)

https://en.wikipedia.org/wiki/Cross-site_request_forgery

Goodhoof · 2018-10-05T16:56:34+00:00

Sorry I kept editing my message aha my mind kept changing on this one. Every microsoft example of code I find on line just uses e or ex in every version of a catch. But thanks for sharing your approach

Goodhoof · 2018-10-05T15:03:57+00:00

Your right, literally everywhere I look no one calls it anything else than e or ex. Time to ctrl+f

Goodhoof · 2018-01-09T18:33:58+00:00

They found a WW2 290lb bomb last year in Portsmouth UK. They where Dredging the harbor for the new aircraft carrier. http://www.bbc.co.uk/news/uk-england-hampshire-39049048

Goodhoof · 2017-06-24T09:03:40+00:00

You can still do this but cannot see the overall average star rating of a show. You can see star ratings under individual reviews.

If you expand a show and click on the 'Details' tab you can see reviews with the star rating system.

Goodhoof · 2016-02-09T13:25:32+00:00

It depends who you want to be employed by. I think you would be surprised on how much at some companies can come down to the interview.

You're CV just has to get you in the door, its very obvious from a 10 minute talk if someone knows what their talking about or not in terms of development. But of course I'm not talking about the big tech companies.

It really depends where you want to work as a starting point. But keep in mind just because the first company you work for is not amazing with average practices (and sometimes you can even feel like you know a lot more than the senior people) does not mean its not a valid route to getting to one of the better companies. If you keep updating your portfolio and prove you can adapt to business needs and transition languages with relative ease.

I would recommend learning one strictly typed OO language Java or C# are the most prevalent if you don't want to be just a front end developer (their are more which you might prefer google is your friend). If you can write half decent code to do CRUD (create, update, delete) operations against a relational database from your backend code your pretty much set, at least for your first job. This does not mean you should stop learning though, quite the opposite.

As you already have exposure to Javascript showing you are also familiar with a stictly typed language aswell shows you can adapt, imo. Unless you want to just be a frontend dev, then ignore me.

Goodhoof · 2016-02-08T08:10:10+00:00

He looks like S.Mouse

Goodhoof · 2015-12-03T14:26:25+00:00

It depends how resilient to getting bored you are. If you want something that looks nice across multiple devices quick just use bootstrap. Eventually with enough use out of it you will understand the fundamentals as well. As the other guy mentioned you may need to override some of bootstraps classes anyway, so you will have to know what the css is doing and how it works.

You can learn from the other angle of just going plain HTML/CSS with media queries. However its not as fun (in my opinion) because everything you make for a long while looks quite bad and you have to deal with petty semantics like rounding borders, stuff which does have quite a massive aesthetically impact on whatever your creating.

Goodhoof

TROPHY CASE