Databases
StackOverflow2013
Postsdbo
POBook translation data format
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POBook translation data format
    primarykey
    data
    text
    <p>I'm thinking of translating a book from English to my native language. I can translate just fine, and I'm happy with <code>vim</code> as a text editor. My problem is that I'd like to somehow preserve the semantics, i.e. which parts of my translation correspond to the original.</p> <p>I could basically create a simple XML-based markup language, that'd look something like</p> <pre><code>&lt;book&gt; &lt;chapter&gt; &lt;paragraph&gt; &lt;sentence&gt; &lt;original&gt;This is an example sentence.&lt;/original&gt; &lt;translation lang="fi"&gt;Tämä on esimerkkilause.&lt;/translation&gt; &lt;/sentence&gt; &lt;/paragraph&gt; &lt;/chapter&gt; &lt;/book&gt; </code></pre> <p>Now, that would probably have its benefits but I don't think editing that would be very fun.</p> <p>Another possibility that I can think of would be to keep the original and translation in separate files. If I add a newline after each translation chunk and keep line numbering consistent, editing would be easy and I'd be able to programmatically match the original and translation.</p> <pre><code>original.txt: This is an example sentence. In this format editing is easy. translation-fi.txt: Tämä on esimerkkilause. Tässä muodossa muokkaaminen on helppoa. </code></pre> <p>However, this doesn't seem very robust. It would be easy to mess up. Probably someone has better ideas. Thus the question:</p> <p><strong>What would be the best data format for making a book translation with a text editor?</strong></p> <p>EDIT: added tag <code>vim</code>, since I'd prefer to do this with vim and believe that some vim guru might have ideas.</p> <p>EDIT2: started a bounty on this. I'm currently leaning to the second idea I describe, but I hope to get something about as easy to edit (and quite easy to implement) but more robust.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USdancek
    1. USdancek
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POBook translation data format
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POBook translation data format
      1. USdancek
      1. VTBountyStart
    3. VO
      singulars
      1. POBook translation data format
      1. This table or related slice is empty.
      1. VTUpMod
    1. CONote that I have *text editor* mentioned in the question on purpose. I need a usable editing interface. I'm open to all suggestions (non-text editor based too), as long as they don't require a great effort to implement.
      singulars
      1. POBook translation data format
      1. USdancek
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload