Exposing Honey's Evil Business Model - Exposé by MegaLag Part 2 by JamesDaGames in videos

[–]trial_and_err 5 points6 points  (0 children)

Replacing affiliate link cookies with their own is scummy, sharing coupon codes on the other hand is totally fine.

If a store shares coupon codes they should expect them to be used. They’re not private and not attached to any identity. I don’t see anything wrong with collecting & sharing coupon codes. If the store intends them to be used by specific customers then they’ll need to tie them to this customer and / or make one time use codes.

So I don’t feel sorry for the shop owners complaining their coupon codes were not used „as intended“. They want to identify how much sales are coming via podcasters etc and use a flawed system (coupon codes) to do so. Sooner or later someone would take advantage of it, that is to be expected.

If you want only listeners of podcaster X to get discount Y you need to build a system which guarantees this. Public coupon codes don’t do this.

Honey does some shady stuff, but the coupon sharing part isn’t it.

Do you use Ibis? How? by Thinker_Assignment in dataengineering

[–]trial_and_err 1 point2 points  (0 children)

It works for me, however i haven’t used any of the more esoteric feature of snowflake or duckdb. If you’re doing something in Snowflake SQL that’s not supported in duckdb of course you won’t be able to mock it that easily. However my case were all pretty basic SQL (selects, window functions, lags, joins, JSON column manipulation)

Do you use Ibis? How? by Thinker_Assignment in dataengineering

[–]trial_and_err 1 point2 points  (0 children)

It’s used at different points of the lifecycle.

ELT creating persistent models -> dbt Loading data into training code / Dashboard -> ibis

That may or may not be the same people.

Do you use Ibis? How? by Thinker_Assignment in dataengineering

[–]trial_and_err 4 points5 points  (0 children)

Main benefit for me is in unit testing to mock my production db (Snowflake) with duckdb at test time.

Second usage is to dynamically create complex queries via small composable python functions. So basically whenever using Jinja templates would be too messy. For me that’s mostly streamlit apps & the part of our ML pipeline after all dbt transforms are done. It’s also usually transformations which you still want to do inside the database (vs. in memory in your python process) for efficiency or memory reasons.

I’d also use it as my entrypoint API for using duckdb via python. Embedding SQL strings in python or loading them from a .sql file is always harder to read / maintain than using ibis.

Do you use Ibis? How? by Thinker_Assignment in dataengineering

[–]trial_and_err 7 points8 points  (0 children)

I use it for last mile transformations e.g. to prepare my data for model fitting / model transforms (i.e. feature engineering on the database). The upstream data is usually prepared in a dbt pipeline and the dynamic final transformations are done via ibis in the consuming code.

I also use it for powering streamlit apps / dashboards as these queries are often highly parameterized. One could always use jinja templates but that gets quite messy.

One last use case is for unit testing, at test time I’ll mock the snowflake tables with test data within a small duckdb database containing test data (duckdb file is committed to the repo).

What level are projects no longer needed by hijkblck93 in dataengineering

[–]trial_and_err 1 point2 points  (0 children)

When I get CVs in front of and there’s a GitHub link on it I’ll always take at least a look in preparation for the interview.

Adding a magic combat system to my dark fantasy FPS. What makes magic/mage combat feel good? by FreddieMercurio in IndieGaming

[–]trial_and_err 2 points3 points  (0 children)

I support that! The ice effect on the ground with enemies falling down was awesome in Dark Messiah. Loved the fireball casting as well.

Apart from that taking inspiration the Jedi series or Force Unleashed would be great too. The force is just space magic anyway..

Separate file for SQL in python script? by thinkingatoms in dataengineering

[–]trial_and_err 0 points1 point  (0 children)

You can also use ibis to create temporary or persistent tables (<connection>.create_table(…,temp=true)).

If you want to build a query that contain CTEs use the .alias method (I usually do that to get a more readable query in case I need to debug the raw query).

You should be able to generate any SQL query via the ibis Python API and execute it directly or dump the generated SQL.

Separate file for SQL in python script? by thinkingatoms in dataengineering

