skysight-inc/HackerNews huggingface dataset:
I do host a medium-sized PostgreSQL database, but i would love not to. I need the control you won't have with a cloud offering (you can't install extensions) but i don't want to do all the other steps, and you always have the fear that backups do not work correctly.

And i am not the only one hosting it by my own, many people are using self-hosting PaaS like dokku, flynn or caprover. And all these solutions have a common problem, they all need to reinvent the database as a service layer. What is currently really missing is a good open-source PostgreSQL as a service appliance, something "simple" like Heroku. There have been attempts like Elephant Shed, but they all try to do too much and therefore fail in adoption as they never reach stability. Or people are forced to use complex solutions like patroni which is doing many things, but if something fails you have no clue what to do.

So what is really missing?

1. A simple old-school PostgreSQL vm image
2. Built on a copy-on-write file system to clone production environments like https://postgres.ai/ and Heroku for development reasons which will not really need any storage space.
3. A built-in backup solution like pgBackRest storing the files encrypted in some cloud storage (and restore options!)
4. It does not need a complex ui or inspection/monitoring software, there are many solutions you can run on a different machine.
5. Replication, Auto-Failover etc. are hard just make it a single server which you scale vertically, if you need horizontal scaling you have very specific needs, there can't be a one size fits all solution, so don't even try it. And a real bare-metal server with nvme disks has a lot of power it's insane how fast it is compared to cloud hosted databases.
> Another thing, instead of using exposing ports like that, the easiest is to use Docker-Compose, so that your containers of a stack have their own private shared network, then you won't have to publish ports to make your services communicate.

That only works with local communication unless you use docker swarm. So byebye high availability.

If you're going to make suggestions, at least think about them from a production point of view.
Why Kubernetes is our modern-day COBOL
https://dev.mysql.com/doc/refman/8.0/en/default-privileges.h...

> Installation of MySQL creates only a 'root'@'localhost' superuser account that has all privileges and can do anything.

It's only a local account. Sure, it would be great to have a password on it, but it's not "a completely open root account".
The first iteration of Ethereum's Proof of Stake protocol, the standalone Beacon Chain, has been working since December 1st 2020:
https://beaconcha.in/

So while not there yet, it's on its way to becoming proven technology. A big test will be how it handles general transaction processing. The Beacon Chain is limited to finalizing Ethereum PoW chain blocks at the moment.
Indeed, pair it with Apple Pay and it's like 5 tap deal.

QR code already knows which table it is and even payment can be optional after the meal (tho I got so used to paying before I might just leave without paying nowadays).
>A floating foundation

reminded - back at University i worked summers on construction mostly doing foundations in Siberia in permafrost zone. The most memorable part of the quick introduction to the profession there was when they showed us several buildings which didn't have piles deep enough - most of those you could easily spot from a distance by the building shape defects like tilting, bended roofline, etc... because if piles aren't deep enough the foundation pretty much becomes really "floating" during warm season after several cycles of freezing/thawing.

Related, at a bigger scale, global warming affecting foundations in the permafrost zone https://www.theguardian.com/cities/2016/oct/14/thawing-perma...
I see. I don't find the lack of ability to share a device as a problem, but I can understand your first point.

On a side note, I was thinking about using both - password/PIN (something I know and must be conscious to provide) AND a fingerprint. Sadly, Windows Hello can't be configured this way.
Except if you believe, as the author does, that the entire market is just scams and insider manipulation there is no meaning to be gleaned from any of the numbers. If it's all a sham it will blow up at some point, it's just a question of when, but that will almost certainly be precipitated by some unpredictable external event.
The buy.axon.com server is misconfigured, it only provides its own cert and not additionally a necessary intermediate "Go Daddy Secure Certificate Authority - G2".

If your client system has the intermediate, it will be able to validate. If not, you will not be able to establish communication with it, even though you may trust the root the intermediate cert is signed by, there is a gap in the middle.
It's been decades since I had fever dreams. But my memories include strange shapes and motions and things being somehow upside down or otherwise inverted. Most of all, I remember an absolutely overpowering sense of dread over how everything was impossible. What was happening should not be happening. It could not be happening. The terror only grew as the impossibility continued.
Doesn't that run counter to what devops actually should be? I know that in practice, this split is what happens at companies, but we should work to close that rift, not widen it.
…or if you want to re-use your existing intercom and hook it up to MQTT, see https://michael.stapelberg.ch/posts/2021-03-13-smart-interco... for how I did that :)
I have used duolingo for like 6-12 months of learning Spanish and it helped me so much. I was in Mexico and could understand a bit what they were talking about on radio and just making connections with people because you could speak a bit of their language was great! And I think that's where duolingo shines.

