solrize @ solrize @lemmy.world

Posts

31

Comments

2,294

Joined

2 yr. ago

Start a blog instead. I'd rather read it than listen to someone babbling.

Lichess.org for online chess, or (most private of all) a physical travel board if you're with a friend who wants to play. Lichess isn't very private but definition though. Not sure why you asked in c/privacy? Anyway what happened to reading a book on a bus trip?

Oh try universal paperclips if you haven't. 5 hours is about right for finishing it. That's pretty private.

Rumble is real time voice chat right? Closest I know to that is Jitsi Meet. For text chat there are many irc networks.

Wow cool, I don't have a project of my own to submit, but can maybe help with someone else's.

Lem-bin pie?

But has he also built an immunity to iocane powder?

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.

Thanks for the good thoughts and it's interesting (I guess not that surprisng) to hear that Trump and MAGA are, for now, even worse than the AfD if I understand what you're saying. I'm pessimistic about local activism here being good for anything at the moment. Changes have to made at the federal level, which for me mostly means kicking out the Democrat establishment. The idea of AOC running against Chuck Schumer in a primary would be an example of that, though I don't know if she would have a good chance of beating him. I'd say she has no serious chance of being elected president in 2028. Of course I'm open to being surprised.

It buys us time to elect a party capable of making good changes.

That's a nice thought and obviously you know more about the AfD and German politics than I do, but on the US side I can say that the Democrats have learned absolutely nothing. Even after two terms of G.W. Bush (2000-2008), one of Trump (2016-2020), one lucky escape* (Biden 2020), and Trump now in a 2nd term, the Democrats make the same mistakes that they always have. It's a safe bet that 2028 in the US won't be any better.

It would be great to hear what kinds of remedies are under way in Europe to fix the status quo as you describe. If anything like that is happening, it doesn't make the news over here. I can say that nothing seems to be happening in the US beyond some meaningless posturing.

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

They can be a lot less coy without triggering whatever happens when they formally announce a run. They can have exploratory committees and that sort of thing.

An AOC 2028 presidential run would be interesting but that is also when Chuck Schumer is up for re-election, giving her a chance to prmary him. I don't have any idea of her chances either way. I think she understands that situation and will make informed choices when the time comes. I'm not exactly a fan of hers but I'll give her some props for electoral savvy.

What does it mean if a democracy bans a party that the voters want to elect? Better to ask what failure of the system made that party popular in the first place. We have a similar situation in the US fwiw.

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.

Is that also the law Trump says lets DHS search people's homes without a warrant, on the pretext that they're looking for migrants?

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.

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.

governments

Be careful what you ask for :(.

Maybe "The Hacker Ethic" by Pekka Himanen, though I looked at it and didn't see much new.

Card payment terminals use the network for card authorization, but depending on the merchant agreement with its card processor, authorization (at least back in my day) was typically only needed for charges above say $50. Otherwise the bank would pay up and eat the loss if something went wrong.

If you're old enough to remember cards with raised numbers on them, those existed so the merchant could make an imprint of the card number on carbonless paper using a hand operated gizmo with rollers and carbonless forms. That used no electricity at all. You'd sign the piece of paper and the merchant would turn it in to the bank. That was simply how credit cards worked for quite a long time. Electronic terminals, and especially portable electronic terminals came along later.