contact

Archive for June, 2009

php and mysql full text search across multiple tables using a relevancy score

Wednesday, June 24th, 2009

the setup

I am currently building a paltfrom to host my air applications on. this is plattform includes a feedback and bug tracking forum application where users can post their thoughts and problems. In order for this to be helpfull i needed to implement full text search. the forum constists of basically two tables.

  • 1.) threads (title,date,author_id,forum_id,threadComment_id)
  • 2.) comments (text, author, date,thread_id)

so the way this works is that a user can open up a thread , which stores a new thread and a comment in the database. the two are linked by adding the thread Id to the comment and the comments unique id to the thread. any futur comments that are posted to this thread will simply have the thread Id stored in them.

App for the milk – second Alpha released

Wednesday, June 17th, 2009

the second alpha is available for download

download app for the milk alpha 0150

changes:

  • hotkey: ctrl+A to add new task
  • hotkey: ctrl+S to search
  • limited support for american date format (in general settings)
  • bugfix: add and search textfield no have focus right away
  • bugfix: now runs properly in the background on windows machines

App for the milk alpha available for download

Thursday, June 11th, 2009

the alpha version of my app for the milk application is now available for download.

app for the milk alpha download

Go check it out and help me by providing feedback.

App for the milk demo video is online

Tuesday, June 2nd, 2009

I just finished the demo video for my remember the milk desktop client project called “app for the milk”.

please check it out and pass it around!