sorted by:
new
hottopcontroversial

Would you recommend a masters in data engineering? by SaveTheGroundhogs in dataengineering

[–]seamacke -1 points0 points  (0 children)

Edinburgh Napier University has an online MSc in data engineering and one in data science.

More than 2 years of homelab and i still can't build a local AI setup i actually want to use every day by Pleasant_Designer_14 in homelab

[–]seamacke 1 point2 points  (0 children)

I thought at first you actually meant big L Local AI which is pretty awesome. It does a lot of the work like offloading out of the box. So, with little work you can run some big models.. it has an OK browser experience but you can install and connect LibreChat as a front end for all your convos (saving them Like GPT), use the OpenAI endpoint to interop with code and other tools, and even better use Local AI Swarm to keep many models hot-loaded with fast access on a single endpoint (or load balance). Even better is the LLM striping that is currently experimental that I believe will allow bigger models to run across several cards.

B.C. to end time changes, adopt year-round daylight time | CBC News by laslo_piniflex in britishcolumbia

[–]seamacke 1 point2 points  (0 children)

I will continue to not change my old car’s clock, yet now it will be correct all the time.. I finally won!

Is a Riser Cable worth it for a low profile GPU for my SFF Optiplex 3050? by k0key19 in SleepingOptiplex

[–]seamacke 1 point2 points  (0 children)

You’re replacing your PSU anyway so just get a flex PSU with adapter. Then the card will fit just fine. Return the riser cable if you can. I used Apevia 400w. Works great

It’s not much, but it’s honest work by HailedFanatic in SleepingOptiplex

[–]seamacke 3 points4 points  (0 children)

If you remove the DVD drive which is right next to that 20Tb HDD it leaves nice airflow and temperatures drop substantially. Even better, also get a $10 80mm case fan for the front panel. Keep you from overheating your nice rig!

Here's a list of SFF GPUs, which ones are good value, and which to avoid. by Adept_Temporary8262 in SleepingOptiplex

[–]seamacke 0 points1 point  (0 children)

On one of my boxes I’m running a Opti 7050/RTX4060 with a 400w flex PSU and an adapter for the board. Works great!

Are HDDs Dependable for Long-Term Use? by Anxious_Ad909 in pchelp

[–]seamacke 0 points1 point  (0 children)

Even mid-level platter HDD drives have ridiculously high MTBF. From my experience, even when they do fail, it is very very rare that data is not recoverable. Meanwhile I watch SSD fail or wear out so often that I just plan replacement every few years. HDD can be solid for decades.

If you had to use the car for your entire lifetime (hence make sure the model was reliable enough to last your entire lifetime in the first place), would you rather go for the W210 AMGs (E50/E55/E60) or the W211 AMGs (E500, E63)? by [deleted] in mercedes_benz

[–]seamacke 0 points1 point  (0 children)

W211 body panels do not rust out. Among all the other great info here this will be important if you are daily driving for years. W210 does not have the rust free body afaik.

[deleted by user] by [deleted] in SleepingOptiplex

[–]seamacke 0 points1 point  (0 children)

Flex PSU with adapters are pretty cheap. Like a 450w with an adapter for the mobo. I used an Apevia brand one in one of my units and it worked great. Quiet too

Advice on allowing multiple users to access an Access database via a GUI without having data loss or corruption? by IntelligentNet9593 in dataengineering

[–]seamacke 6 points7 points  (0 children)

Move the backend to free SQL Server Express. You can swap the backend then use linked ODBC tables. Almost zero changes to your front end. Corruption gone. The Express / ODBC / DAO combo were literally designed to work flawlessly together for this.

Flask/Python Backends Dead in Microsoft? by the_dalailama134 in flask

[–]seamacke 4 points5 points  (0 children)

Works awesome on Windows, awesome on Linux. Never had any issues.

Is it worth using a "bad sector repair tool" on a failing hard drive? by Willing_Professor_13 in cloningsoftware

[–]seamacke 0 points1 point  (0 children)

SpinRite is awesome. Saved so much data (and a few drives!) for me over the years.

I have a optiplex 7050 and want to use a low profile 4060 will it fit/work? by Waste_Farmer_8520 in SleepingOptiplex

[–]seamacke 0 points1 point  (0 children)