They do not want you to learn a language completely/perfectly but it's kind of a bootcamp for languages. And their way of learning is helping so many people. The streaks are probably the drug most people need to continue or grinding a topic. It really helps a lot of people because in general since the main population sucks at consistency. On top of that, their branding is also top notch with duo, and their user experience overall is just the best. Happy to see them IPOing soon.
I am sure there are plenty of web-based alternative UI disasters to replace menus with fonts that are too small to read properly.
3 billion users probably disagree.
I still don't get how this solves any major issues. Neither major companies or the vast majority of people need to wire money at 2am. The main utility of banks (and the main profit center) is giving users the ability to spend money on credit.

Crypto doesn't solve that. I feel like everything you said about the upside of crypto would have applied even more so to the invention of 24 hour ATMs. Was it a huge upside to users they could get money at 2am? Yes. Did it change banking - no. Will faster transfer be upside for consumers? Yes. Will it change banking - probably not the existing banks will just get faster at it and things will be marginally better. I can already use zelle to transfer instantly.
I self hosted everything from Postgres to ElasticSearch.

IMHO, managed solution ins't that much reliable than running your own with the right planning. Failover strategy of AWS RDS is just absurb. It's literally just promote other instance, switch DNS over. And I do see issue where the new master are behind a few transaction compare with the replica...

Managed database is just to move the responsibility when the database is down to somebody else.

Self host gives you a lot of flexibility to mix and experiment with new technologies and tooling.
I’ll try that, thank you.
I can recommend moteino - Arduino with a Lora transceiver piggy backed on it.
Yes, limit connections in firewall. Ideally you are only listening on a private network anyway, better yet only listening on loopback or a local socket. But still firewall it. You can also configure the database to only accept connections from a particular source. Do that too.
I’m also interested. We are currently using the managed pg server where we create multiple databases inside. The managed pg database does not support private endpoint if i recall and it gets pretty expensive.

Also single managed server doesn’t scale well.
> within an economic market

We’ve looped back to that term. What is an “economic market?” Precisely? In a way that makes the law grounded, predictable and extensible.

I’ve struggled with this, too, by the way. The courts have as well.
> We can say with certainty that Bitcoin is not a Ponzi scheme because a Ponzi scheme requires fraud i.e wilful deception.

I agree with you but we can also say with certainty that economics of Bitcoin are identical to a Ponzi scheme. Earlier investors are payed with funds from more recent investors.
How We Made Our Maps 10x Faster
> When is the last time you knew of someone becoming blind from a poorly made moonshine?

This may not be a problem in urban America, but the world is slightly larger than that.

Try living in the Eastern bloc, you will find Russian moonshine is wildly popular and sometimes comes with methanol.

Same goes for China, India and many African countries — the profit motives are stronger where knowledge is more scarce.
That's the most gish gallop I've ever seen crammed into a single sentence... I've given up writing rebutals to the 8 different tangents, insinuations, conflation, etc. and will instead focus on a single point:

Every single ideology will say their opponents are responsible for countless lives lost. (And if they lump everyone who disagrees with them together can probably make such a case) Just for an example, capitalism vs communism. I'd rather not be stuck in a China like situation where arguing against government beliefs like "this new virus in Wuhan is nothing to worry about citizen" gets censored or we get eternally stuck in a suboptimal state because arguing for anything different is considered dangerous.
Don’t say anything.
Yes, I selfhost Postgres/Redis/Mongo for small projects (db + app server on the same machine or a small number of VMs). Usually in docker, sometimes systemd units. It's amazing what you can do on a single $5-50/month machine if HA isn't super important.

On larger projects (typically once k8s gets involved) I'm running on a cloud provider anyway and I might as well use a hosted version like RDS for the main database.

It comes down to the importance/budget of the project. I'm not a Postgres expert by any means but I'm confident enough that for simple use cases I can manage selfhosted. And if I need more, hosted versions are available at a cost.

However, any hosted DB product I use has to be open source and in theory easily replaceable with a selfhosted version. After the Parse.com fiasco I'm averse to closed/proprietary components in my infrastructure.
So you're using web apps that run sqlite? With some logic on a central server, which then updates all the web apps?
We did exactly that last year.
Banks are bad because they charge to much, but they aren't that bad. What kind of unbelievably shitty bank doesn't provide 24-7 money transfers through a convenient phone app? Those transfers always take 0 time within the bank and have legally forced waiting periods between banks and between regions. The time may be legally required to be higher for certain scales of transactions, but they are generally as fast as they can be. Btw if your bank does not provide these services, just switch to one that does.
Amazing. What are some advices that you would give for someone who is looking to self host?
Many of your comments reflect a misunderstanding of basic economics
MIPS Assembly Programmming
While it's true in some regions, most of the globe banking is still very slow. In any digital currency, like cryptocoins of CBDC it's the same globally, not per region.
If it doesn’t work then by definition nobody is being denied effective treatment, therefore there is nothing to be outraged about.
Nice. Next step would be a microphone and speaker. You are effectively building an outdoor SIP videophone.
i know duo isn’t perfect. but i appreciate it because it’s the only language learning thing that’s gotten me to consistently do it everyday for over a year.

