leononame

Ok, got it, thanks. The wording in the comment I was responding to confused me and made me think it was possible to also change the overcommit behavior for a cgroup, not just the limits.

Interesting idea. How does that work in practice? If I've got 64GiB RAM, and PostgreSQL has 32GiB memory usage, and Go has 32GiB of memory.

If the database requests more memory, it gets ENOMEM, but if the backend app requests more memory, it does get some more because it can overcommit?

Sounds dangerous, if the go program then writes to the overcommitted memory, you'd still trigger the OOM killer, right?

I was aware of GOMEMLIMIT, but it didn't cross my mind in this case, thanks for pointing it out. It could be really useful! I'll have to check our specific use case

This has bitten me multiple times. The problem I have is that at work we deploy the application (written in Go) and PostgreSQL on the same machine. The backend app allocates a lot of virtual memory, and initially we had overcommit to 0 (heuristic). This caused crashes on big queries in PostgreSQL and we set it to 2. The whole system became a bit unstable because the backend would still allocate a lot of virtual memory and at some point we ran into errors when allocating.

For now, we have overcommit_ratio set to a value that is stable from experience, but there really seems to be no silver lining. Go is very happy to allocate a lot of virtual memory, but so are most managed languages. The best solution would probably be to host the backend and the database on separate servers.

Sure. But Occitaine is also incredibly different to Normandie, so it'd be a fairer comparison.

Romania and France are different in a way that Oregon and Florida aren't. They have the same federal government, the same official language and relatively similar culture. Yeah, there are differences, and they can feel huge if you're in the western bubble, but differences like those are also found in other countries.

I will concede that the US is more ethnically or racially diverse than most parts of Europe, but that's about it. Saying that Oregon and Florida are as different to each other as France and Romania is, in my book, incredibly incorrect and it feels a bit insulting, though I can't out my finger on why exactly.

A US state is not a country. I get that there is a lot of federalism in the US and that states often have different laws and regulations, but the same is true for European countries. You can compare the US to Germany, or Sourh Carolina to Bavaria, by your own logic.

That's fair. Experiences have a great influence on opinions you form, and everyone's experience is different. You live in a different part of the world than I do and know different people. I even conceded that in North America, the amount of people that take the bible literally might be higher or at least more visible than other parts of the world, and I'm going to assume you are from the USA because you said "state".

According to one survey I found[0], around ~20% of Americans (25% of Christian adults) say the bible is the literal word of god. Not exactly a huge amount of people, but a very considerable number nonetheless. I didn't find any numbers for other regions, but maybe it would help to see number of followers by denomination and try to derive some data from that. The official stance of the Catholic Church e.g. is that the bible should not be taken literally. Most protestants in Europe also don't practice much fundamentalism, but there are an estimated 25 million Evangelicals in Europe, around 2.5% to 3% of the population. There's probably more people preaching biblicism than only fundamental evangelicals, but I just wanted to look up two examples real quick.

[0] https://news.gallup.com/poll/394262/fewer-bible-literal-word...

Yeah, but only if you take the arguments fully out of context and only if you view a subset of the arguments.

First, the argument of your garden-variety nerd atheist don't always map so cleanly to negative theology. I've seen plenty of arguments in the realm of "The bible contradicts itself, so you're stupid if you believe in it. Checkmate", etc. You get the idea. Just some of the arguments map well to negative theology.

Secondly, the context is missing. In my original comment, I was talking about how being very literal is seen as poor social adaptation because subtext, inaccuracies etc are part of social communication. Pretending to not understand that, or not understanding that, does not make one a logical being, it just makes you look like a dork.

Your argument is applying a very literal take of the hypothetical garden variety atheist we've brewed up. This is the same as taking the bible very literal and then calling people stupid when they believe in it. It's not arguing the main point, but picking out something that's easy to criticize and building your argument around it. My point is that taking something very literal is exactly a sign of poor social adaptation when there is a relatively big agreement on not taking it literally by society.

Now, your garden-variety nerd's arguments hold up very well against people who actually do take the bible literally, but I'm getting to a point where I want to get off the religion debate, because that's not really what I wanted to point out originally.

