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:
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.
> 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
Bad argument, as the alternative is the DN (just as the tourist) simply not coming to the island. If a DN spends 2000€ a month, that is 2000€ taxable income for someone else. If the DN doesn't come someone else makes 2000€ less of income. This does not compare to people living in the place, as they are there no matter what. Every cent of foreign money flowing into your economy ON TOP is a bonus. It is only bad if it removes someone else who would spend that money, but that is not the case.
And if you would argue that the economy does not need more foreign money and you do not want productivity and wealth increase and have stay things as they are, you are advocating socalism - look at cuba, venezuela or argentina how that worked out.
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".
> Take a place like Barcelona, a famous example for people not being able to live there anymore due to high prices.
I always hear this bullshit "People can't afford to live there anymore". That is complete nonsense, because unless there are deserted buildings and empty apartments, people DO live there and people CAN afford it. Just not you.
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.
I understand you perfectly clear, but to me you are spreading socialist ideas. If prices are high for a given scarce resource, it is because of high demand. Now you want to basically cut off demand (less foreigners, DNs) for prices to go down. But you do need the high price signal in order to create an incentive to create more of that resources.
In the case of the EU (I'm a german EU citizen living in another EU state) we are all equal in terms of freedom of movement. There are no "locals" that have for some reasons more rights to any resources than anyone else. Giving "locals" preferential rights is completely unfair, as this would be excercising some kind of birth right.
I myself getting priced out of vintage german sportscars myself, could we please cut the rights for non-germans to buy up those cars so I can afford one again? You can see how ridicioulous that would sound.
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.
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."
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.
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.
I was traveling in the EU a year ago and was in need of a toothbrush. The one I picked up at an arbitrary pharmacy in Antony, FR has nothing special about it but has lasted (I mean the bristles are not wearing hard or splaying, getting soft, whatever the usual failure mode for a toothbrush is) in 12 months of use. And I'm usually pretty hard on my brushes.
Why can't we in the US just have nice cheap things. Why is everything an electronic life-hack with a fun take on how to be eco-concious, that involves buying something I don't already own?
For what it's worth, the toothbrush was also not the cheapest I could find (that would have been Lidl or somesuch), and was made in France, so maybe that makes a difference.
The usual problem with toothbrush bristles is they become microscopically worn down, so they don't scrape off plaque as effectively. Even if you can't see the problem, it might not be working as well as a fresh head will.
You can find electron microscope scans of fresh toothbrushes and worn ones in this[0] Applied Science YouTube video.
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.
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
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.
I'd be super interested in your writeup, I'd like to build a homemade Tonie for my kids as well. Any way you could contact me when you're finished or do you have a blog I could regularly check out?
> 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:
Does not look like an amazing saving either.