skysight-inc/HackerNews huggingface dataset:
> and unlike SQLite, we do not substitute it with an unclear alternative

This portion of the statement is harsh, and I think the project could do better by stating what they are doing and why, rather than focusing on what SQLite is doing and why it is bad.

I would say that it seems feasible (to me) that SQLite's "Code Of Ethics" works for a small team, open-source, closed-contribution model but wouldn't work for the open-contribution model that libSQL is trying to achieve.
Thanks...SIM's is a niche I'm really not familiar with...Lippert says it requires an AT&T SIM...and I couldn't tell if I could just swap in a Cellphone SIM...I suspect you can't. The industry has done a great job of locking up access behind fee structures.
Yeah, this is the first part, and I doubt the second part will be a natural reaction.
Check out the Altinity Sink Connector for ClickHouse [0]. This is advancing quite quickly and already has prod deployments. Please feel free to try it out.

[0] https://github.com/Altinity/clickhouse-sink-connector
> Many other things invented by humans stay in use for decades with no alterations. Beethoven's 5th symphony hasn't had any updates in more than 200 years.

I don't understand this argument. Are you saying that some things don't require updates, therefore we shouldn't expect software libraries to be updated as well? But there are also things that do require updates or maintenance. Would that invalidate the argument?

Some examples of things that need updates or maintenance: buildings, infrastructure, tools, machinery. Even immaterial things like books or laws receive updates.

And that includes the 5th Symphony too, which has different editions.
Eh, they acquired it when it was going to be an OS for digital cameras, and had no uptake. The point doesn't really stand here.

The better point in favor of the "Google can't sell anything" argument is that they don't really sell Android to end users. The OEMs do all the selling, and they just get taken along for the ride while they offer a platform where they also sell ads and gather user data to target ads better.

The devices they actually sell (Nexus, Pixel) have never really had that much success outside of enthusiast communities.
I don't want to distract too much from the intended point of this, but something to keep in mind per QEMU and virtual machines - SQLite has its own VM too.

In fact, by binding application-defined functions to your SQLite connection, you can realize your own virtualized application execution environment.

https://www.sqlite.org/opcode.html

https://www.sqlite.org/appfunc.html
Implementing Map, Reduce, and Filter with Go Generics
Read the other comments for the answer.
One of the things I think is really innovative [1] about SQLite's code of conduct is that it's a one-way covenant. The developers are agreeing to act and engage with the community in a certain way without expecting anything in return or enforcing any of their beliefs on others. The rules are also very clearly defined, even the ones I personally don't agree with.

