BitOneZero

joined 2 years ago
[–] BitOneZero 12 points 1 year ago* (last edited 1 year ago) (2 children)

Try without being logged in, incognito or private and see if it all appears. Almost always this problem comes about when someone fiddles with their language settings and Lemmy doesn't show the rest. Or some other setting like not showing already read posts. The apps really need to say "5xx posts not shown due to your preferences".

[–] BitOneZero 2 points 1 year ago (1 children)

The thing they want to conserve is the way society is, or rather, the way it was back in the mid-1900’s.

I don't even find that to be true. They adopt technology based on the whims of advertising they consume. Donald Trump was king of Twitter and they ate that up. They just don't follow what they say. They say they hate California, but consume every bit of technology (like Twitter, Apple, Disney, sports teams) they can that comes out of it.

[–] BitOneZero 7 points 1 year ago* (last edited 1 year ago)

I find the whole self-labeling of conservative to be founded on shaky grounds. Basically it's authoritarianism by another term. I often don't see conservatives actually cite some great example of it by some philosopher or even a nation. Because they don't want to face that Middle East nations are what conservatism looks like. The Taliban taking over Afghanistan and regulating women and building a class system is the kind of thing they seem to express in roundabout ways as the desired outcome. But, of course, they don't just outright say "I want to be like the Taliban". But the threatening people with guns, economic system that favors those in power, women's rights, anti-education, discrimination against other faith systems... all fits. And, monarchy, I see them praise powerful monarchy. Many want business kings they admire to rule everyone with an iron fist.

Donald Trump has sure inspired a lot of follower who are incredibly loyal, and he openly praises North Korea as some kind of model nation. But I notice the followers are unwilling to outright say "we want things run like North Korea" either... they just describe a system of powerful rulers who "fix" problems using the same techniques.

[–] BitOneZero 8 points 1 year ago (1 children)

serous problems with scalability, it works fine if there is little data in the system.

[–] BitOneZero 9 points 1 year ago* (last edited 1 year ago) (7 children)

Just because it’s written in Rust doesn’t make your app safe, or performant.

