# off-topic
- h
HarryET
10/25/2021, 10:43 AMand table references - v
VuNguyen
10/25/2021, 10:44 AMso i have should a table
yea?characters - h
HarryET
10/25/2021, 10:44 AMyeah - h
HarryET
10/25/2021, 10:45 AMHave a look at examples - v
VuNguyen
10/25/2021, 10:45 AMi mean - v
VuNguyen
10/25/2021, 10:45 AMcan i just use json type? - v
VuNguyen
10/25/2021, 10:46 AMcuz i have like 2000 rows already doing this - h
HarryET
10/25/2021, 10:46 AMif you really wanted but i wouldn't recoment it - v
VuNguyen
10/25/2021, 10:46 AMim kinda lazy to update - v
VuNguyen
10/25/2021, 10:46 AMi see - h
HarryET
10/25/2021, 10:46 AMless performance - v
VuNguyen
10/25/2021, 10:47 AMhow can i bulk update? - h
HarryET
10/25/2021, 10:47 AMlike move from json to the references? - v
VuNguyen
10/25/2021, 10:47 AMyea - h
HarryET
10/25/2021, 10:47 AMit would depend on your implementation of it - v
VuNguyen
10/25/2021, 10:48 AMdoes upsert update ur data when it exists - h
HarryET
10/25/2021, 10:48 AMuhhhh not 100% - h
HarryET
10/25/2021, 10:48 AMthe reference is very good - h
HarryET
10/25/2021, 10:48 AM - v
VuNguyen
10/25/2021, 10:49 AMi have few columns that use json array instead of foreign key - v
VuNguyen
10/25/2021, 10:49 AMwell i think i have to change them - h
HarryET
10/25/2021, 10:53 AMMaybe yeah - h
HarryET
10/25/2021, 10:53 AMalso @User who do I speak to about getting experience that is talked about in #867318180615421973? - v
VuNguyen
10/25/2021, 10:54 AMuh i think ill change from json to jsonb - v
VuNguyen
10/25/2021, 10:54 AMcuz im lazy - v
VuNguyen
10/25/2021, 10:54 AM👉 👈 - v
VuNguyen
10/25/2021, 10:57 AM@User btw i want RLS allow read, write and update (in my server only), but i want RLS allow read only in client - v
VuNguyen
10/25/2021, 10:57 AMis there anyway to do that - h
HarryET
10/25/2021, 10:57 AMRLS donsen't apply with service key - h
HarryET
10/25/2021, 10:57 AMso use service key on server - DO NOT SHARE WITH CLIENT