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.

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

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…

rake 대신 postgres를 사용해 데이터베이스를 변경할 수 있을까요?

개발

pfaffman (Jay Pfaffman) 3월 24, 2023, 2:21오후 3

일괄 업데이트를 수행하는 방법에 대해서는 관리자 일괄 작업도 참고하세요.

글		댓글	조회수
How can I directly edit Discourse database from a GUI? Self-hosting	20	4011	5월 14, 2020
Writing directly to the database Development	17	666	3월 24, 2024
Is there a way to bulk-change user 'names' (note: not usernames) Product Support	8	803	11월 1, 2019
Rake db:migrate error Product Support	3	702	5월 13, 2019
Getting issue with Database Migrations Self-hosting	2	821	10월 24, 2018

rake 대신 postgres를 사용해 데이터베이스를 변경할 수 있을까요?

Related topics