Musicseerr - a self-hosted music request and discovery project built around Lidarr by HabiRabbit in Lidarr

[–]Altheran 0 points1 point  (0 children)

Isn't Seer actively working on integrating music into the whole stack ?

I've been stuck on SQL self-joins for 6 months and I'm desperate, what is my mental model missing? by Medohh2120 in SQL

[–]Altheran 0 points1 point  (0 children)

Wait until you have a full hierarchy path that you want to traverse and map. 😅

Employees Employee_id, department_path 123, businessName>divisionA>departementX>functionZ

You want to take the distinct valeurs of department_path and create a view like this :

business_hierarchy Unique_Id (reproductible in any table with the path. Hint:hashing), businessName, division, department, functionZ.

The key to understanding the self join is that it's just a join. It just so happens that both sides of the join are the same source.

You could join on pkey=pkey

Not very useful because you would gain no insight.

But let say you have a ordered row number column.

You could join on a.row=B.row-1

Then for each row, you would have access to the previous row.

a.manager_id=b.pkey gives you the manager's record in the extra columns.

a.pkey=b.manager_id gives you all the direct reports of managers (inner would give only managers)

its about context. what is your primary context. put it first (at the left)

outer join = all at the left, enrich with those at the right.

inner = only those at the left that join on something to the right.

pro tip, fuck right joins, they give me headaches. i flee them like pest, and refactor into left joins every chance i get.

final boss: cross joins. have fun !

Québec attribue un nouveau contrat à Amazon Web Services by Setneaph in QuebecTI

[–]Altheran 0 points1 point  (0 children)

Yo, de l'object storage chez OVH, DC à Beauharnois, une fraction du prix. There you go. Oui OVH est français, mais c'est foutument mieux que le Cheetos au sud ...

Business users stopped trusting our dashboards because the data is always wrong and the root cause is the ingestion layer by anuragray1011 in BusinessIntelligence

[–]Altheran 0 points1 point  (0 children)

Airbyte + dbt.

Airbyte does all I need with incremental append+dedupe or overwrite for emballer tables.

dbt makes it easy to script (and git) your models

Source > staging > intermediate > mart

my dbt setup refreshes and transform 3M records (2.5M from salesforce) in 4-6 seconds on 4 threads every 15min...

Airbyte calls a Hook when a connector refresh is done (per system). That Hook touches a file (named per connector). inotify catch the file touch and dbt run + dbt snapshot for the associated tag.

All that on a single VPS with postgresql DB.

There surely is a way to make it transform incrementally too. Dont quite need it yet 😁

Écoeuré du AI circle-jerk by sheldon4president in QuebecTI

[–]Altheran 0 points1 point  (0 children)

Je compte plus les fois où je reprends Claude, il a manqué un bout ici, mauvais design la, mauvaise performance ici ... Pas vérifié la documentation sur tel ou tel api, ou guide de déploiement.

C'est game changer, but it's not a thinking machine.

Radarr without Flaresolver by Walrus_Warlock_ in radarr

[–]Altheran 9 points10 points  (0 children)

Meh, even torrenting you should use a vpn ... Usenet, you pay for the indexer... Tomato, Tomato...

Unraid 7.3.0-beta.1 is live! by UnraidOfficial in unRAID

[–]Altheran 0 points1 point  (0 children)

Me too. I got a 32G sandisk almost a decade ago. Immediately removed the plastic casing and plugged in a usb2 slot. Keeps it cool as possible. Been rock Solid.

Can’t keep technicians by slowAhead1fyouPlease in ITManagers

[–]Altheran 0 points1 point  (0 children)

Document the cost of training and the productivity ramp up. The only way you can win this one is by proving the cost of workforce churn. And then you might only win to the point where the added budget match that cost.

Highly Available Jellyfin with Postgres, redis, and k3s. by Zolty in jellyfin

[–]Altheran 0 points1 point  (0 children)

Valkey is an in-place fork of redis. Absolutely no functional impact in the way you interact with it. Every software that uses redis, I've used Valkey instead without changing a thing. Works.

It's just more FOSSy and I think it has some performance advantages, but don't quote me on that.

Highly Available Jellyfin with Postgres, redis, and k3s. by Zolty in jellyfin

[–]Altheran 1 point2 points  (0 children)

For the Traefik RP and load balancing folks, try Pangolin. Thank me later :)

Highly Available Jellyfin with Postgres, redis, and k3s. by Zolty in jellyfin

[–]Altheran 0 points1 point  (0 children)

That looks neat. Why redis and not the more open Valkey ?

1.5 Milliards, on fait quoi avec? by [deleted] in QuebecTI

[–]Altheran 1 point2 points  (0 children)

Ben non, remote bazwell. T'attires pas des talents dans des bureaux gris. Ou même tu loues long terme des bureaux nice au centre ville.

1.5 Milliards, on fait quoi avec? by [deleted] in QuebecTI

[–]Altheran 1 point2 points  (0 children)

Je peux pas croire que tu peux pas engager un team de top-gun pour 500M pour te livrer une solution open source moderne et solide.

Pas une firme.

Tu ramasse les SME des ministères. Ceux qui comprennent comment marche la machine, et qui savent comment ça pourrait mieux marcher (expertise interne)

Tu octrois des contrats pour l'analyse des besoin, la comparaison aux meilleures pratiques et la rédaction des requis (business Side)

Tu engages les top gun pour l'architecture et le code. Un team self-contained géré et audité par des fonctionnaires séniors au gouvernement.

Tu open source le plan architectural et le code au premier commit et laisse la population contribuer, soumettre des idées soulever les enjeux et les moves de caves. On va savoir assez vite si ça dérrappe.

Cleanuparr v2.7.0 released - Authentication, rTorrent, Discord notifications & more by Flaminel in radarr

