skysight-inc/HackerNews huggingface dataset:
Ever used `SQLite_OMIT_*` directives to reduce SQLite's memory footprint?
I recently came across a section in the book "Using SQLite" by Jay A. Kreibich where he mentions[1] the `SQLITE_OMIT_*` compile-time directives.

> Using the default configuration, the compiled SQLite library is less than 700 KB on most platforms, and requires less than 4 MB of memory to operate. By omitting the more advanced features, the library can often be trimmed to 300 KB or less. With minor configuration changes, the library can be made to function on less than 256 KB of memory, making its total footprint not much more than half a megabyte

While this sounds promising, I'm struggling to find any discussions or blog posts on the use of these directives. Has anyone here tried them?

[1] https://www.oreilly.com/library/view/using-sqlite/9781449394592/apas08.html
At least in the US, that's not how the healthcare system works. Some blame CYA. Some blame the fact that the system only makes money per procedure. The GP is saying in the US, patients often get procedures that are not worth the risk.
You certainly have to appreciate the irony of Hashi calling others freeloaders, having integrated Open Policy Agent into TFC/TFE and contributing nothing in exchange.
Stack Exchange also provides one: https://archive.org/details/stackexchange

There was a hiccup around June but that seems resolved now: https://meta.stackexchange.com/questions/389922/june-2023-da...
> As of June 30, 2023, we had 1,458 customers generating over $50,000 of ARR, representing growth of 94% year-over-year.

Of 130,000 customers
The iPad pro is basically this, but just needs to be able to swap when you hook up the Magic Keyboard.
The hardware in the iPhone is probably powerful enough to run all software he'd run on his Mac if it were similarly unhampered by iOS.
What the world needs is a bunch of Letzte Generation volunteers gluing themselves to the launch pad to show their commitment.
> One thing I couldn't wrap my head around, why there is no standalone version?

Standalone version of what? DuckDB? If you mean DuckDB, there is:

https://duckdb.org/docs/archive/0.8.1/installation/index

> How would it achieve storage of data (large data volume)

- There are so many ways you can do this that you end up going down many rabbit holes...

- Locally on your own machine's local storage.

- On AWS you could use EBS, EFS, expandable /tmp, S3...

- On a Data Lake you could use parquet/json/csv/etc, hive, and in version 0.9.0 (Sept 11th) you could use Apache Iceberg.

And probably so many other options I haven't even thought or read about...
> But admittedly i was convinced by one of those "my second brain changed my life forever and cured cancer" videos [...] But all the videos and posts claiming its changed their lives or something is a bit much.

Would you have clicked on the video if the title was "My second brain has been kinda useful, I guess"?
The stress is temporary. Eventually, you come to terms: You will die and there will be nothing you can do about it. So be grateful for everyday, and take nothing for granted. Then, you will know peace.
I do the infra from our company. I _want_ them to train on our infra and everyone else's infra and to tell me what actually works and will solve my problem, not what my account manager recommends because AWS approve it. That's basically the value add of the tool.
It's much better to use something like bge-large-en - https://github.com/arguflow/openembeddings
Show HN: Take a recipe website URL and remove the cruft
> how is this more dangerous than trials for a new heart medication that might kill patients?

Clinical trials happen through an established regulatory framework to minimize harm to participants, for starters…
My guess is they went IPO. There was a massive cash infusion. Good. Eighteen months go by and people will be exiting. That means cash and talent leave.

Now sales are tough. Pricing is terrible. We've been using their services for years while being offered enterprise services without much incentive.

Why the license change? Lock out competitors or perhaps a charitable assumption, secure future service offerings without being exploited by cloud offerings that use their code while competing.

The decision was a business decision. The amount they spend on sales to sell what I think is an amazing product, just over priced, is their doom. Why lock an enterprise into a three year contract tied to usage?
That's pretty impressively expensive, especially given that the innards should not have any particular dependence on the rated current. (I suppose the GFCI sensing circuit needs to tolerate an increased amount of induced current as the available fault current goes up.)
Ubuntu Unity did better than most in that department.

