Skip Navigation

fiah

@ fiah @discuss.tchncs.de

Posts
6
Comments
425
Joined
3 yr. ago

  • What's the best headset to use for both PC and console right now?

    Jump

  • for what, Bluetooth?

    which adds latency btw, no bueno

  • The Steam Deck Crushed It In 2023

    Jump

  • yes, that's a start

  • Huge Shakira statue unveiled in her hometown of Barranquilla

    Jump

  • most vandalized letter m in the world

  • The first EV with a lithium-free sodium battery hits the road in January

    Jump

  • also it's not a trivial task to engineer for swapable EV batteries, doing so comes with a whole host of disadvantages / compromises that don't make sense for most (I guess) consumers right now. It's not very different from the phone battery issue, except on a huge scale and with much more severe consequences if things go wrong

  • The Holy Trinity of JavaScript

    Jump

  • Can you write a website in other languages, like c# or python?

    sure, as long as it compiles to javascript

  • Huge Shakira statue unveiled in her hometown of Barranquilla

    Jump

  • Berlin says EU should prepare for war by end of decade

    Jump

  • you're right, we should just let the aggressors take everything, that way nobody has to die

  • How have you personally found the Lemmy community compared to its competition and other social media?

    Jump

  • I think part of it is that some of the Lemmy crowd came over because they were banned on reddit for being hyper-disagreeable, rude, violent lil bastards

    this wouldn't be the first time it happens either

  • I'm giving you Boxing Day

    Jump

  • the chonk is only barely being contained

  • Ukraine will suffer ‘insane’ losses if US stops aid, warn frontline troops

    Jump

  • Ho Ho Holy shit!

    Jump

  • hah! The 1993 documentary The Nightmare Before Christmas already conclusively proved that Santa can't even evade regular ol' flak

  • TIL that SQLite has only five data types

    Jump

  • But, you totally can? When you store all your dates as an ISO 8601 string (UTC, so with Z at the end), you can simply compare the strings themselves with no further complications, if the strings match, the dates match, if one string is less than the other, the date therein is before the other. Their lexical order is equal to their chronological order

    I agree that it's a massive and unnecessary overhead that you should definitely avoid if possible, but for anything where this overhead is negligible it's a very viable and safe way of storing date and time

    edit: I forgot, there's also a format that's output by functions like toUTCstring that's totally different and doesn't have any logical order, but I honestly forgot about that format because nobody in their right mind would use it

  • Ukraine to celebrate Christmas on 25 December for first time

    Jump

  • If only there was a summary of said article right here in the comment section, not even a click away

  • TIL that SQLite has only five data types

    Jump

  • why not? assuming you're saving them all in UTC they should be perfectly sortable and comparable (before, equal, after) as strings, even with varying amounts of precision when you compare substrings. You can't really do math with them of course, but that's what I meant about how DBs interpret dates and time: if you use it do to math and then you also use your application's date library to do math, you'll likely run into situations where the two come to different answers due to timezone settings, environments, DB drivers and the like. Of course if I could rely on the DB to do the math exactly the way I'd expect it to, then having that ability is awesome, however that requires more knowledge about databases and their environments than I currently have

  • TIL that SQLite has only five data types

    Jump

  • Personally, I would probably just store them as text, because I'm objectively a terrible programmer.

    I don't know man, I'd far prefer storing a string and have whatever date library I'm using figure it out than have to deal with whatever the database thinks about dates and timestamps

  • Exoskeleton pilot project shows positive results

    Jump

  • it has been shown that the MATE-XT upper limb exoskeleton and the MATE-XB lumbar device can reduce users’ effort by up to 30 percent

    I guess every little bit helps, but I thought they'd be shooting for something like 50+% at least

  • Linux too mainstream for some 🤷

    Jump

  • don't worry, they'll tell you all about it

  • Russian Women Are Starting to Demand Putin Bring Their Men Home From War in Ukraine

    Jump

  • we'll know if the tipping point is reached because it'll be violent. This isn't violent

  • I Just Need a Programmer

    Jump

  • We have everything important figured out

    well that's how we know that you haven't, because if you had actually spent enough time on it to think everything through, you wouldn't be so confident about what you know and what you don't know

  • DIY Simulators. Simracing, Flight simulators and more @discuss.tchncs.de
    fiah @discuss.tchncs.de

    just finished assembling my simxpro x80

  • Hardware @lemmy.ml
    fiah @discuss.tchncs.de

    The Best 120mm Fans (For PC cases, heatsinks, and radiators)

    www.hecka.tech /p/the-best-120mm-fans
  • Hardware @lemmy.ml
    fiah @discuss.tchncs.de

    AMD Announces $230 Ryzen 5 5600X3D CPU - AM4's Last Stand

  • PC Gaming @lemmy.ca
    fiah @discuss.tchncs.de

    NVIDIA GeForce RTX 4060 GPU Review & Benchmarks | Gamers Nexus

  • Formula 1 @lemmy.ml
    fiah @discuss.tchncs.de

    Albert Fabrega - New sidepods, floor and rear suapension for Williams. Big upgrade. Only Albon.

    twitter.com /AlbertFabrega/status/1669741339074785282
  • Formula 1 @lemmy.ml
    fiah @discuss.tchncs.de

    PU and gearbox elements used till now