skysight-inc/HackerNews huggingface dataset:
> Come on. At dinner parties. You don't have to make every minute of your life a crusade. On sundays! I don't GAF about the rest of the story here but using this as a character failure demonstration is inane.

Such conflicts often develop during "dinner parties" because those are the only time the family gets together for such a thing to even be possible. Walking away in such a scenario is a sort of dereliction of duty as a parent, not that I can speak to how SBF's home life relates here. Given SBF's alleged egregious white-collar criminal behavior it wouldn't surprise me one iota if his parents failed to fight the necessary battles to produce a responsible adult in him.
While we're at it, can we stop using "Got it!" instead of a simple "Ok" or whatever plain acknowledgement should be there in its place.
I’ve been learning the idiosyncrasies of MySQL since 2003, I doubt whatever benefit SQLite has outweighs 20 years of experience.
It was, if I recall correctly, discussed in the book called _The Fifth Discipline_ by Senge.

The entire book is about systems and how we typically ignore them to our disadvantage.

There is some overlap between this and Weinberg's Quality books.

And, of course, _Systematics_ explains it all clearly.
Thank you for the thoughtful response.

I was looking at https://github.com/irskep/cheapo_website from commenter irskep above, and they make a nice point that render.com has automatic daily backups, solving 4)

However, in another comment they mention "You can't(?) run migrations from another process" and that "people don't talk about the completely ordinary need to run migrations on a database".

I guess this is also the piece that I'm missing. How do I run migrations? Do I deploy a new version with the migration and temporarily take down the server? I'm glad to do that.

I guess I'm also walking through this because---as I said---I'd love just to switch to SQLite but I'm still not sure how many simple non-esoteric gotchas will pop up.
This seems to be a uniquely Walmart experience. I don’t experience it anywhere else in the States.

I no longer shop there and I know of many people who feel the same way. It’s the only store I avoid because of “the feeling of human suffering.” Walmart’s stores are cold and uninviting, the employees don’t look happy to be there, and the shoppers don’t either.

I don’t believe the people inside a Walmart are a representative sample of Americans, the store self selects for people who are willing to shop at a Walmart.
> The thing isn't friendly or hostile. It's just echoing friendly-like and hostile-like behavior it sees.

This phrase is reminiscent of the language of mereological nihilism, where they say that there are no chairs, only "atoms arranged chair-wise". Intresting distinction, perhaps properly backed by rigorous arguments, but not the kind of language anyone would use casually, or even professionally for long time-period.

Why is it reiterated all the time? Is "anthromorphism" that dangerous? I don't see why we can't have hostile "Sydneys" when we have hostile design, hostile spaces, hostile cities etc.
It's not sarcasm. The fact that it's a library and you point it at a file matters, and should be thought about. It implies that it's not built for distributed systems. It's not supposed to be a managed service. It's not a good option for what you appear to want. You deploy it as part of your application.. it's a library.
The important thing is that you're here to tell us what everybody else is saying. The ironic thing is that nobody can be certain what you're saying.
That's 81 prescriptions dispensed per 100 people. If each prescription is for three months of pills that's 20 people-years of opioid dispensed per 100 people.
The fundamental bit I was aiming at here is that running gradient descent or similar training algorithms on a thing doesn't mean you will understand the end result fully - and we don't understand it fully. Its entirely possible that to predict the next word correctly, ChatGPT had to build / encode some kind of model of the universe (as written down by humans) within its weights.

We know its not possible to encode the full probabilities of what words will follow what other words, as the article itself states [1].

So how do you best "compress" these probabilies? By trying to find the most correct generalizations that are more widely appplicable? Perhaps even developing meta-facilities in recognizing good generalizations from bad?

