skysight-inc/HackerNews huggingface dataset:
Postgres IS missing an analytics engine. benchmark.clickhouse.com puts it at the bottom of the list and ~1000x slower than @duckdb and @ClickHouseDB.

Here are the scenarios and how to address them

1. Query Parquet and Iceberg from Postgres. When Parquet files are stored in S3 Postgres should be able to run analytical queries on them.

2. Postgres should allow creation of columnstore tables inside Postgres storage subsystem. Analytical queries on top of these table should be FAST. Top 10 on Clickbench fast. This allows to run analytics without S3 and have super low latencies for analytics.

3. Postgres should allow creation of secondary columnstore indexes to speed up analytical queries in mixed workloads. This is super useful for Oracle migrations since Oracle had this feature for a while.

So How do we get there? 10 years ago it would be a MASSIVE project, but today we have @duckdb - super fast analytical engine with an open license. The work is still not trivial, but it is much much simpler.

First you need to integrate an analytical query processor into Postgres and today @duckdblabs announced github.com/duckdb/pg_duck…. Yay and congrats!

This plugin runs duckdb alongside with Postgres and integrated Postgres syntax with the @duckdb query processor (QP)

With that it now can trivially query external files from S3. This addresses scenario 1.

With that it now can trivially query external files from S3. This addresses scenario 1.

Building columnar table requires either implementing columnar storage from scratch or integrating duckdb storage into the Postgres subsystem. You can of course let duckdb create duckdb files on local disk, but then all the Postgres machinery: replication, backup, recovery won't work

Duckdb tables have to mapped into 8kb Postgres pages pushed through the Postgres WAL for replication, recovery and transactionality. This will give us scenario 2

Scenario 3 is even more work. You need secondary index maintenance and it will require hybrid query execution. We will need to modify Postgres executor so that it can mix and match regular Postgres query operators and "vectorized" query operators from duckdb. Or built vectorized operators into Postgres

Scenarios 2 and 3 will take some time, but I'm excited for this roadmap: this will unlock a huge world for millions of Postgres users and simplify the lives of many developers dealing with moving data between transactional and analytical systems.
> Java does at least have ordered maps

Weird

An "ordered map" is not a hash table. I think they want a tree.

But you can get the keys and sort them.

I really do not see the problem

Use a tree if order matters, Hash if not.

(Since I am not a Go programmer, maybe I missed something)
Re-rendering shouldn't be hard, it's just a specialized version of seeking. VLC has seeking.

The claim that you would have to decode all previous frames in the entire video is... completely baffling to see coming from the dev. He's arguing a stupid technicality that a video might not have keyframes. That's not a reason to omit the feature entirely.
hrmph...

Form no work on FF.

Form only Works on chrome - but just gives me signup: https://i.imgur.com/ePcBVBE.png

Page has zero meat to the info...

No screenshots, all cartoons. No talk of price/model/package/install/ etc...

No confirmation email with info...

Nice blurb - but needs work.
Yeah, I tried out the swiping and it was pretty bad to start. But GBoard has had a lot of time to learn from me, so I'll give it a chance.
OTEL was designed like it’s a Java app, and I mean that as a condemnation.

The errors are opaque and the API is obtuse. It’s also not quite done yet. The Node implementation has had major major bugs only fixed in the last twelve months, and necessary parts of the ecosystem (across all languages) are still experimental.

Overengineered and underdelivering. I’m using Prometheus on my next project. Though I’m tempted to go back to StatsD if I can find a good tagged version. Don’t hold data in a process with an unknown lifetime. Send it over loopback to a sidecar immediately and let it sort aggregation out.
That's evidence of having more allies than China, not evidence of being more militaristic than China.
You Can't Own a Pen
I am gonna call you on that. We can choose a plagiarism checker of your preference, would like to see how much ai generated content is in your hour long effort.
2008 is ancient for optimization!

