• Entries (RSS)
  • Comments (RSS)

How to list Stored Procedures and Functions in MySQL database

Posted by | Posted in How to, Resources, Tips and Tricks, Tutorials | Posted on 26-05-2009

Tagged Under : , , ,

How to check if there are any STORED PROCEDURE in MySQL database?

SHOW PROCEDURE STATUS;

Similarly for MySQL database FUNCTIONS

SHOW FUNCTION STATUS;

But it displays a list of all PROCEDURE and all FUNCTIONS, you can chop down the list by appending

## display FUNCTIONS from 'test' db
SHOW FUNCTION STATUS WHERE db LIKE ='test';

Hope it helps somebody.
Enjoy!

CodeIgniter or CakePHP? can’t decide

Posted by | Posted in PHP, Personal | Posted on 26-05-2009

Tagged Under : , , , ,

Can’t decide between CodeIgniter or CakePHP for my personal project. CodeIgniter is faster in terms of performance but development is slow, CakePHP‘s cake-bake makes development faster but its performance is not good. My problem is that I need both. I want it at best performance since I will be handling millions even billions of domain records AND I cannot spend more time developing my own system.

Any ideas?

10 Awesome Free Handwritten Fonts

Posted by | Posted in Resources | Posted on 26-05-2009

Tagged Under : ,

I like this resource, 10 Awesome Free Handwritten Fonts.

Get Adobe Flash playerPlugin by wpburn.com wordpress themes