anything else i couldn’t maintain the habit. obviously not going to fluent off but as a novice i do appreciate it.
Don’t you think the whole market of language learning apps should be looked at with suspicion? I talked to my brother-in-law the other day, and he said he hired a tutor in the Philippines to teach his kids English. Unsurprisingly, it was super cheap. Low paid labor might be hard to get for Japanese, but it seems like for most languages people want to learn lessons over Skype will be far greater value than even a well designed app.
Or show a more affluent customer a different menu — one where everything is labelled deluxe, bespoke, or through terminology substitutions similar to "Patagonian toothfish" → "Chilean sea bass".
Welcome to HN and your comments are not in bad faith at all.

Some views here are very ‘boolean’ and lack nuance... presented as simplifying complex matters. But it’s rather a simplistic mode of thinking, which reduces our lives to lives devoid of empathy. This mode of thinking also tends to see ‘working class’ folks who can’t manage their finances as folks who simply lack character.

In the words of Rutger Bregman... poverty isn’t a lack of character, it’s a lack of cash (recommended read: his book ‘Utopia for Realists’)

And don’t forget, what this pandemic has showed us is that lots of working class folks really are essential workers.

Yes, there are some folks who are lazy, but you find that in all sectors.

Letting simple algorithms designed by folks with a very ‘boolean’ worldview determine who is worthy of employment (survival) and who is not leads us to world as illustrated in the movie Elysium.

I for one appreciate your view.

Please continue baptizing ;)
That headline makes no sense.

Fucking illiterates.
That was Panasonic, and for the China market they switched to the same pouch cells as everyone else.
My understanding is that it is a bit more subtle than that. For more exact information, consult a lawyer, instead of random non-lawyers on the Interwebz.

If you file a DMCA claim on behalf on entity E, while knowingly not being entity E, or an authorised agent of entity E, you are committing perjury.

If you file a DMCA claim, you must have done a fair assessment that the material is actually under your copyright. If you know that you do not have the rights to the alleged infringing material, you are (I think) committing perjury.

