friendica (DFRN) - Link to source

My goodness, VARBINARY sucks so much!

When I wan to run some SELECT statements on some tables, I always get a SQL query like SELECT *, HEX(`column`) AS `column` FROM `table` WHERE `other` LIKE UNHEX('%foo%') in tools like #Adminer (a PHP-based web-frontend I usually use to administrate my database server). This causes it that zero records are being found and the culprit here is the wrong/excessive use of VARBINARY instead of VARCHAR (string variable character length) and a proper collation like utf8_general_ci for all tables.

I don't know why you e.g. want to have non-alpha-numerical characters in URLs or keys?! Why on good Earth that? I think a #RFC states that such characters needs to be URL-encoded with %HEX-CODE to avoid interference with not so tolerative systems. For example, I sometimes like to know how many contacts my node knows for a specific domain, so I usually choose LIKE %% and enter the domain name to look for. It worked always flawless before but since VARBINARY is in place, I can no longer find records. :-(

Very sad to see such development.

cc !Friendica Developers

#rfc #adminer

friendica (DFRN) - Link to source

CSS class' "icon" property "height" causing distance beween two lines in profile views

The said #CSS class .icon has a property height: 48px which with current HTML structure causes a distance between two lines when I view a remote profile (view: /contact/X or a post (view: /display/X):

I'm sure, removing height from the said CSS class won't fix it in the long run but maybe checking the HTML/div structure would.

cc @Friendica Support

#CSS @Friendica Support

Friendica Support reshared this.

friendica (DFRN) - Link to source

Jason Robinson 🐍 🍻 🚴

2022-11-15 21:57:38

socialhome - Link to source

I Do Not Want A Mastodon | Oliver Darkshire on Patreon


patreon.com/posts/i-do-not-wan…

I love this ❤

But on a serious note, I do get the fact a lot of people are not happy about #Twitter taking a hit from a nuclear missile called Elon. For a lot of people that was an important community, which is being actively destroyed. I feel for those people. And I also feel sad about the fact that one single man can destroy such a big and important platform all in one go.

It's annoying to be coming up with answers from hindsight - but hey maybe we shouldn't have large centralized platforms like Twitter that are able to be taken down by some douchebag billionaire. This is why we have decentralized platforms. They may be more complex to understand. They may not provide the same benefit for #capitalism to sell its products. But what they do well is provide resilience. No Elon can take down the #Fediverse - and that is a guarantee, not just words, because the fediverse is a collection of thousands of servers - and the number is going up by the day. Twitter is one server, which can be bought by a billionaire.

I don't want a #Mastodon either. I have my own platform, #Socialhome. But what I do want is to be a part of the Fediverse, and for social media to be more resilient to rich people going on shopping sprees for their own political agenda.

#fediverse #mastodon #twitter #capitalism #socialhome

friendica (DFRN) - Link to source

Null-safe invocation of Enum.compareTo()?

I look for an utilities class or self-implementation to invoke Enum.compareTo() in a null-safe manner.

Does anyone know such a class or how to implement it? I have a few enumerations written here and I COULD write one for each one. But I guess there might be a more intelligent and flexible way to do this.

The background here is that I have a public default constructor for the #JPA here and an other constructor that beside some other class fields sets this enumeration. Still I need to compare both instances ("empty" one and one with set values) in a null-safe manner. If I try to implement it without the null-check, it throws the all-famous #NPE at me and a unit-test fails.

PS: Is there a #Java group/forum like !java available somewhere?

#Java #Enumeration #NullPointerException #NPE

#JPA #enumeration #Java #npe #NullPointerException

friendica (DFRN) - Link to source

Ted

2022-11-11 13:21:36

diaspora - Link to source

This article, published in April 2021, tears the cover off the lies told about Julian #Assange, but few can shake off the disinformation they've absorbed from major media sources.
What made a Special Rapporteur on Torture work on the Assange case and write a book on it?

“When Julian Assange was still at the embassy in December 2018, his legal team actually reached out to my office. I remember it was just before Christmas, I saw this message pop up on my screen and I swiped it away immediately. I had this intuitive reaction: what does that guy want? He’s a rapist, a narcissist, a hacker, this isn’t serious, so I just discarded it. I have around 15 requests per day, and I can do one, it’s very routine for me to decide quickly, but I remember those negative emotions I had, that I usually don’t have.

Three months later his lawyers came back to me in March 2019, and they also sent me Dr. Sondra Crosby’s medical assessment. And I knew Dr. Crosby was a big name as an independent medical expert, who was not associated with Assange activists. I read these objective assessments by Dr. Crosby, by the UN Working Group on Arbitrary Detention, I also read an article by James Goodale the Pentagon Papers man. I realised that I had strong prejudices against Assange, even though it’s my profession as a Human Rights expert to be objective. I started investigating further, scratching the surface of this case. The deeper I got into the case, the more dirt and contradictions came to the light. I also knew that I could not rely on information in the media and in the press, because that’s precisely the source that had deceived me in the first place. To be objective, I had to go visit him in prison, and, to be sure, I took not one medical doctor, but even two medical doctors with me, who are independent from each other and are not employed by the UN; they work as external experts for the International Criminal Court, the International Committee of the Red Cross and so on.

We spent 4 hours with Julian Assange, I spoke to him for one hour, and the forensic expert had one hour for a physical examination, and the psychiatrist did a two-hour psychiatric examination. Each medical examination was done separately from the other, so they wouldn’t influence each other. All three of us at the end compared our conclusions and agreed that he showed all the signs that are typical of victims of psychological torture. I must admit that I didn’t expect such a clear result.


#uk #us #sweden #hypocrisy #corruption #freepress #journalism #torture #wikileaks #julianassange

ilfattoquotidiano.it/in-edicol…

#corruption #torture #us #Assange #UK #WikiLeaks #JulianAssange #sweden #journalism #hypocrisy #freepress
⇧