Skip Navigation

InitialsDiceBearhttps://github.com/dicebear/dicebearhttps://creativecommons.org/publicdomain/zero/1.0/„Initials” (https://github.com/dicebear/dicebear) by „DiceBear”, licensed under „CC0 1.0” (https://creativecommons.org/publicdomain/zero/1.0/)S

solrize

@ solrize @lemmy.world

Posts
8
Comments
581
Joined
3 yr. ago

  • Going old-school: I'm reading "How to Design Programs" by MIT Press, and using LISP variation

    Jump

  • I don't remember being that impressed with HTDP but it's been a while and I didn't look much. I'd say read SICP first in either case.

    The Java thing sounds totally uninteresting and if your next language after Lisp isn't a a mainstream one, I'd say try Haskell.

    Regarding math: it can help but it's not that important for pure programming. If you're good at languages and writing, that's helpful in the same way. If you're good at music, that is at least a helpful mindset.

  • Man speaks to killer from beyond the grave in Arizona courtroom through AI video

    Jump

  • This is awesome. Next we can have AI Jesus endorsing Trump, AI Nicole Simpson telling us who the real killer was, and AI Abraham Lincoln saying that whole Civil War thing was a big misunderstanding and the Confederacy was actually just fine. The possibilities are endless. I can hardly wait!

  • How do you imagine your experience compares to that of those with minimal or extraordinary agency?

    Jump

  • Somewhere in the middle I guess. Same answer as for almost everyone, I imagine?

  • NSFW Deleted

    Permanently Deleted

    Jump

  • What should the subset of the Fediverse that is Lemmy + Mbin + PieFed be called?

    Jump

  • Lem-bin pie?

  • database greenhorn

    Jump

  • What? Problems like this usually come down to some missing indexes. Can you view the query plan for your slow queries? See how long they are taking? IDK about SQL Server but usually there is a command called something like ANALYZE, that breaks down a query into the different parts of its execution plan, executes it, and measures how long each part takes. If you see something like "FULL TABLE SCAN" taking a long time, that can usually be fixed with an index.

    If this doesn't make any sense to you, ask if there are any database gurus at your company, or book a few hours with a consultant. If you go the paid consultant route, say you want someone good at SQL Server query optimization.

    By the way I think some people in this thread are overestimating the complexity of this type of problem or are maybe unintentionally spreading FUD. I'm not a DB guru but I would say that by now I'm somewhat clueful, and I got that way mostly by reading the SQLlite docs including the implementation manuals over a few evenings. That's probably a few hundred pages but not 2000 or anything like that.

    First question: how many separate tables does your DB have? If less than say 20, you are probably in simple territory.

    Also, look at your slowest queries. They likely say SELECT something FROM this JOIN that JOIN otherthing bla bla bla. How many different JOINs are in that query? If just one, you probably need an index; if two or three, it might take a bit of head scratching; and if 4 or more, something is possibly wrong with your schema or how the queries are written and you have to straighten that out.

    Basically from having seen this type of thing many times before, there is about a 50% chance that it can be solved with very little effort, by adding indexes based on studying the slow query executions.

  • What do you use for listening to podcasts?

    Jump

  • I just download the mp3 and play it with mplayer. Don't need no apps.

  • Removed

    Sriracha - Imageboard and forum

    Jump

  • This looks kind of cool. It's written in Go. License is LGPL3, kind of a weird choice, but whatever. I'm not crazy about the name "Sriracha" but I guess you've got call it something. I might give it a try. I haven't understood why so many forums are written in PHP.

  • If you’re in the market for a $1,900 color E Ink monitor, one of them exists now - Ars Technica

    Jump

  • I'm happy with say 3 hz, fast enough to not be too annoying when flipping pages while reading. It's fine to not be good for video. What I really want is a 16 inch or so e-reader though.

  • If you’re in the market for a $1,900 color E Ink monitor, one of them exists now - Ars Technica

    Jump

  • That is a video of a much smaller monitor. It does show reasonably responsive refresh. Do you have one of the 25.3 inch monitor described in the article?

  • If you’re in the market for a $1,900 color E Ink monitor, one of them exists now - Ars Technica

    Jump

  • What is the refresh time? They carefully avoid mentioning that. There's a comparable Pimoroni monitor whose refresh takes 14 seconds so I'd call it a static display rather than a computer monitor.

  • All four major web browsers are about to lose 80% of their funding | by Dan Fabulich | Apr, 2025

    Jump

  • governments

    Be careful what you ask for :(.

  • Why did we stop using Firefox?

    Jump

  • I don't even remember many times Firefox/Mozilla has changed its extension API and broken everyone's add-ons. It gets tiresome.

  • Content moderators are organizing against Big Tech

    Jump

  • Contract workers for Meta, TikTok, Google, and more are forming a global group to fight for better working conditions.

    Try Reddit also, the moderators there don't even get paid :(.

  • Removed

    Ms Lindsey has lost his mind

    Jump

  • DRM-Free OnlyFans Downloads See Widevine Project Nuked From GitHub

    Jump

  • p2p solution for opensource projects

    That's called Git and it's been around longer than GitHub. There is also Usenet which by now is mostly dead. People fell for centralized alternatives. Oops :)

  • The YouTube Alternative Nobody's Talking About ! Peertube

    Jump

  • The difficult part is not the software or even the hosting. It's more about the network effects and the ability to let users monetize uploads, which in turn creates vast potential for abuse and fraud, which in turn has to be addressed by burning stupendous resources. At a certain point people stop wanting exposure or "making a difference" for their own sake, and instead want to get paid in genuine coin of the realm.

  • Anybody else annoyed by news headlines being predominantly clickbaity now?

    Jump

  • See the existing posts there, I guess, or look at the reddit version. I agree that there's not much point in cross linking it unless there's a significant discussion thread for that post. But reddit got those sometimes.

  • Anybody else annoyed by news headlines being predominantly clickbaity now?

    Jump

  • Yeah I made c/savedyouaclick in the hope of getting people de-clickbaiting stories, but I was the only poster afaict. I wonder if calling it newssummararies could help.