skysight-inc/HackerNews huggingface dataset:
With only two indexes, one on organization_id and one on updated_at, for the query

select * from foo where organization_id = 1 order by updated_at limit 10 offset 0;

I think foo_updated_at_idx is the better choice and not foo_organization_id_idx. If it chose foo_organization_id_idx then there would be ~1e7 matching rows whose pages would have to be randomly accessed and then sorted. I'll try the same exercise in SQLite, but right now I can't see how it could possibly do better.

> When I removed the use of the wrong index, (ORDER BY update_at + range '0 day' forces the use of the correct index), the query used less resources and was much faster.

I don't know about the "range" keyword. When I try that in PostgreSQL, I get a syntax error, though the "interval" keyword works. However, that produces a much worse plan:

explain analyze select * from foo where organization_id = 1 order by updated_at + interval '0 day' limit 10 offset 0;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------
Limit (cost=1759524.82..1759525.99 rows=10 width=64) (actual time=2008.442..2011.879 rows=10 loops=1)
-> Gather Merge (cost=1759524.82..2740241.49 rows=8405556 width=64) (actual time=1983.144..1986.580 rows=10 loops=1)
Workers Planned: 2
Workers Launched: 2
-> Sort (cost=1758524.80..1769031.74 rows=4202778 width=64) (actual time=1974.717..1974.718 rows=7 loops=3)
Sort Key: ((updated_at + '00:00:00'::interval))
Sort Method: top-N heapsort Memory: 27kB
Worker 0: Sort Method: top-N heapsort Memory: 27kB
Worker 1: Sort Method: top-N heapsort Memory: 27kB
-> Parallel Seq Scan on foo (cost=0.00..1667704.28 rows=4202778 width=64) (actual time=36.576..1573.855 rows=3332288 loops=3)
Filter: (organization_id = 1)
Rows Removed by Filter: 30001046
Planning Time: 0.079 ms
JIT:
Functions: 14
Options: Inlining true, Optimization true, Expressions true, Deforming true
Timing: Generation 0.734 ms, Inlining 61.765 ms, Optimization 44.619 ms, Emission 28.563 ms, Total 135.681 ms
Execution Time: 2012.205 ms

As expected, because of the high-cardinality (~1e7) for any given organization_id, because the pages will have to be accessed randomly, and because they all have to be sorted before the limit can be applied, there's no benefit to the using foo_organization_id_idx. Sure enough, it has to do a table scan, then a sort, before it can apply the limit, and it's about 6000x slower.
An interesting quote from the article I found personally relevant "adding broadband increases the value of a property by about the same as adding a bedroom".

From my personal experience living in a rural community, I would say that is a very conservative estimate.
He does seem open to asking. And not acting above anyone.

Everyone is a beginner at something, even OP.

Exploring curiousity, whether it's new to someone, or everyone is a good quality.

I wonder how many of the students who have attended these classes have applied all that math that's existed for so long into a self driving solution
Enjoy your retirement at 64, given to you by a president whose main voting bloc consists of people who enjoyed the Mitterand reform of retirement at 60. Hopefully stupid 1930s cartoons make the last 2 years bearable.
>Good journalism isn't free, and nobody is willing to pay.

NYT costs costs $4/mo for the first year, then jacks up to a staggering (by subscription standards for 'digital media') $25/mo. They have almost 10M subscribers.

Wallstreet Journal costs $6/mo for the first year then it goes to $12.50. They and have ~4M subscribers.

For both publications the subscriber counts are mostly online-only while print numbers continue to fall.

