Best strategy to store multiple translation records in DB
Assuming few fields (say under 6/7) whats the best strategy to store multiple language translation for DB records, consider the following two cases.
Say we have a table with the following fields:
id, title, description
Every record will have an English and Arabic translation. So, consider the two cases I am using:
Case 1:
Add two more fields: title_ar and description_ar.
Case 2:
Add a field: language and make a composite key out of id and language.
Considering the complexity of dealing with the composite key (I am using Sequel ORM), I am rethinking whether going with the first approach might be better. Please explain if there are any major drawbacks or advantages for either of the approaches.
This approach would scale even if it's planned to accommodate multiple language translations.
Associations
Sentence has many language translations
Translation belongs to Sentence
Drawbacks of the first approach,
If we were to extend the application to multiple languages then we have to add the corresponding fields to the table
Advantage of the second approach,
As we have id reference specific to the sentence, we can fetch the corresponding description in desired language quicker.
- error connecting external database with rails
- Linking Ruby with HTML Code
- How to enforce Ruby code to break long lines with multiple arguments into one argument per line
- How to compile Ruby?
- Configuration issues trying to install Ruby on Mac
- Checking if a variable is not nil and not zero in ruby
- Uninitialized constant Admin::Admin
- Ruby Console Input Character by Character
- How to write to file in Ruby?
- pod --version error can't satisfy 'rexml (~> 3.2.4)', already activated 'rexml-3.3.6'
- Fix ruby project inconsistent files using zeitwerk
- Why is there no "returnif <expr>" that could replace (and optimize) the pattern "return <expr> if <expr>"
- 'rails new --css tailwind' Does not create either bin/dev or Procfile.dev in rails app
- Unknown sequence in ruby marshal
- Rails 3.0.2 installation build fails with "error: 'maybe_unused' attribute cannot be applied to types"
- Working with bundler and different platform gem requirements
- Parsing a string representation of nested arrays into an Array
- Convert string array to array object
- Rails ( set_no_cache method) Cannot disable browser caching in Safari and Opera
- A Regex to ensure that a string contains at least two words
- Error running '__rvm_make -j 1'
- failed to install ruby Error running '__rvm_make -j4',
- Unable to install any Ruby with RVM on MacOS 10.14.2 Mojave: Error running '__rvm_make -j4'
- How to expect some (but not all) arguments with RSpec should_receive?
- Understanding the Rails Authenticity Token
- incompatible marshal file format (can't be read) format version 4.8 required; 0.0 given
- mysql2 Segmentation fault at 0x0000000000000000
- Return Range Ruby
- is there a built in method to remove the elements in a ruby array from another array
- Sorbet: How do i write a generic factory method?