Posts

MySQL: The complete FULLTEXT checklist

  • Published
  • 3 minutes
  • 600 words
  • Tags

In an effort to help a colleague with FULLTEXT search troubles today, I tried to find out everything that could go wrong with setting up this search method on a table. My short research resulted in this checklist. Failure to comply with these checks will result in catastrophic failure :P

Read on

MySQL: Boolean substitution

  • Published
  • 3 minutes
  • 500 words
  • Tags

Today I faced a quite interesting problem, that originated from pure laziness. I’m developing a backend system for a quite complex database structure. Within this backend, an almost limitless amount of table views have to be created for the end user. Because I’m extremely lazy, and didn’t want to develop the html view …

Read on