Avoid Rails When Generating JSON responses with PostgreSQL - DockYard

{ "tags":[ {"id":1,"name":"Tag #0","note_id":1}, {"id":1001,"name":"Tag #1000","note_id":1}, {"id":2001,"name":"Tag #2000","note_id":1}, ... ], "notes":[ { "id":1, "title":"Note #0", "content":"Lorem ipsum...", "tag_ids":[9001,8001,7001,6001,5001,4001,3001,2001,1001,1] }, { "id":2, "title":"Note #1", "content":"Lorem ipsum...", "tag_ids":[9002,8002,7002,6002,5002,4002,3002,2002,1002,2] } ] } What

[yss44]

あと読み

[shin1x1]

JSON化を PostgreSQL にさせてパフォーマンスを改善する / DB サーバの負荷はどうなんだろ。遅くなっても Web/APP でやった方がスケールしやすい気ががする。

[luvtechno]

PostgreSQLのextensionでJSONをつくる “10X faster than plain ActiveModel::Serializers”