Skip Navigation

orsetto

@ orsetto @lemmy.dbzer0.com

Posts
9
Comments
76
Joined
2 yr. ago

  • Thoughts about my (potential) first server?

    Jump

  • 3.60 €/month is not bad. however i'd look for something even cheaper, given that the lowest plan gives 4 cores and 8gb of RAM, which I probably won't need

  • Thoughts about my (potential) first server?

    Jump

  • You're the only one giving me a positive answer!

    I do not mind RAID, so i won't lose data when a drive fails (the most valuable thing will be backups, which i mean, are backups, so not that critical if i can make a new one, but even losing other data would be a bit boring). I think I'd do software RAID tho, so if the controller breaks i wouldn't have to find the same model, which could be hard for old hardware i guess.

    the other comments scared me about power consumption, so i'll have to investigate more of it.

  • Thoughts about my (potential) first server?

    Jump

  • Old desktop pc would be ideal, for exactly the problems you pointed out. The only thing that is making me consider this is the already included drives, which is where i'd end up spending most of my money (especially now, thanks ai)

    I mean, the same capacity would cost WAY too much more. For a similar capacity + the system i'd have to spend at least double :(

  • Thoughts about my (potential) first server?

    Jump

  • yup, desktop components are what i was originally looking for, but this is 200 euros for a lot of storage, which would be way more expensive if i were to buy it separately

  • Thoughts about my (potential) first server?

    Jump

  • Do you have an estimate on the energy consumption?

  • Selfhosted @lemmy.world
    orsetto @lemmy.dbzer0.com

    Thoughts about my (potential) first server?

  • the wok agenda

    Jump

  • Wait, i skimmed the website, it looks like a dream. What do you think of it/how long have you had it?

    I'll (relatively) soon have to replace my current phone and i'm looking for a valid alternative.

    It doesn't seem to be supported by lineageos tho, which is something I'd like (even if i never used it lol)

  • cant get past me

    Jump

  • In this economy?

  • How do I design a multi-language database?

    Jump

  • I mean for now it's not being requested to add other languages beside italian and english, and i'm pretty sure my employer will never care about languages he doesn't speak, so chances of languages that require some work other than translations are basically null.

  • How do I design a multi-language database?

    Jump

  • Sorry, I didn't think to add in the post that the translations are in fact of user generated content, and are themselves provided by users.

    Project Fluent is still a good resource tho, thank you.

    And also yeah, I'll use a better schema for language tags, that's a clear fault

    Using an ID instead of the text content itself as part of the PK should be a no-brainer. Languages evolve over time, and translations change. PKs should not.

    I still don't get why having a separate table for languages is useful. I mean, even if the translation changes, the language itself will remain the same, right?

    Oh, right. Taking into account language variants makes VERY obvious why I'd want to use a table to store them.

    people tend to believe that translating is enough to localize. It is not.

    Onestly, I just hope that won't be something i should have to worry about. The rest of the codebase is as shitty as it gets, and I don't want to be the one to refactor it for proper localization. I'm implementing a new feature that allows me some degree of movement to think about a good design for that, and new, features, but this is as far as I'll go (Yes I know I probably sound like an ass but it really is that bad)

  • How do I design a multi-language database?

    Jump

  • But why would I need that? (Onest question, I hope I don't sound rude)

    I mean, I could easily retrieve the list of available languages, and it makes it faster to delete them using an ON DELETE CASCADE (right?), but it also complicates stuff a bit for general use

  • How do I design a multi-language database?

    Jump

  • That's probably a good call, thanks :)

  • How do I design a multi-language database?

    Jump

  • Shouldn't that be TextContent(TextContentId, OriginalText)? Something like

    (then you should make the id a primary key, index originaltext and make the id in the other table a foreign key)

    Yup, TextContentId is PK, and I'd set to auto_increment so that i wouldn't have to worrya bout it.

    Sure, but the you would have to reference the text via TextContentId in your code, which would be very annoying

    Not really, the translations I keep in the database are for entity that would be retrueved from the client with already the translated values instead of ID (should have specified this in the post maybe)

    BTW1/2: the translations on the database are for entities on the db (stuff like user generated content, which will also input the translations). For general text on the page I'm using a specific framework, which would be difficult to use for the user generated content, at least how it's set up now (it's angular's ngx-translate)

  • Programming @programming.dev
    orsetto @lemmy.dbzer0.com

    How do I design a multi-language database?

  • house rules

    Jump

  • How would you get small cylinder unstuck from the prize at the carnival

  • Removed

    Polish Train Maker Is Suing the Hackers Who Exposed Its Anti-Repair Tricks

    Jump

  • Forgot to clarify, that was reverse engeneered code from the train firmware (i don't remember what it was trying to do)

  • Removed

    Polish Train Maker Is Suing the Hackers Who Exposed Its Anti-Repair Tricks

    Jump

  • The best part of that presentation was code thst looked like the this

     
        
if (day > 15 && month > 11 && year > 2010) {
    // Yes the date is random i don't remember the real one
}

  • Huge encrypted files filling dribe

    Jump

  • Encrypting home is good (although full disk encryption is better and with mint it's still easy enough)

    Mint uses some helper scripts to mount/unmount your encfs, so maybe while trying to delete the files you deleted those too, and this would explain the login failing. It's been a while tho so I'm not sure, better to wait for someone else.

  • Anarchism @lemmy.dbzer0.com
    orsetto @lemmy.dbzer0.com

    The concept of right. I hope it makes sense.

  • Trump shares the message he receives from NATO leader Mark Rutte

    Jump
  • Deleted

    Permanently Deleted

    Jump

  • Oh yeah i figured there were some tools able to do that, i meant to say that you can't substitute one with the other in place without doing some sort of conversion.

  • Deleted

    Permanently Deleted

    Jump

  • sorry for the late reply. I honestly do not remember what the procedure is. The best thing you can do is look on the internet for a easy to follow guide, or wait for someone else's response

  • Linux @lemmy.ml
    orsetto @lemmy.dbzer0.com

    Help with sed commands

  • linuxmemes @lemmy.world
    orsetto @lemmy.dbzer0.com

    Reject vim return to emacs

  • Programming @programming.dev
    orsetto @lemmy.dbzer0.com

    Node.js segmentation fault does not happen on different envirnment

  • 196 @lemmy.blahaj.zone
    orsetto @lemmy.dbzer0.com

    I though was a photo of the rule