My point is there seems to be a healthy market for quality national reporting that use pay-walls especially when the organizations have the revenue to afford international bureaus (NPR being an exception that doesn't have a pay-wall). People will pay for a product they feel hits a certain quality/trust threshold.

However, most major US cities have only 1 single newspaper remaining and those print versions get thinner and thinner due to lack of ads. Where I live, the newsrooms have indeed been gutted and/or eliminated entirely. This has been going on since around 2005 or so. Back then, the first wave was due to the dominance of Craigslist and the evaporation of the Classifieds section, which generated a lot of revenue for papers.

A significant percentage of the stories in the Seattle Times (my local paper) have stories reprinted from NY Times, Washington Post and others. Cheaper for them to pay licensing fees than hire professional journalists to write articles.
I always find it odd when startups pick names that resemble large, unrelated companies. BuildZoom is another one - has nothing to do with Zoom
I agree. Apple's play here is not as an additional revenue stream, but and additional means to be central in your digital life. Instead of using Bluetooth to the car's system or using built-in maps, you're using their tools.
first you have wrong facts about the open source drivers for gpus timeline. They are still not 100% complete, and only were usable last couple years.

Second you forget that while not supporting full 3d performance on those gpu, you still had at least a 2d framebuffer to use your system.

On mobile, Without those blobs, the CPU doesn't initialize. The bootloader won't pass some signature safeboot check. The radio won't turn on. Wifi and bluetooth won't work. The screen won't display anything. the digitalizer won't work. no battery charging. usb into otg? nope. etc etc etc.
This is a tool that automates the copying and pasting of multiple source files into a Markdown document (the prompt) in order to contain an entire code base in a single prompt.

By prompt structuring format, I mean something higher level (format, language) like OpenAI's ChatML: https://news.ycombinator.com/item?id=34988748

A document generated with the project you showed me would just be "user input" inserted into a ChatML document, just below the actual OpenAI instructions defined in a system node. Here, the LLM would consume the ChatML document inside which is inserted the Markdown (containing an entire code base) generated by the tool you showed me.
during 2020, instagram heavily advertised cheap body armor, autosears, and greymarket 'not a suppressor' kits to certain demographics.

the body armor is legal. reporting the suppressors doesn't work because the kits aren't recognizable by the moderators, who don't know how a suppressor works. moderators have learned what certain kinds of autosears look like, due to rap-culture glamorization and media scares, but they're still widespread.

i think these advertising engines have a bigger hand in the political destabilization of america than anyone understands or is willing to admit. it doesn't matter if it's negligent or deliberate.

these days i see drone munition drop kits.

we may already be in the american years of lead
Was writing them, and is (maybe) still updating them. i am no fan of Boeing as it is or has been for some time, but I doubt the maintenance manual sections related to body panels on a 90s-vintage 737-800 have been updated particularly recently. In the only (low res) photo I’ve seen of the damage it looks like metal fatigue or maybe some kind of strike damage. In the former case it’s quite likely the operator’s fault, in the latter it’s the fault of providence, one or more gods, or a suicidal bird. Regardless it’ll still damage their holy stock price, even if the reporting is shoddy.
Why Isn't There a Canadian Traffic Safety Crisis? (2022)
https://archive.is/0kPrh

https://archive.today/0kPrh
As a Flemish person, it's surprising to do how some of these still have variations in use today.

And it's disappointing how little I can find about these in Dutch.
Enjoy https://www.sec.gov/Archives/edgar/data/1713445/000162828024...
au contraire:

https://www.theguardian.com/business/2020/feb/09/texas-busin...
I thought this was a meme pump, are these guys actually having some legitimate products or services?
The problem is that if you do that, you have to test every word (~42k) against every pangram (~16k) to see if it's a subset.

I just wrote two quick test programs to find the score of the set of words for every pangrams, and my approach takes 6s vs 15s for your proposed approach: https://gist.github.com/llimllib/cc01daa8be8ced13ddeb6c76cf1...
Alex Lindsay commented that he loved the big touch screens in cars because they are a perfect place for a suction cup mount for his phone.
> Vietnamese sources are credible because it’s Vietnam.

What an incredible sentence. Do you ‘trust the bro’?
luckily i won’t be able to understand it either
Can we really blame loss of objectivity on the loss of the business model? The NY Times is doing fine and they totally threw out objectivity as a goal. Seems more like a cultural shift to me.
Their moat is good server hardware that can be ordered without talking to a sales person that has one goal - determine how much they can milk your budget.
Easiest IPO that will be shorted as soon as the VCs and other employees can dump their stock on the public markets either dumping a small percentage such as 20% on IPO day or they will do it after the lock up period or both.

Which ever comes first.
Hi! Really happy to see my project being posted around, please feel free to give feedback or ask any questions! :)
> You know what other business model doesn't work if we enforce laws mandating anti-drug morality? Drug dealing.

