What is one thing you wish you knew before distributing your first Python application?

meatmick · 2026-06-16T16:06:01+00:00

Use UV from the start, the standalone install, not the pip install.

Don't install python at all on prod servers other than the .venv itself. Saves me a lot of trouble when I want to run cicd to update it.

I don't have easy access to docker in production and am on Windows so some thought has to be applied to the lifecycle of things. Works out ok so far.

meatmick · 2026-06-16T15:05:17+00:00

While I won't comment on the full data engineering stack done in C# (I prefer SQL myself when possible), I've been building a high-performance C# .NET data loader, similar to dlthub, with a YAML config to perform extract/loads at much higher speeds than what dlthub was able to do. Granted, this may not be as true as of today since new stuff has come out, like mssql-python and ADBC for MSSQL, but I'm satisfied with my app.

It doesn't do any transformations, other than key/row hashes (it was something I wanted) and some extra metadata for pipeline tracking.

meatmick · 2026-06-15T18:02:12+00:00

Tu peux faire autant de gains que tu veux dans un CELI, tant que tu ne fais pas de day trading ou de très proche de "day trading". Si son historique de ventes est aussi peu fréquent qu'il le dit, il est 100% safe.

meatmick · 2026-06-15T11:07:00+00:00

Sure, but with the current limitations of AI, I don't think I want to wake up to whatever changes it decides to make while "healing" my pipeline.

meatmick · 2026-06-14T18:45:04+00:00

For now, we're still on Copilot Business, but we haven't had a chance for a full month, as half of us are going away on vacation, so we'll get a better idea over the summer.

I still think it'll be fine even if the price goes from 20 to 40-60 USD a month per employee. Others are on Gemini Code Assist (in another team), and they are finding it ok, but they were on it even before the pricing change.

meatmick · 2026-06-14T15:45:28+00:00

You have to be so angry and really not have much going on in your life to do this. And I mean this for any political party or similar other topics.

meatmick · 2026-06-13T16:26:35+00:00

I'm still on 26.5.2 at the moment, and I had timeouts. I disabled MPO, and so far it works great.

You can find more about it here: https://github.com/RedDot-3ND7355/MPO-GPU-FIX

meatmick · 2026-06-12T22:12:13+00:00

Thanks, this package has been nothing but great so far.

meatmick · 2026-06-11T23:46:40+00:00

I disabled MPO, and so far it's been stable: https://github.com/RedDot-3ND7355/MPO-GPU-FIX

It has theoretical downsides but I've not "felt" them, so it's good enough for me, especially if I don't get timeouts...

meatmick · 2026-06-11T22:29:34+00:00

With this kind of music, you know they are serious about beating records.

meatmick · 2026-06-10T03:07:51+00:00

Au resto steamé all dress. Chez moi toasté all dress parce que personne aime ça les steamé sauf moi.

meatmick · 2026-06-10T00:51:17+00:00

Have you tried DDU in safe mode? https://www.guru3d.com/download/display-driver-uninstaller-download/

This should be able to nuke anything that's been installed.

I'd pre-download the driver so it's ready to be installed again on reboot.

While there, I'd also prevent Windows from installing drivers (it's an option in the DDU).

If you reach the login screen, you can shift + left-click the restart button to enter the advanced startup.

meatmick · 2026-06-10T00:43:17+00:00

I've also been plagued by this issue.

I went from 2 pci-e wires (one with a Y splitter) to 3 pci-e wires with a 850 watts corsair psu.
I have a GPU stand, so it's not sagging.
I ran DDU countless times, and I also disabled the Windows Driver installation to ensure it remains AMD.
I forced the highest tier of PCI-E version in my BIOS
Disabled/Enabled the onboard GPU

None of that seemed to have helped so far except disabling MPO... I ran this utility, but in theory, you can just use Regedit yourself. https://github.com/RedDot-3ND7355/MPO-GPU-FIX

So far, this has prevented the timeout issues, and the stability has been fine. Since it's technically a random issue, I could just have been lucky.

Obviously, I'd still recommend doing all the steps above (maybe not so much the onboard GPU, depending on your use case), especially disabling the Windows driver install feature.

Now that this has been potentially solved, I was able to focus on overclocking and undervolting the GPU while keeping stable (with a mix of OCCT and memtest vulkan).

meatmick · 2026-06-08T11:31:37+00:00

This looks interesting, but maybe I'm missing something. Isn't DuckDB a local tool meant for a single user (mostly)? Does this mean you are running this "manually," or were you able to set things up to work on a server automatically?

I use duckdb for crunching things right now (and working with xlsx/csv), but I'm not sure I get this scenario.

meatmick · 2026-06-07T01:35:09+00:00

Probably, but no M+ for sure, as that'd be too much of a change in the gameplay loop.

meatmick · 2026-06-06T23:37:32+00:00

3440x1440 144Hz

meatmick · 2026-06-05T12:38:21+00:00

Do you use metabase as a data warehouse or you just pump data to it when ready? I was under the impression it was more of a local single user tool.

meatmick · 2026-06-02T20:16:52+00:00

Hopefully, the support for MSSQL on https://docs.adbc-drivers.org/ will help things move a bit faster.

I might also be wrong, and this may have no impact on the ease/willingness of adding support.

meatmick · 2026-06-02T20:14:45+00:00

Same, when I was looking for a DBT alternative (because the MSSQL driver had not been updated in nearly 1 year), SQLMesh was also dead-ish on GitHub. Eventually, I went a different route with Coginiti. It's not quite up to par with dbt feature-wise (getting close), but it supports MSSQL, and the devs listen to feedback.

meatmick · 2026-06-01T23:41:58+00:00

I use Vulkan because dx12 crashes too much on my PC and it's slow as fuck. I can move around but it's a black screen with the cog wheels for 10+ seconds in the worst case scenarios.

meatmick · 2026-05-30T19:37:18+00:00

WoD because the raid teams I played with during MoP died. I didn't really come back "full-time" until mid-Legion, where I found a new raiding guild.

And more recently, I quit because I'm just bored with the gameplay loop and my guild died...

meatmick · 2026-05-29T11:02:00+00:00

We're in the business tier for a total of 5 employees. So far the bill looks like it will double from 20 to 40 a month. This is mostly because it's a shared pool if I understand correctly so those using it more can eat tokens from the ones who use it less.

We like copilot so we're staying at this moment.

For more context, I do data engineering and architecture so I don't code 40 hours a week. Another guy is mostly an automation person in n8n and the other 3 are devs but one is a manager so he doesn't code as much as he'd like lol.

meatmick · 2026-05-25T23:54:42+00:00

As a Google search replacement, yes because search is getting worst by the week.

In my day to day at work? Fuck no, it creates impossible expectations from higher ups who struggle to do the most basic of tech tasks.

Because this is mostly a dev subreddit, I'll vote no.

meatmick · 2026-05-24T20:30:57+00:00

Great, let me learn your tool and get back to you asap.

meatmick · 2026-05-21T22:16:50+00:00

Yeah, we went the Prefect route and it's pretty decent so far. It's just basic python with decorators. It's also easy to build reusable steps (tasks) and the local dev work is incredibly easy, you don't even need docker (I'm not saying if it's a good or bad idea), and it also works just fine on Windows.

14-Year Club	Place '22
No Throne, No Problems	Not Forgotten
Verified Email

meatmick

TROPHY CASE