People have tested old year 2000 lp and milp solvers against recent ones while correcting for hardware. Hardware improvements made up ~20x improvement, while lp solvers in general sped up 180x. MILP solvers speed up a full 1000x (Progress in mathematical programming solvers from 2001 to 2020).

Solvers from 2008 are entirely different levels of performance: there are many problems that are unsolvable by those that are solved to zero duality gap in less than a second by more modern solvers.

In MINLPs the difference is even more standing. This doesn't mean that those books are useless (they are quite good), but do not expect a solver based on those techniques to even play in the same league as modern solvers.
Not really.. the closest approximation would be if both sides set their `--transit-helper` to an unusable port like `tcp:localhost:9`. That would effectively remove the relay helpers from the negotiation list, leaving just the direct connection hints.

But you can't currently force that from one side: if you do that, but the other side doesn't override it too, then you'll both include their relay hint in the list.

Note that using the relay doesn't affect the security of the transfer: there's nothing the relay can do to violate your confidentiality (learn what you're sending) or integrity (cause you to receive something other than what the sender intended). The worst the relay can do is to prevent your transfer from happening entirely, or make it go slowly.
A lot of these were unsustainable to begin with, the number inflates the viability. The key players are expanding, and increasingly building out manufacturing in cheaper countries like Mexico, Vietnam, Thailand so they will become much more dominant.
And yet in the same breath we have people seriously claiming that the US government was >this< close to being overthrown by a bunch of unarmed boomers on January 6th.
I work for a FAANG in London and we have cross geo teams in US (California mainly, some in WA). Anyone interested in relocating to the US teams needs to work for at least a year in the UK office before they are eligible to move to US on L1B if engineer or L1A if management role.

More often than not chances of moving to US after working at a FAANG in Europe should be possible unless your company doesn't support relocations; it's better to be upfront in the interviewing stage if you want to do that.

I have never aimed for PR in US so can't speak to that; I may want to move to California only for the weather and the higher salary but my wife likes the UK weather ;-)
Money (like stocks and bonds and ETFs and ...) is already digital.
Right. It's plausible mathematics, not an experimental result. That's reasonable research, but the title and conclusions overreach.
Imagine that every so often, without warning, a 47-61 db house fly buzzes somewhere in your house. I'd grab a swatter and hunt it down before it disturbed me again.
Low level of Magnesium linked to disease-causing DNA damage
Things slip through the cracks occasionally
Thank you, I use this software so much and it's really a wonderful solution
I have ran into this issue as well. I believe my solution was to use pot player but i am not sure if its open source
I need to find a really good intro to queuing theory to send people to. A full queue is a slow queue. You actually want to aim for about 65% utilization.
> Say to your LLM, ‘Make me a copy of TikTok. Steal all the users, steal all the music, put my preferences in it, produce this program in the next 30 seconds, release it, and in one hour, if it's not viral, do something different along the same lines.’

I think it all boils down to value. Sure, in a few years time, that might be possible. But what is the value in doing that? How am I bettering my own or anyone else's life by doing that? Say what you will about social media, but it at least has theoretical value: the spread of ideas. What does this level of AI have?
There's a `wormhole send --text BLOB`, which doesn't bother with a bulk-data "transit" connection, and just drops a chunk of text on the receiving side's stdout.

You can also import the wormhole library directly and use its API to run whatever protocol you want. That mode uses the same kinds of codes as the file-sending tool, but with a different "application ID" so they aren't competing for the same short code numbers. https://github.com/magic-wormhole/magic-wormhole/blob/master... has details.
Security keys don't work with android phones when you want to logon to m365 email. This is a showstopper for a lot of people.
> If this was a superior strategy that was so obvious no 1 would be making mistakes so how does this work?

I agree with duckmysick, and also please take note that having a strategy of not making mistakes will not avoid all mistakes. Outcomes and intent never match up perfectly. But that is why it is important to learn from others right from the start.
> I am working in tech to fund my creative pursuits, an industry on its way to being blue collar

I can't tell if you think tech or art is going to be blue collar, but based on the AI revolution, you should stay in tech, or join UA.
Beware of AI generated random photos
I feel like we have now stepped into that territory. Its not going to be easy anymore to just look at a random photo and quickly spot it as AI generated.

Recently released Flux is very good at generating you random every day real life photo like images. See this example on reddit https://www.reddit.com/r/StableDiffusion/comments/1euqwhr/realism_comparison_amateur_photography_lora_flux/

There are many more. I think it mostly started from this thread https://www.reddit.com/r/StableDiffusion/comments/1en09cy/you_dont_need_a_realism_lora_for_flux_just_tone/ afaik where people realised how good it is.

And now the community (/r/StableDiffusion) is kind of focused on making Loras focused on imitating real like photos. There are quite a few threads where you will have to look way too carefully to find something unusual.

https://www.reddit.com/r/StableDiffusion/comments/1eq5400/lora_training_progress_on_improving_scene/

https://www.reddit.com/r/StableDiffusion/comments/1etypim/amateur_photography_lora_flux_dev/
I think it’s okay to be paranoid in this space. Most of us are playing the role of consumers here. Strictly identifying the data collected, and identifying Apple’s interest/ disinterest in using that data for its own shareholder’s profit is definitely worth looking at from a consumers pov.
"This is what happens when apps are developed by engineers who don’t have a strong knowledge of customers"

I'd replace "engineers" with "product owners". I'm sure the engineers at Microsoft know some of the stuff they're doing is braindead and are unable to do anything about it.
A lot of people here are suggesting metrics that are easy to collect but nearly useless for troubleshooting a problem, or even detecting it.

CPU and Memory are the easiest and most obvious to collect but the most irrelevant.

If nobody’s looked at any metrics before on the server fleet, then basic metrics have some utility: you can find the under- or over- provisioned servers and fix those issues… once. And then that well will very quickly run dry. Unfortunately, everyone will have seen this method “be a success” and will then insist on setting up dashboards or whatever. This might find one issue annually, if that, at great expense.

In practice, modern distributed tracing or application performance monitoring (APM) tools are vastly more useful for day-to-day troubleshooting. These things can find infrequent crashes, expired credentials, correlate issues with software versions or users, and on and on.

I use Azure Application Insights in Azure because of the native integration but New Relic and DataDog are also fine options.

Some system admins might respond to suggestions like this with: “Other people manage the apps!” not realising that therein lies their failure. Apps and their infrastructure should be designed and operated as a unified system. Auto scale on metrics relevant to the app, monitor health relevant to the app, collect logs relevant to the app, etc…

Otherwise when a customer calls about their failed purchase order the only thing you can respond with is: “From where I sit everything is fine! The CPUs are nice and cool.”
Does it matter? It's the same with every language, expect for the three or four major languages it handles best. Automated translation is derogatory to the audience.

It's an anti-feature. Just remove it. The target users will read the web page just like they read any other web page, in the language it is written.

Should they find their own language skills lacking, they will click the translate button in their web browser. Just like they do on any other web page.
Breaking the law isn't a meaningful part of the economic argument. X can hire employees in any country in the world. Ireland is proving itself to be more costly than a competing country and thereby pushing employment away.
My OnlyFans Journey to Fire: Net Worth $3.6M
Do you know if it's still maintained? I have a bunch of PDFs where images don't show up in Preview. I filed bugs for them, but they're being ignored.
Most artists can't make a living from their art. So they do other things to supplement that income. Its not glamorous. It sucks.
I end up using a combination of scp, LocalSend, magic wormhole and sharedrop.io. Occasionally `python -m http.server` in a pinch for local downloads. It's unfortunate that this xkcd comic is still as relevant as it was in 2011: https://xkcd.com/949/
I think technically he’s correct (I haven’t worked on media decoding code, but I understand how common video encoding formats work). If you have a long video with only a single key frame at the beginning then to step back you would need to, starting from the beginning of the video, decode every frame up to the previous frame you wanted to jump to in order to apply frame deltas, also assuming you have some sort of frame counter to determine when you’ve reached the target frame. In the worst case this does require a lot of compute, but this is an edge case if you primarily care about common video formats with normal encoding settings. I assume seeking backwards is also painfully slow on videos encoded in this manner, so why stepping back 1 frame is out of the question when compared to seeking backwards, I don’t fully understand, it must have something to do with precise frame counts being unavailable on some hardware decoders for some formats (and there being no good workaround) so you _may_ not actually go back 1 frame.

I don’t see any reason it couldn’t be supported for a set of formats with reasonable encoding/decoding settings, and provide some error message for other formats if a user attempts to step back, e.g. reverse frame stepping unavailable for current video due to format/encoding/decoding settings.
Does that seem right to you?
They’re taking your human rights away from you for your own good, my friend. They guide rails. Just don’t act out or say or think anything they don’t like and they won’t beat you because they love you.
In the old days I remember various custom (unofficial) builds of Windows XP etc. that stripped it down to basics. And then that scene went away as storage and cpu became plentiful and it was simpler to disable various annoyances through the official means.

But I hope that scene gets revived if/when they get rid of local accounts altogether, and this would be another thing that would make custom builds attractive again.
Also, there was a formula for determining the optimal cache size. I forget the name all the time. IIRC, in the end, caching most popular 10 items was enough to respond to 95% of your queries without hitting the disk.
I use wormhole a lot, but I've been too lazy to figure out if it's as secure as ssh/scp, so I always gpg the file I'm transferring before putting it into wormhole.

Is that paranoid behavior?
this is sadly true. as much as i "want" the old stories like OP to be true now (they may still be in rural areas i suspect), those times are basically over. i suppose one could do jobs like fruitpicking (totally unskilled) or other things like that but those employers dont want someone fluffing around for 3 days a week they want your life
See also: https://en.wikipedia.org/wiki/There_Is_No_Game:_Wrong_Dimens...
> If it had the stability of entire countries behind it, it wouldn't fluctuate this much and even if it did, if everything's in that currency then you don't notice it in daily life either.

Common misconception. You basically need currencies tied to countries (more precisely, OCAs or optimal currency areas, characterised by either 1. homogeneity with respect to external shocks (not the case e.g. within Europe), 2. complete factor mobility (not the case e.g. within Europe), or 3. transfer payments (that is, fiscal support)).

In other words: If there were one currency (only), even with the stability of entire countries behind it, it would still fluctuate too much to be very useful. Or, to put it different again: You need FX. One currency is not enough.
> Can Large Language Models Understand Symbolic Graphics Programs?

The title is framed as a question. And even throughout the study, the authors are careful to refer to this apparent reasoning ability with the appropriate qualifiers.

> To understand symbolic programs, LLMs may need to possess the ability to imagine how the corresponding graphics content would look without directly accessing the rendered visual content

> We find that this task distinguishes existing LLMs and models considered good at reasoning perform better

In short no such assumption is made.

You are so overwhelmed by your personal biases you're not even comprehending what you're reading.
> so, electronjs still rules

You fell trees with saws, not hammers.

I cannot imagine electronjs having the chops to implement KeenWrite.

https://keenwrite.com/screenshots.html
There are solutions to this problem that don’t involve crypto.
> Oh, so, how is it going with getting hdmi 2.1 support upstreamed into the kernel tree these days?

About as lousy as getting Vulkan upstreamed into MacOS, for much the same reason. Corporate interests and licensing feuds regularly supersede what the community would prefer, or even is capable of making for themselves. Big platforms will gladly reject a free solution if it means they lose out on licensing costs; just look at iOS and the way Apple rejects common-sense standardization so they can eke-out the last vestiges of cash from their victims.

If HDMI® Licensing Administrator, Inc. let AMD provide a free interface to their IP, how could they strongarm Apple and Microsoft into paying for a license to their kingdom? Is this colloquial "big platform" protecting consumer interests now?
I haven't looked into any claims or followed these links, so I don't know what the limitation is.

But abstractly, it's absolutely possible to write a program that decodes frame at a time and displays them slowly.

Now, whether there is some architectural difficulty based on design decisions within their player, or any player, I don't know.

Edit: I guess downvoters have never worked with a video decoder api before? I just read the link and it seems like the rationale is to not seek one frame backwards because you'd have to seek to a key frame and waste some work? That's not the same as it not being possible.
This is a catch 22, because Bolsonaro team was using social media and fake news to move dumb masses towards their objective, pretty similar to Trump in the US.
The judge in question, with his despotic tendencies, was in an open war against Bolsonaro (started by Bolsonaro) and stretched the powers of the judiciary to bring Bolsonaro down.
Now, we have 2 wrongs here. But how one should react to all of this?
What non-maintenance work needs doing? From the outside, it plays basically all the formats. There is always the potential for improving algorithms, but it strikes me as pretty feature complete.
This is how I describe Buc-ee's to those who aren't familiar - Imagine a convenience store that's the size of a football field. Inside is freshly made, but not healthy at all food and the cleanest bathrooms you will ever see at a gas station. Next to the store, imagine another football field of gas pumps. Finally, all around the pumps and store is enough paved land to fill yet another football field.

If you think I'm exaggerating, here's the Google Maps view of the one in Katy. Measure yourself.
https://www.google.com/maps/place/Buc-ee%E2%80%99s/@29.77804...
What is WebM? (2012) [video]
Really? I am sorry, but this sounds completely off-base to me. The idea you're holding onto about how the world works is counter-productive and after you spend all that money and put yourself at risk you might find yourself in the same position anyway. Perhaps consider therapy instead?
Adding onto this is Outplayer, which similarly uses MPV for its backend, for iOS & iPadOS.
This is a great example of issues with LLM design, which is that they apply a constant amount of compute to both sentences (modulo a token or two).
was the material purple-green by chance?
Yes, you obviously can’t fit 10 TB of data onto a developer laptop. However you’ll run out of disk before you run into Postgres issues.
As someone who's been working on a file upload service for a while, this is the only real way to download very large files on Firefox.

The file system access API is a great way to write chunks of a file at a gime, but for now Firefox doesn't support it

https://wicg.github.io/file-system-access/
https://mozilla.github.io/standards-positions/#native-file-s...
Something speculative is where the ghosts and soul live. How else are we ever going to prove Intelligent Design isn't total crap?
Of course it's enforceable technically. Any exemption is up to the issuer.

https://www.checkout.com/blog/exemptions-to-sca

> If you attempt an exemption and the bank returns a decline code indicating that the payment failed due to missing authentication, you’ll have to reattempt the payment with your customer but this time utilizing SCA.
> The formulation of Rawls’ question is designed to get people to focus on statistically unlikely scenarios at the expense of probable ones. As an engineer and an Asian I find it incomprehensible that Rawls has so much purchase.

We saw a lot of folks carefully ignoring a related issue during the covid pandemic: They argued angrily that it made no sense to mandate masks, lock down society, and spend billions on vaccine development, when only a small percentage of people would die or have long-term adverse effects. (There was a lot of that kind of talk in Texas.) But those folks never seemed willing to admit that they were really saying, "I'm willing to roll the dice that I'll be all right; the rest of you, well, you're on your own."

Sadly, folks like that seldom take enough precautions on their own — and they're often the first to plead for "the gummint" to help them when they get in trouble. (Cf. the bail-outs of big, de-regulated banks during the financial crisis that kicked off the Great Recession, the demands for federal hurricane assistance by people who lived in flood zones, etc. Privatize the profits, socialize the risks.)
In a similar position as you, I fully agree. I see no step wise function like gains in the foreseeable future, merely the incremental improvements you mention. Though I'm not surprised Schmidt would put these words in a sentence and express them publicly.