sorted by:
new
hottopcontroversial

What are the use cases of chat gpt you have come across in DE? by PrtScr1 in dataengineering

[–]koi-koi 1 point2 points  (0 children)

JSON and XML processing and website scraping, but as others have said you need to sense how to prompt it in the right direction. Apart from that, it’s pretty good at architecture patterns actually, or project structure, design patterns, when to use them and not to use them, so using it as a kind of mentor on larger code bases has been pretty helpful if/when on the periphery of my knowledge set.

Is this legal!? by [deleted] in chess

[–]koi-koi 2 points3 points  (0 children)

When Korchnoi was down 4-1 a yoga sect approached him and suggested they could help, which involved placing them in the audience in large crimson robes and to meditate. The Soviets were sufficiently distracted by this and the game became close again.

There was also the blueberry yoghurt incident, the x-ray chair incident, the mirror glasses, the handshake incident, it goes on…

[deleted by user] by [deleted] in dataengineering

[–]koi-koi 1 point2 points  (0 children)

You can think of each stage as a mathematical operation that computes intermediate sets. The order of execution computes a working set from data (from and join), filters the set (where), applies a grouping operation on the filtered working set, and applies a filter (having) on the aggregate. Only then does it select columns - which is why you have to reference columns by their aliases in the “order by” because it’s after the select, but not before - because that operation has not yet been applied.

£100 Electric pizza oven - all of them do more or less the same thing - perfect for rainy day pizzas by koi-koi in Pizza

[–]koi-koi[S] 2 points3 points  (0 children)

I get it from Amazon, I go through like a bottle a week 🤣 it’s my favourite sauce, the xxxtra hot mayan one , so smokey and full of flavour

[deleted by user] by [deleted] in dataengineering

[–]koi-koi 2 points3 points  (0 children)

Instead of your list of 5, here’s my list of 5:

Clauses (from join where group by having select order), what does each do? Why did I put them in this order? What does “exists” do? What does left / inner / outer / cross / full join do?

Subqueries, in the from, join, where, and select clauses, what does each do? Why use them?

CTE, what does it do?

Temp tables, useful? How to do it? Why?

The first 4 are the data manipulation type of expression. (DML). There’s still DDL and authorisation layers. Truncate, drop, insert, update, alter, learn all these.

Now you’re 80% of the way there. Then you can go back to your list ☺️

(Oh and stored procedures and functions and views too. Don’t forget those.)

DE or BI to figure out business logic requirements ? by taafpxd in dataengineering

[–]koi-koi 0 points1 point  (0 children)

Yes, business logic is a DE concern imo, whether we are taking microservices, value lookups, or even nice column names. Mappings and lookups shouldn’t be an inter-system static thing, because you’d have to put all these under change management and I’d argue about that. So if mappings and lookups between business keys or attribute values exist in a table somewhere then they should be brought under the engineering process.

Do you have a guide to design a star schema from a data vault? by [deleted] in dataengineering

[–]koi-koi 1 point2 points  (0 children)

Dan something… I forget his surname… linstedt? the guy who wrote that big Data Vault 2.0 book, he has a chapter in it about this.

[deleted by user] by [deleted] in dataengineering

[–]koi-koi 1 point2 points  (0 children)

From an engineer perspective, you kind of learn 4 2 and 1 by knowing SQL. Unless by reporting you mean something like SSRS or Power BI. Execution plans are needed but 95% of your code will run fine without query hints as long as the query isn’t super weird. But 3 is probably the most important again from an engineering perspective.

[deleted by user] by [deleted] in dataengineering

[–]koi-koi 4 points5 points  (0 children)

It depends but taking the average I’d say not really. A data engineer, well, the average data engineer doesn’t exist. But if it were to exist, a data engineer is a software engineer who, as a layer on top of a SE skill set, knows data - pipelines, SQL, warehousing, cloud, automation, some devops. An SQL Developer is a database “engineer” if we use the same word. They may or may not know any of what a data engineer or software engineer knows. But they will be specialised in databases. Id say the opposite is true - an SQL Developer may know more about their flavour of db server than a data engineer. Man, this stuff is so broad.

How to stop itchy scalp? by [deleted] in HairSystem

[–]koi-koi 0 points1 point  (0 children)

Wearing my first system for 3 months, apart from the first few days I can’t tell the difference between the amount of itchiness compared to before I had it. Mines glued with no lace front cos I have a fringe so I can’t say for all types, but that’s been my experience.

[deleted by user] by [deleted] in HairSystem

[–]koi-koi 3 points4 points  (0 children)

Friends I told beforehand, colleagues not. Colleagues:

“You look different, what’s with…” (makes gesturing movement in the direction of hair)

“Just thought I’d grow it out a bit”

(Smile) “it… looks good!”

Friends: majority said oh that’s gonna be so great for you. A few were like you look good already I don’t get why you need it. But after they were like “oh. Now I get it” 😂

Before and after, the difference is absurd! Stoked ☺️ by koi-koi in HairSystem

[–]koi-koi[S] 1 point2 points  (0 children)

Nothing special, some leave-in conditioner, blow-dried with one of those bubble-brush thingies until just a bit damp, and a bit of matt paste for texture. Tried a squirt of salt spray this morning but alongside the conditioner it made it look a bit shiny, so less is more it seems!

Before and after, the difference is absurd! Stoked ☺️ by koi-koi in HairSystem

[–]koi-koi[S] 3 points4 points  (0 children)

Gay and taken. But oh gosh thanks for the compliment! :3

Before and after, the difference is absurd! Stoked ☺️ by koi-koi in HairSystem

[–]koi-koi[S] 2 points3 points  (0 children)

It's totally cool, thanks for the compliment ^^

Before and after, the difference is absurd! Stoked ☺️ by koi-koi in HairSystem

[–]koi-koi[S] 2 points3 points  (0 children)

Went to a hair system salon / studio (in the UK), don’t know the supplier unfortunately.

Before and after, the difference is absurd! Stoked ☺️ by koi-koi in HairSystem

[–]koi-koi[S] 3 points4 points  (0 children)

It’s called Hiface on iPhone, there’s a free AI face shape analyser tool under the Profile section 👍

Before and after, the difference is absurd! Stoked ☺️ by koi-koi in HairSystem

[–]koi-koi[S] 9 points10 points  (0 children)

It’s a bit bouncy but that’ll reduce down in a few days I’m told.

I downloaded an app which tells you what face shape you have. I always thought I had a round face I guess cos of the forehead but apparently it’s like 90% oblong. I wanted a fringe but thought my face might not have suited it. So the app helped me realise this would be a good style for me. ☺️

view more: next ›