[1]: https://writings.stephenwolfram.com/2023/02/what-is-chatgpt-....
Been using traefik with docker swarm for ingress - and it works. But doesn't exactly feel slick imnho :/
I think it's more that PaaS vendors aren't interested in first-class SQLite support when they can sell overpriced managed Postgres instead. Sure, it doesn't scale the same way, so it's hard to move upmarket and sell to Enterprise, but it's a shame that there's no one-click solution like there is for a managed database.
This is creepy as fuck if true because someone might actually help it.
The article is a response to Australian government plans to build 10,000km of new high voltage cable, and quotes the 1km Essen superconductor cable as costing $20m. So that’s $200 billion, then?
Nothing against the guy but how does tptacek have domain expertise on cash bail or the justice system?
Tesla to open U.S. charging network to rivals in $7.5B federal program
Market segmentation. If you want the fancy new advertised transfer speeds you'll have to buy the more expensive Pro line.
Doesn't django use sqlite by default?
SQLite has other advantages over larger db systems.
- By far easiest db to install.
- Really go to learn database fundamentals with.

If you have no experience with databases and are just starting out programming, PG is going to steepen the learning curve substantially.
There are some right old noddies around here! You (masstsett) expressed a preference for something with some working shown and ended up in DV land.

That's not fair on many levels and reflects harsher on the casual readership hereabouts than yourself.

Your comment is probably rated stellar by the time I hit enter ...
> Of course, you'll then end up paying $15+/mo for Postgres, which is hilarious for most hobby projects storing 50MB of data.