I think the new "Contributor Covenant" is a step backwards. It's pages and pages of text to say "don't be a jerk", and the rules are so poorly defined that it isn't much more precise than a one liner saying "don't be a jerk". There's lots of catch-alls like "... And any other unprofessional behavior is against the rules". You could stretch this to cover almost anything. Hell, I've worked in professional settings where wearing shorts was verboten, but I don't think open source projects should be policing how participants dress except in the most extreme circumstances (like if someone shows up to a convention naked when it isn't pre-planned as being a naturist event)

I find it confounding that the the new covenant is described as being less vague when it relies on poorly defined terms like "community spaces" and "community leaders". What's a community space? Who are the community leaders? Idk, but I've seen a handful of cases these covenants have been weaponized against developers expressing their personal opinions in a context that has nothing to do with Github.

[1]: I know calling it innovative is a bit ironic when most of it was written 1500 years ago, but it's innovative compared to other software projects.

(Edited for grammar and to flesh out why I think the new covenant is vaguer despite the author's claim, unlike the old one with well-defined rules)
Thank you! Its an html document that I compiled with R Markdown. Cosmo theme, with a floating TOC. :)
Ask HN: Privacy Friendly Local Grammar Checker?
Hello all,

I went online today to look for a grammar checker to help me proofread my articles and stories. I kept finding notes in the privacy policies, or discussions online (eg, "Is Grammarly a Keylogger?" https://news.ycombinator.com/item?id=30470457), that made me pause before sigining up for anything.

Can anybody recommend a grammar checker that doesn't send your content to a server?
Oh please - Apple had more than a decade to improve on the lightning cable - you somehow infer that progress will be hindered now because of this ruling? You do realise why standards actually exist?
It is changing -- a CS degree is far more of a requirement today than the 1990s.
It's probably because the two teams don't have a common direct report until they get to an SVP who has hundreds of issues and conflicts on their plate.
Does handbrake presets give you good space savings? I was imagining at most something in the 10-20% range.
Not in the very long term but it will fix the issue atleast for the next 100.
> How on Earth are devs supposed to sanitize this??

By using the widely-available free tools which are near universal by now? This hasn't been technically _hard_ since around the turn of the century[1] but developers, especially Americans, have been lazy and tried to avoid doing the work needed to get beyond C-style string handling or, in the case of the apostrophes, using parameterized queries.

1. Having build a site which supported English, both simplified and traditional Chinese, Thai, and Vietnamese (including what passed for webfonts back then) in the 90s, I know how bad it used to be but also that was 3 decades ago.
It does not seem to be preventing adoption of SQLite anywhere.

People should have codes of conduct if they believe in them (I do) and find they're necessary in the circumstances they're working in (I have not yet).

People should stop going around proclaiming that pro-forma codes of conduct are a basic necessity for every project; all that does is exacerbate the drama around codes of conduct --- which are perfectly useful and often necessary for huge projects, and which don't at all need to be the topic of 500-post message board threads about freedom.
Right. I would also say that this is more of a symptom of university degrees being a title system, rather than strongly signalling candidates' capabilities.
Show HN: Gabble-alternative to Yelp that eliminates fake reviews
I meant innovation in consumer electronics or even just software services as a result of legislation, not legislation itself. Payments and bank APIs count. Thanks for the examples.
The amount by which the EU is better than the US in environmental protection is basically a rounding error relative to what’s actually necessary to stop climate change. You might as well say they’re equal.
> A standard that would do just power delivery <100W and works in damp environments, so it could cheap and universal, would have been so much better.

Don't you just have a RCD/GFCI on your outlet / breaker for this purpose?
USB-C is just a connector.

If we follow this logic, the EU should also mandate which aspects of USB-C PD are required to be supported and enforce that. Otherwise we'll end up with a slew of devices without even the required 5.1k resistors, which can't charge from PD-compliant adapters, but can be charged using a USB-A to USB-C cable.

As an EU citizen, while I do agree that regulation is often required (it did wonders for our roaming charges!), I do not like this development.
The main tc39/proposals (on Github) Repo lists that proposal as currently Stage 2. Appears to be under active review for Stage 3: https://github.com/tc39/proposal-record-tuple/issues/336
I've been randomly skipping around inside these books for a long, long time. They're full of little gems that you won't find elsewhere.

For example, in Volume 4A there's a simple technique for comparing two pointers in bit-reversed form. This technique was patented by Hewlett-Packard as a method of randomizing search trees (treaps):

https://bugfix-66.com/fdb8bb4fa84cf810aa25ff40c88a13c1874410...

From Volume 3, here is by far the fastest method of sorting integers (Singleton's method), an algorithm I have used professionally several times (e.g., for beam search in a speech decoder):

https://bugfix-66.com/834f0677c85b23c0bf1047d3654ab7c27ff054...

Knuth's books are just packed with gems like that.

The meticulous high quality of the books is also remarkable. However, if you look very carefully you can find rare mistakes. I received payment from Knuth and have an account at his bank:

https://www-cs-faculty.stanford.edu/~knuth/boss.html

Getting your name on the above list was once a Hacker rite of passage.
"The blueprint is a set of non-binding guidelines—or suggestions—providing a 'national values statement' and a toolkit to help lawmakers and businesses build the proposed protections into policy and products."

This is performative governance, not material policymaking.
> it coincided with the emergence of agile software processes

Not really. The first item and all the propaganda around it was a direct cause of the popularity of Agile. It wasn't a coincidence.
How did I?

I have impulsive ADHD. It’s been a great tool but also got me into a lot of trouble.

I never thought I could change who I am. I am right but I could become aware of what I am an try to engage my bigger brain rather than the impulsive part.

Once I started investing in knowing me better rather than just allowing me to be on a seemingly uncontrollable train I could see how certain behaviors could be toxic to me and others.

And forgiving myself.

This mostly came through the enlightenment of having a son who has it and dealing with that whilst having ADHD. And that has been my greatest challenge and success.

Meta cognition. We talk with him about it in a way which isn’t blame or ‘you can’t do that!’ and while there is still a lot of support he is thriving.

Happy to chat offline too
Or maybe every EU tech company approaching success will voluntarily move to US, since that is where the (free) market is and that is where it can become successful.
At some point the electons start tunneling through the channel, regardless of its state... I don't remember my semiconductor theory that well, but possibly unaffected by the height of the potential barrier? In which case better electrostatic control or changing materials does nothing. Hot carriers (high voltages) are more affected, so you can lower voltages to an extent.

You can go below 20 nm, but you get this constant tunneling current, which deteriorates your on/off ratio, and increases power consumption (and TDP). It's doable if you can turn that part of the die off (dark silicon).
Things like rqlite are great and all, but I'm not sure if that's something that should be included in SQLite no matter which development model it uses.

Looking at the libSQL page, it seems they want SQLite to go in quite a different direction in general. That's all fine, but at that point you're working on other problems than what SQLite is intended to solve. People want software to solve every possible problem under the sun, but SQLite is a project with a fairly specific and narrow scope, which is intentional.

The "trick" is to enable things to be extended and patched easily, if need be, so people can build extensions and derivate projects if they want. I don't know to what degree SQLite allows this – I'm not familiar with the SQLite source code.

At any rate, for this to succeed you need at least one person actually writing code for it. Thus far, all I see in the repo are some non-code changes (add license, coc, Makefile twaeks, etc.) I don't know what the exact plans are, but you need more than a GitHub repo with "we accept contributions" and wait for people to submit them, because most people/companies won't. Almost all projects live or die by their core contributors, not the community.
Noice! Of course there's youtubes on this stuff. Thanks for the recco.

I also would point those that want to boogie to old episodes of "Soul Train" too.

And for the curious, "Why the 1970's and 1980's?" ...

https://en.wikipedia.org/wiki/Cocaine_boom
It may not be a coincidence that one of the author's other books is on Biblical studies: https://www-cs-faculty.stanford.edu/~knuth/316.html

I didn't realize it had been blurbed by a professor emeritus at a seminary (as well as Martin Gardner).
I was thinking the same thing when I clicked on the comments. I somewhat expect this will be the last volume in the series, so one could now hope to buy a "complete" set. I would love to revisit and explore all of the material using modern programming languages.
Just for clarity, there was a "could" in there, in the context of what I stated.

Google and other authorities having such access to so much data about individuals, means they can know of relationships, that the interacting individual parties involved don't know about each other. So, if a wife were cheating on her husband, that can be known. A line can be crossed, where information is leaked to the husband, in various ways. This of course is just a "theoretical" example, of many other kinds of possibilities.

Access to private and personal information is its own kind of power, that can be easily abused under many gray areas, and under all kinds of pretexts and weak justifications.
> Will make the online test, though...

Go see doctors and therapists, different ones, to get different opinions

Not fitting in our crazy modern world doesn't mean you're "sick"
> This document continues to be used for its original purpose - providing a reference to fill in the "code of conduct" box on supplier registration forms.

It seems somewhat deceitful to use this list to check those boxes, which makes this entire page self-contradictory (specific points highlighted):

> 24. Do not entertain deceit in your heart.

> 28. Utter only truth from heart and mouth.

> 39. Be not a grumbler.
> Which means that the data that hits a single SQLite instance now needs to be replicated to all the others.

My initial reaction:

Yeah because ... SQLite is not a database server - it's an awesome API on top of a flat file? Do you want a replicated database? Then use a replicated database.

Then looking at the list of solutions (rqlite, BedrockdB, dqlite, ChiselStore, LiteFS) ... I guess people really do want to make it replicated.

Why not use a SQL server?

Also: I was using QEMU on an old 32-bit Dell server that was before Intel's VM efforts. It worked decently. :)
Your code is not properly enforcing the communication constraint between the two players. Try to enter code that passes the bell tester widget included in this blog post and you'll find the problem:

https://algassert.com/quantum/2015/10/11/Bell-Tests-vs-No-Co...
I feel one disadvantage of globalization ("de-localization", "de-tribalization"?) is that the (potential) positive effect of shame - putting attention on and collectively (de)valuing antisocial acts and individuals (but not outright expelling them) doesn't work anymore. Abusers, scammers, grifters can just move on to the next community that knows nothing about their behavior, and restart the cycle of abuse without consequence. And the scalability of such schemes, and the lack of granularity and affordability of the legal system prevents any negative consequences for the perpetrators "in the small".
An Apple TV 4K with Infuse app does all of this without problems and supports many kinds of storage backends.
Def don't need to eat crow. Never heard that phrase before funny. It's just my opinion. I often get it wrong and there are def a few ways to think about it here.

100% agree on getting more visibility and ammunition and 100% agree on having an inventory. I was leading the effort at the OSSF to create to the plan that was taken to the WH summit ;-)

I can't believe that there isn't a good tool for being able to scan production to match build outputs. Sounds like a good OSS tool project !
They also require a statement presented as fact, not opinion, which is false and designed to harm someone's reputation.
My anecdote was only supposed to show that USB-C has not so far needed mandates for it to be adopted.
on the other hand, I don't think Mickey should go public domain.
Completely wrong. The 6th circuit's affirmation of the lower court's summary judgement was entirely based on the officers' entitlement to qualified immunity. Read the opinion yourself: https://law.justia.com/cases/federal/appellate-courts/ca6/18... . That's the particular dispute that's heading to the Supreme Court. The municipal liability is unrelated to this amicus brief, which is entirely about the QI dispute.
> We encourage others to speak up if they feel uncomfortable.

OK - your weird swipe at Sqlite tentatively tells me you're founding with a grudge, which (a) doesn't tend to last very long as a motivation and (b) has nothing to do with me, so I'm not interested at all.

So I don't have a dog in this fight, I'll check back in a few years and see how it went. Happy forking!
I'd love to hear about this too: especially after running the model through an onnx optimizer, like this one [0].

[0] https://github.com/daquexian/onnx-simplifier
Nanking Massacre Photographic Proof
That is the beauty of all things.
If using the same business logic is one of the main reasons, why not JavaScript / TypeScript?

Also, what are the limitations of JSON that EDN handles better?
I had this. Changing jobs, freelancing, jumping from project to project, hobby to hobby. Couldn't be at a job for more than a year...until I found a company that actually does work properly.

I had same symptoms as above but for me it was not ADHD but bad employers. Even hobbies are stable now.
I’m disgusted to say you could probably make A LOT of money with this idea.
It really doesn't.

No-one is insisting on anything, really. "If you'd like us to adopt your technology, do X" gives both parties a choice in the matter and total freedom to walk away.
I'm not convinced of the uphill battle of securing a job. Credentials seem to matter in that they modify the gradient you advance in ranks with. I have a degree. It has certainly helped the speed at which I advanced. But I don't believe it helped me actually get the job. My first job was 10 years ago and it still wasn't that big of a deal to not have one at most jobs.

However, government jobs almost always have a hard degree requirement. I'm not sure why this is. I wouldn't take government jobs as representative of the industry.
Have I seen any of the fruits of this labour in my daily life, or is this for stuff like string theory?
50 years ago, he claimed he was going to write 10 volumes of TAOCP. The actuarial tables are not encouraging here.

He doesn't respond to emails, but his assistant does, and I sent a copy of my book about Xerox to his home address. No answer. But hey, it was worth a shot.
In other words, Musk has issued an open invitation to stop the existing lawsuit and go back to negotiating.

He has already proven that any offer he makes is really just another negotiating tactic.

Musk is working real hard to be the new Trump --- his word is his bond --- in Bizarro World.
When 99% of the workers in the space have a degree, it’s a fair statement.
I strongly agree.

But I'm also increasingly worried that we're not very far from losing this. It already seems like social media sites like Twitter, Facebook, and Reddit are increasingly controlled by US propaganda and corporate interests. It's hard to know how far gone what we think is true freedom of speech and democratization of voice already is.
digital artifacts do not play well with capitalism as it is. something has to be done.

I refuse to watch what could have been vanish...(e.g. napster, megaupload, what.cd and those kinds of complete medial-cultural archives). Heck, we're going the opposite direction, libraries are starting to get mud slung. There are too many incentives to shift that public perception, into libraries being bad; just a couple more generations.

sure, people whose job is to make this expensive productions involving lots of people need to earn a living somehow... it's an open problem but we need to look beyond capitalism to find an answer acceptable to all people, both those who come up with the ideas (who when coming up with them are greatly benefited by open access to all culture) and those living off the rent of the produced cultural artifact.
Just like huge public libraries or our 200 channel, 24/7 television systems; there are some real 'gems' out there on the Internet but they are drowned out by the 95%+ of worthless drivel. The task is finding meaningful content in a world of mostly pablum, scams, and other harmful content.

With hundreds of millions of websites, you absolutely need search capabilities like Google (at least how it was in its early days) in order to find relevant information. The problem of course, is that the search sites are run by algorithms that attempt to direct your search based on criteria that is often the opposite of what you desire.

It is definitely a 'Centralized vs Decentralized' situation. The Internet was originally designed to be a decentralized structure where every site was a pure 'peer-to-peer' connection where it was so easy to jump from place to place without being re-routed to the central players. Now all the big sites like Facebook are designed to be walled-gardens that want to control everything you see.
Yes but I wouldn’t
Best Practices on Explainable AI
SQLite's maintainers have a choice. They can spend their time coding, or they can spend their time explaining, over and over again, why they don't want to do a distributed database.

I can see why they don't take contributions.
I mean, most if not all homeopathic remedies label themselves as homeopathic.
Standardizing shit that doesn't need to be different, in order to let markets function better, is one of the oldest functions of the state as we know it, and a precursor to the development of capitalism.

Seeing the benefit to doing that kind of thing (which required developments in thought & practice in political economy) and being able to effectively enforce such decrees (which required various other developments in theory and technology, plus the right circumstances) on a large area is even seen as one of the hallmarks of the development of the nation-state, and a major stepping stone to our modern global economic system and the modern state.
Two books I would strongly recommend:

(1) Range: https://www.goodreads.com/book/show/41795733-range

The book describes the advantages that generalists have and how they can get the most of them, and basically says that specialization is somewhat overrated. As a fellow generalist I found it uplifting and encouraging.

(2) Stolen Focus: https://www.goodreads.com/book/show/57933306-stolen-focus

This book is all about focus, why it's hard to maintain focus and what you can do to improve it. Candidly it's a bit discouraging, because many of the conclusions are that the problem is environmental and there's not a ton that individuals can do about it. But for me, it's still very reassuring and empowering to recognize the environmental problems around me and know how they are affecting my ability to focus.

I think you'd find reading those to be very helpful and time well-spent :)
All of the UML diagrams are some formalization of older ideas.