Hacker Newsnew | past | comments | ask | show | jobs | submit | more salzig's commentslogin

> STRING_AGG aggregation result exceeded the limit of 8000 bytes. Use LOB types to avoid result truncation.

Looks like not all databases (mssql in this case) like the generated result.


Thank you for catching that issue with the STRING_AGG limit! I just pushed a fix that now supports nvarchar(max) to avoid truncation. This should resolve the issue with large outputs in MSSQL. If you still encounter any problems, please let me know. I'd love for you to give it another try and see if everything works as expected now. Your feedback is invaluable!


now it kills the process (dev env, container).

Not sure what kills it, but without "columns" in "full_json_result" it runs through.


Yeup. Seconded. MSSQL as well. Was curious what the output would look like given it's a fairly large db (a crap ton of mostly useless tables kept for archival purposes).


In regards to VR, I think Valve could really move the hole situation by building/providing SteamLink VR on AVP, as they do on Meta Quest. Buy any Bluetooth (VR) Controller and enjoy games streamed.

And maybe in some future I will be able to stream from Linux hosts via SteamLink.


Exactly, a device that expensive has to deliver as much value as possible.

Trying to sell a lifestyle accessory for people who have to own every Apple product that there is the beginning of the end for Apple that they’ll be talking about in business school the way we talk about DEC, Tandem and Commodore today.


IMHO: the AVP is a DevKit that is sold to consumers. But more polished then the typical DevKit.

But looking into the past and seeing how many people where eager to buy GoogleGlas/Oculus Devkits, why shouldn’t a brand like apple decide to push out a devkit as high price consumer device, instead of trying to keep a devkit for a upcoming product a secret?

I’m still wondering what direction the product can and will take from here on. If you compare it with iphone1 vs iPhones today, it could be quite interesting.


Because they invested billions of dollars into making said devkit and despite seeming promising the actual general usefulness of it was still extremely unclear, so it was down to 2 choices: a) kill it, or b) ship it and see what happens when the rubber meets the road.

Arguably Apple has never done b) before, but then again they’ve also never poured billions into a R&D project like this before. (The only other example that comes to mind is the car, and that one got killed, so maybe they were loath to kill the two billion dollar science fair projects at the same time).


You mean 21st century Apple. Because 20th century Apple had plenty of good flops: Newton, Pippin, Macintosh TV (no, not Apple TV).

https://www.macrumors.com/2023/01/14/apples-biggest-hardware...


I think the issue is just that the developers Apple wants to poach for this are the ones that they push away the most.

Not only does Meta already control a large chunk of VR game development (to the point that even regular PCVR has been kind of starved for content), but game developers, besides for the iPhone, don't really care for Apple, and considering that the AVP does not have the things that the iPhone has going for it...


I disagree, given Apple’s marketing around it, features like Persona FaceTime, and integrating spatial camera shooting on iPhones. But even if it were true, it’s also failing as a devkit, given how few devs are interested in it.


Because they're 10 years late to the party, everyone has moved into AI now, and even those headsets are hardly selling a lot.


When have Apple ever shipped a product as a "dev kit"? Dev kit is a euphemism for failed market launch. (Maybe Apple should retroactively call the Newton a dev kit as well.)


The ARM porting device for the x86 transition, but that was optional to return.


I was thinking of something that was an actual "product".


To me it seems obvious that the end goal is something with identical functionality to the AVP but in the form factor of a pair of wraparound shades, and that somebody high-up at Apple decided it was perfectly acceptable to set money on fire for 20 years if it let them eventually get something like that to market before anyone else and thereby replace the entire phone/tablet market.


The author doesn’t believe his content is worth reading (full page „popup“). Good he included this feature so I can leave the page early.


Next Iteration: malware checks for scarecrow and starts anyways ^^


yabal requires quite some privileges. Did you check out https://github.com/nikitabobko/AeroSpace ?


FYI AeroSpace is nice but can't handle apps with tabs, like Finder. This is a non-starter issue for me at least.


Elevated privileges for yabai are optional, it works just fine without disabling SIP.



Just dropping this "random" ffmpeg command here, as a reminder that you can turn video files into actual transparent webm using

    ffmpeg -t 5 -i example.mp4 -c:v libvpx-vp9 -b:v 2M -filter_complex "[0:v]chromakey=0x00ff00:0.3:0.2[out]" -map "[out]" -map 0:a stop.webm`
where `example.mp4` is a video with the typical green background.

Maybe someone needs it :)


Last time I checked QuickTime was still not able to. Did I miss something?


I checked and seems to be just Microphone (or other audio) input w/ QuickTime when recording sceengrab videos or recording just audio.


This is correct. And if you use a headset it won't pick up the general system sounds. Used it for an IEP call last week and found out afterwards the only audio it picked up was my own. Pretty frustrating.


yah, I just recently made the purchase for BlackHole because I couldn't get the system sounds otherwise. Great little project!


Free like QuickTime to Record/Capture Screen contents and iMovie to modify the material?


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: