Support » Plugins » Hacks » Use my own MySQL tables?

  • Is it possible to use my own tables for custom post types?
    I think it’s quite annoying when ALL data gets stored in the wp_posts table. Images, posts, tags, categories you name it. It looks like a real mess when you look in the database.

    Lets say Posts (title & content) go into 1 table, images into another, tags into another etc. Why? To get more control over the database of course. Or should I consider making my own CMS?

Viewing 2 replies - 1 through 2 (of 2 total)
  • catacaustic

    (@catacaustic)

    very awesome

    If you’re using the standard features, it makes more sense to use the standard database tables because all of the built-in WordPress functions will know what to do. While you can og moving everything around if you want to, you’ll have to go and recreate every built-in function that you want to use because you’ll need to get your own info. For me, I’ve used separate database table sbefore, but that’s been to store information that’s not part of what is offered by a standard installation.

    Moderator bcworkz

    (@bcworkz)

    You are applying a human sense of order to database management. All post types in one table makes perfect sense to SQL. It doesn’t matter to SQL that the post types are unrelated to each other, that’s a human desire to relate things. SQL can very quickly and efficiently make sense of the apparent disarray. Separating post types into different tables will actually hamper SQL, don’t do it.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Use my own MySQL tables?’ is closed to new replies.