…just led me to CQL (Contextual Query Language). Thanks StackOverflow and njk for showing the way! (Please note that since version 1.2, “Contextual Query Language” is changed from former “Common Query Language”) This lets the user write advanced searches using logical operators, indexes, even proximities… So, let’s create a search for all the cql-to-php-to-sql libraries… [Read more…]
July 7, 2009
The normal case when using foreign key relationships in database tables might be “ON DELETE CASCADE ON UPDATE CASCADE”. If you have a table connecting a user_id to an activity_id, this means that deleting the activity post also deletes the connection post. Fine! The activity is gone, and so the table post defining the connection… [Read more…]
July 7, 2009
When using the InnoDB table format in MySql, there’s the possibility to define foreign key relations to guarantee referential integrity. Setting up the relations by using “ALTER TABLE” sql statements is not that trivial though. I had some struggles the other day… Luckily there’s a view in PhpMyAdmin that takes care of this. Check out… [Read more…]
September 25, 2009
0