With Sun’s announcement that the company will be bought by Oracle, a very big question comes into mind: What will happen to MySQL?

MySQL is currently under Sun, and soon Oracle, one of its competitors will buy Sun and claim MySQL. What does this forebode with MySQL’s future? Right now, MySQL is a huge threat to Oracle. For one, MySQL is free and open source, while you need to purchase Oracle. And MySQL’s market share cuts off Oracle’s bottom-line.

One scenario is that Oracle can simply drop MySQL support to kill off competition in the low-end market. They could also send MySQL to a slow death where future developments for MySQL are slowed or halted. Another possibility is that MySQL will be transformed into Oracle Lite and better integrate itself with Oracle. This opens up additional revenue from upgrading from MySQL to Oracle. The last outcome is that Oracle fortunately leaves MySQL alone to continue its normal operations, but everything is still uncertain at this point.

But in any case Oracle decides to be business-minded(greedy), expect a fork in the future.

This article is a continuation to the Filtering Lists Using jQuery. In the previous article, we’ve discussed how to filter a simple list using a single category. However, in real life this isn’t simply the case. What if we have a new column for our database table which adds a new category to our fruits list:

tbl_fruits

The front-end would be a products list with all of the products in place and customers can filter which color and type of fruits they need to find.

Traditional wisdom would tell us that we would need to make a script that would send a query to the backend for every post request the reload the page for the search results.

SELECT fruit FROM `tbl_fruits` WHERE color = “Red” AND type = “Berry”;

However there are some instances that this approach has too much overhead on our backend and our database. In cases where all data has already been preloaded, we don’t have to query the database once again for data that is already available. We can simply use jQuery to control this information.
Read more »

List filtering is when we have a list of different items, belonging to different categories and we can choose a category to hide or display. This is very convenient for users if they only want to view items belonging only to a particular category. However, list filtering can become one of the most resource-intensive workloads on a server.

Imagine a database table with the following data:

tbl_fruits

Read more »

Or the title can be put shortly as: Why doesn’t my jQuery events work after an AJAX callback?

Lets create a very simple example jQuery script which simply changes a list’s class on hover:

We’ll assign red as the hover color:

<style type="text/css">
.hover
{
	color: #f00;
}
</style>

Then add the jQuery hover() event to toggle/change the list’s class when the mouse hovers over the list. This is how the javascript code will look like inside the document.ready() function:

$("li").hover(
function()
{
	$(this).toggleClass("hover");
},
function()
{
	$(this).toggleClass("hover");
});

Read more »

Or a.k.a how every other advertising program will contribute to the downfall of the quality of the internet.

Its just another rambling of an uninformed person on how this game will end:

1. Almost all advertising programs earns you money whenever a user clicks on a banner ad.
2. For a user to click on a banner, the banner content must be more interesting to the user than the content on the website.
3. Websites owners usually have no control over the quality of content on these banner ads.
4. The banner ads are usually of low value to the users compared to the content of your website.
5. The only logical way to improve the gradient is to lower the quality of the content of your website.
6. Since lower quality content website will rank lower on search engines, the website will resort to dubious SEO.
7. Now that most of the top ranked search results are mostly low quality content wesbites, at one point the user gives in a clicks on the banner ad just to get the proper information. A typical user does not have the patience to check the first 20 search results. The good content websites would be found on a lower ranking instead.
8. Low quality websites are now earning a lot while those with good content operates at a loss. By natural selection, low quality websites proliferate.
9. Search engines will become basically useless since the majority of websites are now of low-quality content and of no use to users.

No wonder Google needs a lot of PhDs for their search algorithm. The only thing it can do is delay the inevitable, because low quality websites will eventually reach a threshold where it will be almost indistinguishable from good ones. Expect the signal to noise ratio to become even lower…