That's the first solution (a function based index), however it has the drawback of fragility: a seemingly innocent change to the query can lead to not matching the index's expression anymore). Which is why the article moves on to generated columns.
One of these bluetooth messaging app was made by a developer who was on a cruise ship with family, and the Internet over satellite costs an arm and leg. So he wrote an app to communicate with his families over bluetooth.
Also why would one want to have the data go over some servers thousands miles away when the device is right next to you? Seems like bluetooth is the perfect way to communicate for devices that are close to each other.
Yeah I can imagine a jam-packed cruise ship might be useful provided the signal propagates from deck to another (unlikely), but it's quite a niché use case.
>Also why would one want to have the data go over some servers thousands miles away when the device is right next to you?
Why would that matter? Use Signal to protect the content, or use Cwtch to protect content and metadata. If you need to exchange secret communications that mustn't go through some server, why not discuss f2f with no phones around? You'd also eliminate attack vectors where your (chances are, Chinese Android) device spies on you, as well as anyone who has compromised it to read messages from screen.
If your message goes though my infrastructure I can shut it down when I feel like it but even if I really don't want to do that I still might be forced by other parties commercial, private and state owned.
You shouldn't need any kind of permission to send a picture to your mum sitting next to you on the sofa.
I remember a different app thats was used on e.g. festivals where the local broadcast cells where overwhelmed when a quite rural area suddenly had to server 50000 to 100000 additional people and 3g and 4G basically stopped working. I think it was called Firechat or something.
> For me the cell phone without internet is almost useless
Projects like this one are a step towards fixing that. Personally I choose to keep both street and topographical maps of the entire continent locally on my phone. There are plenty of uses for a computer without a WAN connection.
I once wrote an article detailing as many prepper uses for an offline phone as I could think of. Dozens of offline apps useful for a survival situation. My favorite might be ATAK, which is from the US military and allows a team to communicate encrypted over Wi-Fi or radios, completely offline. Share GPS coords, camera feeds, messages, map markers, all kinds of goodness.
And if nothing else, you can always rupture the battery and start a fire :-)
The fact the even simple encryption with walkie-talkies is basically illegal might be problem (though I have no idea how/if that applies to at-sea ships).
On the cruise I'd need to seek the written permission of the vessel's master's to operate :) (and ideally cruise company permission to even bring the transmitter on board)
Unlicenced passengers could probably plead ignorance and sneak UHF DMR radios.
Or get a business allocation and use P25 radios and once again plead ignorance :)
I imagine in a situation like Iran, carrying a backpack full of WiFi gear to stay connected to the meshnet is a red flag.
Establishing a bunch of base stations is likely to raise red flags too.
It's pretty trivial for a nation-state that is jamming GPS to go around and jam WiFi or analyze WiFi spectrum for a meshnet operating in and around a protest area.
> Just get off your ass and go and give them the message...
If I need to have all 4 members of the family meet me at the pool, first I need to go find each one of them. They could all be at different place. And then tell them individually to meet me at the pool? Is that the better solution you are proposing?
Best thing about sites that works in TUI browser is that it can also work in Tor Browser "Safest" mode. In fact to those who are saying that these text based website are anti feature. I would argue that it is a safety feature to be able to browse and work in Tor Browser "Safest" mode. In fact ALL web page should strive to work in "Safest" mode, and only throw in bells and whistles when needed. As one can see just by turn on JS the site is NO longer really safe.
Let me ask you, is TOR even still safe or worth it?
I'm seriously asking cause I don't know. I heard that the US govt runs a lot of the exit nodes now. So maybe it's safe, as long as you don't live in the US?
"When you give money to an eligible organization, we’ll match your donations one-for-one, so your $1 has the impact of $2. And if you choose to donate your time, we’ll contribute $25 for every hour you volunteer. Whether you donate time or money, Apple will match your contributions up to $10,000 a year."
>If you have a mental image of Spanish conquistadors sparking global inflation purely by looting Inca gold, erase it. The real culprit was silver extracted from Potosi and a few other New world mines.
That is when labors start to flood to Netherlands.
>I am very impressed with how smooth and problem-free Asahi Linux is. It is incredibly responsive and feels even smoother than my Arch Linux desktop with a 16 core AMD Ryzen 7945HX and 64GB of RAM.
Hmmm still have issue with the battery in sleep mode on the m1. It drains a lot battery when it is in sleep mode compare to mac sleep mode.
If the asset has risen in value over the years, the donor could (a) sell it for dollars, pay capital gains taxes, and then donate the rest or (b) donate the asset and let the FSF do the selling. (b) avoids the tax which means more money for the FSF. It's a common approach with non-profits.
Are you saying 501 non-profits don't pay capital gains? (b) certainly avoids tax on the donor's part, but on the non-profit? I am assuming the non-profit would have to convert to fiat to do something useful with the donation.
> Are you saying 501 non-profits don't pay capital gains?
Correct, as long as those gains are used as part of the 501-aligned mission. Same with donations, they don't pay a corp income tax. This is part of being a tax exempt organization.
Is it also possible to create index (maybe partial index) on expressions?
reply