CIPWTTKT&GC 0x2E - Abort, Retry, Fail? - Hardware & Software

I'm working on that for mine, I'm using two for my CPU rad, the 3K RPM one came with my Vega LC rad, and then I'm replacing my front intakes with them slowly..

I didn't know you could still buy gentle typhoons, they're amazing. They're the fan that's on the Fury X radiator and it shifts so much air.

Ships with Vega LC rad too. And yeah, they can be gotten via Darkside, and PWM versions can be gotten on Amazon direct from Nidec.

I want to be done working on this shitty database. I either have the option to have like six tables for pricing at different location or extra columns in one table and I'm not sure which is the better way to go so I've just completely avoided that part for now. I made the DB calls so much faster though so I'm proud of that at least.

go for the extra columns. I hate having to navigate a DB where things are associated with eachother in different tables. It sucks.

Absolutely do different tables for this. Adding a column per store is silly, and if you have a situation where you add/remove stores in the future, it will get even sillier. If I am understanding you correctly, you should be shooting for something similar to this (bare bones example): https://files.facepunch.com/forum/upload/109738/6a6002e0-953f-490a-a18c-d85b8be3d12f/db.png You have an inventory table that holds data for your items being sold. A store table that holds data for each store you have. Then in pricing, you have the item_id (id from inventory) and store_id (id from store) to make a unique primary key with price assigned to each. This way if you delete a store, the associated pricing data is also deleted, likewise with an items that may be deleted from your inventory. Having all of the store pricing in columns completely invalidates database design, and you might as well just make an Excel spreadsheet. In response to the poster above, joins are a pain but they are easy and effective when you build the database properly. "Proper preparation prevents piss poor performance"

To add to this, if you really want your database to be more human-readable, you could always make a view that simulates the column solution. You can always abstract away complex database design further down the line, but you can't fix shit database design without changing the database itself.

To add further, human-readability isn't for database design. Machine-readability is. Like above, views are for people. Database design should be as atomic as reasonably possible. A database admin adding columns like this into a live database should be grounds for public lashings with Cat5. (I know this is likely a school project or something, but there's no such thing as a bad time to learn good practice)

Do you work at Ubiquiti?

It's actually for work, I was handed a shitty DB that's basically falling apart and told "fix this and make a program do things"

Welp, all the more reason to do it the right way. Contact me if you need some help, I'm all for fixing stupid.

tell me more

Manually migrating a half broken Unifi controller that's been upgraded way too many times is a bitch and a half.

Well I understand why nearly everyone I know that's used ESX absolutely hates the web client, it constantly freezes up any browser I try it with that isn't chrome, and if it works, the console view usually makes the whole thing shit itself

I wonder if LIDL has the same prices in every store nationwide here as a marketing trick, or because the IT department said they can't do different prices for every store.

Columns that store values that can be recalculated when needed and end up out of sync with reality drive me up the fucking wall. I'm looking at you, outsourced payroll developer whose spaghetti I must correct.

Nah, I don't think he runs his webserver as root on an embedded device.

If you're on 6.5U1 make sure to install the rest of the small updates, it fixes a lot of bugs in the web UI.

Getting a ban email for a game you haven't played in two years is interesting. learning that Ubisoft's password change system is completely fucked isn't fun.

I wanted two simple numbers two weeks ago. Now I'm reading about instruction execution cycle counts on Cortex M3 and Flash wait states. https://www.youtube.com/watch?v=AbSehcT19u0 Fucking hell.

my stupid plan is working my friends and I now have three SIP phones running through tunnels back to my central server so we've essentially got a private phone system accessible from anyone with an IP phone and some form of routing device. This is so stupid and impractical but damn it's fun

Just moved to a new house, paid for gig service and wired the place up with Cat6. Installed 4 AP-AC-Pro's and installed an ethernet jack in each room. Got everything terminated in a basement server cabinet I had to hammerdrill into the cinderblock walls. https://files.facepunch.com/forum/upload/281778/6eaf6328-b34b-4e10-aee8-9935cae7331e/IMG_20180526_214404.jpg Now I'm looking for a firewall with IPS (DPI would be nice) that can handle a gig throughput. The USG-PRO-4 is underpowered and the USG-XG-8 is overkill. Any ideas? My guess is I'm SOL unless I want to spend a lot of cash.

Looks sexy outside of the unpainted wood support.

I've got them both on 6.5U2 and 6.7 and they both throw up issues that make me resort to the remote connection console.

Steam summer sale ends today buy payday is tomorrow. No new games this year for me Not like I'd play them, but I could've bought something.

Steam sales so shit now I didn't even know it was on. Nice one Valve.

Your employer is making sure you are not wasting your money on games you won't play.

I can't remember when I've last bought anything on sale, on Steam. There's no new games out there right now that I'd care about.

My girlfriend bought me Fallout 4 VR and I bought me Skyrim VR. Feeding the Bethesda machine of rereleasing stuff I guess. But for real, I'm not sure if the sales are getting worse or if I have most of the games that are on sale so they seem worse.

Only a few triple A games that come out each year are really worth getting, and triple As usually don't go on sale until they've been out for over a year With a huge backlog of games already, you're probably not looking at indie games much, and the huge influx of Indies has made it hard for decent ones to stand out I personally don't think the sales are much worse than they've ever been; they're just not as exciting anymore.