skysight-inc/HackerNews huggingface dataset:
I don’t know about this architecture for AI, but your description sounds like the explanations I’ve heard of the Ruby on Rails philosophy, which is clearly considered optimal by at least some humans.
https://youtu.be/daVny9y72UE

I gather there should be an entire class of aperiodic automatons waiting to be found

(And no more riffs on the lava as if we are high on children's games?)
I remember when I first voted at 18, thinking that I'd be pissed if I were old enough to die fighting a war, but not old enough to elect the people that drafted me in the first place.
So we share personal experiences now; okay, let me share mine.

Once, one of my teammates committed an extremely complex piece of code that I wasn't able to understand. As I expected, we soon started to start bug reports. Finally, the original author couldn't fix it properly, so I threw away the code and rewrote it from scratch. I made it simple, readable, and, what's more important - debuggable. And it was correct.

So what? Your personal experience says that you are not the smartest person in the world, and my personal experience says that magic is magic — it doesn't work properly in the real world.

It's easy to build "magic" code that's hard to understand. You can just run any readable piece of code through an obfuscator. Still, no one believes that an obfuscator is genius. If you see "magic" code that, for some reason, truly works, it means that the author did a ton of research and forgot to put that into comments — i.e., obfuscated a code. If, even with comments, it still looks like magic, then the author avoided doing a self-review & simplification of the code. And well, sometimes, even after that, code can still be magic... if we have chosen the wrong tool for doing the job (does it sound like a depiction of genius?).
> And they'd be right to riot.

Care to explain? I can make assumptions but I will probably not have the same interpretation you have.
Part of the issue is that you haven't shown the 30 year old to be competent when s/he stood for the first election. (Now I think of it, you haven't shown a 70 year old to be incompetent, but that's another issue.)

If you have rules that are not based in competency, but on a simple feeling you have that group of people X, are not competent to do job Y. That's just not going to go well for you. Age minimums as conceived by the founders, for instance, were based in competence. A desire for people to have experience. Even then, they were not draconian. As evidenced by the fact that someone 35 years old could be President of the US.

If you were arguing in favor of competency testing, people might get behind you. But you're arguing in favor of a blanket ban. Which is another matter entirely.
Aaron has some biases but could be worth watching his reality check report from december 2023 "OpenAI, Inc. Video Reality Check: Decoding Non-Profit Tax Returns and Business Structure": https://youtu.be/PdQxPQf_1EQ

...and reading his perspective from November 2023 ( http://www.aarongreenspan.com/writing/20231122/openai-gets-p... ):

"They are smart people. About that I have no doubt. But I’ve seen how they treat rules. I know what they think of ethics.

Good idea?

Enter Larry Summers, who was just added to OpenAI’s Board of Directors—now that all the women are gone—to be Sam’s babysitter, so far as I can tell. Why? Because with Sam at the helm, OpenAI clearly violated its non-profit charter, repeatedly. The company is likely looking at an impending investigation by the California Attorney General, which has authority over tax-exempt organizations in the state, and perhaps an uncomfortable audit by the Internal Revenue Service as well. By having Larry on the Board, the company can plead that there’s now an “adult” in the house"
You can buy a license, and maintain your public fork while also letting everyone know you validated your fork with the same TH3 as the origin version. You just won't be able to show people your TH3 since I doubt you can buy a license that allows that.
Thoughts on the Nuclear Family
I haven't even thought of Berkeley DB in years. Used to use it quite a bit but most notably perhaps with apache mod_auth_db to handle authentication and subscriber information on a fairly high traffic site (yes, this was long long ago ;) ).
Simulations dampen excitement about liquid water on Mars
The number of societal-wide problems that occur if your Lightroom database gets corrupted is zero.

The amount of hell that would be unleashed if the financial systems layers upon layers of database transactions got broken is impossible to comprehend.

So if you mean “important” as “necessary for society to function”, then no, your browser bookmark files, contact list, or the other two dozen things your laptop and phone use SQLite for are not important.
I don't have to think, people have done research.
Llama3 still is worse than GPT4 for programming, but I expect this gap to be eliminated as newer versions of Llama keep coming.

https://openlm.ai/coder-evalplus/ says that CodeQwen1.5-7B-Chat is the best open model for coding.

https://huggingface.co/spaces/open-llm-leaderboard/open_llm_... lists davidkim205/Rhea-72b-v0.5 as the best open model overall.

https://leaderboard.tabbyml.com/ lists DeepSeekCoder-6.7B as the best for coding.

The takeaway is that Llama 3 looks a lot better than Llama 2, and I expect this trend to continue to 4 and 5, to the point where 5 could overtake GPT4.
Sweden says Russian warplane violated its airspace
Maybe some biological/chemical processes are efficient in some unexpected ways on certain things, for example, that would make mechanical/silicone based "machines" non competitive with such biological machines.

Which was the point of the post that you were responding to, if you actually read it.
It's part of the Mypy project: https://github.com/python/mypy/tree/master/mypyc
> Meh. The running hypothesis on the "other side" is that we're going to have a pole shift and grand solar minimum at the same time.

The "other side" in this instance is fossil fuel funded think tanks promoting bonkers denialism ala the same institutes and their pro tobacco work in the decades earlier.

What "pole shift"? Magnetic pole on earth or the sun? The Earth magnetic pole flipping this century or the next is improbable at best and the solar pole flip happens every 22 years or so, neither that nor a grand solar minimum has anything to do with the glaciers on earth.

> I haven't really done the prerequisite reading

You might like to start with Syukuro Manabe's 1967 Thermal Equilibrium of the Atmosphere with a Given Distribution of Relative Humidity - it was 15 years old when I first read it in an applied mathematics class prior to a career in geophysical exploration for minerals and energy clients.

It's 57 years old but still an absolute stonker of a paper, rightly considered the single most influential paper in climate research. (and only 19 pages).

https://journals.ametsoc.org/view/journals/atsc/24/3/1520-04...

> I have, however, read about all the stupidity surrounding "global warming" and how it was totally going to end the planet in 2000 and 1980 and 2024

Ignore that, that's not science that's media spin, half coming from people that really struggle to convey what a slow rolling train wreck climate change will be and desperate to urge people to take steps before it's too late, the other half coming from groups paid to up the FUD and hype in order to dilute the threat which has clearly woirked in many cases (you seem to be a fine example).

> This only makes me NOT want to spend my free time untangling "conclusive" climate decisions backed by ""science""

It's not much harder than understanding the heat equations.

> I, as an individual, don't have a horse in this race.

Exactly. Like many you're likely old, will be dead before this is a big issue, have no children, don't care about them if you did, and can't be arsed consuming less or making an effort. It's completely understandable.

> I don't believe in either one because my carbon emissions can be eclipsed by a volcano or a plane in a few hours.

Collectively though, it's the sum total of human emissions that are the problem, with a small percentage being the biggest problem and being reluctant to set an example.

> It's completely useless to expect me to not buy a car or to watch my energy consumption when it's not going to make a dent anyway.

Indeed, just rearrange your deck chair and listen to the band playing onwards.

Of course if you are in your 20s (as your HN profile claims) then you might want to do something that has an impact on the world about you and the people you know .. other than rolling coal and buying a lambo or whatever.
Maxar's WorldView-3 satellite captured image of Starliner at ISS
Then they're are means to change that.

Maybe tomorrow some state decides that freedom of religion is bad?
Let’s differentiate between:

1) a user-agent which makes an authenticated and authorized request for data, and delivers to the user

2) a user who then turns around and distributes the data or its derivatives to users in an unauthorized manner

A “dumber” example would be whether I can indefinitely cache and index most of information via the Google Places API, as long as my users request each item at least once. Can I duplicate all that map or streetview photo information that google paid cars to go around and photograph? Or how about the info that Google users entered as user-generated content?

THE REQUIREMENT TO OPEN SOURCE WEIGHTS

Legally, if I had a Creative Commons Share-Alike license on my data, and the LLM was trained on it and then served unlimited requests to others, without making the weights available…

…that would be almost exactly like if I had made my code available with Affero GPL license, someone would take my code but then incorporated it into a backend software hosting a social network or something, without making their own entire social network source code available. Technically this should be enforceable via a court order compelling the open sourcing to the public. (Alternatively, they’d have to pay damages in a class action lawsuit and stop using the tainted backend software or weights when serving all those people.)

TECHNICAL ANALYSIS

The key, as many here have missed, is authentication and authorization. You may have authorization to log in and view movies on Netflix. Not to rebroadcast them. Even the question of a VCR for personal use was debated in the past.

Distributing your scripts and software to process data is not the same as distributing arbitrary data the user agent found on the internet for which you don’t have a license.

If someone wrote an article, your reader transforms it based on your authenticated request, and your user would have an authorized subscription.

LEGAL ANALYSIS

Much of the content published on the Web isn’t secured with subscriptions and micropayments, which is why the whole thing becomes a legal battle as silly as “exceeding authorized access” which landed someone like Aaron Swartz in jail.

In other words, it is the question of “piracy”, which has acquired a new character only in that the AI is trained on your data and transforms it before it republishes it.

There was also a lawsuit aboot scraping LinkedIn, which was settled as follows: https://natlawreview.com/article/hiq-and-linkedin-reach-prop...

Legally, you can grant access to people subject to a certain license (eg Creative Commons Share Alike) and then any derived content must have its weights opened. Similar to, say, Affero GPL license for derivative software.
Will read the article now thank you
Would you classify a nurse call system as requiring important data retention and access? Mapping backbone devices with passive and interactive end user devices with means to communicate whom should provide assistance?