Circling back to my original: Logic and reasoning is not against social norms. Being a dork who pretends to not understand or actually doesn't understand social norms just to make a point is. Being hurtful just to feel superior is against social norms. Pretending you're interested in "truth" and that's why you are not conforming to social norms is also a pretty stupid take, imo. Yeah, social norms aren't always great, and they certainly don't work for everyone and a lot of people are left out being the "weird" ones, it sucks. But the reason these people are the "weird" ones is not because they're on a noble crusade for truth and logic.

I'm pointing this out even though you're not the original commenter I was responding to because we kind of got derailed into the details of this thing that was more meant as an example than really the main argument.

As for the why, I don't have an answer, but I thought I addressed it with this:

I'll admit that there are also groups of Christians that take the bible very literally, as I'm sure there are for other religions as well. From what I can see, these don't make up the canon of religion, and I kind of believe they're mostly concentrated in North America, but that might be my skewed perspective.

There will always be people falling off on one side of the spectrum or the other. Personally, I haven't met anyone who takes the bible literally, and I know a _lot_ of Christians, including pastors and priests. Some people simply just believe that there is something more, others have a feeling that you can sense that, some just need this believe to feel safe, etc. I guess it depends on where you're from, I believe biblicism is more common in North America, or at least more visible.

Additionally, the "everyone understands religion is not literal" was citing my parent. Usually, "everyone" is kind of understood not to mean "exactly 100%". It's a device to communicate intent.

You could just as sensibly flip the argument and argue that the garden-variety 'nerdy' atheist is talking literally about atheism but really doing negative theology ("your idea of God is totally wrong and does not exist, because the true God is necessarily inaccessible to human reason") but that would be silly and make you look like a dork too.

Yeah, it'd make you look like a dork because it'd be obviously incorrect. The intentions of your garden-variety nerd talking about atheism are pretty clear, and it's not to make some greater theological point. When you talk to people who talk down on religion and believers, it's usually really easy to tell whether it's because only they themselves understand the True Intention Of God or whether they just think Christians are stupid and if you're smart you have to be an atheist. Said garden-variety nerd is the latter.

Nerds were often seen as poorly social since "logic and reasoning" would go against socially accepted norms. This where the fedora tipping meme comes from: "everybody understands that religion is not literal, but we have to all accept the lie for social cohesion". But "nerds" would be the ones willing to take the ridicule and ostracism because truth would be more important than conformity.

I don't think nerds are/were seen as poorly social because logic and reasoning go against social norms. I'll bite on the religion focus. If everyone understands religion is not literal, being smirk about taking it literally is not logical or reasoning or making anyone look smarter. It just makes you look like a dork. Subtext and not being meant to read literally are a core part of social interaction.

I see the same in school, when some overly literal students argue about the interpretation of a book they are assigned to read. "the author can't possible mean that" or "show me where it says that on the page" is a common lazy criticism with little value. Some people are just like that, and (warning: personal observation) nerds tend to be a bit more like that. But the arguments I hear from that corner against religion are seldom great, they are just some minor gotchas.

I don't want to get into the whole religion debate, and I'll admit that there are also groups of Christians that take the bible very literally, as I'm sure there are for other religions as well. From what I can see, these don't make up the canon of religion, and I kind of believe they're mostly concentrated in North America, but that might be my skewed perspective.

It's quite sad that social mechanics in our society don't work well for some people, but that doesn't mean they don't exist and it doesn't make everyone except nerds "illogical".

The internet was different, for sure. But the post you are responding to just stated that they don't really believe arguments were rational and logical back then. I don't think any of your points refutes that.

Is that a good thing? I think getting stuck is an intrinsic part of the learning process and sometimes it's good that there isn't an immediate answer from a senior. For some things you'd never have solved yourself, sure. But pain and suffering is a big and important chunk of learning and I fear we just throw it all out of the window with asking AI.

That's not true. A heat pump produces 1.5 to kwH of heat per kwH of electricity consumed, so it's already much more efficient than a diesel generator.

