I’m just getting started learning ruby, but I’ve been a DBA for over 30 years, the last 20 of them on PostgreSQL. The data structure is complex, but I’ve seen (and probably written) worse. Is it possible to do things like change what group a large number of users are in using SQL rather than rake?…

You are kind of playing with fire if you go down that path, you are likely to miss records in all sorts of auditing tables and clearly bypass lots of validations in code. It is technically possible buy highly risky.

Yeah and I’m not going the SQL route. Sometimes when you are faced with a problem, a more creative approach to the problem is more elegant than your original design, and that’s how I’m structuring my archives. But I am impressed with the data structure Discourse is using, and my congratulations to…

האם ניתן לבצע שינויי מסד נתונים באמצעות postgres במקום rake?

מפתח

pfaffman (Jay Pfaffman) 24 במרץ,‏ 2023,‏ 2:21pm 3

See also Administrative Bulk Operations for ways to do bulk updates.

נושא		תגובות	צפיות
How can I directly edit Discourse database from a GUI? Self-hosting	20	3702	14 במאי,‏ 2020
Writing directly to the database Development	17	493	24 במרץ,‏ 2024
Is there a way to bulk-change user 'names' (note: not usernames) Support	10	699	18 ביולי,‏ 2023
Rake db:migrate error Support	5	614	16 בספטמבר,‏ 2022
Getting issue with Database Migrations Self-hosting	2	804	24 באוקטובר,‏ 2018

האם ניתן לבצע שינויי מסד נתונים באמצעות postgres במקום rake?

נושאים קשורים