Still alive and being maintained, too.
Are you claiming that, at population level, the amount of false positives MRIs produce outweigh the benefits in terms of human health benefits?
If you don't mind sharing, could you elaborate on the process of finding these ideas and how to look for them and validate them? Thank you!
Verifying your identity on Twitter will require taking a selfie
What is your definition of an identity of a ternary function? Say i is the identity of f. Must it hold that

f(i, a, b) == f(a, i, b) == f(a, b, i)?

For all a, b in f's domain? The seems like the obvious choice, and certainly holds for ternary functions "built up" from associative binary ones, but I've just never seen such a thing. Is there a case where it's useful to talk about the identity of a 3-valued function?

I think the thing I find weird about this is that a binary operator op2 over some set S is defined as S^2 -> S. So we can sensibly say:

op2(a, i) == a == op2(i, a)

But the extension of this to a 3-valued function from S^3 -> S cannot have that middle condition, because it has too many "free variables". We can't say:

op3(a, b, i) == op2(a, b)

Without establishing a relationship between op3 and op2, but must there be a sensible "decomposition" of op3 into some op2? Surely not. I guess I just don't know what it means to be an identity of a 3-valued function.

As an example, consider mult3(a, b, c) := a * b * c. Then,

mult3(0, a, b) == mult3(a, 0, b) == mult3(a, b, 0)

for all a and b. We intuitively know that 0 is not behaving like an identity. Can we write down an identity rule that must hold for a generic op3 that excludes 0 as the identity of that function? Without relying on some oracle to provide us an appropriate decomposed op2?

Edit: I would also like to point out this function over R^3:

f(a, b, c) := a*b + a*c + b*c

Note that every value in R meets the condition:

f(a, x, y) == f(x, a, y) == f(x, y, a) == ax + ay + xy

For all x and y. Is every number an identity of this function? In fact, this is trivially true for any completely associative function. I guess I just need to see the definition of an identity of a ternary operator.
i'm familiar with the literature and the incorrect consensus in the field
I use both with Org-mode, except my R=refile and is my org-roam directory.

Some notes have a known place in a system from the start. Some need to wait for connections.
I felt that was a bad sign for the generative AI bubble anyway, that an enhanced Bing was being touted as one of the flagship products (around April iirc). It felt like a bad joke. It seems like gen AI has been able to shake off Bing without any reputation damage.

Personally I use chatGPT as a tool but I don't really see it as a complement for search as their uses are so different. Modern search imo is basically a smart web portal (1999 Yahoo style) as in I'm using it mostly to get something I know exists, not really discover something, but instead of having to click into something I can imprecisely enter a query to get it. So if I'm doing a search, I generally just want the site I'm looking for, not a summary or whatever.

Otoh, LLMs I use when I want a synthesis or explanation that I'm not expecting I can find on a website and would otherwise have to read a few things and put something together.
Which is extra annoying, because they shouldn't, but it's somewhat vague.

CCPA says: "Businesses also should not require you to verify your identity, though they can ask you basic questions to identify which personal information is associated with you."[0]

The worst is that some of the bigger services (intelius, who provides data for many of these sites) have begun to require opt-outs come from an email address that they already have on file for you. Really need to legislate these companies out of existence.

0: https://www.oag.ca.gov/privacy/ccpa#sectionb
That was an interesting comparison of behavioral vs non-behavioral ads, thanks.

But my question was geared towards the value of advertising itself, in general (if there is any).

I am aware of the unknown unknown problem you mentioned (I think), but in my experience as a layman, very very rarely (if ever) was I introduced to a great product or service through advertising that I wouldn't be aware of in other ways.

Conversely, the amount of ads for substandard products and services (i.e. those which I know for sure there are better alternatives, at least for me and others around me) is infinitely greater.

