In this economy?

I’m sure you’re going to find some fanfic about this if you look deep enough in ao3

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.

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)

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

That’s probably a good call, thanks :)

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)

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

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

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
}

https://truthsocial.com/@realDonaldTrump/posts/114738606142462442

Good enough source for you?

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.

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

Unfortunately changing from MBR to GPT also deletes existing partitions and partition table, because the two are not compatible.

Luckily, testdisk should be able to recover the old partition table without much fuss, if you didn’t write other data to the disk.

I don’t have a manual handy but the man page from what i remember is pretty clear, and there’s also an online documentation.

And all that just because someone decided that an array bigger that 16 bytes would have been too expensive (/s probably)

I’m almost sure the backstory to how you gained this knowledge is “i spent hours debugging something, and that 15 chars limit was the problem”

I might be a robot, I don’t know why but i can’t solve the captcha lol

I’d love to give this a try tho so maybe I’ll come back later

Just a random idea, but would you consider using anubis instead? (That new thingy that has been popping up lately, for example on the archwiki). I haven’t checked it out but I bet it’s also better on a privacy standpoint in respect to google’s captcha

There’s no shame in combining multiple tools, that’s what pipelines are all about

Not at all, but some times it’s just funny

You can select specific lines, with regex or by using a line number; or you can select multiple lines by using a comma to specify a range.

Yep, learning this made sed even more useful to me.

I also gave awk a try and now i know what i’ve missed all these years

(Also, sorry for the 12 days old reply :))

12 days late, but thanks for the bit of history, I always enjoy this stuff :)

I understand what argument could be made against musl, which is licensed under MIT, but what’s wrong with GPLv2?

I remember Torvald saying something about not wanting to change the kernel’s license to GPLv3, but I’ve never understood the differences