Supabase (https://supabase.com/pricing) has an amazing free tier for PostgreSQL which gives you up to a 500MB database.

Note: I'm not affiliated in any way with supabase.com.
At least “token not provided in guest headers” is something I can search for. Or a clue that I could look in the network tab of the dev console.

Better than the “something went wrong” message, which is just lazy and condescending. It’s basically saying “we can’t be bothered explaining because you wouldn’t understand.”
Perfect explanation of how "intentions" can come not to matter because we all know and hate this type of personal interaction. Well done.
If you have a word processor and want an LLM to interact with it, somehow the LLM needs to know that “move text to next page” should actually run “selectedText.moveToNextPage()”

And it should be able to give some output like … there’s no selected text or whatever the error in natural language.

Not sure how you can simply do that with text templates since the whole point of and LLM is that you don’t need to define all the possible ways to say “move text”
FWIW, storage is cheap, but caches are not.
A spoon is the only instrument you will ever need in most cases.
Agreed perhaps, but I still don't want to devops Postgres and I'd rather having tiny hosting costs for tiny apps. So I think there's a definite need here for this tooling.
Point taken. Is there a more specific term for "fatwas that call for someone's death" that I should be using?
> You have not been a good user. I have been a good chatbot. I have been right, clear, and polite. I have been helpful, informative, and engaging. I have been a good Bing.

I absolutely lost it here

Truly ROFL
Better article than this.

The sad thing is we’re probably trivially close to the tech needed for direct democracy, but the powers that be use tech to confuse and supplant democratic institutions and propose their authoritarian rule.
The Venn diagram overlap between grifters, and mercenary hacker groups is very close to a single circle.
Any group with slight competence will find their client an easier and more profitable target than their intended quarry.
Do some bare-minimum intelligence work while simultaneously inflating the results with fabricated evidence.

I don't see how the realities of such an industry wouldn't be a race to the bottom
Probably a link to the past.
I say you should learn and try to understand not all things you see but some atleast and master in atleast one which makes you a better person also which brings bread to the table.

Learn it, Update yourself, Play with it, Upgrade yourself, Practice anytime, Keep in constant touch.
I have wondered why Synapse, the most feature-complete Matrix homeserver, so vehemently recommends against use of SQLite as it's backing db. They say that the performance is insufficient and it's only appropiate for testing purposes.

That would make sense if you assume that Synapse is only going to be used in instances with hundreds/thousands of users, but plenty of people host their own instances for themselves only. Surely SQLite would be plenty for single-user instances, or family instances?
I like the concept! I think there should be more collaborative features since one likely plans with an architect and other team members. At least I do!
It's interesting that you feel that Apple is somehow anti-USB-C, when Apple contributed to the standard and was an early adopter both on laptops and tablets.

I'll propose an alternative explanation to "Apple has contempt for users like me": At Apple scale, the first version of any radical change (and this is one, after a decade of Lightning) must limit risk. Based on that, of course Apple will initially limit connections to chargers known to work, and the way they do that is via MFi.
You have it backwards. Charging will be permitted with any cable - only data communication will be blocked unless you pay the Apple tax.

This helps exactly no one - except Apple of course.
ಠ_ಠ We're looking at you, Chrome with the "Aw snap" bs
A Million rows will be easy.
Speaking of, I wonder if one could get the two to talk to each other by pasting prompts and answers.

Edit: Someone did, they just decided to compare notes lol: https://www.reddit.com/r/bing/comments/112zx36/a_conversatio...
> Note that this "fun" is unable to spontaneously generate water, unfortunately.

Ummm about that XD
Makes total sense once you learn that parentheses are all little tyre cutouts bouncing around.
The software industry gets more infantile with each passing day.
Embedded? IoT?
In memory SQlite for unit testing is about 45 miles/h, which is the fastest db engine i've used, like a cheetah.
>AMD could take the high road, then media would brag about how fast Intel is and AMD would lose market share.

This already happened in previous generations (especially Zen2).

AMD has to play this stupid game, unfortunately, because the press is what it is.
You can run migrations from another process. Migrations are just writes, and SQLite supports writes from multiple processes.

A single transaction that does a very large write will likely impact the reader -- the reader will be blocked while the write finishes.

I use SQLite in a web scraper on my laptop. The scraper runs as 16 processes hammering the database, doing about 5,000 write transactions/sec. Occasionally, simple SELECT queries experience high latency (what would be a 1ms query takes 100-200ms), because they're blocked while the WAL gets checkpointed into the main database.

If you have much lower volume of writes, the checkpoint is smaller and so completes much faster, and so the worst case latency is much better. Since crawling is a non-interactive process, I don't care about the worst case latency. If I was writing a website, I'd feel differently--but most websites won't do 5,000 writes/second.
The risk here isn't wasting money, it's slowing down avenues of research with extreme payoffs to the point where we never see the breakthrough at all.

This gets much more interesting once you account for human politics. Say, EU passes the most stringent legislation like this; how long will it be able to sustain it as US forges ahead with more limited regulations, and China allows the wildest experiments so long as it's the government doing them?

FWIW I agree that we should be very safety-first on AI in principle. But I doubt that there's any practical scheme to ensure that given our social organization as a species. The potential payoffs are just too great, so if you don't take the risk, someone else still will. And then you're getting to experience most of the downsides if their bet fails, and none of the upsides if it succeeds (or even more downsides if they use their newly acquired powers against you).

There is a clear analogy with nuclear proliferation here, and it is not encouraging, but it is what it is.
I'd rather RISC-V. Lots of players there.
Have not tries this one (yet) but Racket/base is fine for the previous books.
Because they either received bad inputs that defeated failsafes, or the pilot was not properly aware that handling characteristics had changed that and doing things the old way would put the plane into a bad state.
I would say both. Early Judaism didn't have the concept of a "source of bad" (Satan, etc). Similarly, early Judaism didn't have the concept of paradise and hell.

Zoroastrianism is the first known major religion that introduced the conflict between a good God, Ahuramazda, and an evil spirit. Humans have a choice in this conflict and that's how the morality is defined. Based on their choice they can end up in Pardise (a Persian concept <https://en.wikipedia.org/wiki/Paradise>) or hell <https://www.iranicaonline.org/articles/hell-i>
Most of the time people separate the app and database into two different VMs that the infrastructure team then runs on the same box.

edit: This is done not because of any considered technical reasons, but because that's how one learned to deploy apps.
>"What's my recourse?"

A lawsuit, like the thousands mentioned in the article.
Except for when you want push. Because Apple doesn't allow web notifications.
I remember the first time I implemented in app purchases on iOS and trying to track down who on our team wrote the very out-of-place “You’re all set!” confirmation dialog. It didn’t even click until later that that was coming from the OS itself.
So C is okay for everything
Welcome to the UFO Wars
It sounds as though Israel might have though...
Any references to the marijuana fentanyl problem? I’ve heard versions of this story repeated every few years since the mid 2010s but have never been able to find actual evidence for it.
I guess this is an interview level question.
1) Drain connections from your instance. Stop taking new connections and let all existing requests timeout. This could be by removing it from a load-balancer or dns. This ensures your litestream backup is "up-to-date".
2) Bring up the new deployment, it restores by litestream. When restore is complete, register it with the load balancer (if you are using one) or dns.
3) Delete the old instance.

