Jack Reichert

Fullstack Philosopher

Tag: databases

  • Database Indices

    I recently had the pleasure of indexing our company’s sites’ tables. The custom CMS I inherited has some really brilliant code, but it also has quite a large amount of idiotic code blocks as well. In this case, the database was not thought out as best it could have. I was able to reduce some…

  • How WordPress Works: Dissecting the Database

    There is beauty in the simplicity of WordPress’ database structure. All the functionality of posts, pages, custom posts, taxonomy, users and core settings are here. In 11 tables. For comparison, the almighty Drupal has 72 tables, Joomla has 68. All posts, pages and custom posts are saved in the wp_posts table. They are differentiated by…