I’m planning to store data with a plugin, of literally 1 value, a topic id. What’s the best way to do this? Thanks.

If you only need to store a single Topic ID (like a configurable value), the simplest Discourse-native way is using a SiteSetting. You also get a built-in admin UI automatically. config/settings.yml: plugins: my_plugin_enabled: default: true client: false my_plugin_topic_id: defa…

I think PluginStore is the most suitable way. A site setting will not fit this use case. Thanks!

Your question reminded me of something I recently read on Meta. [图片] How Discourse Uses Discourse “Are there any topics that talk about not using PluginStore anymore? Trying to figure out if I should use PluginStore or just make my own db table and columns in a plugin I’m working on,” the Discou…

I was just about to start - thanks for bringing this up. It seems like making a whole DB table for 1 value is overkill, and completely unnecessary. Any ideas?

What is the reason why you don’t want a site setting? It could be hidden so admins won’t see it, kind of like the IDs for the special topics in core, like TOS. config/site_settings.yml 908d590fe default: "summary" hidden: true client: …

My use case is this: any topic or post created from the time the plugin is enabled is synced and stored somewhere else. But topics before that aren’t, so I have to run a job to sync those, perhaps in batches of 100. I need to store the lowest topic I’d so the next batch is that minus 100, and so on. …

Chatbot does something very similar. Here is the migration: db/migrate/20240217010103_create_chatbot_post_embeddings_bookmark_table.rb main # frozen_string_literal: true class CreateChatbotPostEmbeddingsBookmarkTable < ActiveRecord::Migration[7.0] def change create_tabl…

That’s good - at least I’m not the only one :laughing:… my next hurdle is how to run the migration - in a dev Discourse site or something else… wouldn’t running the migration then just add to Discourse’s migrations directory? Should I copy the file manually? Thanks.

You place it, as per all plugin migrations, in the plugin (just like Chatbot above). You run migrations with LOAD_PLUGINS=1 rake db:migrate Read up on migrations here: [图片] Active Record Migrations — Ruby on Rails Guides Migrations are a feature of Active Record that allows you to evo…

I know, the only thing I don’t get is that I’m supposed to write the minute and second manually as I create the file?

存储插件数据有什么最佳方式？

开发

NateDhaliwal (Nate Dhaliwal) 2025 年11 月 19 日 08:32 5

我正准备开始——感谢您提出这个问题。似乎为一个值创建一个完整的数据库表是矫枉过正的，而且完全没有必要。有什么想法吗？

话题		回复	浏览量
What are appropriate uses of PluginStore? Development	12	1570	2020 年7 月 6 日
Where can I view the use of PluginStoreRow? Development	3	860	2018 年4 月 3 日
How to use the database without destroying Discourse? Development	4	1197	2016 年9 月 28 日
Adding a method `get_like` to PluginStore class Development	7	1078	2019 年8 月 8 日
Create custom db table and fields from plugin Development	10	4189	2023 年6 月 24 日

存储插件数据有什么最佳方式？

相关话题