this post was submitted on 03 Apr 2024
9 points (61.5% liked)

Ask Lemmy

27100 readers
2259 users here now

A Fediverse community for open-ended, thought provoking questions

Please don't post about current US Politics. If you need to do this, try !politicaldiscussion@lemmy.world


Rules: (interactive)


1) Be nice and; have funDoxxing, trolling, sealioning, racism, and toxicity are not welcomed in AskLemmy. Remember what your mother said: if you can't say something nice, don't say anything at all. In addition, the site-wide Lemmy.world terms of service also apply here. Please familiarize yourself with them


2) All posts must end with a '?'This is sort of like Jeopardy. Please phrase all post titles in the form of a proper question ending with ?


3) No spamPlease do not flood the community with nonsense. Actual suspected spammers will be banned on site. No astroturfing.


4) NSFW is okay, within reasonJust remember to tag posts with either a content warning or a [NSFW] tag. Overtly sexual posts are not allowed, please direct them to either !asklemmyafterdark@lemmy.world or !asklemmynsfw@lemmynsfw.com. NSFW comments should be restricted to posts tagged [NSFW].


5) This is not a support community.
It is not a place for 'how do I?', type questions. If you have any questions regarding the site itself or would like to report a community, please direct them to Lemmy.world Support or email info@lemmy.world. For other questions check our partnered communities list, or use the search function.


Reminder: The terms of service apply here too.

Partnered Communities:

Tech Support

No Stupid Questions

You Should Know

Reddit

Jokes

Ask Ouija


Logo design credit goes to: tubbadu


founded 2 years ago
MODERATORS
 

EDIT: You don't have to answer for my specific purposes, if you use a database for any purpose yourself then please share and tell what and why.


I'm not planning to host any fediverse or mastodon instances just yet, but maybe a private email server and porting a discord channel to matrix might be in my future.

What do you use and why? Is it limited to a specific OS, and if you were on a different OS then what would you be using instead? Do you think server hardware is required for most operability or can a good desktop computer and internet speed suffice as long as downtime isn't a problem?

you are viewing a single comment's thread
view the rest of the comments
[–] breadsmasher@lemmy.world 9 points 8 months ago (1 children)

There isn’t a one size fits all database. It really depends on what you want to do

[–] FiniteBanjo 2 points 8 months ago* (last edited 8 months ago) (1 children)

I'm gonna try to port a discord channel over to Matrix, never attempted anything like it before.

Also, if you use a database for literally any specific reason, then feel free to answer the prompt with that information.

[–] themoonisacheese@sh.itjust.works 2 points 8 months ago (1 children)

Are you doing that as a challenge? Because there are multiple tools that do that already, discord/matrix bridges are a dime a dozen

[–] FiniteBanjo 1 points 8 months ago (1 children)

I'm not making the bridge, just a database. Some other users have informed me that as long as I can use Docker or equivalent then running the compose will generate a database on its own, which was news to me but I'm still learning a lot about databases and maintaining with this discussion so I think it was a worthy discussion.

[–] themoonisacheese@sh.itjust.works 2 points 8 months ago (1 children)

Seeing your other comments on this post, I urge you to think twice about embarking on whatever it is you're about to attempt, because it is clear you have no idea what's in store for you. I really don't mean it as a demeaning thing, what you're describing is hard.

I suggest looking into a postgres tutorial first and foremost, it will teach you the basics of DBMS and how to use SQL, and when you understand that and what the database does for the applications you're used to, revisit this project. Being a database administrator is a literal full time job in the enterprise world, and for good reason, and you don't sound like you know enough about it to go in guns blazing.

[–] FiniteBanjo 1 points 8 months ago

No worries I'm not the person to jump in head first, clearly.