Pedantically, the drug dealing business model definitely still definitely works, even if anti drug laws are enforced.

It just gets more expensive, risky, and often has to pick up either organized crime backing (e.g. gangs and liquor in prohibition, or gangs and cocaine/crack/h during the height of the war on drugs) or government backing (not in an IranContra sense, rather lobbying to make your drug legal, so long as the government gets a cut - e.g. liquor or marijuana).
She runs an under-3-hour marathon. And she's prepping for the 2028 Olympics
you can buy a perfectly fine house in the US for 30k, you'll just have to be okay with living in a rural area.
I made some improvements based on the feedback received, looking forward to more comments.
> even was running dual celerons

Another member of the ABIT BP6 club! My friends could not believe that I could play Counterstrike and burn a CD at the same time :D
It doesn’t really matter. It’s fluid and redefined as needed.
That's how you airdrop straight into the worst of the python 2 3 fiasco, probably the worst time in history to start using python, meanwhile when Ruby on Rails and Java were probably the kings of that era.
Reddit thinks they’re going to sell data but their system is extremely easy to scrape (including post API changes) and all the relevant players procured that data a long time ago.
If anyone wants a legitimate business opportunity that’s admittedly notoriously difficult to monetize, consider starting a Reddit for porn. Once they’re public, all it takes is some bad PR (“I was sex trafficked on reddit” or “Reddit profited off a video of the abuse I was a victim of while underage”) for them to throw in the towel on the adult content that comprises half or more of their site. at which point there will be an overnight exodus seeking a similar platform. Reddit is a spineless and liberal company and will cave to pressure. Just my theory on a likely future event.
There's lot of undocumented things you can do with those, which the developers include because of their own itches. For example, i know most of the android and pixel core team at google have toggles for wifi and data. But they shipped a single quick setting tile for both. Yet there is a hidden setting to bring the two tile mode back.

why that happens at google so often?
I think there is a dearth of really clean uncomplicated software in the world, and many of us feel a kind of subconscious oppression due to that.

Anyone using this is responding in good humor to the psychological relief due to its design, an impressive lack of clutter. And isn't taking it seriously for its feature set.

Your reaction was so strongly negative, perhaps consider the positive response is on a different dimension from the one you are (no doubt correctly, as far as it goes) judging it.
Virgil doesn't use frame pointers. If you don't have dynamic stack allocation, the frame of a given function has a fixed size can be found with a simple (binary-search) table lookup. Virgil's technique uses an additional page-indexed range that further restricts the lookup to be a few comparisons on average (O(log(# retpoints per page)). It combines the unwind info with stackmaps for GC. It takes very little space.