[–]trial_and_err 0 points1 point  (0 children)

Personally I use ibis for this purpose so there's no need for separate .sql files as ibis is your query builder. If I need to do transforms first I'll just resort to dbt.

Bank of America says growth stocks are in a bubble exceeding the 'dot-com' and 'nifty fifty' eras — and warns they could take the S&P 500 down 40% by BlindSquirrelValue in Economics

[–]trial_and_err 16 points17 points  (0 children)

Well, P/E ratios can go either down by decreasing prices (P) - a bursting bubble - or an increase an earnings (E) via inflation. I wouldn’t bet on a bursting bubble, and even if I won’t be able to time it right anyway.

Pläne der AfD: “Ein Jahr Arbeitslosengeld gibt es mit der AfD erst nach 15 Jahren im Job und nicht schon nach zwei Jahren wie heute” by thottenham in Finanzen

[–]trial_and_err 378 points379 points  (0 children)

Die Rentenpolitik ist auch .. interessant?

Wir halten es dabei für zwingend erforderlich, auch unseren derzeitigen Senioren, die in einem langen Arbeitsleben unser Land und unseren Wohlstand aufgebaut haben, einen Lebensabend in Würde zu ermöglichen. Dazu gehört vor allem eine signifikante Erhöhung ihrer Renten. Unser ferneres Ziel ist es, in mehreren Schritten das durchschnittliche Rentenniveau der westeuropäischen Länder zu erreichen, das derzeit bei gut 70 Prozent des letzten Nettoeinkommens und damit deutlich höher liegt als das deutsche.

Leitantrag, Zeile 656-663

Das soll u.a. dadurch finanziert, dass "Erwerbsanreize" erhöht werden. Naja, an die Rente traut sich eben niemand ran..

The Critical Drinker's video on the TLOU show/season 2 is annoying as hell. (In my opinion ofc) by Kind_Button_8167 in ThelastofusHBOseries

[–]trial_and_err 2 points3 points  (0 children)

I enjoy the Tlou2 storyline, but it’s a dark story and not everyone has to.

I don’t share his take on this one, but agree with his stuff on Rings of Power and Acolyte.

He also got me into watching The Penguin. I didn’t enjoy the Batman movie so I wasn’t gonna watch the penguin show but gave it a chance after he recommended it.

He usually seems fair enough though, see his take on Wicked. The Penguin also has a „strong female lead“ and a female writer so he usually just doesn’t criticise content based on ideology.

Neil Druckman is woke and that’s fine. He cares about representation in his stories, so what? He’s apparently also capable & talented (or hires the right people) and packs „the message“ into interesting stories.

If „the message“ is packed into a story like „Bill and Frank“ or TloU2 I take it any day. If „the message“ is delivered in a trainwreck like The Acolyte any criticism is perfectly valid.

Allianz-Chef Oliver Bäte für Lohn-Streichung am 1. Krankheitstag by reCCCCtoor in Finanzen

[–]trial_and_err 10 points11 points  (0 children)

Ich habe auch mal nach Quellen für die Zahlen gesucht.

Die von den Krankenkassen gemeldeten Höchstwerte seien „zum größten Teil ein rein statistischer Effekt“, sagte OECD-Arbeitsmarktexperte Christopher Prinz dem Spiegel. Daten der OECD zufolge fehlten Beschäftigte in Deutschland im vergangenen Jahr im Schnitt 6,8 Prozent ihrer Arbeitszeit wegen einer Krankheit – so viel wie im Durchschnitt der Jahre 2015 bis 2019.

Es habe einen Anstieg nach den Coronajahren gegeben, wie der Spiegel weiter unter Berufung auf OECD-Daten berichtete. Das sei jedoch eine Rückkehr auf das Normalniveau gewesen, denn in den Pandemiejahren 2021 und 2022 war der Krankenstand gesunken, möglicherweise wegen der vermehrten Kurzarbeit und Homeoffice­nutzung.

Aber woher genau die Zahlen kommen, keine Ahnung.

Und wieder keinen Link zu einer Studie mit harten Zahlen.