If you file a DMCA claim, you must consider if fair use applies (but, crucially, I don't think there's a requirement that you reach a correct conclusion.

All of this makes cases like "I have licensed a song by creator C, for use as my intro" and a management firm DMCA-claiming all of your videos for using it a bit dodgy, as they really REALLY should check that before they react to any ContentID-originated "this may infringe". In at least one case[0], the management firm apparently thought the onus was on the licensee to proactively register each uploaded video with the management firm, which seems wrong to me. I would like to see one of those instances taken to court, and (preferably) end up with the conclusion that it is on the filer to consider licensing before making DMCA claims.

[0] No, I don't even recall the name of the creator, but I think he was mostly doing gaming content. There's bound to be more, though.
The Productivity Encyclopedia – a guide to all things productive
Code hasn't been touched in two years.

There are so many things you can get wrong when writing a new Bitcoin implementation.

I'd stay very far away.
100ms of latency just to encode seems a bit high if you have to buffer up a few packets before playback on the other end, plus network latency. For comparison, the Opus codec recommends 20ms packets, and it can be lowered to 5ms. (High-latency voice calls drive me crazy...)
It’s an unpopular opinion but it’s 100% a good idea. If at all possible, bind local services to UNIX sockets instead of localhost ports. At least that way you’ll get some measure of access control effectively for free.

If you’re writing software that deals with network connections (as a client or server), write the code for UNIX sockets first. It’s usually trivial to bolt network connection code on top, and being able to deal with sockets directly can make automated testing significantly easier.
New Zealand had a referendum on leaglisation with a 52/48 opposed result.

Instead of reading this as rightly that people wanted change, Ardern has done nothing.
Global transfers are slow because they generally undergo some form of manual review for risk and AML/KYC. Crypto is fast because it pretends that this isn't a requirement. That only works as long as it's small enough people don't care. Once people care, things will look a lot different than they do now.

There's no reason whatsoever that a crypto payment would be faster than a traditional payment - in fact, there's a ton of reasons the lower bound is much slower.

This is an intentional process decision, combined with some (replaceable) outdated technology. However, the former strictly dominates the latter.
Right now we (team of 12, 1 devops engineer) use mongodb atlas. While mongodb/nosql itself really is not giving us any value and that I really wished that postgresql was picked for our relational data, I must admit that atlas really is a nice product.

Hosting is not only about speed and price. We use atlas (=hosted mongodb), because we get that nice dashboard with all those statistics and performance tuning hints. Also, if we screw something up, mongo engineers are available immediately to help us. That was nice when we broke production because of index creation on the foreground. (Which pymongo defaults to, even though mongodb itself defaultst to backgound creation). We consulted them for tuning a frequently running “slow” query and that helped.

In short: hosted solution for support and less maintenance. Backups are arranged. We can choose which version to run on and upgrades are also arranged.

Question: is there a comparable service for postgresql like mongodb atlas?
Since he bought his puts on 6/26, BTC is up 9.5%, MSTR is up 9.9% and COIN is up 13.5%.

He's already pretty deep underwater.
actually coinbase’s revenue tracks pretty well to bitcoins price. as when the price crashes people lose interest in it and volume goes way down. this is basically what happened between the end of the last bull market and the start of this one

and the same is true for robinhood with stocks. bull market attracts more investors trying to get rich and drives volume. in turn when it crashes the volume dries up as retail loses interest
Eventually the government. So many people (including in this thread) keep advocating that the decider on what to censor should be the government.

I'll also point out that the deciders in Twitter, Facebook, etc are not the most ideologically diverse bunch, so one could argue that the so-called blue tribe is being the central arbiter.
Nice to see sdfx [1] there, this project is impressive.

deadsy built some rather sophisticated models, be sure to check out the renderings in the github README!

https://github.com/deadsy/sdfx
Decriminalization is a back door for criminal enterprises. They would still control supply, which means they would control quality, variety, price and availability.

Do we want to give monopoly on those powers to organized crime? Just look at the Netherlands: on the surface everything looks fine, but then there are murders of politicians…
I don't really see an agreement here. It's also not Instagrams content they are hiding behind the implied paywall. Because that's the real hidden truth, they make you pay, not with money, but with your soul. They will stalk you everywhere to the end of your existence, try to learn everything about you and use it against you in every way they can that gains them something.

It's been bad a long time now, but not like this. You really want to tell me it was this blatant?

So yeah, fuck you, I just wanted to look at cats.
In fairness, that history seems to indicate that maybe it really was SUSE who decided to enable it. Sure seems like "RemoveIPC" option should have been advertised as a 15.2 -> 15.3 update repercussion. :-( :-( Leap 15.2 didn't do that, 15.3 does. Unknown what the other systemd distros do with "POSIX shared memory cleanup"
I'm surprised the author didn't mention the worst part

In most cases, the file is called "menu.pdf", so after downloading the PDF you then have to figure out if menu(12).pdf is the cocktail menu or the food menu.
Real Dino Hunting 2018: Carnivores Dino Zoo Game
Real Dino Hunting 2018: Carnivores Dino Zoo Game is a shooting journey to the Jurassic jungle world and hunts the wild T REX and different free survival dino zoo game to survive in the world best dino hunting games dangerous jungle. This dino hunting 2018 real shooting and carnivore hunting attack adventure will move you back to the prehistoric Jurassic hunter free survival dino zoo game. Load your world best dino hunting games weapons and Hunt T REX (Tyrannosaurus) in Jurassic jungle world. Now, in free dinosaur hunting games 3d game you can enjoy wild dinosaurs hunting adventure in wild hunt wildness game dangerous forest. There are many best dinosaur games in the world but this is one of the dino adventure dino hunting 2018 in the category of best Dino shooting games. Thus, in the free hunting games without wifi game select dangerous weapons of your choice to shoot and finish world best dino hunting games wild dinosaurs.
Science absolutely does not claim biological human races exist. Almost all of the major anthropological societies have a statement somewhere like this:

https://physanth.org/about/position-statements/aapa-statemen...

Or this:

https://www.americananthro.org/ConnectWithAAA/Content.aspx?I...

Those statements also explain why being post-race is more difficult than it should be.
What kind of a bank do you use that doesn't allow you to send money 24/7?
> In Canada, we have about 7 major banks ... They print profits and will not compete on fees.

How does this happen with 7 competitors? What stops one of them undercutting the others and winning customers? Is it that retail banking customers aren't that price elastic and there's too many frictions involved for a customer to switch?
If you use Windows don't worry too much. Whatever you do, you will end up with a virus, and the worst part is that you probably won't even realize it.
Probably not any time soon. The current trend among the woke crowd seems to be emphasizing importance of race, rather than trying to get past it.

Worst racists of today are ones who divide people to privileged and underprivileged simply based on their skin colour, when the reality is way more complicated.