Help us understand the problem. What is going on with this article?

【Rails】Sealize JSON メモ

More than 1 year has passed since last update.

単純に自分が感じたことです。

参考サイト

ActiveRecord serialize / store の甘い誘惑を断ち切ろう

結論

RDBにJSON形式のデータはあまり扱わない方が良い
RailsというよりRDBの問題かも...

なぜか?

  • 単純に処理が複雑になる

【弊害】
-> バリデーションをカスタマイズしないといけない
-> ページに渡すときに加工しないといけない(CRUD全ての処理に)
-> 単純に扱いについてキャッチアップすることが増える
-> 不整合なデータが入った場合、見つけることが困難
-> データが変わった場合、修正が難しい

使うのであれば

読み取りだけのマスタなどであれば、いいかもしれない。
変更や作成が多いテーブルであれば、おすすめしない。

課題

  • アンケートの回答などは、どうモデリングするのだろう??
Why do not you register as a user and use Qiita more conveniently?
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
Comments
Sign up for free and join this conversation.
If you already have a Qiita account
Why do not you register as a user and use Qiita more conveniently?
You need to log in to use this function. Qiita can be used more conveniently after logging in.
You seem to be reading articles frequently this month. Qiita can be used more conveniently after logging in.
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away