The main driver is in (https://github.com/titzer/virgil/blob/master/rt/native/Nativ... the rest of the code in the directory implements the decoding of metadata.

I think frame pointers only make sense if frames are dynamically-sized (i.e. have stack allocation of data). Otherwise it seems weird to me that a dynamic mechanism is used when a static mechanism would suffice; mostly because no one agreed on an ABI for the metadata encoding, or an unwind routine.

I believe the 1-2% measurement number. That's in the same ballpark as pervasive checks for array bounds checks. It's weird that the odd debugging and profiling task gets special pleading for a 1% cost but adding a layer of security gets the finger. Very bizarre priorities.
What bubble do you live in? I live in SV and can easily count 30-40 couples with a well-off woman and a well-off man in my social and professional circles, mostly where they both work in tech. That number will go up if I think harder.
Platform o plomo
That may be the target, but there have been a handful of Spelling Bees with less than 20 words in the answer list. For instance, March 27, 2023 had 16 answers:

> MORTIFY, FORTIFY, FIFTY, FORTY, MOTIF, FIRM, FOOT, FORM, FORT, FROM, IFFY, MIFF, RIFF, RIFT, ROOF, TIFF
I filter them too. Anyone who posts an ad and doesn't allow comments is a coward.
Server-grade motherboards that have been widely used for a long time sounds like a legitimate product business. Whether or not they have long-lasting competitive advantage, that is another question.
It's the oldest, most successful, cheapest and for many people technologically superior server maker that's not IBM or HPE. Many successful businesses were built on their products in the past 3 decades. Most notably Google.
Ask God's words in different religions with LLMs
I decided to build today this quick tool that can help you ask religious questions in god's words only from ( bible , quran , torah ). i will continue adding feature and fixing bugs and sources in future releases.

future features:

- all questions and answers by users will be indexed in html pages or create automatic forum ppost to allow further discussions
- mentions the sources on the website ( https://askreligion.com/islam/quran.pdf , https://askreligion.com/christianity/bible.pdf , https://askreligion.com/judaism/torah.pdf )

let me know your feedbacks or comments or donate to help build this project.
> No. Don't forget your password. Why would you?

Because passkeys are replacing my password, right? Also, I think if I don't ever have to provide it on a regular basis, I'll eventually forget it.

> Use your password. Or if you can't use it use the "I forgot my password" process.

Why should I use passkeys then if I sometimes need my password anyway?

> They can try if they have this question.

Ok, I tried it and it doesn't work. Is that my fault or the site's? I'm confused – will your support be able to help me out?

> Nor did I think about these questions ever since even once.) So I would suspect worrying about these questions is not the primary reason why people use or don't use passkeys.

These concerns aren't about people not using passkeys, quite the opposite: They're about sharp edges that people usually only hit months or years into using a new authentication method.
Deleted due to incorrect understanding.
[dupe]

More discussion https://news.ycombinator.com/item?id=39721381
Better in way that it's reading is free from distraction and you can control the speed at which you want to read.
Or they are immigrants. I am an immigrant myself and in my circles, >90% are married by the time they are 35.
What does "liberal" have to do with anything else you've said here? Are conservatives known for their friendliness to online porn sites?
This is really cool!

What kind of hardware does it require?

Does it run without a GPU?
With all the data that’s being put up for sale by Reddit to AI companies, why do they still focus on ads? They could focus on a better user experience (unlike the @*^% move last year to cut off almost all third party apps and strangle the rest to death slowly). The value of gathering more content from users in order to freely sell it to companies should be a lot higher than tweaking ad placement and styling. Seems like u/spez (Reddit’s CEO) ran out of decent and ok ideas a long time ago and has been acting out of spite time and again.
> In the 1610s and 1620s, a new computational technology took hold in England: printed mathematical tables for compound interest and discounting (“present value”) problems. [...]

> Mathematical tables like Acroyd’s emerged out of long-running conflicts between church landlords and tenants over how to determine just and reasonable fines on church lands. Discounting tables were thus not tools of instrumental rationality evincing a new capitalist mentality, but tools of social accommodation and products of the era’s “economy of obligation.”
That's (anonymous) device attestation, not authentication key/credential attestation. Two completely different use cases.

One prevents against spam/bots, the other prevents against users getting phished/scammed into registering an attacker's credential on their account (or using an insecure credential that can later be phished/hacked, e.g. because it's not hardware-bound and easily exportable).
htmx 2.0.0-beta1
Like every other search engine, social media platform, etc. ever. Remember when ads on Google were highlighted with a big yellow block? Now they look exactly like regular search results, just with "sponsored" in small text at the top. And my guess is they went with "sponsored" instead of "ad" or some such because for some subset of the population it's probably not even clear that sponsored=paid advertisement.
The article doesn't mention it, but I read another article about car washes that argued they're used as a way to speculate on commercial real estate in cities because the car washes provide just enough revenue to pay for the purchase of the land and property taxes. Then when the land becomes valuable they can sell it to another developer.
Thanks for the feedback, yeah that's the main idea behind the project. Glad that you find it useful.
TBH, if they give us first class support for hardware optimized local LLMs and other "AI", I'll forgive them.
That would require the tool to prove the equivalence of the two programs, which is generally undecidable. Maybe this could be weakened to preserving some properties of the program.
im sure in ancient mesopotamia there was somebody arguing about you could brew beer faster if you stop measuring the hops so carefully but then someone else was saying yes but if you dont measure the hops carefully then you dont know the efficiency of your overall beer making process so you cant isolate the bottlenecks.