And I don't think it's just because the ads are not targeted enough. I'm pretty sure I am a hugely interesting target for many, many companies, but I am simply not interested in them (and never will) because other companies have much better products/services (many of which I already use).

I am assuming, of course, that the only reason they're interested in targeting ads to me, is to influence me to make a buying decision that I wouldn't do otherwise, and not just because I wasn't aware of the product/service. Because if it wasn't for influencing me making a buying decision, why would they spend the money to show me an ad?

That's why I always try to ignore (and block) ads as much as possible, even though that's not always possible (e.g. street ads). Yet, I am still being bombarded with non-stop ads and I have no question that I'm being negatively influenced by them, especially in those areas I know very little about (e.g. cleaning products) or am susceptible to being influenced against my own interests (e.g. fast food or other crappy, addictive food products).

In my experience, the success rate of my own research (when looking for a product/service) or even word-of-mouth recommendations has far, far outweighed the success rate of all the ad campaigns I've ever been a target of, from my own perspective (not from the companies' perspectives, of course).

So it's not that I don't see any value in advertising, which I don't (unless you're the advertiser), it's that I think it's actively damaging to society (due to leading people to make bad buying decisions) and the economy in general (due to increased inefficiency).
> This article solidified the concept for me, and I’m grateful. Why so cynical?

If it were not posted on HN you wouldn’t have seen it, I’m guessing. As for the article itself, it is a surface-level, paraphrased encyclopedia entry on this observation. It could have provided more value with more than just a jar of coins as an anecdote, perhaps showing how this can apply in face-to-face negotiations.

I think it’s fair to be skeptical of intentions because of low-effort junk out there that exists solely as a lead gen.
It's quite trivial actually. It's just `make deb-pkg`. It may complain about a cert. https://github.com/torvalds/linux/blob/master/scripts/packag...
That's exactly what I have with a convertible Chromebook. Super Snappy ChromeOS for web browsing. It can run Android apps, or stream them from my phone. Flip it around and it's a BIG tablet. 15.6" 4k screen. Going back into computer mode I can run full blown Linux, very quickly via Crouton or virtualized slightly less quick with official Crostini. Can also do a lot of the terminal stuff directly in the ChromeOS shell. In either Linux environment I can emulate Windows via QEMU/KVM. It's as fast as native in Crouton, again a bit slower in Crostini. Lightweight,long battery life, charges over USB-C will fast charge my phone and interfaces seamlessly with the phone for tethering that doesn't use hotspot data and doing messages notifications, etc.
"Won't someone please think of the big-tech ad profits?" - You

Why should the web's profitability or lack thereof, be my problem as a user? That the SV elite can't buy platinum plating on their yachts? Are they sharing that wealth with me? Then, good riddance! My privacy is more important than your wealth.

There's been profitable SW companies and careers before user tracking became the norm. Remember when Windows came without any ads and blogs and forums had generic non-targeted ads?

Same how the big tobacco industry got kneecapped for our own health and the greater good, a similar tech industry correction is long overdue. Is this the world you want for your kids?
Such bad journalism it took so long to work out if he put poison in this stuff or people were using it to poison themselves.

So it's curing salt but misuse can lead to death.

Unfortunately for this guy the UK is such a nanny state they'd probably go after him for murder if he sold a toothpick if it could take someone's eye out.
One additional (non-security) feature that this guide missed is a reverse PTR record for your server's IP address. You'll have to set this on the side where you get your IP address from rather than in your own DNS, but lacking it will get your email classified as spam even if you implement all the other protocols. Basically, when your mail server says "EHLO mail.chamaris.tld", the other side will try to validate that the IP address you're connecting from actually points to mail.chamaris.tld.