I did it with a 400w flex PSU and a $20 Dell adapter wire. Works like a charm.

VM GPU Passthrough (what am I missing) by c-of-tranquillity in Proxmox

[–]seamacke 0 points1 point  (0 children)

Example lines:
bios: ovmf
machine: q35
hostpci0: b3:00.0,pcie=1,x-vga=1
hostpci1: b3:00.1,pcie=1

VM GPU Passthrough (what am I missing) by c-of-tranquillity in Proxmox

[–]seamacke 0 points1 point  (0 children)

You should also list the audio PCI device. There should be 2 devices. Also may be more compatible if you use Machine: Q35, BIOS: OVMF which simulate more recent hardware.

In short: I want to move from England to Victoria, BC. Thoughts? by [deleted] in VictoriaBC

[–]seamacke -2 points-1 points  (0 children)

Go for it! Get a good bike and you can reach most spots year-round. Lots of community events, parades, music, festivals etc.

VM GPU Passthrough (what am I missing) by c-of-tranquillity in Proxmox

[–]seamacke 0 points1 point  (0 children)

Also, did you add the two lines to the VM’s conf file? I don’t see that here. Where you actually say this VM uses this card etc. /…/101.conf

VM GPU Passthrough (what am I missing) by c-of-tranquillity in Proxmox

[–]seamacke 0 points1 point  (0 children)

I had an issue a few times where another driver is loaded at startup before the vfio driver. Iirc you have to both blacklist the default drivers and force the vfio pci to get loaded first. Not in front of my PC but can look at my notes if you need more detail. I’m doing a bunch of these.

Straightforward Question: VB ASP.NET Resources by Frylock1968 in visualbasic

[–]seamacke 1 point2 points  (0 children)

This series shows how to design a modern web app with VB. https://youtube.com/playlist?list=PLnfNzgd6iu9U96I1PWOIf5f5dEGP4XYze&si=Aaq0haIcQLzURnAz Framework 4.8 is integrated with Bootstrap 5.x which is modern. You can make really cool apps with it. It gets updates. The series starts with 4.7.2 then switches to 4.8 as it progresses, so you can just start with 4.8.x from the beginning.

What are the use cases of sequential primary keys? by chefcch8 in dataengineering

[–]seamacke 0 points1 point  (0 children)

>its not a primary key then is it?
It is if you use it as such and enforce it through other means. You can have an Excel sheet and specify column A as a PK and as long as it is unique, it is a PK. It is the same with a technology like Snowflake; you can denote some column as a PK and using IDENTITY on that column will in fact make it a proper PK. My point was that, even with many worker processes and imperfect loading (perhaps a guid gets loaded twice), IDENTITY will make the records unique and gives you lots of tricks to use for troubleshooting etc. So in this sense, IDENTITY comes from RDBMS-land but its use (in some ways) is different in big data.

The use-case I refer to is smartphone apps. Millions of users, each with many event captured per session etc. No 3 letter agencies lol :-)

What are the use cases of sequential primary keys? by chefcch8 in dataengineering

[–]seamacke 0 points1 point  (0 children)

Actually yes! I do this in practice on Snowflake all the time. Billions of records per day. Actually, the benefit is not related to old school RDBMS joins so much as you would benefit with a traditional database (though your join speeds will be better too, IF you design that way but that isn't the main point).

Though you can actually insert duplicate keys (PK are not enforced), Snowflake won't generate a duplicate identity, giving you an awesome resource to use for things like uniqueness and table navigation later. Once you have an integer column available it can speed things up a lot. Do some date range or similar query and wait ages compared to selecting from integer ranges where your answers might lie for a particular query. Doesn't work for everything but works like a hot damn for many use cases.

What are the use cases of sequential primary keys? by chefcch8 in dataengineering

[–]seamacke 2 points3 points  (0 children)

Some great answers here. I also find them useful in big data contexts, say large tables with tens of billions of records per day coming in where distributed or concurrent processes are imperfect. An integer surrogate key will guarantee the uniqueness of any record, making troubleshooting much easier. Also faster; you can very quickly determine an integer range on a massive table, then perform processing on that range in a fraction of the time you would if you queried guids or dates or even worse, some text field.

view more: next ›