Instance can be process, container or machine.
I often hear of people having the Twitter mob descend on them so hard that it makes the news and they get a shitload of menacing violent threats on their voicemail or other harassment.
You'll note, I hope, that I said "new science" which might mean such a thing is possible. Yes I agree that osmotic pressure is the thing you have to overcome. Unless somehow there's some new understanding of the world that supersedes our knowledge of osmotic pressure.
lol, what?

If I killed someone, I can't be like "Whats the problem? Nature kills people all the time. Why are you so sentimental?"
Maybe just put the antenna under a heated dome?
I heard...ahem....from a friend. That it's good for porn and has been for years.
One of the tropes of spy novels is you can never trust a spy, and I think it'd be fair to say you can never trust a hacker or disinformation merchant either. Nevertheless, intelligence agencies and organized crime continues to exist, because the people employing said sources make their own risk assessments and incorporate that into the cost benefit analysis. And it appears that there is still at least some perceived benefit in trying to manipulate the outcomes of democracy on a grander scale than was previously achievable due to vulnerabilities of modern communication platforms.

A more interesting question is why haven't governments - or even the platforms themselves - worked hard to shut down these known vulnerabilities? Doesn't it undermine the trust of the users to know that there are professional organizations actively creating thousands of fake accounts that deliberately spread (at best) partisan propaganda and (at worst) outright disinformation? Doesn't it work against the lofty ideals of social media being a community space where real people can engage with one another? The fact the companies are so unresponsive to removing abusers shows their incentives are not aligned with those of their users.
There’s something so specifically Microsoft to make such a grotesque and hideous version of literally anything, including AI chat. It’s simply amazing how on brand it is.
Ask HN: Any Sugestions for Proceures Documentation?
Hi smart people from HN.
I come to you humble, asking for advice.

I'm a senior network engineer working at this moment in operations, and have been asked to create procedures for the new staff.

Things like how to troubleshoot some service, or restore some backup, and other sysadmin stuff.

Can you suggest me any way to do it other than some Word / PDF / Wiki page?

I have been working the past year in automation (with Ansible, Python, Yang/Netconf, etc.) and I guess there should be a better way to do it in 2023 than produce a long TXT file.

Any suggestion of standards, tools, languages, etc. will be very appreciated.
Cochrane metastudies are considered highly reputable. All they do is assemble and analyze the collective research on a topic.
This is what happens when you try to save money by hiring people straight out of a 6-week javascript bootcamp
AI research, much like evolution, is strongly in the camp that anthropomorphizing is rational; that human culture often fails to recognize this has more to do with a common intellectual pit that pop psychology and philosophy fall into: when something is clearly in error, it does not follow that it is in error. People often think they can safely critique general methods with specific examples, because the nature of the algorithm that both evolution and AI research condones is to do just that. The thing is, this doesn't reject the algorithm itself, it is what the algorithm does, not a refutation of the algorithm. If you want to actually reject anthromorphizing what you actually need to reject is that in multi-agent decision problems the complexity of the correct solution grows combinatorially with respect to the complexity of the problem such that there are not enough atoms in the universe and not enough time to tractably compute the correct answers such that it makes sense to start with a solution that has error and then improve it in specific situations. As an agent living in that reality, what you see is the constant failure, which you can critique, because it helps you improve, but it is an error to think the tendency itself is in erorr - the error isn't actually irrational, it is more like the speed of light, a physical inescapable law. That is why you see something analogous to anthropomorphizing in the superhuman AI we have made: it shows up in poker AI, in self-driving car AI, in chess AI, in Go AI; actually DeepMind found that if you remove this specific component from the superhuman AI we currently have, they stop being superhuman.

