Database Best Practices

  • WordPressIsAwesome

    (@wordpressisawesome)


    13 years, 7 months ago

    Hi,

    I am creating a plugin that needs to use a lot of new custom tables in the Database. I noticed all the plugins that I’ve downloaded have added tables directly to the WordPress database.

    Is it best practices to add all plugin tables to this base WordPress database? If these tables are going to be frequently modified through the backend, does it make sense to create a new Database separate from the default WordPress one and create the tables there? Just wondering what the best practices are, and what the pros and cons there are for each approach.

    Thanks a lot!
    Will

Viewing 1 replies (of 1 total)
  • Thread Starter WordPressIsAwesome

    (@wordpressisawesome)

    13 years, 7 months ago

    Some of the data that I’m accessing should be private, so I’m wondering if there are any security ramifications of simply building the tables within the WordPress database?

    Since you do not need to connect and deconnect every time if you build the tables directly into WordPress DB, is it safer to build another database and store the tables there? And simply open and close the connection as needed?

Viewing 1 replies (of 1 total)

The topic ‘Database Best Practices’ is closed to new replies.