Even in winter, electricity from the grid is greener than burning diesel. I didn't find specific numbers for winter, but wind is about 30% of Germany's (just picking the biggest country out of DACH to support the point, not trying to come up with exact numbers) electricity production year-round, and wind doesn't tank in winter like solar does.

So, in short. Installing a heat pump and just taking electricity from the grid is still better for the environment. Of course, having your own solar is great if you live in a house, but you don't need it.

Why not? Could you elaborate? I'd love to know more. I always had the feeling that supporting SteamOS basically meant that generic Linux Desktop support was almost implied because in the end it's almost always on Proton rather than native.

I didn't do this, I just stumbled across this on reddit. The building sizes are determined by the number of views in the past 12 months.

Posts like these make me realize I know next to nothing about a lot of the systems I daily work with.

It is always humbling to read things like these!

English has present perfect, and past perfect. E.g. "I have walked" and "I had walked", both tenses are participated (ie "walked" instead of "walk"). These two are similar to the German Perfekt and Plusquamperfekt which are also participated.

The problem here is that the simple past "He went" uses an auxiliary verb for negations "He didn't go". In this case, "go" is not participated.

I'm also wondering about that. But maybe this could be it?

Surprisingly, the table is just as big as with the enum type above, even though an enum uses four bytes. The reason is that each table row is aligned at a memory address divisible by eight, so PostgreSQL will add six padding bytes after the smallint. If we had more columns and could arrange them carefully, we could see a difference.

This could be the explanation. If the row is padded to 8, bigint is 8, then smallint or enum also use 8. The entries in the string table will be 8 or 16 due to the string length. So one row in person_e and person_l is 16, one row in person_s could be about 20 on average, that is a bit closer to the reality than my intuition, although the storage savings are still less than what I would have expected.

edit:

I did also try out the test and dropped the primary key on the table to compare only enum and string size:

  SELECT PG_SIZE_PRETTY(PG_RELATION_SIZE('person_e')), PG_SIZE_PRETTY(PG_RELATION_SIZE('person_s'))

  277 MB,330 MB

That is not true, though. Reading from a nil map panics, and reading from an empty map does not.

I think there's multiple things coming together. I'm in no way arguing to forbid immigration, I'm just pointing out that I don't think Digital Nomads are a net positive and that there are real economic consequences beyond "they spend money so it's good".

I also specifically said I don't have a problem with anyone coming. You're welcome. I expect people that come to to a country to pay income tax there (as is usually required by law), but I'm in no way arguing to "cut off demand".

