Tryangled Solutions web designing tips tricks

MySQL is a relational database management system (RDBMS) based on SQL (Structured Query Language). First released in January, 1998, MySQL is now one component of parent company MySQL AB’s product line of database servers and development tools.

Many Internet startups became interested in the original open source version of MySQL as an alternative to the proprietary database systems from Oracle, IBM, and Informix. MySQL is currently available under two different licensing agreements: free of charge, under the GNU General Public License (GPL) open source system or through subscription to MySQL Network for business applications.

MySQL runs on virtually all platforms, including Linux, Unix, and Windows. It is fully multi-threaded using kernel threads, and provides application program interfaces (APIs) for many programming languages, including C, C++, Eiffel, Java, Perl, PHP, Python, and Tcl.

MySQL is used in a wide range of applications, including data warehousing, e-commerce, Web databases, logging applications and distributed applications. It is also increasingly embedded in third-party software and other technologies. According to MySQL AB, their flagship product has over six million active MySQL installations worldwide. Customers include Cisco, Dun & Bradstreet, Google, NASA, Lufthansa, Hyperion, and Suzuki.

There are still some minor “stone age” search engines around that uses them.

The main reasons why they have been ceased to work are mostly from these factors:

* Most webmasters tried to fool the search engines with meta tags unrelated to their content and services.
* With improved FTS (full text search) tool kits from verity and many other companies, search engines can index your web pages and know the theme of your web page. With such advanced APIs, search engines like google can easily decide, what your website is about and what your website offers.

Some of the basic features of FTS API are that they can filter out text of your webpage and get important statistics such as:

1. How many times a word gets repeated
2. How far each repeated words are from each other
3. How many times a particular word gets repeated in a particular sentence
4. How far a word ‘Online’ appears from words like ‘Party’, ‘invitations’ to
see if that sentence makes any sense.
5. They can easily figure out, if you are doing keyword dumping.

So with such API’s the webmaster should concentrate on the content/layout and not put the meta tags as a main concern.

However it has been tested that the meta keyword tag still has a minor influence on the rankings and the meta description tag should be used as it is some times shown in the SERPs (search engine result pages).

You can request a Google robot visit at www.google.com/addurl. The robot will browse your site and index it’s contents. Expect to have to wait for a couple of weeks before this will happen.This is Google’s webdirectory and, next to the google robot, an important source of the google search API.

Staggernation.com offers three tools based on the Google API. The Google API Web Search by Host (GAWSH) lists the Web hosts of the results for a given query (www.staggernation.com/gawsh/). When you click on the triangle next to each host, you get a list of results for that host. The Google API Relation Browsing Outliner (GARBO) is a little more complicated: You enter a URL and choose whether you want pages that related to the URL or linked to the URL (www.staggernation.com/garbo/). Click on the triangle next to an URL to get a list of pages linked or related to that particular URL. CapeMail is an e-mail search application that allows you to send an e-mail to google@capeclear.com with the text of your query in the subject line and get the first ten results for that query back. Maybe it’s not something you’d do every day, but if your cell phone does e-mail and doesn’t do Web browsing, this is a very handy address to know.

I’ve worked with a couple of API websites in the past and I’ve always been interested on the concept of running websites which are supplied with continuous amounts of free content. Furthermore, people are now creating scripts that are meant to utilize these APIs.

Anyway, I found this great website with a list of numerous APIs on the web. If any programmer wants to take up this opportunity, go nuts! My prize API-based website is Vol3D, which pulls videos from Revver itself and uses my affiliate ID to display them for money!

After a long development and QA cycle, we are proud to release version 2.0 of PHP-GTK. This release, named leap day special, marks PHP-GTK 2 as stable and comes with support for GTK+ versions 2.6 through 2.12. Although support for more recent versions than 2.8 is not 100% complete, we hope to cover as much of the API as possible in upcoming releases.