Daily Dose of Drupal - Drupal Training Videos

The Daily Dose of Drupal is a collection of Drupal training video tutorials containing all different types of Drupal related topics. We try to post a Drupal training video tutorial almost everyday (or at least as often as we can). The Drupal video topics will vary, but the basic idea is to provide step by step videos on how to do something in a short Drupal video. We try to keep it short, and try to cover a wide variety of topics. If you would like to see something a little different shoot us an email and let us know what Drupal topics you would like us to cover.
If you are interested in sponsoring an episode of the Daily Dose of Drupal, you can learn more on the CodeKarate sponsorship page.

Source: http://codekarate.com

WATable- - A swiss army jQuery table plugin Filter, format, paginate and sort your data with ease.

WATable 

- A swiss army jQuery table plugin
Filter, format, paginate and sort your data with ease. Give it a try!

• Demo
• Options
• Methods
• Events
• Data Structure
• Dependencies
• Download
• Discuss 

Source: http://wootapa-watable.appspot.com/

Remote desktop sharing Ammyy Admin - download!

Ammyy Admin is free of charge for non-commercial use. You can download remote control application and start working with it within a few seconds.

Ammyy Admin - is a fast and easy way to gain remote sharing and remote desktop control!

Source: http://www.ammyy.com/en/downloads.html

Get list of existing TRIGGERs in MYSQL

While MySQL has features like StoredProcedure and View, it doesn't have any option for displaying TRIGGER list in the 'Schemata' tab (right) section of QueryBrowser.

Generally, we need a third party control like MySQL Workbench to get the list of existing TRIGGER lists.But there is another way through which we can get existing trigger lists and that is from the Metadata(Data about data).

To get all the trigger list irrespective of the database name:

 

SELECT * FROM information_schema.TRIGGERS;

To get list of trigger against a specific database:

 

SELECT * FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA='database_name';

 

 

Source: http://www.mindfiresolutions.com/Get-list-of-existing-TRIGGERs-in-MYSQL-856.php

 

Howto: Performance Benchmarks a Webserver

Apache Benchmark

You can benchmark Apache, IIS and other web server with apache benchmarking tool called ab. Recently I was asked to performance benchmarks for different web servers.
It is true that benchmarking a web server is not an easy task. From how to benchmark a web server:

First, benchmarking a web server is not an easy thing. To benchmark a web server the time it will take to give a page is not important: you don't care if a user can have his page in 0.1 ms or in 0.05 ms as nobody can have such delays on the Internet.

What is important is the average time it will take when you have a maximum number of users on your site simultaneously. Another important thing is how much more time it will take when there are 2 times more users: a server that take 2 times more for 2 times more users is better than another that take 4 times more for the same amount of users."
Here are few tips to carry out procedure along with an example:

Apache Benchmark Procedures

• You need to use same hardware configuration and kernel (OS) for all tests
• You need to use same network configuration. For example, use 100Mbps port for all tests
• First record server load using top or uptime command
• Take at least 3-5 readings and use the best result
• After each test reboot the server and carry out test on next configuration (web server)
• Again record server load using top or uptime command
• Carry on test using static html/php files and dynamic pages
• It also important to carry out test using the Non-KeepAlive and KeepAlive (the Keep-Alive extension to provide long-lived HTTP sessions, which allow multiple requests to be sent over the same TCP connection) features
• Also don't forget to carry out test using fast-cgi and/or perl tests

Source : http://www.cyberciti.biz/tips/howto-performance-benchmarks-a-web-server.html#comments

Writing Object-Oriented JavaScript

Introduction

ASP.NET and Visual Studio 7.0 are making important contributions to the improvement of the web development experience. Unfortunately, there is also a tendency created among developers to limit their interaction with JavaScript. Clearly JavaScript is valuable for adding client-side functionality to web pages. However ASP.NET programming models suggest that developers produce page layout while emitting client-side JavaScript from ASP.NET controls. As a consequence, this model tends to limit JavaScript to procedural adjuncts. This is rather unfortunate because it severely limits the power of an object-oriented scripting language that developers can use to write rich and reusable client-side components.

Source: http://www.codeproject.com/Articles/5608/Writing-Object-Oriented-JavaScript-Part-1 
Another Source: http://mckoss.com/jscript/object.htm

Date Drop Down Lists

This JQuery plugin converts a textfield with date value into a set of drop down lists for day, month and year.

Demo

When applied, the original textfield is replaced by a set of drop down lists, but it's value can still be referenced by the original ID:

Source: http://www.amdonnelly.co.uk/experiments/date-drop-down-lists.aspx