Works great there too with μC/OS-II. Competition was using Windows XP and Microsoft Access.

Only time ever using Oracle has been with internal business analytics, not very important.
The React support looks interesting, are there any examples available? I couldn't spot any in https://github.com/observablehq/framework/tree/main/examples
You almost sound like you think Buffett micromanages the businesses that he owns or those that he invests in.

I believe that you are mistaken. Everything that I have ever read indicates that he buys companies that are already well-managed with good long-term prospects and then he lets those proven managers operate without interfering.

I could be wrong. As far as BNSF goes, I know that when Matt Rose was running it after BH bought BNSF that he was highly regarded at BH. I think he was rumored to be in line to replace Buffett if Buffett decided to hand off his position to someone else. I don't think that happened but I know that Rose was a good person who was available to speak with anyone on the railroad if they wanted to talk directly to him.

Like I said, I believe that Buffett looks to make his money by owning profitable companies with strong leadership in markets where they can remain competitive for a long time.

Perhaps to you that means that quarterly reports, though required by the SEC, are not important to Buffett or BH since they obviously take a long view before buying the company in the first place. I don't think it means that BH controls the day-to-day operations of any of the companies that they own or invest in.
> As such, anyone with two brain cells to rub together will immediately outsource money handling, which means that your minimum price is now limited by how much your processor charges.

Which should be significantly less than a dollar for small charges.

Processing fees get in the way of charging a dollar each month, but they're perfectly compatible with charging $5. And that $5 could be for multiple months.
Former, I'm too lazy to write serialization/deserialization :P
Fun fact: my (french) company audited the french navy and found out they share important nuclear submarine maintenance data as excel files through email.
Now compare the inertia your car has vs a jetliner.
Tech has always been part of the establishment, funded by capital trying to solve capital's problems. The only part of tech that really deviates from this is the free software community, which has always been hostile to capital. The blackout day emerged from people, not the industry, and people have changed.
Optimizing Resident Schedules for Minimum Suffering
If a human fetus model is controversial, I will make it without a heart or brain
This is a false equivalence, as one user’s particular usage of SQLite is not comparable to all financial instructions’ databases.

Better to compare to the prospect of all smartphones being irreversibly corrupted at once.
Your linked article is two years old. Many of the issues cited were handled in the trainmen's favor under the new collective bargaining agreement finalized last year.
But that's already cheaper than building new coal or natural gas plants. The cost per watt of solar plus battery, right now, is the cheapest available form of power. I don't understand why you don't think that it's going to replace a majority of primary and secondary energy usage on the planet relatively quickly.

I'd bet a dollar that, in 50 years time, nearly all energy usage is going to be primitive biofuels or solar-PV-origin.
I’ve run into this a few times. At first I think it must be me, that I’m not communicating correctly. But then I see everyone else run into the buzzsaw, despite differences in style and approach, and I realize the “exec” is simply an interrupt-driven dopamine fiend. Inevitably they get rotated along, because having the attention span of a coke-addled squirrel is not actually good for business.

If you can’t wait them out, or if they’re the CEO, find a different job.
It most definitely does and I’m serving several read-only production databases from memory. It is insanely fast if you do it right.

https://www.postgresql.org/docs/current/pgprewarm.html
What is lag? Baby don't hurt me, no more
We’re about due for a new edition with some updates. I read it again just recently and in certain sections I would love some updates. Many things have changed in 7 years.
Former US military officer here. This does not surprise me at all. I wasn’t in subs but we absolutely did this for maintenance of other multimillion dollar assets.
> Shareholders can get in line behind employees as far as I'm concerned.

I'd say even more, if a company is large enough they should get in line behind workers, and society at large.

For such amount of power there should be systemic mechanisms putting society's interests above shareholders. They can get their share of the pie after that, they definitely wouldn't starve if so.
There is no power. Power is IV, current times voltage. The voltage will be the rated voltage of the panel at that sunlight level, but the current is 0 (minus some very, very small (microamp) internal currents).

Alternately, power can be expressed as V^2/R. But in an open circuit R is infinite, so again, zero power.
There's also the nuance that while SOPA/PIPA were bills being legislated for potential passage, France is citing laws already in effect.

For better or worse, if you do business in <x> you follow <x>'s laws or GTFO.
Great article.

Can someone smarter than me explain why an embedding is or isn't a poor man's form of encryption? You can retrieve the closeness to something using cosine similarity, but you can't go back to the original source (unless you store the embedding side by side, which is what most people do with those vectors).

But, isn't using an embedding model a good way to cloak your original data and still make it comparable?
The goalposts keep moving here. You can just take any arbitrary definition of important and use it to exclude SQLite deployments.

