JoomlaWatch allows you to watch your Web site visitors and bots in real-time from the administration menu, particularly their IP addresses, countries they come from, geographical location on a map, which pages they are viewing, and their browser and operating system. It creates daily and all-time stats from this information plus unique, pageload, and total hits statistics. Furthermore, you can block harmful IP addresses, see blocked attempts stats, evaluate the trend charts, and create goals based on many parameters. In the frontend, it can show the top countries, user, and visit information for certain periods of time.
RedQueryBuilder fills the gap between a hand coded "quick search" and a full blown query language. A typical use is in an intranet Web application where experienced users need a quick ad-hoc way to find particular data. This means they don't have to use report frameworks or ask a techie. To use it in your app, you just need to drop in the JS, feed it the metadata for your database, then handle the change events to get the SQL and argument values.