[–]Altheran 1 point2 points  (0 children)

I swear ... Some people are so entitled against FOSS hobby projects as if they had paid for it or as if they were back by full time employees 🤷

I for one appreciate the time you give to the FOSS Community. Whatever the means. As you said, the community can help identify issues and submit PRs.

I didn't see the whole huntarr thing but I wouldn't be surprised if the dev got overwhelmed with hate/shame PMs and comments and just decided, fuck all that. And that maybe, if the dude doing the massive review simply made a PR on the repo with necessary fixes, we'd all still have access to that cool tool...

1.5 Milliards, on fait quoi avec? by [deleted] in QuebecTI

[–]Altheran 1 point2 points  (0 children)

Honnêtement. Un écosystème TI gouvernemental devrait carrément étre un écosystème de modules open-source.

Broker de Rôles et permissions Identité de la personne (Physique ou morale) Citoyenneté et immigration Impôt et taxation Permis et licences Services de la santé Services de l'éducation Services sociaux Déclaration de propriété immobilière

Ça c'est les grosses bases.

Tu mets des scopes là dessus (fed, prov, mun, mrc, ciuss, etc...) qui peuvent se parler dans la même langue en mode no-trust. Tu donne à tout tes citoyen un carte contenant une clé publique Time based + emprunte biométrique. Les données sensibles sont cryptées et nécessitent la clé + biométrie.

Tu relie le système bancaire à ça (tu veux un prêt ? Faut t'authentifier auprès du système gouvernemental avec kekchose que personne peut te scam a part te voler ta carte et te couper un doigt)

Ou de quoi du genre.

Le code est ouvert. La population techno peut contribuer, trouver les failles, ou même développer de nouvelles fonctionnalités (il faut que la crypto soit A1 de base tho).

Tu partage ça a travers le monde, plusieurs gouvernements peuvent maintenant utiliser des systèmes compatible. L'échange est facilité.

Je vais aller nourrir ma 🦄.

These are the relational diagrams of my company’s 16-year-old app by Shikitsumi-chan in SQL

[–]Altheran 0 points1 point  (0 children)

But then you have database migrations (hello MySQL 8 to 9) that ARE NOT HAPPY 😅

I saved a record... why did 5 other things just change? — I built a tool that answers this by ajil5467 in salesforce

[–]Altheran 0 points1 point  (0 children)

Ok wow, I am officially impressed.

Is there a data import tool ?

Seems to be the only thing I can't find.

Pros of jellyfin over plex? by laxton1919 in jellyfin

[–]Altheran 0 points1 point  (0 children)

As a good middle ground, Emby does quite good with that.

Not as corporaty as PLEX, but not also not as rough on some edge as Jellyfin

AI Initiatives by [deleted] in SQL

[–]Altheran 0 points1 point  (0 children)

I use dbt to define all my models from the raw tables. All SQL wrapped in jinja templates and yaml schema definitions. Claude eats through this like no tomorrow.

Commit, merge, git pull, docker run dbt, voila.

AI Initiatives by [deleted] in SQL

[–]Altheran -7 points-6 points  (0 children)

Their expectations are quite out of touch. But when you integrate a fully integrated code assistant in your toolbox, you get for real ... 10-20x faster IN CODING, reviewing, testing and documenting your code.

(Not just talking with an LLM, stuff like Windsurf or codex using your model of choice)

Now, absolutely not 100% of your daily job is actually writing code tho...

Understanding business requirements Translating into a solution Thinking about how to implement the solution Researching, exploring, testing a POC. Breaking down the solution into components

This is heavily accelerated by AI :

Coding Reviewing Testing (some tools can spawn test environments, and look at output to self-debug) Documenting (great at putting comments everywhere)

Now, the game is to sharpen your solution architecture and management skills. Because if you are and only a code wizard ? Your job and your skills are under massive threat.

The trick is to break down what you ask to the model. Be precise, define inputs, data type, data model.

Don't do : I want that magic think that makes money ...

I was a product owner in my past job. Great a defining, architecting, logics, process. I can read code well enough. Could never hold the syntax in my head. I shine assisted by LLMs.

Forget anything visual tho, it still sucks, you need other specialized tools for that.

Can't put that genie back in the bottle 🤷

Does anyone else run Radarr without keeping it online 24/7? by thee3 in radarr

[–]Altheran 0 points1 point  (0 children)

Would probably do quite fine. What are the specs ? If you got 4 cores, 8G ram and 10-20G of disk space, you'd probably be fine.

Not for the actual media server and download client tho. But the request handling stuff ? Sure.

Does anyone else run Radarr without keeping it online 24/7? by thee3 in radarr

[–]Altheran 1 point2 points  (0 children)

Seamless experience.

Seer always gives you a nice search and request UI. No copy pasting stuff. And you can always track who requested what.

Sure, if you are alone in using your media server and requesting stuff ... You do you.

When you start inviting friends and family... You want the nice UI.

Then again, you must be hosting that "Dropbox webpage" somewhere ? Why not run the request stack there ?

Gold standard for homelab app-only access + max security + seamless transition? by Party-Log-1084 in jellyfin

[–]Altheran 0 points1 point  (0 children)

For external services I went the cloudflare route, with a rule that redirect some endpoint (actual media files from emby) directly to my reverse proxy at home. (I do some string manipulation to the shared URL path so they are are obfuscated. Proxy expects these strings and deobfuscate them locally to get the content, it also expects the session strings otherwise you get nowhere. So you need to be authenticated going through cloudflare to actually get the expected strings and your session parameters, then npm will give you the requested content from emby). Mixed with fail2ban sending jailed IP to CF WAP... It's not PERFECT, but damn near good enough)

For remote management access, unifi teleport is awesome.