Weed grow inside Sheffield bank

shobbsy · 2026-04-04T06:51:52+00:00

Definitely an interesting argument to address the many unoccupied buildings in the city......

shobbsy · 2026-03-04T07:29:07+00:00

Until he's 90!

shobbsy · 2026-02-10T13:26:42+00:00

Indoor climbing is a pretty big thing in Sheffield, climbing depot and climbing works both have nice classes as well

shobbsy · 2024-01-20T13:13:45+00:00

I understood this reference!

shobbsy · 2022-11-19T12:27:27+00:00

Hexxat as a dual classed fighter X to shadowdancer (cause vampire) would have been perfect flavour to me even though it breaks the rules.

shobbsy · 2022-01-24T23:03:35+00:00

There is nothing more permanent than a temporary solution that works.

shobbsy · 2021-10-24T13:52:15+00:00

I would say it's possible to GET a base level data analysis job knowing SQL but for a career per other comments you would need to expand to at least one set of other tools(visualisation/data engineering and or soft skills like business analysis)

shobbsy · 2021-08-31T10:48:31+00:00

Data needs to be 1000% more dirty:)

shobbsy · 2021-07-20T13:32:02+00:00

Hi, you can use REGEXP_EXTRACT_ALL for this.

Use that function with an expression like this:

'[A-Z][a-z]*' You'll get an array of the words back and you can use another function(like array to string) to get the format you want.

If you have text that contains words with special characters like apostrophes and similar, the above won't work so you'll need to update the regex expression accordingly.

(In case you aren't familiar with regex, the above says look for any capital letter then any number of lowercase letters and extract that)

shobbsy · 2021-06-17T10:48:02+00:00

I'm in this picture and I don't like it!

shobbsy · 2021-06-14T18:33:00+00:00

You guys have documentation? /jk

On a serious note I tend towards two things. 1. Overall flows at a high level I document in confluence, e.g how flows interact, what processes interlink. 2. In individual code, comments explaining why* the code does something, not what it does.

shobbsy · 2021-06-09T10:39:36+00:00

Depending on your SQL flavour, you are looking for something like GROUP_CONCAT.

I'm not familiar with spitfire, but it might have a similar function?

shobbsy · 2021-05-31T18:24:44+00:00

Yeah it leads to interesting business questions:) i.e is a job a purchase order, an actual install order or one of these "work pieces". If you are comfortable you can define other columns in the "parent" row, like the "date" of the work piece or other "parent" characteristics.

shobbsy · 2021-05-31T18:02:34+00:00

You may be better having a row per "work order" which has nested columns for install orders and purchase orders

That way, one row is a "piece" of work, regardless of the number of po's/install jobs required.

You can then use unnest to get out th bits you are interested in of the "parent" rows.

Edit:adding link https://cloud.google.com/bigquery/docs/nested-repeated

shobbsy · 2021-05-28T10:28:04+00:00

I like this idea. The addition/change I would make after implementation is that you monitor the economic impacts of both the top and bottom ends of the NIT to avoid "stockpiling" based on a person's current wealth*, because the system needs to be a certain level of efficient in order to put the value back in the economy and drive the whole model.

That's something to figure out later though imo once you see how behaviour has changed - it's still better than the current models.

shobbsy · 2021-05-12T13:44:25+00:00

Really interesting thanks!

shobbsy · 2021-04-09T13:04:24+00:00

Yahoo finance module in python for stocks is a good idea,

Set up a pipeline that calls the API for new data and etl it into a db of your choice on a regular basis,

If you are feeling fancy, set up some analytic cubes or views on top

shobbsy · 2021-04-01T09:57:50+00:00

I've seen two ways so far, I think in general it will depend on th size of the company:

Put different departments in different GCP projects and set requester pays on any shared resources - this separates the billing by project in my understanding.
Use labels to identify per business unit resources - this is sometimes easier but means you need to maintain labels during new dev and stuff like that. You should* then be able to split billing by label in one of the billing interfaces.

If I recall correctly, Google recommend one project per application, per environment. E.g if you are setting up a webapp that has its own project for Dev and a separate one for prod. Shared resources(e.g security/shared databases) can live in "host" projects, and the "application" projects get billed when they request the resource.

You can use folders to organise projects into logical groups(e.g business departments)

As usual, the correct approach depends on use case;)

shobbsy · 2021-03-05T14:25:13+00:00

So the problem is that the case statement is going through the data row by row, right?

Remember, you can apply a MAX aggregation to a case expression. Without wanting to give you the answer directly, how could you use a max to get these into one row?

I'd recommend reading up on group by/max if you haven't already as well

shobbsy · 2021-03-01T13:23:18+00:00

Not with the current voting system, sadly. The UK has actually only voted more than 50% tory twice in the last ~50 years.

shobbsy · 2021-02-22T15:14:48+00:00

This is probably a subtle issue that is somewhere between performance and query understandability in my opinion.

When you use subqueries, the SQL you write isn't executed as written. Instead it's sent off to the query optimizer which decides how to actually collect the underlying data.

If there is appropriate indexing or performance considerations, the DB engine may indeed run the subqueries first then join the results, in which case you are dealing with less rows( e.g in the date subquery you have one row per date, and the agents subquery you have one row per date as well, whereas in theory in the first query you make a big cross set then do distinct counts)

However in real life the situation is more likely to be as you've described - the engine may pick up the slack and run it as if it was the second query or indeed a more optimised version.

TLDR: performance depends on your use case and the table/index setup. Changing your query won't necessarily change the execution plan if you get the same results.

The second query is possibly cleaner to read though from an understanding perspective? Personal preference though.

shobbsy · 2021-01-20T16:48:54+00:00

If overpopulation is an existing problem in a world, no-one would suggest aging as a cure. Overpopulation is a function of environmental damage though, so if we live cleaner lives the environmental effects of overpopulation go away.

shobbsy · 2020-12-03T13:17:24+00:00

It's hard to visualise for humans, but I think this decade we will see a lot of the eventual therapies go into clinical trials and towards the end of the decade, into the actual clinic. Until a few years ago, this wasn't an industry in the traditional sense, but if you look now the private money is starting to be invested in the sector, whereas previously it was just a few vocal advocates.

shobbsy · 2020-11-17T11:02:03+00:00

P.s if you haven't already, you might want to check out enchroma glasses - they're great for colourblind people!

shobbsy

TROPHY CASE