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/)G

GodOfThunder

@ GodOfThunder @lemm.ee

Posts
94
Comments
31
Joined
3 yr. ago

  • What would you considered "Ethical Piracy"

    Jump

  • There should be a way to pay only the workers when you buy something. In that case, you could pay them but only after pirating and making sure you enjoy it. Since there is nothing like that, I think you should pay only content from small creators. Big creators already have plenty, and paying for anything else just gives money to greedy executives who then lower the quality of the content to make more money. Of course, if you have the means and don't pay anything, you are just making sure there will be less of that content made in the future. It isn't scalable; if everybody pirated content without paying a single cent, there would be no content made except by hobbyists who don't want to make a living out of it.

  • What Thematic Instances Would You Like to See on Lemmy?

    Jump

  • I really like to see communities like lemmy.film, mtgzone.com, and programming.dev and wish there was an instance about literature.

  • What thematic instances are there, and what others do you wish there were?

    Jump

  • Data privacy: how to counter the "I have nothing to hide" argument?

    Jump

  • Edward Snowden, a former National Security Agency contractor and government whistleblower, has been credited with the quote "Arguing that you don't care about the right to privacy because you have nothing to hide is no different than saying you don't care about free speech because you have nothing to say". Snowden has argued that privacy is a fundamental right and that without it, individuals cannot have anything for themselves. The "nothing to hide" argument has been used to defend the collection and use of government data beyond surveillance and disclosure, but critics argue that it is inherently paradoxical and that what is hidden is not necessarily relevant. Snowden has also stated that the burden of justification falls on those seeking to infringe upon human rights, and that nobody needs to justify why they "need" a right.

  • Viewing lemmy posts by all tends to be dominated by a few communities

    Jump

  • How do you choose an instance and does that have a significant effect on your Lemmy experience?

    Jump

  • I don't know there is a lemmy-stats-crawler utility that does it automatically and produces a json file. So all I do is parse that json file to get the numbers.

  • How do you choose an instance and does that have a significant effect on your Lemmy experience?

    Jump

  • Depending on which instances are blocked you will see different content in ones or others. Which is why I choose instance based on the minimum number of blocked users based on the results of this script.

  • China mandates that AI must follow “core values of socialism”

    Jump

  • Building the fediverse is an investment in us and the open web.

    Jump

  • What Algorithms from Popular Platforms do you Like the Most?

    Jump

  • The one I like most is YouTube, where it shows everything from the last few days and then only the most popular content from the last few weeks, months, and even years. I would like something similar, where the further I browse, the more votes a post must have to show up in the feed.

  • Worst States To Live & Work In. All 10 Are Republican States

    Jump

  • why don't you post this in a us community. I don't give a shit about this.

  • YSK: There's now a Lemmy Issue Tracker Community to Share Suggestions and Issues

    Jump

  • .

  • Why people can't handle the truth?

    Jump

  • Humans are more influenced by emotions than logic, which means that critical thinking alone may not convince them. Only those who are receptive to logical reasoning can be persuaded.

    A video about it

  • YSK: Imagus is Hover Zoom for Lemmy that actually works

    Jump

  • Imagus is a browser extension for Firefox that allows users to enlarge images and display images/videos from links with a simple mouse-over. It is similar to the Hover Zoom extension, which is a popular tool for browsing memes and gifs on desktop. However, Hover Zoom has been flagged as spyware, so users may want to consider using Imagus instead. Imagus works with a wider range of links than Hover Zoom, including those from imgur. The extension also has customizable settings, including an expandable set of rules for getting larger images, media, or other content.

  • Search Lemmy 0.4.0 update (an enhanced search engine for Lemmy)

    Jump

  • I've saved this, but it would be nice to see the syntax somewhere in the search engine

  • What's the best approach to avoid defining sqlite3 conn and cursor in many different functions?

    Jump

  • A function decorator: You can create a decorator that handles the connection and cursor creation and passes the cursor to the decorated function.

     python
        
import sqlite3
from functools import wraps

DB_FILE = "your_database_file.db"

def with_cursor(func):
    @wraps(func)
    def wrapper(*args, **kwargs):
        conn = sqlite3.connect(DB_FILE)
        cursor = conn.cursor()

        result = func(cursor, *args, **kwargs)

        conn.commit()
        cursor.close()
        conn.close()

        return result

    return wrapper

@with_cursor
def insert_post_to_db(cursor: sqlite3.Cursor, issue: Issue, lemmy_post_id: int) -> None:
    cursor.execute(
        "INSERT INTO posts (issue_url, lemmy_post_id, issue_title, issue_body) VALUES (?, ?, ?, ?)",
        (issue.url, lemmy_post_id, issue.title, issue.formatted_body),
    )

  • What's the best approach to avoid defining sqlite3 conn and cursor in many different functions?

    Jump

  • A context manager: Create a context manager that handles the connection and cursor creation, as well as closing the connection when done. This way, you can use the with statement to manage the connection and cursor in your functions.

     python
        
import sqlite3

DB_FILE = "your_database_file.db"

class DatabaseConnection:
    def __enter__(self):
        self.conn = sqlite3.connect(DB_FILE)
        self.cursor = self.conn.cursor()
        return self.cursor

    def __exit__(self, exc_type, exc_val, exc_tb):
        self.conn.commit()
        self.cursor.close()
        self.conn.close()

def insert_post_to_db(issue: Issue, lemmy_post_id: int) -> None:
    with DatabaseConnection() as cursor:
        cursor.execute(
            "INSERT INTO posts (issue_url, lemmy_post_id, issue_title, issue_body) VALUES (?, ?, ?, ?)",
            (issue.url, lemmy_post_id, issue.title, issue.formatted_body),
        )

  • Why are we stuck with bash programming language in the shell?

    Jump

  • This is so cool. It's exactly what I had in mind when thinking of a modern bash alternative.

  • How would you quote someone using CommonMark markdown syntax?

    Jump

  • Github style:

     
        
> If you need to find a post, don't use search engines or indexers, use lemmy's own search page, which allows you to filter by community if you wish. Its been a concious decision from the beginning to not favor SEO over simple urls.
> 
> *Originally posted by @dessalines in [#839 (comment)](https://github.com/LemmyNet/lemmy-ui/issues/839#issuecomment-1304368786)*

    Result:

    If you need to find a post, don't use search engines or indexers, use lemmy's own search page, which allows you to filter by community if you wish. Its been a concious decision from the beginning to not favor SEO over simple urls.

    Originally posted by @dessalines in #839 (comment)