I can confirm that the Opera method works. I couldn't create an account before but I've managed to create the account using the built-in VPN of the Opera browser. Here's an example of a Python script written with Claude 2 that GPT-4 wouldn't have enough context for, https://lemm.ee/post/2595655 Really impressive.

Oh yeah I was thinking more along the lines of video games or movies where there are too many people creating it. For books, etc you can definitely donate.

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.

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

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.

This has already been mentioned a few times. Just find the relevant issue on GitHub and give it an upvote.

• The rank of a post in the aggregated feed should be inversely proportional to the size of the community #1026
• Weighted Community Subscription for Customized Feed #3518
• Balance Instance Scores Based on Monthly Active Users #3642

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.

I knew I recognized him from somewhere. He was the developer of lib.reviews. https://github.com/eloquence

I'm still waiting for a local autonomous AI agent with search. I don't understand why most autonomous agent projects use GPT-4 without incorporating search capabilities. Allowing the model to continuously hallucinate is not productive. Instead, it should be able to discover factual information and perform genuinely useful tasks.

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

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),
    )

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.

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),
        )

> *[@username](profile_link)* said:
>
> > Original quote from the person
>
> Source: [Link to the source](source_link)

For example:

> [@GodOfThunder@lemm.ee](https://lemm.ee/u/GodOfThunder) said:
>
> > How would you quote someone using CommonMark markdown syntax?
>
> [Source](https://lemm.ee/post/1063209)

Result:

@GodOfThunder@lemm.ee said:

How would you quote someone using CommonMark markdown syntax?

Source