It's all semantics, and also irrelevant to the original article anyway, since nowhere does it argue that SQLite holds the most data (important or otherwise).
Can you train models via Ollama or is it just used to run existing/pre-defined models?
> destruction of the creative industry is already pretty noticable.

Can you explain what you mean by this? I’d be interested to know what jobs have been lost to AI (or if you are talking about something else)
there’s a different between a 40 year old wanting to serve 20 more years and a 70 year old doing the same

No there isn't.

Both these people will put your society into a world of hurt. They want to serve 20 years. I can guarantee that ain't for the benefit of the poor and downtrodden, any more than the district they draw up for themselves to achieve their dream is for the benefit of its constituency.
> Currently, 3 months out of each year, my work belongs to the government. They also don't care whether I have the "profit" to pay them;... The taxes are due regardless.

In Western countries tax due depends on there being some surplus to tax and if there is insufficient surplus there is no tax and you may qualify for government benefits instead. Taxes paid can only be earned sustainably from activities that generate a surplus. How else could it be?

> There are countries with mandatory military service today and they're doing fine.

How many of these countries have governments that do not depend on taxes? If the government depend on taxes and military service depends on government then military service depends on taxes as well does it not? And if military service depends on taxes it also depends on the surplus that these taxes are collected from else how can military service be sustainable? Solider need food, housing, etc some surplus generating activity must pay for that. It used to be an army would pay for itself by looting etc but clearly that is not sustainable.

> Slavery is perfectly sustainable; it existed across the globe for thousands of years. There are reasons it's not great, but sustainability isn't one.

Societies that use slavery have difficulty competing with ones that do not. If the use of slavery was sustainable why did slave using societies not have the geopolitical power to keep doing it? You think slave owners gave up their slaves from goodness of their hearts?
SimCity in the web browser using WebAssembly and OpenGL
The link about ligatures under the textbox leads to a page about selling annuities.
I think they're making the false assumption that only the effected parties would be out protesting.

I mean, I'm in my 50s and I'd be out in the streets throwing down with the cops if they took away the right to vote from a significant portion of the population.
It's also heavily used on Android, so that's some 3bn devices (based on active users numbers from earlier this year). Plus it's in Firefox, Chrome, and so on.
It's just a projection, you're looking at the sphere of the sky as seen from a (stabilized) Earth position. When you zoom out, you increase your field of view beyond that of the human eye to encompass the whole sphere. Because there's no way to compress a sphere into a plane, you have to choose a projection; this is a common projection (stereographic) which lets you zoom out as far as 180 degrees, by presenting the field of view as if it were the surface of a sphere as seen from an infinite distance.
"Risk-dependent" would be a much better name for this methodology. (Why are programmers so fond of this "[X]-driven" phrase?)
No.

No matter how decentralized something is, ultimately you need to have a server and cables connecting it to the internet located somewhere. That somewhere will be within some legal entity or sovereign's jurisdiction which you must answer to and comply with.
That doesn't really seem like a good reason. They remove all formatting control with an automated tool so it doesn't matter when (if, big if) an automated tool later rewrites some of your source code formatted in a way you don't control?
For some reason I pictured Mario 64 with the wing cap while thinking out your examples.
Even if someone could do fine, I'd prefer to skip out on them rather than let those who aren't fit through.
What have you used if i may ask? It seems very simple indeed. What search API is best?

Also there is a program called html2text to throw out the html formatting so as to use less tokens. Have you used this or something similar?
A few others:

- Want to distribute data to users that don't want to manage a server? A lot of people don't want to manage a server and don't need the best possible performance.

- Want to take data with you on a thumb drive and work with it offline? It's extremely convenient to be able to use SQLite for an app that has to work offline.

- Does the app mostly just read from the database and fit in memory? It's undervalued to just put the entire database into memory so you don't hit the disk and don't introduce network latency. For example, the following website does all enrichment with in-memory SQLite databases: https://shdn.io/analyze?target=ycombinator.com

At Shodan, we distribute versions of our datasets as SQLite and they're a popular way to consume the data without having to manage infrastructure.
It reduces cognitive load on integrations, both software and wetware. So many brain hertz are wasted on internally bikeshedding format details. Autoformat fixes a hole where the rain gets in and stops my mind from coding.
I took a bootcamp with them many many years ago and have to agree it was one of the better training experiences. Best wishes on your next chapter.
Couldn't Cloudflare route these DNS queries outside the country, and therefore not be subject to French laws?
I didn’t comment earlier so I can’t move a goalpost I never set down. I agree with the root comment that there may be more instances of SQLite, the most important data is not in SQLite.

For what it’s worth, I have used any number of databases over the years and SQLite is very good for a number of things.

None of those things are the core infrastructure that stores your emails, money, and other must have, shared, high availability data.

There are different tools for different jobs, that’s fine.