Furthermore, you need to pick a host that takes action when their IP addresses appear on blacklists. Microsoft, particularly, uses UCEPROTECT as a blacklist source, and that particular company will blacklist and entire ASN if they receive too much spam from a particular IP address block (that doesn't get resolved in time).
Um, 11 years ago would be 2012. The Voyager missions launched in 1977.

<https://en.wikipedia.org/wiki/Voyager_program>

And the article you're linking appears to have been published in 2008 based on <https://nap.nationalacademies.org/read/12675/chapter/24>:

Specifically: Edward C. Stone, "Voyager’s Journey to the Edge of Interstellar Space", Laboratory for Atmospheric and Space Physics, University of Colorado at Boulder, Boulder, Colorado. April 14, 2008.

Edward C. Stone, Professor of Physics, Caltech; Voyager Project Scientist, JPL
National Academies of Sciences, Engineering, and Medicine. 2010. Forging the Future of Space Science: The Next 50 Years. Washington, DC: The National Academies Press. https://doi.org/10.17226/12675.

The submission title also doesn't seem to match the article's title, noted above.

How do you arrive at 11 years ago, and what specific mission or mission-element are you referencing?
Awesome! Will keep my eyes peeled
On an individual level, lets assume a polyp in the colon, there's no way to know which may become individually cancerous and which will remain small and benign. The genes are the same, the size and appearance may be the same. You can't know.

At a population level its well established that beyond a certain point you're injuring more people than you are helping by doing the colonoscopies at all. Where to draw that line is where the debate is playing out. The problem is well known, and I'm not aware of ANYONE seriously suggesting that it's possible to eliminate this problem.
The problem with a convertible MacBook is that you'd have to move the battery to behind the display, at which point you're really just making an iPad that can be attached to a keyboard dock and run macOS.

I think the latter is a plausible evolution of the iPad Pro.
Well that does suck. I would also wonder if that's a legal battle they would win.

I've never used Spacelift, etc. so I may be off base with the comparison. But I think about them like specialized CD tools that do nice things with/for terraform. Their value is that you don't have to implement these nice integrations yourself in e.g. Jenkins.

So replace Spacelift with Jenkins. There are some community plugins that idk, facilitate reporting plan impact from code changes. Is Cloudbees now in violation of Hashicorp's license?

Regardless, good luck.
That was not about the license of the code I think.

The code for IceWeasel is still MPL, only they have changed the artworks and names that are trademarked or otherwise protected by Mozilla.
Apple wants there to be a distinction between the two devices, otherwise people would only purchase one if they were equivalent.
if investigating it further isn't worth the risk, you don't need to investigate further

if investigating it further is worth the risk, then it's a good thing you did the scan

this superstitious ideology that ignorance is good for you has always been popular; what's surprising is that some people still hold to it despite the industrial and scientific revolutions

knowing about the minor slipped disc in your back might be important information if it starts hurting; you'll know it isn't a metastatic bone cancer. you might also be well advised to avoid taking up olympic weightlifting
I'm also looking for a two in one, a tablet that can be a laptop. The best I've found is a surface, and I think dell has some two in ones too. The surface feels like the right call because it's just light enough to be a powerful tablet, but not so power hungry that it's stationary. I think they've hit the right balance here.

It's a shame this form factor isn't so common, and what would be perfect for a vacation would be a Chromebook. It's browser centric which is 98% of vacation related activities.
>Why would I want to switch to this?

Because you value free software. That's the only reason.

It's a very compelling reason for many people. If it's not compelling for you, that's ok.
> large amounts of html

It only sends large amounts of html if there is a lot of data, and if there is a lot of data it will send large amounts of JSON. html in itself doesn't add much, it's the data that makes the bulk of the content
Nice to hear from you :)

yes, that is the direction...
Never understand why apple ships their iPads and Macbooks with such little ram by default. Yes I understand profit, but it really limits what these devices can do. The numbers have not really changed much in the last several years...
If anything it's an antiproduct.
This. Or a Yoga style fold-over in an 11" formfactor.