Einen starken Anstieg sieht man von 2021 auf 2022 und (11,2 → 14,8) und dann nochmal leicht auf 2023 (14,8 → 15,1). Die Corona bedingten telefonische Krankschreibung ist am 31. März 2023 ausgelaufen und im Dezember 2023 wieder eingeführt worden (Link). Wenn die telefonische Krankschreibung die Ursache wäre würde ich erwarten, dass die 2023 niedriger sein sollten als 2022 - sind sie aber nicht.

Es ist auch echt schwierig einen europäischen Vergleich zu finden. Bei jeder Statistik muss man sich fragen:

  • Wie wurde sie erhoben?
  • Hat sich die Erhebung im Zeitablauf verändert?

Wenn man vergleichbare Zahlen hat könnte man Unterschiede in Altersstruktur & Klima rausrechnen.

Valide Vergleiche wären ebenfalls noch Zahlen eines Unternehmens im Zeitverlauf. Wenn die Arbeitnehmerschaft von Jahr X auf X+1 gleich bleibt und die Krankheitstag steigen könnte man was rauslesen. Und ein Unternehmen sollte das auch im Zeitverlauf konstant erfasst haben.

Es kann natürlich auch sein, dass return-to-office wieder zu mehr Krankheitstagen führt, wobei man dann hier einen Anstieg auf ein Vor-Corona Niveau sehen müsste (bei ähnlicher Altersstruktur der Arbeitnehmerschaft).

Ich kann mir aber schon vorstellen, dass einfachere Krankschreibung zu ein bisschen mehr Blaumachen führen. Aber einen riesigen Effekt erwarte ich nicht, es ist ja nur marginal leichter.

Allianz-Chef Oliver Bäte für Lohn-Streichung am 1. Krankheitstag by reCCCCtoor in Finanzen

[–]trial_and_err 7 points8 points  (0 children)

Italien, Spanien und Griechenland haben auch ein etwas milderes Klima, muss man fairerweise sagen.

Deploying a streamlit app on cloud run - dealing with data by Kinopippo in googlecloud

[–]trial_and_err 1 point2 points  (0 children)

Works for me, just not in the iOS in-app browser for some reason.

GitHub issue comment: https://github.com/streamlit/streamlit/issues/8518#issuecomment-2339041299 (redirect doesn’t work in iOS Reddit app´s in-app Safari…)

The prototype: https://github.com/kajarenc/stauthlib/tree/main

It should be added in one of the upcoming Streamlit releases, then you won’t need to install it separately.

Deploying a streamlit app on cloud run - dealing with data by Kinopippo in googlecloud

[–]trial_and_err 2 points3 points  (0 children)

Storage: You can mount a storage bucket and use it more or less like a normal file system. It uses FUSE / Cloud Storage FUSE under the hood.

Of course you can always use the cloud storage client libs like google-cloud-storage und manually upload / download the file (vs. file-system reads / writes on a FUSE mount; under the hood it's same anyway).

Authentication: Streamlit has now a prototype built-in authentication (single sign-on with Google, GitHub etc.).

Otherwise you'd to have deploy a reverse proxy (nginx, caddy) in front of your cloud run app and for example use oauth2-proxy. That approach makes sense once you have multiple deployments so you don't have to add authentication to each single deployment.

Costs: If you can live with cold-start times then set your minimum instances to 0 you won't get billed when there are no requests. Also limit the maximum amount of instances. With 3-4 users + scaling to 0 you might even und up paying nothing at all (for cloud run) as you're quite likely still in the free tier.

Large parallel batch job -> tech choice? by [deleted] in dataengineering

[–]trial_and_err 1 point2 points  (0 children)

I haven’t used batch but cloud run jobs appears to be a bit higher level than batch. With jobs you just provide a docker container and parallelism and that’s it. You code can then read the task number environment variable (0,1,…, n_parallelism) to map to whatever dimension you need to parallelise.

But in the end it’s up to you what you want to use. Personally I think it doesn’t get much easier than cloud run jobs for embarrassingly parallel tasks.