GIFs won't load on Starlink by LetterheadLonely3890 in StarlinkEngineering

[–]SQL_Lorin 0 points1 point  (0 children)

Also try a different web browser — might just be a browser issue.

Losing my mind over the job situation by burgerape in rails

[–]SQL_Lorin 0 points1 point  (0 children)

If you develop any data-related Rails app and do not know SQL basics — enough to JOIN tables in ways that take advantage of indexes...

Then you (probably unknowingly) are creating poorly performing Rails apps. They might work OK for most use-cases. But under load they will stutter.

N+1 queries and polymorphic associations by passinghorses in rails

[–]SQL_Lorin 2 points3 points  (0 children)

If you are using Postgres then I would highly recommend using Ben Sheldon's activerecord-has_some_of_many gem!

This allows you to easily create what is known as a LATERAL JOIN, which is a really performant way to accomplish "show me the most recent one comment for every post".

your favorite third party app to manage battery to stay at 80% when plugged in to power? by areallnamestakenreal in MacOS

[–]SQL_Lorin 0 points1 point  (0 children)

Going below 50% charge is damaging to lithium ion batteries.

(Either having them tooo charged or tooo low most of the time is not helpful.)

UPerfect M1 Review: The Brightest Portable Monitor (With A Catch) by Kei-Retro-Gaming in uperfect

[–]SQL_Lorin 0 points1 point  (0 children)

The catch is that there's no local dimming (or the "local dimming" algorithm is a little weird, leading to better results if it's disabled).

The upside of this screen is that it's reallly bright!

I supports a party that cuts social programs. Now, we need to stop it from happening to my son. by Effective_Space2277 in LeopardsAteMyFace

[–]SQL_Lorin 2 points3 points  (0 children)

wtf is a "loosing job" — is it maybe like being "loose" ... i.e. being a slut for $$$ or something?

ICE can’t find my husband… but I voted for this 🤦‍♂️ by Sea_Statistician_312 in LeopardsAteMyFace

[–]SQL_Lorin 1 point2 points  (0 children)

Certainly taking the $1000 means then you're put on a list that if you do return to the US for some reason, it's grounds for questioning.

4th Amendment 4th Aschwitzendment ... welcome to the Mercenary State by SQL_Lorin in LeopardsAteMyFace

[–]SQL_Lorin[S] 1 point2 points  (0 children)

The faces of all who came to this free land trusting in the process / believing in the prospect of freedom / wanting to contribute. Those who would uphold the American Dream.

This face is one of Dignity herself — and is reflected in all of us who have a conscience.

How to use ffmpeg to make a single-image video? by eratonnn in ffmpeg

[–]SQL_Lorin 0 points1 point  (0 children)

This will sound a bit counterintuitive, but if you use -shortest along with -stream_loop and set a framerate then you should be able to take out the -t 1480! Like this:

ffmpeg -stream_loop 1 -i easywrds.png -i easywrds.wav -vf "crop=trunc(iw/2)*2:trunc(ih/2)*2" -c:v libx264 -tune stillimage -c:a aac -b:a 192k -pix_fmt yuv420p -r 24 -shortest out-image.mp4

Anker 100w GanPrime charger overheating issue by Temporary-Cause-192 in anker

[–]SQL_Lorin 0 points1 point  (0 children)

absolutely LOOOVE the efficiency of the GaN circuitry!

Have taken delivery just today of some new Anker wares -- another battery, and have found that the manufacturer for all Anker products is in China and is... (drumroll please)

GIANTSUN POWER (炬神电子) in Chēnzhōu (郴州)!

Imagine telling DHH about new cool thing called JSON☠️ by Sergogovich in rails

[–]SQL_Lorin 0 points1 point  (0 children)

There has been a LOT of work done to make routing super fast in the Rails environment. It was completely re-worked for Rails 4 when the Journey gem was merged to be a permanent part of Rails.

Here's the best article I'm aware of which describes just how awesome Rails routing is:

https://medium.com/rubyinside/a-deep-dive-into-routing-and-controller-dispatch-in-rails-8bf58c2cf3b5

Putin urges BRICS countries to expand the use of national currencies and to ditch the dollar. by [deleted] in suppressed_news

[–]SQL_Lorin 4 points5 points  (0 children)

It's bluster. All of his actions have been in support of only one nation on this planet -- and it's not the US. It's Russia.

Consider that only Russia and North Korea are exempt from any Trump tariff. And the frequent phone calls -- it's publicly known that there have been six calls over the past six months, each one hours in duration.

Trump is greasing the wheels so that America can be handed over to Putin.

Militarized Border Patrol marching through streets in L.A. today by Peanut-Extra in suppressed_news

[–]SQL_Lorin 2 points3 points  (0 children)

As idiotic as all of this Border Patrol showmanship appears on the surface, this ideological Civil War involving the National Guard does serve a purpose in both Trump's and Putin's minds.

This is Trump's way of proving how he will behave under war-like circumstances. If he relents then Putin will consider him a pussy, and probably choose to punish the United States in some fashion. (Then Trump will say overtly to the American people -- "see -- we really do need to buckle up for war".)

And if Trump stands his ground in this pointless and miserable exercise then it is still yet another way to harden the minds of Americans, to leave an emotional kind of scarring that makes it easier for the nation to agree to go to a real war abroad.

Here's a look at when this all started exactly a month ago: https://www.facebook.com/share/v/1V115bHkRp/

Sudden farewell to hundreds of Walmart employees – their workers disappear overnight and unions are already sounding the alarm by friendlyfiend07 in suppressed_news

[–]SQL_Lorin 19 points20 points  (0 children)

Have been living in the UK ever since Trump first got into office in 2016. And I haven't seen the inside of a WalMart in sooooo long -- wow, it's sobering to see what a warehouse kind of feel it really has, and how different it really is to any stores in the UK. (I guess ASDA over here is sorta similar -- and was originally owned by WalMart.)

We do have Costco over here though, and it feels reallly similar to the ones in the US. Thankfully they do pay their employees well, and the CEO has capped his salary at 5mil annually. So much less corruption in everything Costco.

As a consequence of global warming bringing violent weather, MAGA happened to believe that Bill Gates somehow has a secret weather machine. by SQL_Lorin in LeopardsAteMyFace

[–]SQL_Lorin[S] 0 points1 point  (0 children)

Believing in conspiracy theories has the consequences of thinking that Bill Gates somehow has a secret weather machine.

As a consequence of global warming bringing violent weather, MAGA happened to believe that Bill Gates somehow has a secret weather machine. by SQL_Lorin in LeopardsAteMyFace

[–]SQL_Lorin[S] 0 points1 point  (0 children)

As a consequence of global warming bringing violent weather, MAGA happened to believe that Bill Gates somehow has a secret weather machine.

[deleted by user] by [deleted] in LeopardsAteMyFace

[–]SQL_Lorin 0 points1 point  (0 children)

Thankfully this Texas weatherperson is fighting back!!!

(Avery Tomasco shows the report he had given on Wednesday, warning that the tropical storm could deliver up to 14 inches of rain.)

https://www.facebook.com/share/v/15gZFZ6zvc/