I picked up an X13s (the ARM one) for travel. It's not perfect -- one thing I like about iOS is that the airline apps are kind of required for IFE, but, my X13s weighs the same as my iPad Pro with a keyboard and can do much more. Trying to use Google Slides or Docs on the iPad is a poor experience.
Show HN: ELiTA: Linear-Time Attention Done Right
A novel Transformer architecture that is much cheaper and faster, while matching and outperforming the standard. Sequence Lengths of 100K+ on 1 GPU. Intuition, evaluation and code available on repository.
If the MRI finds a dozen indicators in your body in a bunch of different locations that might be cancer, all with different likelihoods where would you draw the line on getting them biopsied? Would you be comfortable having heterogeneous masses in your body that have a minor chance of being cancer? Because the MRI is going to say "might be", not "is".
Seems a bit odd for people to order this food additive all the way from Canada for use in the UK? Your local cash and carry probably stocks if.

There was also this case which might be related https://www.theguardian.com/society/2023/jan/19/stockport-ho...
No one said they eradicated every crab on planet Earth. They lost a few crabs. There's plenty more of them. And there are many restaurants in SF that serve them up every which way.

Is it an environmental disaster every time you step on an insect?
> Even when I bring up the fact that your internet history is already saved by all ISPs for a year

Can they only see which servers / domains / ips I interact with or can they actually see the paths / endpoints / request-params I use when interacting with exhentai.org?
I’ve been using Remote Desktop to a windows environment in the cloud for a while. It’s been pretty great actually. As long as you have a Bluetooth mouse an IPad makes a great thin client in a pinch.

I know people want MacOs, but it’s a workaround that works.
No, I'm saying that anywhere in the world you might get an unnecessary procedure. It is impossible to know in many cases if small tumors will become malignant, so judgement calls must be made. Finding more of them inevitably leads to more unnecessary procedures across a population. This is well established in European and American public health literature. This is why screening guidelines exist.
Woman dies after being denied transplant for refusing to get Covid vaccine
Unity's implementation of a global menu is probably the most consistently functional I've seen at the very least. KDE has this feature but compatibility is more spotty, partially thanks to necessary packages going unmaintained and on my main distro (Fedora) missing altogether.
SSA doesn't require deconstruction. Keep it all the way to the machine code.

When bytecode is designed for ease of interpretation you get a compact form which is easy to interpret. When you're going to translate it to machine code before it runs, that benefit is much reduced.

Stack vs register machine might be a preference. I find forth very difficult to reason with and don't particularly mind allocating registers to machine stack slots.

I like the idea of interpreting code directly as one walks the ascii file. What example do you have in mind? Most "interpreters" I can think of do a compilation to bytecode and then feed that to a bytecode interpreter. Some walk an AST instead but I'm not aware of any which lazily instantiate that tree from the source code.
Ask HN: Is This the future of Amazon.com?
> The issue is a OS and UX designed around touch screen doesn't work well with a mouse and vice versa.

This is really not the case with iPadOS though. It already works quite well with a touchpad and keyboard. The hardware is already there to control a full desktop OS, iPadOS already allows itself to be be controlled as if it’s a desktop OS, and with continuity mode, it’s already possible to control macOS via an iPad.

All of these things already work pretty well, and paint a pretty decent picture of what might be if Apple decided to go further.

Some things just work better on a touchscreen, even when they’re running on macOS. Some things just work better with a mouse and keyboard, even when they’re running on iPadOS.

As long as there’s some way to transition between them, I do really think a best-of-both-worlds option exists, because it’s mostly there already.
It’s been like that for a long time and it’s an intentional design element. They could get away with it because the site used to a bible for most web designers and had huge brand recognition
The rides are cool and it sounds like a fun project. I was a bit caught by surprise at the mention of being told not to go far from your house during COVID. Different parts of the world handled that very differently.
Nope, it's just Apple wanting to maximize profits.
Hmm, can I subscribe to a newsletter about this SLoPWiT technique you've just invented?
This is the third notetaking post I've seen on here in the past 48 hours. Is something happening in this space? Or is this just the whole "feed your notes to an LLM then $$$" thing?