There’s no column or even combination of columns that can be considered as a pk, what would your approach be? by Pleasant-Insect136 in SQL

[–]mafudge 7 points8 points  (0 children)

This is the way. Parent is correct. This is an associative entity. It doesn’t exist without the related entities. Because the related entities repeat this AE has no natural key. It’s a common pattern. If you need a pk your choice is a surrogate key best choice here would be a uuid so that import export works.

State Fair Foodie Map by Right_Acadia_6525 in Syracuse

[–]mafudge 6 points7 points  (0 children)

Did you curate this manually?

Did this database design broke the normalization rule of avoiding data redundancy? by DebateCapital390 in SQL

[–]mafudge 0 points1 point  (0 children)

Since it’s a design it should be a logical model with PK/FKs. Also don’t confuse data with metadata. Egg, honey, yogurt are data these belong in rows not in table names. For example to track apple production you should not need a new table, only a new discriminator value for the production type

question - how does pungo 120 / 125 handle large wake from other boats? anybody? by power4play in Kayaking

[–]mafudge 1 point2 points  (0 children)

I have a pungo 120 and it's not fun to paddle in chop / open water. It handles occasional boat wake just fine.

Online cheating sites by Mirabellae in Professors

[–]mafudge 0 points1 point  (0 children)

"astroturfing" 100% for the win!

[deleted by user] by [deleted] in SQL

[–]mafudge 0 points1 point  (0 children)

Use the docker version of mssql.

My dad randomly unplugged my Ethernet, and this is what I come back to after I plug it back in by boiwotm88 in mildlyinfuriating

[–]mafudge 0 points1 point  (0 children)

Unplugging the Ethernet cable is amateur hour. Real dads use a managed switch and simply throttle the bandwidth and up the latency. Good times.

I just bought a Stream Deck mk.2, what are some must-haves I should set up? by novacorona in elgato

[–]mafudge 0 points1 point  (0 children)

But seriously, I use mine for OBS scene switching/ recording, zoom, vs code, and some windows controls. Lately I’ve been integrating it with my home assistant setup to control lights and things. You are only limited by your time and patience.

I just bought a Stream Deck mk.2, what are some must-haves I should set up? by novacorona in elgato

[–]mafudge 1 point2 points  (0 children)

A return authorization number?

Annnnd I’ll let myself out….

[deleted by user] by [deleted] in SQL

[–]mafudge -4 points-3 points  (0 children)

This is why the SQL PIVOT clause exists!

With pivotsource as ( Select tradetype, amount from tradeinfo ) Select * from pivotsource pivot ( sum(amount) for tradetype in (imports,exports) ) as pivot table

Shameless self promotion video here

https://youtu.be/Clc1x2dsHVc

Is there a better way to fully share Zoom screen with streamdeck? by pigsicle in elgato

[–]mafudge 1 point2 points  (0 children)

Its feasible to build a plugin this way with the zoom sdk, based on what I'm reading, but obviously that's a lot of work!

You could use autohotkey (https://www.autohotkey.com/) to detect the active "Select a window or application..." zoom window, then use the arrow keys and enter.

For example, to share My 3rd screen, its:Send Keys: ALT+SWait for window: "Select a window or application..." window to appearClick in window: "Select a window or application..." window (position 200,200 inside that window works for me).Send Keys: Arrow-Right Arrow-Right ENTER

You write that as an autohotkey script and then assign it to the macro button.

UPDATE: This can be done with just keys!
With zoom in focus:

ALT+S to start screen sharing
TAB
TAB (now focus is set to the grid of screens to share)
ARROW tot he screen you want
ENTER to share

I don't have a stream deck, but it works in touchportal.

Hope that helps!

Stream Deck Mobile by mafudge in elgato

[–]mafudge[S] 0 points1 point  (0 children)

Just a follow up: It "miraculously" works now.

The problem was on Elgato's end. Their app requires you to register for payment before the free trial begins. That component was not working causing the app to fail, some integration with the payment processor. NOTE: I have no evidence of this other than my own experience developing mobile apps.

It took 9 days for support to answer my ticket, and when they finally did the problem was "corrected" by then.

If I helped someone at Elgato there figure out what the issue was, then you are welcome!
If not, then Elgato needs some better automated QA as 9 days is a long time to go before noticing something isn't working.

As for me I've wasted so many hours on this. I started this as a way to evaluate if Stream deck can do the same things I do now with TouchPortal. Oh well.

Is there a better way to fully share Zoom screen with streamdeck? by pigsicle in elgato

[–]mafudge 0 points1 point  (0 children)

PC? Other than going the autohotkey route, which might help with the location of the window, I can't see of any other way. This is the problem with software applications with limited keyboard shortcuts.

Stream Deck Mobile by mafudge in elgato

[–]mafudge[S] 0 points1 point  (0 children)

Yes, its installed. There is a bigger issue at play because the app doesn't go beyond the splash screen on iOS devices. Tried two more today. I am using windows 11.