Lemmy 0.18.4 listing posts, frequently via ORM Diesel:

            SELECT "post"."id", "post"."name", "post"."url", "post"."body", "post"."creator_id", "post"."community_id", "post"."removed",
              "post"."locked", "post"."published", "post"."updated", "post"."deleted", "post"."nsfw", "post"."embed_title", "post"."embed_description",
              "post"."thumbnail_url", "post"."ap_id", "post"."local", "post"."embed_video_url", "post"."language_id", "post"."featured_community",
              "post"."featured_local",
              "person"."id", "person"."name", "person"."display_name", "person"."avatar", "person"."banned", "person"."published", "person"."updated",
              "person"."actor_id", "person"."bio", "person"."local", "person"."private_key", "person"."public_key", "person"."last_refreshed_at",
              "person"."banner", "person"."deleted", "person"."inbox_url", "person"."shared_inbox_url", "person"."matrix_user_id",
              "person"."admin",
              "person"."bot_account", "person"."ban_expires", "person"."instance_id",
              "community"."id", "community"."name", "community"."title", "community"."description", "community"."removed", "community"."published",
              "community"."updated", "community"."deleted", "community"."nsfw", "community"."actor_id", "community"."local", "community"."private_key",
              "community"."public_key", "community"."last_refreshed_at", "community"."icon", "community"."banner", "community"."followers_url",
              "community"."inbox_url", "community"."shared_inbox_url", "community"."hidden", "community"."posting_restricted_to_mods",
              "community"."instance_id", "community"."moderators_url", "community"."featured_url",
              ("community_person_ban"."id" IS NOT NULL),
              "post_aggregates"."id", "post_aggregates"."post_id", "post_aggregates"."comments", "post_aggregates"."score", "post_aggregates"."upvotes",
              "post_aggregates"."downvotes", "post_aggregates"."published", "post_aggregates"."newest_comment_time_necro",
              "post_aggregates"."newest_comment_time", "post_aggregates"."featured_community", "post_aggregates"."featured_local",
              "post_aggregates"."hot_rank", "post_aggregates"."hot_rank_active", "post_aggregates"."community_id", "post_aggregates"."creator_id",
              "post_aggregates"."controversy_rank", "community_follower"."pending",
              ("post_saved"."id" IS NOT NULL),
              ("post_read"."id" IS NOT NULL),
              ("person_block"."id" IS NOT NULL),
              "post_like"."score",
              coalesce(("post_aggregates"."comments" - "person_post_aggregates"."read_comments"),
              "post_aggregates"."comments")
             
              FROM ((((((((((((
                ("post_aggregates"
                   INNER JOIN "person" ON ("post_aggregates"."creator_id" = "person"."id"))
                INNER JOIN "community" ON ("post_aggregates"."community_id" = "community"."id"))
                LEFT OUTER JOIN "community_person_ban" ON (("post_aggregates"."community_id" = "community_person_ban"."community_id") AND ("community_person_ban"."person_id" = "post_aggregates"."creator_id"))
                )
                INNER JOIN "post" ON ("post_aggregates"."post_id" = "post"."id")
                )
                LEFT OUTER JOIN "community_follower" ON (("post_aggregates"."community_id" = "community_follower"."community_id") AND ("community_follower"."person_id" = $1))
                )
                LEFT OUTER JOIN "community_moderator" ON (("post"."community_id" = "community_moderator"."community_id") AND ("community_moderator"."person_id" = $1))
                )
                LEFT OUTER JOIN "post_saved" ON (("post_aggregates"."post_id" = "post_saved"."post_id") AND ("post_saved"."person_id" = $1))
                )
                LEFT OUTER JOIN "post_read" ON (("post_aggregates"."post_id" = "post_read"."post_id") AND ("post_read"."person_id" = $1))
                )
                LEFT OUTER JOIN "person_block" ON (("post_aggregates"."creator_id" = "person_block"."target_id") AND ("person_block"."person_id" = $1))
                )
                LEFT OUTER JOIN "post_like" ON (("post_aggregates"."post_id" = "post_like"."post_id") AND ("post_like"."person_id" = $1))
                )
                LEFT OUTER JOIN "person_post_aggregates" ON (("post_aggregates"."post_id" = "person_post_aggregates"."post_id") AND ("person_post_aggregates"."person_id" = $1))
                )
                LEFT OUTER JOIN "community_block" ON (("post_aggregates"."community_id" = "community_block"."community_id") AND ("community_block"."person_id" = $1))
                )
                LEFT OUTER JOIN "local_user_language" ON (("post"."language_id" = "local_user_language"."language_id") AND ("local_user_language"."local_user_id" = $2))
                )
                
                WHERE
                (((
                    (((
                    (
                    ("community"."removed" = $3) AND ("post"."removed" = $4))
                    AND ("community_follower"."pending" IS NOT NULL)
                    )
                    AND ("post"."nsfw" = $5)
                    )
                    AND ("community"."nsfw" = $6)
                    )
                    AND ("local_user_language"."language_id" IS NOT NULL)
                    )
                    AND ("community_block"."person_id" IS NULL)
                    )
                    AND ("person_block"."person_id" IS NULL)
                    )
                    
                ORDER BY "post_aggregates"."featured_local" DESC , "post_aggregates"."hot_rank_active" DESC , "post_aggregates"."published" DESC
                    
                LIMIT $7
                OFFSET $8
			;`

That is with hand-optimized person_id = $1, which the Rust code does not do.

[–] BitOneZero 2 points 1 year ago

"Terms of service" checkmarks are their reality

[–] BitOneZero 10 points 1 year ago (9 children)

What a non-story.

Lemmy project set wild unrealistic expectations on GItHub project: 1) "high performance', maybe the Rust code but PostgreSQL logic is the ORM madness. 2) "full erase" while sending all your public comments and posts to ActivePub without agreement on concept of delete.

[–] BitOneZero 3 points 1 year ago* (last edited 1 year ago)

I appreciate that Beehaw stands for greatness beyond the apathy of the 4.5 years of Lemmy established developers who seemingly don't use Lemmy to discuss Lemmy. “...the opposite of love is not hate -- it's apathy. It's not giving a damn. If somebody hates me, they must "feel" something ... or they couldn't possibly hate. Therefore, there's some way in which I can get to them.” ― Leo F. Buscaglia

[–] BitOneZero 23 points 1 year ago (1 children)
[–] BitOneZero 11 points 1 year ago (3 children)

The scorching of previous content I also found rather destructive... people were deleting 10 years worth of posts and content.

[–] BitOneZero 5 points 1 year ago (1 children)

Based on how they treated the top of medical science during the pandemic, I don't think they want educated workers. They can travel to smarter places. They want trade skills, technology skills, not people educated in humanities. They believe in 25% business growth every year and it's a unsustainable fantasy that was largely build off over-exploiting the earth and creating population booms.

[–] BitOneZero 1 points 1 year ago

I hope you get the rest you desire. Take care.

view more: ‹ prev next ›