Strapi database

Questions and Answers Database-SQL
#1
System Information
  • Strapi Version: 3.6.10
  • Operating System: Linux
  • Database: PostgresQL
  • Node Version: 14.9.2
  • NPM Version: 6.14.17
  • Yarn Version:

Hey strapi community, there are two questions i need to ask:

  1. does doing crud operation directly on strapi database via pgAdmin or any other sql tool, disturbs strapi’s response time or indexes? if so what is the best way to do this and
  2. how to make bulk update to column of a table in database?
#2

Welcome to the Strapi Community @picaso69 :wave: :cake:
to try answer your question

  1. I don’t think it will disturb it but it’s not the right way to do it I guess. It depends on what you are trying to do with it. Might fiddle with the indexes indeed but not the response time. (Unless your doing heavy operations while Strapi is quering it)

  2. If you are doing mass updates, I guess you can write your own service in Strapi to do the updates on bulk items with loops and FindOne Find Many etc.

#3

hey @Eventyret thanks for responding, I’m just updating a table’s column for all rows in that table also tryin g to move one content from this table’s column to another table as strapi is now looking into that table to get contents, in this case do you think the response time will slow down or i have misconfigured the database or strapi in any way :slight_smile:

#4

Not to sure but manually move it means you also need to update indexes etc.
But don’t think thr response will be any slower no