How about extending the software so that communities replicate between sets of servers over time? That way, things are more robust even if one server goes down.

Is it permissible to transfer the submissions from reddit to lemmy directly, to at least provide a seed to start conversations going?

That is awesome! how soon until Beehaw is federated with them?

Has anyone considered creating a bridging API interface for lemmy? Something that can translate between the lemmy and reddit API to make this easier?

I wasn't thinking about reuploading comments, just submissions. There are a lot of submissions that would be interesting to discuss here as separate conversations away from reddit. For example, Futurology, Science, Finance, and even Aww and Eyebleach have some nice things to discuss.

Here's a kind of guess on how to create a post using python's requests library:

import requests
import json

# Define the URL for the API endpoint
url = "https://lemmy.ml/api/v1/post"

# Define the headers for the request
headers = {'Content-Type': 'application/json'}

# Define the data for the new post
data = {
 "name": "Your Post Title",
 "community_id": 123,  # Replace with your community ID
 "url": "https://your-url.com",  # Optional
 "body": "Your post content",  # Optional
 "nsfw": False,  # Optional
 "language_id": 1,  # Optional, replace with your language ID
 "auth": "your_auth_token_here"
}

# Send the POST request
response = requests.post(url, headers=headers, data=json.dumps(data))

# Print the response
print(response.json())

Does this look right? I understand that I'll have to authenticate to the server to do this, but I'm really not sure how to do that.

Thanks, I'll revamp my code when I start testing it later. I think eventually I'll put together a python library for interacting with Lemmy, or at least give enough of an example that someone else can get a good start.

Well, I can't see a reason either, but from a community standpoint is that okay?

Well, I do get a lot of alerts from Google as new topics come in, and I could post those links. That's mostly the way things are handled in the Futurology and Science subs. Posting those to Lemmy communities should work, I think. I guess I worry about swamping a community with traffic, but if so, I guess whoever manages that community can let me know to dial it back.

Those work, but require a lot of careful structuring to get right, and can be a pain to debug. With a CTE, you can just call on the intermediate steps to trace down problems.

There was one time a good while back where I used window functions to perform edge detection in a dataset. I'll see if I can dig up that query later.