For testing, we at least have a Dockerfile to automate the setup of the pgduck_server and a minio instance so it Just Works™ with the extensions installed in your local Postgres cluster (after installing the extensions).
The configuration mainly involves just defining the default iceberg location for new tables, pointing it to the pgduck_server, and providing the appropriate auth/secrets for your bucket access.
gonna say: the pinephone has been hell over the last few weeks. Phone auto-boots whenever power is applied (either by their keyboard case or via USB-C), then the battery dies very quickly, and you need a minimum charge to boot the phone, so that means you have to swap an SD card in there with JumpDrive just to charge the darn thing. There are some mitigating factors (larger battery, Tow-Boot + loading OS from SD card, potentially some SMT soldering shenanigans), but I genuinely feel like this is a fire hazard. I -do not- recommend inflicting this on others.
someone suggested (I can't lost the link) flipping the script with a GLiNet Mudi hotspot with SMS forwarding (to e-mail); I really like this idea. It would be suuuper neat to play around with the tethered model: make SIP calls with a hacked Switch with Android installed / dedicated ruggedized VoIP phone for emergencies, or justify making and carrying a cyberdeck.
Personally, I'm hoping to revive my 3DS because I fell in love with the darn thing again (and its near infinite battery life). I heard you can make calls on the original DS with SvSIP, so suuurely that can work on the 3DS too. As a fellow gamer and android dev I'm sure you'd appreciate the idea.
I don't want a phone owned and controlled and spied on by governments and mega corporations. I want a Gibson-Neuromancer style obelisk disk blob thing that does Internet, Telephony, and Computer stuff and uses whatever I tether it to as the human interface.
Edit: and to be clear, I’m against this change by google. I think there is value in protecting grandma from sideloaded apps (if that even happens in the real world) but this isn’t about protection of consumers, it’s about centralised control of what you can and can’t do, in preparation for handing over the reigns to an authoritarian government. ‘Security’ either to protect you from scams, protecting YouTube from third party apps, or preventing nation state hacking or similar will inevitably be the driving narrative.
My primary for the time being remains GrapheneOS, which, ironically enough, only runs on Pixel hardware for now (though the GOS team is working with an unnamed major Android OEM to produce a handset that meets GOS's strict platform requirements).
My Linux phone is a PinePhone pro, which I believe is no longer being sold. It's not great. Phosh could generously be described as "in progress" last time I used it. UIs for many applications aren't built for small touchscreens like that.
I'd have to review the hardware market again if I were going to make a fresh recommendation. Librem looks cool conceptually, but they're a bit pricey, and their framing of a "Made in USA" variant as a premium feature rather than a red flag, a reputation risk, and a supply chain risk make me skeptical of whether Librem is a trustworthy entity at all, or might just be controlled opposition. That could just be me erring on the side of paranoia, though.
i've had a positive experience with OnePlus 6 and Mobian, but if you want something more modern with a business behind it, check out https://furilabs.com/
This looks kind of cool, but it lacks a headphone jack...
Which you think would be the first thing you'd put on there since Bluetooth pairing is extremely difficult to get right when you're using custom operating systems.
You know, this would be a fantastic time for Google to get their sandbox in order. If we need to do it like this, go ahead and create a secondary user, call it sandbox and let me install all my wild and unapproved apps there. SecureNet can automatically fail in Sandbox.
But I don't think they're going to do that, ultimately users who actually care about this are an absolute tiny percentage of the market.
And weirdos like us can always just import a Chinese phone that doesn't have mandatory Google verification crap.
> And weirdos like us can always just import a Chinese phone that doesn't have mandatory Google verification crap.
No, we can't. One of the first countries with that mandatory Google verification is Brazil, and we can't import phones which are not certified by ANATEL, they will be rejected by customs in transit.
I knew Brazil was kinda weird with tech import taxes but I didn't know they banned non-certified phones, jezz. Here in Chile they get disconnected from the cell towers after 30 days, but you just need register it^.
Do you know if the Brazilian gov or regulators asked for this first from Google or something?
^: It's less spooky than it sounds, any phone in Chile needs to be compatible with the natural disaster alert system.
With elections coming next year, and this being practically a "law" created in partnership with the banks cartel, this may be the time to make some noise about the change.
The point parent is making, if Google makes it so difficult sharing the software with other people, who is going to make those itch-the-scratch software going through so much trouble?
We would miss out a lot of creative people making software.
There is still a few points of course like being able to modify the base system. Just being able to say, kill the built in facebook is a quality of life improvement.
But it just feels like the benefits of a self owned phone os are going away even when you have it, because everything else changes around it and out from under it, so you don't get the functional benefit from it any more even when you have it.
You give up the use of things like tap to pay (would have been nice a couple times when I forgot my wallet) and drm content, hell, I can't use the stupid LG app that controls an air conditioner, and (increasingly) don't get something else important in return.
Today, there is still some benefit, because this latest change is only just now happening. I can use say, open source password manager and totp apps instead of google authenticator, and can use a pandora client that Pandora absolutely does not approve of, because the author doesn't need anyone's approval to produce the app and there is no choke point that Pandora can petition to block it. Hell why am I even talking about Pandora instead of Youtube and Newpipe? In what universe does Google EVER ratify the developer of Newpipe? (Wait, for that matter, what developer? what if there's an ever-changing fuzzy cloud of 20?) Or full-fat ublock origin...or countless other things whos sole purpose and value is to thwart some will of Googles? Or like the game emulator apps that Nintendo shuts down so aggressively, etc. Those ICE tracking or merely documenting apps. Countless...
Will those various authors still bother putting in the time and effort it takes to make these apps so good when only about 18 people will be able to use them?
I imported a Sony phone to the US because they don't sell it here, and no one else sells a current flagship with a headphone jack and removable sd card and high end cameras.
I successfully found and imported the phone, and got it working on a US carrier. Yay me. It's even rootable! Yay me. Yet I still can't run Lineage on it, because there is probably not a dozen other people like me to be an audience for Lineage on this hardware, and it's too much work to do for no audience.
The fact that today most phones are unrootable means that even if you somehow get around that, you still don't get the benefit because you're such a small audience that no one is producing say LineageOS for example for you.
My individual success bucking the system still did not result in me getting what I want.
I haven't tested it myself, but as far as I know you can run ADB in the phone itself via Termux. Perhaps it's possible to make a wrapper that install apps from F-Droid with ADB? It would mean that you would only need to be tethered to the your PC once.
Obviously they'll eventually remove this because Google is hostile to things like ReVanced / some spook wants this power.
* Search for "Smartphone-1 to Smartphone-2" "adb tcpip 5555" in "Motorola moto g play 2024 smartphone, Termux, termux-usb, usbredirect, QEMU running under Termux, and Alpine Linux: Disks with Globally Unique Identifier (GUID) Partition Table (GPT) partitioning": https://old.reddit.com/r/MotoG/comments/1j2g5gz/motorola_mot... (old.reddit.com/r/MotoG/comments/1j2g5gz/motorola_moto_g_play_2024_smartphone_termux/)
* Search for "termux-adb" in "Motorola moto g play 2024 Smartphone, Android 14 Operating System, Termux, And cryptsetup: Linux Unified Key Setup (LUKS) Encryption/Decryption And The ext4 Filesystem Without Using root Access, Without Using proot-distro, And Without Using QEMU": https://old.reddit.com/r/MotoG/comments/1jkl0f8/motorola_mot... (old.reddit.com/r/MotoG/comments/1jkl0f8/motorola_moto_g_play_2024_smartphone_android_14/)
AFAICT it only works on non-rooted devices when used over USB to access another device, because without root it has no access to the adb server on the phone running termux.
I'm definitely not 100% sure about that though, so someone please correct me if not.
Just tested⁰, it works with WiFi ADB but it has some limitations.
- The pairing process is kinda awkward, you need to split screen Termux and the Wireless debugging submenu, if you change windows the pairing IP and code are changed.
- The pair survives a reboot and WiFi change. You can disable the 7day revocation, so the pairing process is a one time thing.
- After a pair you still need to connect (adb connect localhost:port) and the port changes after a WiFi change or disconnect. I searched for solutions and apparently it's simple as running nmap twice¹
- It obviously doesn't work without a WiFi connection (unless is there some dark magic to connect your phone to its own hotspot).
So a wrapper seems viable if you are ok only installing apps on trusted networks.
[0]: I'm on GrapheneOS but I believe the dev menu is the same.
More googling, Shizuku² does this already in a polished way and exposes an API for other apps. Some related-ish apps are SAI³ (for installing split apks) and Canta⁴ (removing system apps).
EDIT: Even more googling, the whole setup already exists in
Obtainium (i.e. F-Droid but with Github Releases) apparently so apps show up as being installed via Play Store and subsequently be usable in Android Auto⁵.
So hypothetically you can install stuff day one on a stock phone after this atrocity is turned on.
wifi adb is a clever workaround, lol. I haven't seen that before, but it does kinda make sense. I've used SAI before (though it has been having lots more problems in the past year or three), but haven't seen Shizuku.
You can't write any automated tests without some kind of AI holding your hand? did you start writing software in 2021? did you just not test it before that?
Lots of well-tested software was produced without any kind of AI intervention. I hope that continues to be true.
>The Software, including its source code, documentation, functionality,
services, and outputs, may only be accessed, read, used, modified,
consumed, or distributed by natural human persons exercising meaningful
creative judgment and control, without the involvement of artificial
intelligence systems, machine learning models, or autonomous agents at
any point in the chain of use.
A UI automation script, is arguably an autonomous agent.
Easier to avoid this license than get into some philosophical argument.
You could probably tell them to eat dirt,the receiver of services can't be collected against as he's no longer physically here.
Getting the money from his estate would probably take years, if possible at all. I am not a lawyer, so I might be completely wrong, but suing a widow for 200k would be a nightmare for any hospital.
Anyway, maybe one day we'll join the civilized world and not bankrupt families for the crime of being suck.
The coolest way to display these is to have them sublimation-printed onto fabric (not silkscreened; silkscreening applies the ink heavily enough to reflect sound, while sublimation printing leaves the fabric still soft and porous), then wrap them onto frames containing sound-absorbing material. Hang them around the place and they improve your acoustics and aesthetics simultaneously.
LED walls are cool (and cheap via China) otherwise, and you can start small and then expand if you want since it's relatively modular, just a bunch of square LED panels linked together. You would need a driver though which you may or may not be able to hide behind/somewhere else, makes it kind of bulky compared to just a vertical TV :)
If it's anything like super base, your question the existence of God when trying to get it to work properly.
You pay them to make it work right.
reply