Arguing that someone who would want to close borders and stop immigration (both of which policies I don't support at all, btw) is socialist is a bit far fetched. As I said, I welcome immigrants. Immigration brings with it a whole class of problems that need be addressed, but that doesn't mean it should be forbidden.

And lastly, there's also a big difference between housing a vintage cars. One is an essential need, the other is not. You getting priced out of vintage cars, a luxury item, is not nearly as bad as you getting priced out of housing. That is a real problem that is actually happening in a lot of places, not some weird fantasy.

I feel like either you're really dense or you're misunderstanding me on purpose.

It's exactly my point that mist people can't afford to live their because they're being priced out by foreigners. Most people native to such an area see that as a net negative, regardless of how much you want to dress it up as people coming and spending their money.

Well, that only counts if you see the DN as a net positive. Similar to tourists, a lot of people see DN as a net negative because they spend some money, sure, but they also raise rent and hospitality prices. This can harm local communities and economies because it may benefit few people over many or change where people have to go live.

Places relying on tourism as economic activity are very susceptible to economic crisis and it can even go as far as suppressing generation of jobs in other sectors and people leaving because you only find jobs in tourism or you can't afford to live in the city because Digital Nomads live there already. This is obviously exaggerated to make a point, but I think the point still stands in smaller scale.

Foreign money flowing in does not need to be a bonus. DN have the potential to change the microeconomy and in ways that affect your macroeconomy much more than just money flowing in.

Take a place like Barcelona, a famous example for people not being able to live there anymore due to high prices. On top of that, a lot of digital nomads don't interact much with local culture. When people start leaving, is the influx of DN money really still a net positive? Especially considering some of them don't even pay income tax?

I don't want to demonize immigration, but people moving somewhere and treating it like a cheaper version of their hometown is not a positive in any way, culturally or economically.

I am not arguing for socialism by saying that people coming and spending some money (not even that much) is not a sustainable way to do economy. I've got no problem with foreign investors building things that are actually valuable to the economy by building up industry, creating jobs or whatever. Cuba, Venezuela and Argentina have a whole lot of different problems and the reasons they are in the positions they are are much more nuanced than "socialism bad".

I live in what's not exactly a digital nomad hotspot, but they do come. You pay 150€/month for a coworking space in a city where some people pay 300-400€/month rent. These digital nomads come here, pay absurd amounts of rent without blinking an eye.

And the tax thing is not a bogus argument. When people only pay taxes indirectly, they are tourists. Digital nomads pay _much_ less tax overall than other people, because people who pay income tax pay indirect taxes as well. If the digital nomads don't come, they also wouldn't raise rent and café prices for everyone around them. You come here, register yourself as a freelancer and pay income tax? You're very welcome in my book. But if you come to the country to leech off its cheap prices but don't pay income tax, you can go back where you came from.

We bring in millions of poor immigrants for various reasons: It's the human thing to do, these immigrants do cheap and hard labor that a lot of natives won't do (think construction, food delivery, etc.) and as such even provide benefits to us.

Digital Nomads mostly aren't immigrants. They come for a limited time, don't provide much to the local economy outside spending some money (and even then it's not that much because a lot of them come to cheap countries to live for cheap and save money) and then leave again. It's not really comparable.

The quote reminds me of Tucholsky, a German journalist known for this style. An example that comes to mind was his review of James Joyce's Ulysses: "It's like meat extract: you can't eat it, but many soups will be made with it".

I think putting a bit of fun writing into reports of everyday events or reviews can go a long way. Tucholsky again, I'm paraphrasing and translating from memory where he wrote a trial against dada artist Grosz who depicted army officials as grotesque and ugly: "To demonstrate that there are no faces like this in the Reichswehr (the army), they brought in lieutenant so-and-so. They shouldn't have done that."

Good writing goes a long way

Still a valid counterargument. A good browser based DB GUI might just not exist because the existing desktop ones are so good already.

I personally also vouch for DataGrip, a fantastic tool. No browser based tool is going to come close to the experience of an actual desktop app imo

For context, because I had to look it up: For BB(6), Σ(6) is known to be least 10 ↑↑ 15 for in Knuth's up-arrow notation. You can read this as 10^(10 ↑↑ 14) = 10^(10^(10 ↑↑ 13)) and so on. It's much more than just a lot.

Anyone know how many digits this is?

Interesting, the dentists I have asked (4) all said it doesn't matter (Spain and Germany, maybe it's relevant) at all and it's up to personal preference.

A Boatmurdered read is one of the few times I actually burst out laughing in front of my screen - multiple times.

Every time I read it I want to get back into dwarf fortress, but this damn game introduces so much new stuff over time that I can't shake off the feeling it's just too much for me. I _loved_ that game until about ten years back but haven't played in ages.

What I mean is that it'd be nice if you could store them somewhere else explicitly. Create a new workspace and store its contents in your code repository so that you can commit it and share it with your team directly through git.

Congratulations! The local API client space urgently needs some Open Source tools that don't suck. I've ditched Postman and Insomnia for Bruno, but since this supports gRPC I really want to give it a try.

Python as a scripting language sounds nice, I don't particularly enjoy working with JS and I think it'd be a nice addition for people like me who prefer something else. Not having to install an electron app is also huge for me.

For me, installation failed with "Package xkbcommon-x11 was not found in the pkg-config search path.". I needed to install libxkbcommon-x11-devel on fedora.

It definitely is super snappy and lightweight.

Is there an option to use a dedicated directory for a workspace to share it in git? That'd be huge for me, being able to commit the request yaml files to git is super nice