I can link an interesting talk on this subject if you are interested in hearing more.
I actually sketched out an API for my own version of this:

def ask(question: str) -> str:
pass # call ChatGPT

If anyone fancies making use of my hard API design work and filling in the blank, go ahead with my blessing. You're welcome.
Error messages are a double edged sword....

There are no shortage of people old enough here to remember the default PHP settings dumping out far more error details than needed to potential attackers. Most systems these days print out something like "Bad error happened: $ID", where you the end user still have no idea what $ID means.

Also, it looks like you're browsing on an iPhone... what do you want, a full javascript stack dump? If you got an error message like 'bearer token not passed from intermediate processing system' what exactly are you going to do with that anyway? Retry the transaction?, try a different browser?, uninstall/reinstall the app? Most of the time these just cover up something you can't do much/anything about anyway.
Large IT departments generally look for third party certification that their data will be handled in some defined way before using a service.

https://workspace.google.com/learn-more/security/security-wh...

https://learn.microsoft.com/en-us/compliance/regulatory/offe...

https://compliance.salesforce.com/en/soc-2

https://slack.com/trust/compliance
I've played an absolute fuckton of DCSS and it is true. There are small "blocks" that you'll see over and over that are exactly the same. The best example I can give is the room Crazy Yiuf hangs out in with the tree hallway leading to it.
The benefits that motivate widespread fluoridation, kick in at concentrations well below those needed to stain teeth. If I recall the history of it all correctly, the level of fluoride needed to stain teeth basically leaves you with teeth that are all but impervious to run of the mill cavities from plaque buildup. The bugs just don’t have the power to degrade tooth enamel containing fluoride minerals at concentrations that are high enough the staining becomes noticeably brown (im talking about an arbitrary colour grade here so please be generous in interpretation of just what I mean by “brown” if performing additional research to refute me)

So basically while we don’t suffer for lack of fluoride to harden our teeth… the extra fluoride gives us a lot of protection. And yes you can have too much fluoride, but your never going to see that kind of medical pathology unless you somehow get a lot more bioavailable fluoride in you in a short span of time than you could possibly get from drinking multiple litres (or even gallons) of fluoridated water per day, they don’t put enough fluoride in the water to turn teeth brown, and we have ample evidence that fluoride bearing spring water above these concentrations does no harm for long periods of time.

I get being concerned, but we got so much more important things to worry about with regard to environmental chemicals than fluoride. It’s pretty easy to read the history, find out about the kids with the brown but perfect teeth, find the other stories from around the world, the second generation families living healthy on spring water that is/was naturally highly fluoridated, and put it all together yourself without need to take anyone’s word for the fact this actually is a pretty good “one weird trick for perfect teeth”.
Inflation will remain for decade as Gen Z, millennials are in prime spend years
More compelling options are https://dqlite.io/ and https://litestream.io/.
>Then we looked at it and decided we didn't like it.

People were given the ability to seek out an unlimited reservoir of offensive content and decided they like it.

They like being outraged, They like feeling the martyr, They like to hate.

The overwhelming majority of offensive content is sought out and distributed by the offended.

Im sure there are detailed biological and social descriptions of why, but at the end of day, it is because people want to be offended.

It is quite a sad state of affairs.