I've run into a snag with an sqlite database I've been working on. Below is a simplified example of the problem.
Suppose I have the following table:
CREATE TABLE "prices" (
"id" INTEGER NOT NULL UNIQUE,
"name" TEXT NOT NULL UNIQUE,
"list_price" NUMERIC NOT NULL,
"sale_price" NUMERIC,
"tax_rate" NUMERIC NOT NULL,
PRIMARY KEY("id" AUTOINCREMENT)
);
Is there a way to do something like the following?
SELECT
name,
CASE
WHEN sale_price IS NULL
THEN list_price
ELSE sale_price
END AS price,
price * tax_rate AS tax
FROM prices;
The
tax
column doesn't seem to acknowledge the price
column's existence, presumably because it's a column in the query rather than the source table. I could re-implement the CASE
logic for the tax
field, but that feels inelegant and error-prone.Is there a better way to do this?
Isaac Ji Kuo likes this.
Email: "Hey, we noticed you were in our store looking at stuff and didn't check out"
Hey, I noticed you do a lot of creepy tracking shit you shouldn't be doing and seem to think that following window shoppers home and yelling WHY DIDN'T YOU BUY at their house is somehow a good business model
Jonathan Lamothe likes this.
reshared this
Jonathan Lamothe, Justin To #НетВойне and Liz💃 reshared this.
Jonathan Lamothe likes this.
reshared this
Shannon Prickett, Jonathan Lamothe and josh :floppies: reshared this.
While on the subject of Buzz Aldrin… people have called out his seemingly odd habit of wearing three watches, but those mere mortals fail to realize that he understood the later classified problem of time sanity.
Basically, he wanted an odd number of sources to be able to determine a consensus of what time it really was… a valid concern when one has actually, factually stepped on the surface of another heavenly body, or configured NTP.
like this
Cy and Jonathan Lamothe like this.
reshared this
screwlisp, I am Jack's Lost 404, CatSalad🐈🥗 (D.Burch) :blobcatrainbow:, Jonathan Lamothe and Shannon Prickett reshared this.
Us watch nuts have a saying:
"A person wearing one watch knows the time, a person wearing two watches is never quite sure."
... I was supposed to be a lot of things. 😬
like this
Cy and Jonathan Lamothe like this.
reshared this
Jonathan Lamothe, Cory Doctorow and Mother Bones reshared this.
I'm broken, sorry.
Wait. I missed this.
What is this?
Some kind of off-brand Underoos?
presearch.com/images?q=+undero…
Edit. i get it. some kind of spencer gifts type thing...
“you’re a smart kid, but…” from teachers.
I even responded once with “how would you know if I never do the work?”, which I don’t think was appreciated. 😬
A text I just sent to my mother (presented with no context):
It's sometimes tricky that my wife and mother have very similar looking names and are alphabetically right next to eachother in my contacts. It's astonishing that that hasn't led to more embarrassing mistakes.
like this
Justin To #НетВойне and fedops 💙💛 like this.
Okay, I'm calling uncle.
I've exported the data from the LibreOffice Base database I've been working on to an SQLite file, and I'm just going to write a proper UI for it.
like this
Steven Rosenberg and unixjunk1e 🌵 like this.
reshared this
Steven Rosenberg reshared this.
I'm planning a video a few weeks from now talking about "I switched to Linux and enjoy it."
If you've switched to Linux *in the last year*, do you have any uplifting stories you'd like featured to help my viewers?
Message me here, or via email at explainer(at)vkc(dot)sh.
reshared this
Jonathan Lamothe and Light🐧⁂ reshared this.
Jonathan Lamothe reshared this.
@fancysandwiches Wow, that joke failed on a cosmic scale.
It was a bad joke that didn't land. I'm sorry. I'd delete it, but there are a bunch of replies up now.
While I’m not the target audience (though I watch anyways) I highly appreciate your approach. It’s very difficult to cater to “advanced” users (first Linux install in 1996) as we tend to be all over the map, and even if I surely knows more than your average computer user, it’s not easy to help those just starting out.
A library of beginner friendly videos is a treasure trove.
I was Ubuntu guy for a couple of years, I switched from Windows when Valve started releasing games for Linux.
But I got more into music production than gaming, and when I realized how well Mac was suited for it, I've been a Macbook guy for a decade until a few months ago.
I've dealt with Apple's software and security restrictions, but when my MBP became unreliable because of a botched keyboard replacement from an Apple Service shop, I was over them.
That counts as switching, right?
I mean yes, the only downside so far is only one streaming service (peacock) doesn’t work on Linux (I use iOS for that one for now), but I’d been buying OS-agnostic printers so I’m covered.
I switched last month.
The phones is where I’m in a rut I don’t want privacy nightmare fuel of openAI on next iOS.
I went from Windows to Qubes about 8-10 months ago. I don't know if I have any uplifting stories to tell about it though, hahaha.
But I have enjoyed (most of the time) getting everything really settled-in the way I like it as much as possible.
I consider myself very much in the proverbial "Power User" tier of computer competence rather than a more knowledgeable admin/programmer tier.
I've set a few people up - usually on Linux Mint. The most important stories are from the standard users who shrug, open a web browser, and just use the OS, and barely remember they're using Linux.
They're also the hardest stories to find. Good luck!
Hmm no stories, but I’m definitely interested in your video. Or if your video generates a community of Windows expats - I would like to volunteer moderating as a Linux expert for when more people show up looking for a way out…
I switched my grandparents to Linux Mint and they love that it just works and isn't so distracting and unnecessarily noisy.
The trigger for them switching was a driver Problem with their scanner. So when they switched to Linux and the Device worked without having to do anything (got to love inbuilt drivers, looking at you NVDIA), they were quite impressed.
If my grandparents can use Linux, anyone can, at least if you don't have special requirements, like MS office or something like that.
Transition from Windows to Linux for Ham Radio
In this video I cover my experience with Linux for Ham Radio (and daily driver) after one year of switching from Windows 10.► Pop! OS : https://pop.system76....YouTube
aw shucks - just outside of the window. Well, like 5 months outside the window.
I do wonder how many people "just switch," though. I only count from when I started using Linux as my full time main desktop OS, but I've used Linux on VMs to run sandbox web dev environments for like 8 years nearest I can guess. There was just a point in 2022 I decided to make it full time. I kind of assumed a lot of people dip their toes like that.
I finally got tired of microsoft when they announced Recall and overwrote my windows 10 partition with Debian about two weeks ago.
There's not much I can say though. The best thing is that I do not need to install software that forces the OS to comply and stop asking me to activate stuff that I don't need or want. Other than that, it works and games work.
No good free CAD software though.
Mostly using my pc for gaming.
Haven't booted the Windows drive in months.
couple of weeks ago, no complaints, reasonably easy.
Have a device to look up install stuff if it doesn't go smooth (I had a grub hub boot issue but the Mint page listed what I had to do).
When Google announced that Chrome was going all-spyware, all the time, I started looking into alternatives so as to retire my Chromebook. Saw a bunch of good reviews for Zorin, saw that the lite version was free, downloaded it, loaded it on an old ThinkPad laying around, loved it. Completely painless install, no learning curve.
Am now gradually migrating my media center/DAW stuff off of my Mac Mini as well.
I was thinking to myself that it had been too long, but I actually only switched last october! I have dabbled for many years, but just switched my desktop.
The thing that really made it possible now was great game support. I can play nearly all modern games with no issues, often on day one. I play my MMO, I use discord for chat and it is seemless. I am not a power user these days and I am amazed that I almost never use a command line. That was definitely still the image of linux I had.
I help my aunt switch to Zorin OS from Windows this year and she's been very happy with it. She's 72 (I think?) and intimidated by computers. She still gets up to date, secure apps but she likes that the updates rarely move things around. She also gets intimidated by prompts about new features and those aren't a problem now either.
Is her experience what you're looking for?
I'm in the process of switching my main computer (installed Linux Mint on Friday). I've used Windows since 95 and before that I used MS-DOS.
I'm not a complete n00b in that I've used Linux from time to time before. But this time it seems different, it's looking very likely that I'll switch over permanently.
I switched my personal laptop to Ubuntu full time. I still use Windows for career purposes.
I appreciate the very broad ecosystem of desktops and flavors available in the Linux world. There is something for everyone.
I really appreciate how much even bleeding edge Linux distros breathe new life into old hardware. I never have to by a brand new shiny ever again.
I also appreciate that I have full control over my machine and no corporate overlord gets to tell me what I can or can’t do.
Also, I still use both Windows and Linux (Fedora on my PCs, and a mixture of RHEL, Rocky and Debian on servers), nowadays, so I'm not a full convert yet 😅
Sensitive content
Within the last 2-3 months I've moved from ChromeOS to Linux (Manjaro). I did this for privacy reasons. Now I've been watching MS Recall make the case for migrating to Linux.
Full disclosure: I used to use SVR2 Unix, and Red Hat (am RHCE from back in 2004). Since then I changed my career to teaching, and used ChromeOS a lot, which was lovely, except for the total lack of privacy.
I am currently doing the switch, started two weeks ago! I had tried dualbooting years ago, but now I'm serious.
I've tried some options a bit, including Kubuntu, Pop_OS! and Ubuntu MATE.
I was impressed with how easy it was to connect a graphic Wacom tablet! I did not like random crashes in system settings, especially with translations.
I have liked Cinnamon DE the most, and will be installing Mint next. I like how it just works, but I can still easily customize it to fit my needs.
I switched about 6 months ago due to the ever-increasing enshittification of Windows: lots of little things were starting to annoy me like audio problems but also pushing CoPilot so hard was the final straw.
While I struggled with DraugerOS and ended up binning it, I tried Pop!_OS next and it was beyond my wildest dreams how easy it was to run the live distro and then subsequently install it. I think the most difficult part was setting up dual boot with Windows.
1/2
Katy and I like to watch psychological thrillers from time to time, but I've noticed a recurring trope that confuses me. It goes like this: Psychopath lives in an outwardly normal looking house, but has a secret passage to a secret murder basement.
Who built this? Am I to believe he excavated the earth, poured the concrete, ran the (usually admittedly shoddy) electrical himself? Did no contractor at any point ever think to themselves: "this doesn't seem right. Perhaps I should alert the authorities?"
Edit: typo
Edit: I'm an idiot who confused diameter with circumference for some reason. Embarrassing original post follows.
Was playing around a bit with the OpenWeatherMap API. I wanted to know how precise I needed to be with the latitude & longitude values, so I decided to do some quick calculations.
To get a rough idea, I wanted to determine how much a change of one degree of latitude would move in kilometers. I knew the diameter of the earth was something fairly close to 40,000 km but wanted to verify that factoid. I did a quick duckduckgo search, and the top three results (on seemingly separate web sites) all said 12,756 km. In fact one of them hilariously said 12.756 km.
I assume this is the result of LLMs filling the internet with crap, but it's alarming that if I didn't know any better, I'd have just blindly accepted this as fact.
Jeremy List likes this.
@PerryM ✅ Yeah, but the real problem here was my stupidity. 😛
I don't think post editing works on Diaspora, so you probably can't see the correction, but I confused diameter and circumference.
Edit: why did I think you were on Diaspora? I'm clearly on a roll today.
Also:
Please note that built-in geocoder has been deprecated. Although it is still available for use, bug fixing and updates are no longer available for this functionality.
Source: openweathermap.org/current
12.756 km may be a locale difference; if the site wasn't US or UK-based the decimal might be the thousands separator.
the diameter of the earth was something fairly close to 40,000 km
s/diameter/circumference/
?
Fine, I'll watch #wwdc24 to see what everyone's been talking about.
Before a few hours ago, I didn't even realize it was happening.
Sean Riley likes this.
Today I booked an appointment with my optometrist to get my eyes checked. A few hours later I checked the (postal) mail to find a reminder card from them.
I was shocked at how quick the mail was, only to realize it was just a generic reminder that I was due for an eye exam. It was pure coincidence.
Celeste Ryder 🐾 🐀🏳️🌈 likes this.
Okay, I'm just going to say it because amazingly enough, some people don't seem to get this.
Just because I'm critical of Israel bombing hospitals in Palestine doesn't mean I'm pro-Hamas. I'm not.
It frustrates me that this is a thing that even needs to be said.
Edit: typo
like this
Feisty, Justin To #НетВойне, Lord Matt ✔️✔️✔️✔️✔️, Khurram Wadee, Aladár Mézga, N. E. Felibata 👽, Tess, spaceharper and Cyber Yuki like this.
Sensitive content
Jonathan Lamothe likes this.
Judy Anderson reshared this.
Sensitive content
Cyber Yuki likes this.
just 2c.
@ilyess
ok, personal experience is a bit different....
using debian unstable for ~15y, 4-5 serious issues.. still remember which ones..
4-5y ago, used arch for a month, and things were breaking every (other?) day...
Jonathan Lamothe likes this.
Jonathan Lamothe reshared this.
Conversely, a guilt-free snack that you can add lots of tasty spices to and guilty levels of butter and/or oil.
(I love using the microwave popcorn bowl thing I have, and covering it with the "popcorn oil" I bought and my homemade salt/garlic/chili pepper grinder mix.)
The CPU is far from being the most sophisticated component of a computer.
At least if we're talking about #permacomputing, or, rather, scavenging and collapse computing. Okay, maybe in open source hardware, too.
Designs of new hobbyist computer architectures are seemingly revolving around inventing a CPU and/or mapping the peripherals on the system bus.
And you could find many simple CPUs based on FPGAs, logic chips, transistors, valves and even relays.
What you usually don't find is custom RAM. Before Intel introduced cheap solid-state RAM in 1969, there were at least six contemporary competing types of RAM used in computers, and at least as many were already considered obsolete.
What you don't find is peripherals. There are rare cool appliances, like punch tape readers. But have you seen a custom hard drive? A printer?
All these are "easy" in terms of relative complexity for industry. But they are simultaneously very hard for a hobbyist/DIYer/tech collapsnik.
Change my mind, show me the good stuff~
Jonathan Lamothe likes this.
reshared this
Jonathan Lamothe and Jeremy List reshared this.
@aeva I see! Well, you probably shouldn't do it INSIDE of your flat. It was a common* game for pre-00s children in Russia to cast lead on a campfire, and Zinc has a comparable melting point. If you're wondering where children would get lead, the answer was discarded car batteries and such. If you're wondering if that was safe, no, not at all.
Common = I have heard of this from at least three different regions, including a major city
@aeva a counter point: if you ever tried printing with moveable type, especially without a linotype machine, you would very quickly realise that even the simplest of computers could speed things up a lot.
Even some mechanical linotype machines accept punched tape as an input for the type - word processing like it's 1880
@aeva ah, yes 😀 It's funny to think how people consider "homestead" a solution to this.
FWIW, I think a real collapse-like situation wouldn't mean immediate famine or dying out from cholera, anyways. I've read about the collapse of Bronze age, as well as the downfall of Romans. In those cases, humans didn't rapidly lose access to shelter and sanitation, and they had some food to go around. Even the excess mortality wasn't insane - certainly not the levels in some European countries during the WW2. All of those were very sucky times, that's for sure.
Jonathan Lamothe likes this.
Jonathan Lamothe likes this.
reshared this
Jeremy List reshared this.
But I'm talking about something completely different here! On IBM PC and PC Jr, one of 8255s was used for a cassette interface - a 5-pin DIN that can be connected to a domestic casette player
@Nina Kalinina Just googled (duckduckwent?) what a Colorado drive was, and all the results were about road trips.
I'm not familiar with this term. Could you possibly enlighten me?
like this
Nina Kalinina and PunBoleh like this.
Not a PC, but a Texas Instruments 99/4 I had in the early ‘80’s stored data through a cassette tape port
@nina_kali_nina
In my view, most electronics won't last. The aesthetic is fun, but if we're being realistic, I feel we need to go back to treating computing as a human activity, rather than one influenced by machines.
It's easy, if not desirable, to build things that look like foundations in isolation. But when you strip out something as basic as electrical or mechanical power, design gets.. complicated.
Programming languages, computing stacks, should be able to be run on humans.
@wryl
A few years ago I made a "card game" that could be used to convert an 8 year old child into a touring complete computer running the brainfuck programming language.
The small stacks are memory cells, the big cards are the program. The figure is the pointer. The player just has to follow the instruments on the cards.
@hackbroetchen that reminds me of Cardiac computer, but simpler! Do you have a link for the "print and play" version?
Hm, your post gave me a really cool idea, thanks!
Also it was a bit unfinished. It lacks a loop depth register.
Maybe I should finish that project.
@hackbroetchen gotcha! Thank you for sharing anyway.
As for cutting out, there are simple paper cutter knives that are perfect for this task. I've had a great success with cutting a few hundred small cards with a machine like on the picture, with low effort.
@hackbroetchen @wryl
This reminds me of the game of Alligator Eggs, which seemingly allows an 8-year-old to learn about lambda calculus: worrydream.com/AlligatorEggs/
We might be able to find similar ideas among other esoteric languages.
I think the realization you're approaching here is that collapse computing, as currently practiced, is largely cyberpunk LARPing.
You will have a lot of trouble manufacturing any sort of nontrivial IC, including but not limited to a CPU, in the apocalypse. If your design includes any such component and it's not readily salvageable from the devices normal people are surrounded by, you've already failed.
An FPGA is decidedly nontrivial and also needs an existing, working, relatively modern computer to program it, so that's worse.
Writing an OS for simple Z80 computers sounds like a fun project, but branding it "CollapseOS" is a bit silly because... where are you expecting to find the components to build a simple Z80 computer? If you're salvaging from Game Boys and TI calculators, why not just write an OS for those? The average person in that scenario will have a lot less trouble actually installing and using the thing in practice.
You know what's easy to find in the apocalypse? Existing working computers. Refurbishing them and building methods of powering them is *significantly* more doable without factories. But building an entirely new computer sounds a lot cooler to most people.
@emily yep, I think I agree with you, generally. There is still value in CollapseOS and such - it's an attempt at simplification the stack and bootstrapping, and we need more of those.
I am thinking about this topic in the context of how personal computing stopped being accessible thing; we have lots of computers around, but we often cannot reprogram these, and it's unlikely we could repair or expand them, either. I am also remembering the beginning of 2022 and the effects of sanctions on Russia - the electronics shops quickly ran out of everything, and the marketplaces only had used Pentium 3 and 4, as well as Chinese 8 and 16 bit console clones. These times didn't last, because globalisation and parallel imports, but it was a reminder to me that supply chain hiccups or even total collapse are a possibility.
Certainly, there are different levels and genres of collapse. All of them share the common theme of "we have some existing working devices and everything else must be built from scratch or from parts salvaged from those devices".
For existing devices, Linux is probably a more effective collapse computing project by accident than any dedicated software project will ever be on purpose, because of the sheer amount of stuff it can already run on and the number of copies of it floating around.
For building new devices, ICs are probably the wrong level to build up from. You can assume no new ones can be acquired in most realistic scenarios (either they aren't being produced at all, or supply chain issues mean you can't get them). If you have devices to salvage usable ICs from, they probably still mostly work, and pulling them apart is much higher risk than just using them as is.
On that note, I was under the impression CollapseOS targeted only homebrew machines, but I see now they also have ports for an assortment of real retrocomputers. That's great! The TI-84+ is the only one I'd realistically expect to be able to find outside a retrocomputing enthusiast's home, but it's a hell of a lot more than I expected, and so I partly retract my mocking of them.
But more than that, I want to see more "I made transistors in my garage" projects. *That* is the primary thing we'd need to actually bootstrap modern technology. Software is near trivial in comparison.
One is to leave them on the board they're from. It works best on boards with lots of testpads, and gives you a tiny breakout board for the chip.
Another is to glue the chip upside down to something, and solder the wires to each pin directly - with enough flux, the surface tension force makes it relatively easy to avoid shorts. It is a bit tedious for chips with over 20 pins, but it's doable as long as you have reasonably thin wires (like wires from transformers)
@emily These thoughts reminds me of my writing exploring "what's the least software & hardware required to build an inclusive web browser?"
I think it helped me better wrap my mind around around existing operating systems, & really emphasizes how vital memory is!
For exhaustive detail: adrian.geek.nz/from-scratch/#b…
(I'm currently preparing a page about dev tools for programming it)
In short: The primary (until visual output's required) component would be a hardware pushdown automaton. Which traverses a labelled graph to parse its input data.
Then I added an "Output Unit" to concatenate & demux the output into a new order, a rudimentary processor for occasional/trivial math, & a couple other things.
Anything specific you're curious about?
Also, in a collapse scenario, you're going to be way too busy with basic survival to bother with hobbies. Nor will there be any electricity available.
I've built a printer from scratch, but it's an electromechanical contraption not directly related to computery things and not exactly a convenient form-factor.
(though watch this space, I still have loads of ink and I've been Having Bad Ideas for future projects after watching too many teleprinter videos... 😳)
oldbytes.space/@zxguesser/1125…
ZXGuesser (@zxguesser@oldbytes.space)
Attached: 1 video I'd like to say it worked first time, but then I'd have no explanation for staying up until 4AM soldering...OldBytes Space - Mastodon
There’s hobbyist core memory.
The kind of person who makes a custom CPU design out of discrete transistors or valves or relays also often makes a small amount of RAM with flip-flops or individual transistors. It’s definitely hard to scale up.
Open mechanical stuff is indeed really rare, with the notable exceptions of rapid prototypers and that electron microscope from a while ago.
Turns out there have been more electron microscope designs released than i had thought. U Muenster’s SXM, the ChemHacker effort in ~2010, the recent NanoMi.
An open printer or plotter would be nice. And certainly seems like those would be easier to make than open electron microscopes or CNC machines.
I would expect most types of CNC machine to be more difficult than most types of printer, simply because print heads don’t fight back against the positioning system when they act on the feedstock. The only mechanical resistance they deal with under normal circumstances is on an axis the print head doesn’t move along. Pigment delivery and fixing definitely isn’t easy, but I doubt it’s as difficult as repeatable, extremely strong positioning of tools.
I wonder what would be the best pigment delivery system for such a printer. I’m partial to waxjets (e.g, Xerox Phaser) largely because of the low material waste, but some inkjets come close (particularly if the printer has refillable tanks and you get the ink in glass bottles).
Maybe for wood or plastics. It’s really hard to build a two-axis router to carve channels into metal, though. Swiss lathes and 3+ axis mills are difficult, too.
I’m not familiar with any DIY paper process which yields a uniform enough thickness and composition for most printer technologies. Definitely not good enough for traditional laser. Composition would be a problem for any jet-based. Struck prints like dot matrix or daisy wheel would probably be it.
@bob_zim DIY paper that works with laser is definitely doable. But making it thermo sensitive or cover it with thin metal film is hard 🙁
Soft metal CNCs are okay to make:)
like this
Nina Kalinina and Nelson Chu Pavlosky like this.
Nina Kalinina likes this.
I wonder if anyone's tried replicating the memory used by two of the computers in the Voyager spacecraft. They each have three computers, two with some kind of wire memory and one with a more modern kind.
All the problems the Voyagers have had is with the more modern memory. The wire memory is still working perfectly afaik.
There are a bunch of gpgpu projects, but that's not fun. And then there's FuryGPU but it's Vaporware until it's actually released: furygpu.com/about
Yeah! There's all these projects to make open-hardware laptops but without a GPU that supports standard APIs there's gonna be a hole in the open stack.
A thought I keep having is a good place to start might be to accelerate *just* what is useful for 2D compositing, and pass the rest to Mesa. Then you could get improved desktop performance, and most daily tasks don't involve 3D rendering anyway.
@mcc Vortex¹ ² apparently supports Vulkan 1.0 via a modified SwiftShader—is that at all interesting? (I wonder if it’d be possible to also get OpenGL ES support by layering ANGLE.)
__
¹ github.com/vortexgpgpu
² B. Tine, V. Saxena, S. Srivatsan, J.R. Simpson, F. Alzammar, L. Cooper, and H. Kim, “Skybox: Open-Source Graphic Rendering on Programmable RISC-V GPUs,” in proc. ASPLOS 2023, ACM, Mar. 2023. Online: dl.acm.org/doi/10.1145/3582016…
@hovav I mean, it's a start! I think it's not what nina's looking for but I'd be curious at least to test it.
I'd heard there were projects like this but I didn't know they'd already reached a Vulkan compliance level.
@hovav I wonder how I'd go about porting this to this FPGA I've got if I wanted to run a test and see what it looks like. There's test instructions here github.com/vortexgpgpu/vortex/…
But it's pretty much "run our build scripts!" and don't explain what they do or what they target. Like would I need to integrate this with a litex setup, or…?
vortex/README.md at master · vortexgpgpu/vortex
Contribute to vortexgpgpu/vortex development by creating an account on GitHub.GitHub
vortex/hw/syn at master · vortexgpgpu/vortex
Contribute to vortexgpgpu/vortex development by creating an account on GitHub.GitHub
I don't know ... strictly in terms of STEM learning tools for bright kids, I'll take AdaFruit, Arduino, etc.any day over the GENIAC I had when I was a bright kid!
The long-term problem wouldn't be finding hardware to read an old SSD -- but how to make such devices at all. If we look at a modern factory, how many of those tools could be remade 100 years after a collapse? Have we documented them? Or are they all trade secrets?
I think learning to desolder and solder SMD components could be the top skill for a scavenger technologist. The vast majority of discarded tech is going to be SMD....
That's why I'm working on DIY co-processing using 8 bit CPUs from a begone era 😁😬
@Nina Kalinina I didn't know the term "ball grind array" but had encountered it in the past and based on context was pretty sure I knew what you were talking about.
Looked it up to be sure. Felt like one of my riskier searches.
Nina Kalinina likes this.
Decided to learn and use #LibreOffice Base for a thing because I thought it would be an easier way to slap a quick and dirty UI on a database than rolling an app from scratch (which I already knew how to do).
I was wrong, but at this point I'm going full sunk cost fallacy.
like this
Adam Hunt, Isaac Kuo and N. E. Felibata 👽 like this.
It's also interesting that (as far as I can tell) the easiest way to export the DB schema from an ODB file (using the embedded HSQLDB feature) is by first dumping it into a MySQL database, and then exporting from there.
I mean... really?
N. E. Felibata 👽 likes this.
periodic reminder: you cannot "pass" a security audit. anybody selling you a passable security audit is selling you a lie, and anybody selling you a product that has "passed' an audit is lying to you.
a security audit can uncover bugs, or not uncover bugs, and can (in the words of the recipient) demonstrate positive or negative qualities about the codebase. but it cannot be "passed" or otherwise *endorse* the product or program itself.
Jonathan Lamothe likes this.
reshared this
Jonathan Lamothe reshared this.
You all did it. You (kind of) killed Microsoft Recall.
After weeks of withering privacy and security criticism of the AI-enabled silent recording feature in Windows, Microsoft now says it will be disabled by default when it rolls out later in June.
Jonathan Lamothe likes this.
reshared this
Jonathan Lamothe, Eniko | Kitsune Tails out now!, Steve and Mx. Luna Corbden reshared this.
We've updated this story with points about remaining Recall risks, even if it's opt-in and properly authenticated, e.g. domestic abusers that demand partners' login details and subpoenas/legal discovery.
Microsoft has heavily marketed the feature. Some people will turn it on.
Jonathan Lamothe likes this.
like this
𝕕𝕚𝕒𝕟𝕖𝕒 🏳️⚧️🦋, Jeremy List, DrFriendless 🇵🇸, Isaac Kuo, Kristian and Simon John like this.
Content from 𝕕𝕚𝕒𝕟𝕖𝕒 🏳️⚧️🦋 is collapsed
N. E. Felibata 👽 likes this.
Jonathan Lamothe likes this.
@MJ :blobfoxcomputer: Someone else pointed out that the fastest way to get a company to stop using Windows would be for someone to file a wrongful dismissal suit and to subpoena their Windows Recall records in the suit.
It cuts both ways.
like this
pizzapal and DrFriendless 🇵🇸 like this.
DrFriendless 🇵🇸 likes this.
Theoretically, if you're forgetful, ADHD, or multitask like crazy, you can use Recall as a memory supplement. Whatever you were working on, your computer remembers so that you can view it later. Additionally, it runs everything you do through an AI so that the search capabilities work "really well" (we hope!). (edit: originally I thought Recall also suggested what you wanted to do next, I was wrong, nevermind on that) That's supposedly going to help you work more efficiently.
Of course this comes with huge security and legal risks, plus privacy concerns since Microsoft's software is now watching everything you do on your computer.
If they had forgone the AI bit, released it as an open-source project, made it an opt-in application that you have to intentionally install, and implemented some actually good security, Recall might have actually been quite handy. The concept has merit, it's just the implementation is horribly flawed and a massive liability. They might still be able to redeem it somewhat if they open-source it and make the security better (i.e., *actually* encrypt the database and require the user to provide their password to decrypt it before viewing it), but I don't find that too likely to happen.
like this
Mark Connolly 🍻 🚴🏼♀️ (he, him, his), R. L. Dane :debian: :openbsd:, PerryM ✅ and Spacegoat like this.
Jeff MacKinnon likes this.
Jonathan Lamothe likes this.
Jonathan Lamothe reshared this.
@Lorena 🍏 ...assuming they have the money to but a whole new computer?
There really isn't a one-size-fits-all solution.
@Lorena 🍏 Macs do not work for me and I can generally switch an existing Windows machine over to some Linux distro for $0.
Plus, you say that like everyone's got an extra $600 laying around.
Jure Repinc :linux: :kde: likes this.
Oi!
We need to shut down an alt-right anti-trans conference happening in a few weeks here. If you live in Canada, not just Victoria, this is a tourist town and they are a Canada-wide hate group. The more people show that they’re watching and acting, the more likely councilors or the conference centre will take action. Please sign, or at least bump (the latter goes for folks outside the country as well, please).
Happy Pride, please help us keep the fascists down.
#Canada #LGBTQIA2S #2SLGBTQIA #Queer #Pride #MSTDNCA
nmshr.io/s/email/ZBA_BTbEH_TvS…
Cancel The We Unify 2024 Conference Letter Campaign
Letter campaign to oppose the "We Unify: Reclaiming Canada 2024 Conference" at the Victoria Conference Centre from June 21st to 23rd. Guest speakers include known transphobic and anti-2SLGBTQ+ activists.nmshr.io
Jonathan Lamothe likes this.
reshared this
Jonathan Lamothe and Feisty reshared this.
Jonathan Lamothe likes this.
Jonathan Lamothe reshared this.
Jonathan Lamothe likes this.
reshared this
Jonathan Lamothe reshared this.
Jonathan Lamothe likes this.
reshared this
Jonathan Lamothe and Maddie, Wizard of Installs 🪄 reshared this.
Jonathan Lamothe likes this.
Jonathan Lamothe reshared this.
Well the procreation process isn't neatly divided into decades and frankly blaming some other decade for things you're experiencing that people before and behind you did and will, is a bit pointless.
By the way other people also feel overstretched, whatever age.
I think the "gen" labels come right off some marketing drawing board, initially to sell shoes or something.
Now all the better to divide us by.
Why are you so defensive?
Where is the reaching out to another person?
I assume I'm older than you and if you're having a tough time, I've probably been there (or near enough), it's a thing with age that the years you live actually existed and that's the same for you as it is for me. I just have more of them.
Statistically that means I have more years of being exploited, cheated, robbed, lost dreams etc. on the downside, plus the bits I got together on the upside. What's to envy
@TheDailyBurble Because you’re coming into my mentions putting words into my mouth?
I turn 50 soon, so regardless of how old you are, I, too, have many years of being exploited, cheated, robbed, on top of that, abused to the point of being disabled. Also a single parent for the entire life of my son.
My starting assumption, regardless of our relative ages, is that you and I are equals, with different experiences, & that I could teach you as well as you teaching me. So maybe that’s the vibe I’m picking up? That you are coming here with something to teach me in my “ignorance” as my superior, when I haven’t asked to be taught?
What I wanted from my twoot, and what I got from others, was people relating to having grown up through a particular time, with a shared identity & cultural experiences, who are now taking care of parents.
There are social norms for how to politely insert yourself into this conversation without derailing, lecturing, or talking down. Maybe try again?
Up to you really it's your own outline you need to find. I personally find your ageism offensive also, and am glad that you value your experience more than some arbitrary generation.
As to social norms, I presume you put your views into a public space for comment and engagement in good faith as did I reply.
@me
I'm sure this refers to poor gen x and ageing parents.
"GenX/Xennials dealing with aging parents and grandparents is a whole vibe"
or maybe you're not gen x, I don't 'gen' people and wouldn't know. Perhaps you could clarify the whole point of singling out "ageing parents" as some kind of giant issue.
@Cabbidges To be honest, this whole thread has gone down such a non-sequitur rabbit hole that I'm really not sure how to respond.
I believe the questions you're asking have already been answered.
@me
Not really. Non sequitur just means avoiding via obfuscation. I don't accept that all who are older are automatically an obstacle via age to your aims for a better world, which seems to me rather a mild challenge, given what people have already done before you (both)( I replied to one but now are two to reply to)
It might not be age, or generations you're raging against?
@Aphrodite I somehow managed to get both all in one? Like, that "love" me but maybe have a different idea of what love is than I do, or maybe without the capacity to love me the way I'd prefer.
Making strides with mom this week, though. She's trying very hard. So am I.
❤️
"I don't understand why other people don't think like me" says more about one's lack of curiosity or understanding than about the people mentioned. One doesn't have to agree with someone else to understand what underpins their diverging opinion. Worse, it may show one's assuming there's only One True Way of thinking about something which increases one's sensibility to propaganda.
No matter what you believe in, staying curious about why other people think differently allows you to understand exactly why you disagree beyond a knee-jerk reaction and makes you more able to change your own opinions if the reasons for them change.
like this
Jonathan Lamothe, anubis2814, BEAUBOBO BONOBO ⛳ ⚽🎶♒🐵🎗🏌️♂️, Janet Logan 🏳️⚧️, >sfb< SigmundFreud'sBartender and chavasaurus mex like this.
reshared this
Jonathan Lamothe and anubis2814 reshared this.
@vic This mindset is independent of specific opinions and invoking it to peddle your personal grievances is exactly what I've been trying to warn about in my post.
In particular, branding anything as "evil" directly falls in the "One True Way" pitfall by preemptively forbidding any understanding of any kind. Again, you don't have to agree to understand.
Quick heads up: annihilation.social is the latest home for racist edgelords
reshared this
Jonathan Lamothe and Caelyn McAulay reshared this.
Sourcery - BookWyrm
When last seen, the singularly inept wizard Rincewind had fallen off the edge of the world. Now, magically, he's turned up again, and this time he's brought the Luggage. But that's not all...bookwyrm.social
Jonathan Lamothe reshared this.
Jonathan Lamothe likes this.
reshared this
Jonathan Lamothe, Jeremy List, Christina and Celeste Ryder 🐾 🐀🏳️🌈 reshared this.
like this
Justin To #НетВойне and VINNIUM /|\ The Druid Chief ☀️ like this.
Jonathan Lamothe likes this.
reshared this
Jonathan Lamothe and Mx. Luna Corbden reshared this.
you are so wholesome. Every clique has its quirks and jerks, but as long as you're asking for knowledge, and in good faith, we will explain and explore with you.
None of us have all the answers, and we're often wrong. Being wrong isn't bad, nor is asking dumb. Let's learn together.
Jonathan Lamothe likes this.
Jonathan Lamothe reshared this.
I remember before the pandemic there was a plan to shut it down regularly on weekends, I don’t suppose they’ve picked that up again.
And I’m probably biased because I lived at the park but I also want the same treatment for jubilee dr.
So, the one advantage to being out of ADHD meds is that I can have a drink without worrying about drug interactions.
I'll take my victories where I can.
Okay, sqlitebrowser (from the #Debian repositories) is actually a pretty decent tool. It provides a nice point-and-click interface that makes working with #sqlite3 databases a little bit nicer. Knowledge of how to write an #SQL query is still a requirement, but it makes creating/editing tables more convenient. Maybe it's well known, but I just discovered it yesterday.
Edit: sqlite browser, not mysqlbrowser
like this
Guy Geens, Bob Jonkman, fedops 💙💛, Royce Williams and Apocraphilia like this.
reshared this
Programming Feed and Ben Zanin reshared this.
This website uses cookies. If you continue browsing this website, you agree to the usage of cookies.
Isaac Ji Kuo
in reply to Jonathan Lamothe • • •Sensitive content
Probably not as elegant as you'd like, but:
SELECT tem.*,
price*tax_rate AS tax
FROM
(SELECT name,
CASE
WHEN sale_price IS NULL
THEN list_price
ELSE sale_price
END AS price
FROM prices) AS tem;
Jonathan Lamothe likes this.
Jonathan Lamothe
in reply to Isaac Ji Kuo • •Isaac Ji Kuo
in reply to Jonathan Lamothe • • •Sensitive content
Jonathan Lamothe
in reply to Isaac Ji Kuo • •If you're morbidly curious, the final resulting code was:
Isaac Ji Kuo likes this.
((( David "Kahomono" Frier )))
in reply to Jonathan Lamothe • • •Jonathan Lamothe
in reply to ((( David "Kahomono" Frier ))) • •@((( David "Kahomono" Frier ))) Yeah, that was my assumption. I just wasn't sure what the best way to go about fixing it was. So far, this is the front-runner:
Isaac Ji Kuo
2024-06-13 21:30:16
((( David "Kahomono" Frier )))
in reply to Jonathan Lamothe • • •Ryan Frame
in reply to Jonathan Lamothe • • •WITH
to do it in two steps:Gwen (Almond Joy->Mounds arc)
in reply to Jonathan Lamothe • • •Sensitive content
But yeah, you have figured out why you can't do it. You're actually, imho, best off implementing the case in the tax column. Or changing how you handle sales.