Using Ruby On Rails and the find method with conditions, it is also to possible to use the LIKE statement of SQL without having to escape variables or using raw SQL:

Read more…

You can put the following lines in your wordpress theme into footer.php to see how much SQL statements were executed for generating the page and how long the whole process of generating the page took:

Read more…

Recently I inserted about 200 rows into a MySQL table using Hibernate.

However, my application had an error because of missing data and I explored the database in order to find the problem.

In general, SQuirreL is a good tool to do this and I like using it, but this time it made me crazy.

Read more…