Dear Lemmings/Lemmites/Lemmitors and CCP Bots, what Database do you recommend? (self.asklemmy)

submitted 2 months ago* (last edited 2 months ago) by FiniteBanjo to c/asklemmy@lemmy.world

33 comments fedilink hide all child comments

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

[-] FiniteBanjo 1 points 2 months ago

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 2 months ago

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 2 months ago

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

this post was submitted on 03 Apr 2024

10 points (63.2% liked)

Ask Lemmy

25181 readers

1846 users here now

A Fediverse community for open-ended, thought provoking questions

Rules: (interactive)

1) Be nice and; have fun

Doxxing, 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 spam

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

4) NSFW is okay, within reason

Just 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.