orsetto

Soo I'm working on a database that needs to support multiple languages (two for now, but who knows). I stumbled across this blog post that explains how to develop what it calls a "translation subschema" (haven't seen it called like this anywhere else so I don't know if it's actually how you'd call it), which seems like a very nice way of dealing with things.

I'm not very experienced with DB stuff, so it took me a while to fully understand what it was doing, but now that (I think) I do, I'm wondering if I could just ignore the Languages table, and just use a language field in the tables TextContent and Translations, without loosing any functionality. (except of course having a table listing the available languages, which is not however something I'm interested in)

In my head everything would still work, I'd insert stuff with

INSERT INTO TextContent (OriginalText, OriginalLanguage)
VALUES ("Ciao", "it");

DECLARE TextContentId INT = SCOPE_IDENTITY();

INSERT INTO Translations (TextContentId, Language, Translation)
VALUES (@TextContentId, "it", "Ciao");
INSERT INTO Translations (TextContentId, Language, Translation)
VALUES (@TextContentId, "en", "Hello");

and given a TextContentId, i'd retrieve the correct translation with

SELECT Translation FROM Translations WHERE TextContentId = TCId AND Language = "en"

At this point, I'm thinking I could drop TextContent too, and just have a Translations table with TextContentId, Language, and Translation, with (TextContentId, Language) as primary key.

Am I missing something? I'm trying to simplify this solution but I don't want to risk making random errors.

Edit: translations on the DB are for user inserted text, which will also provide translations. The client then will only receive text it the correct language.

The following is something I wrote earlier. I don't know the validity of it, and I'm not sure I correctly expressed the concepts of "power" and "rights" after translating them from italian.

--

Lately I had in mind the concept of right. Specifically, the idea Stirner had about it.

When I read The Ego and It's Own, that passage stuck with me.

[omitted unrelated stuff, because I started thinking about other things before writing what follows]

I'm thinking how the whole action of Giorgio Rosa [1] was anarchist in it's essence. He created that island just because he could do it: he had the power to do it.

I'm thinking about how many times I did something just because I could, and because I felt like it. I'm sure that more than once me and that-one-friend answered the question "why?" with "because we can". And I'm thinking how "because I can" is one of the fundamental hackers' "ideology" - mostly.

I'm thinking about how "because I can" is one of the most genuine motive that people have to justify their actions.

And, in fact, what I'm saying is somewhat tied to the concept of right. Right now, the first to decide if I have the power to do something is exactly my right to do it. And my rights, at the same time, are decided by people who have power over me! And so I say that the concept of "right" has no meaning, because I won't allow those people to hold power over me.

[1] (but not in its execution) https://en.wikipedia.org/wiki/Republic_of_Rose_Island

Hi all! I have always only used sed with s///, becouse I've never been able to figure out how to properly make use of its full capabilities. Right now, I'm trying to filter the output of df -h --output=avail,source to only get the available space from /dev/dm-2 (let's ignore that I just realized df accepts a device as parameter, which clearly solves my problem).

This is the command I'm using, which works:

df -h --output=avail,source \
    | grep /dev/dm-2 \
    | sed -E 's/^[[:blank:]]*([0-9]+(G|M|K)).*$/\1/

However, it makes use of grep, and I'd like to get rid of it. So I've tried with a combiantion of t, T, //d and some other stuff, but onestly the output I get makes no sense to me, and I can't figure out what I should do instead.

In short, my question is: given the following output

$ df -h --output=avail,source 
Avail Filesystem
  87G /dev/dm-2
 1.6G tmpfs
  61K efivarfs
  10M dev
...

How do I only get 87G using only sed as a filter?

EDIT:

Nevermind, I've figured it out...

$ df -h --output=avail,source \
    | sed -E 's/^[[:blank:]]*([0-9]+(G|M|K))[[:blank:]]+(\/dev\/dm-2).*$/\1/; t; /.*/d'
85G