the funny thing is i am not sure if the world would actually work properly if we didn't have both of these kinds of people.
And yet homeownership rate in the US has been remarkably stable since 1965: https://fred.stlouisfed.org/series/RHORUSQ156N

Right now, it is at 65.7% - higher than the fabled 60s and 70s.
thanks! right now it runs on Apple Silicon and Windows, it works far better with a GPU on PC but should also work with CPU if there is enough RAM. Although some people have mentioned there are some issues with the Windows app so I am looking into that right now.
ironically they could only do that by a lack of investor interest. Let's see how many days this last now.
> Of course everyone reads from left to right

Almost everyone - I wonder if they move the "Ad" disclaimer to the left side when the UI is set to something like Arabic or Hebrew.
You're targeted by disinformation networks more effective than you realize
> it is the ability to be influenced that should be studied and improved.

I'm curious about what you mean by "improved?"
“There’s not a reason Dell can’t do exactly what they’re doing,” Bryson said.

I find that quote interesting. As someone that worked for Dell, I can figure out why - they're heavily-invested in the support side of things. They're too busy with that and their current consumer and business-class offerings that realistically the server market segment they're already in doesn't exactly overlap with Super Micro, and most likely never will outside of some buzzword AI marketing.
As someone who worked on V8 for some years, I can assure that Web bloat is not due to frame pointers.
Have there actually been advances in robotics that could make them mainstream, or is the progress still painfully slow? I think robotics would be the next logical step after AI hype, but I'm having hard time figuring out which company will be the next Nvidia there.
Nsfw posts is a big one i think. In the opposite direction, RedReader doesn't seem to have the disguised ads
Perhaps you are seriously underestimating the actual dollars companies spend on advertising.
You have to have an X account to do that now right? Whenever I try to scroll through an account’s tweets lately, I just get a list of their tweets from random dates in no apparent order.
Meh. If a ton of competitors rushed in and drove ad price down to marginal cost, they’d still be screwed. They got all their money from classifieds and eBay and Craigslist are to blame for the death of that business model.
All the kids in my neighborhood growing up tried a Milk Bone at one point. Close enough right?
I see videos of successful bund dig operations; digging half-craters to catch water apparently keeps the water from flashing off.

Tilling turns topsoil to dirt due to solar radiation.

No-till farming methods like residue mulching prevent soil depletion and retain water in topsoil; in order to create healthy soil as an output.

Hugelkultur is basically residue mulching and rainwater catchment.

Removing all of the trees reduces the level of water in the air and soil.

What sorts of agricultural machines can service bunds, raised beds, and hugelkultur mounds instead of rows?
You are saying that sales, usage, range of use cases and types of audiences of VR headsets today is comparable to Smartphones (Blackberry Palm), Cell phones and personal music players in 2007? Those are the devices that iPhone improved upon and replaced. Most VR headsets stopped being used shortly after purchase and only a few games sub genres have signs of product-market fit
How the abnormal gets normalised – and what to do about it
No idea what OP if referring to but I could pretty consistently cause Settings to soft lock for a few months by loading a configuration profile while the settings window was open, just small things like that are basically everywhere in macOS.

Don't even get me started on Screen Time bugs...
My grandparents assured me we’ve been heading to dystopia since the invention of the television. Pretty sure their parents said the same thing about radio.

Presumably if you go far enough back you’d find warnings of dystopia applied to coming down from the trees.
Google also did this. One days ads stopped being pale yellow divs but very close to actual results.
The 2140 or so puzzles I've grabbed over the years all have at least one panagram.

> 1: 1642, 2: 364, 3: 90, 4: 24, 7: 2, 5: 12, 6: 5, 8: 1

That 8 panagram day was December 16, 2021