This guide provides an overview of Yahoo! Query Language (YQL) along with information on how to use YQL to retrieve data from Yahoo! Social Directory, MyBlogLog, and data from other Yahoo! Web services. YQL also allows you to retrieve data from external sources such as the New York Times as well as feeds such as RSS and Atom. This guide is intended for software developers who are familiar with SQL, MySQL, or Yahoo! Pipes.
Read the rest of this entry »

• 0 Comments

Everybody who wants to install a web server database but does not know which software is necessary and how it is installed should benefit from reading this text. This text provides all information necessary to get a SQL database for a web server going; it does not go into any detail of CGI programming, nor does it explain the SQL database language. Excellent books are available on both topics, and it is the intention of this text to provide a working platform based on which a user can then study CGI programming and SQL. For getting a small scale SQL system running (not the notorious example of a major airline booking system, or space mission management database) it will be sufficient to have the software described in this text and the documentation accompanying it. The user manual of msql (a database introduced in this text) provides sufficient information on SQL for building your own database.
Read the rest of this entry »

• 0 Comments

SQL - Structured Query Language
Structured Query Language, is a computer language designed for retrieval and management of data in relational database management systems database schema creation and modification database object access control management.
History:
The first version of SQL was developed at IBM by Donald D. Chamberlin and Raymond F. Boyce in the early 1970s. Standardized in 1986 by ANSI. Subsequent versions of the SQL standard have been released as ISO standards
Read the rest of this entry »

• 0 Comments

MySQL is a Relational Database Management System. A relational database adds speed and flexibility, by storing data in separate tables rather than putting all the data in one area. These tables are linked by defined relations making it possible to combine data fromseveral tables upon request. Using a RDMS means it is possible to add, access, and process the data stored in your database. ‘SQL’ stands for “Structured Query Language” - the most common standardised language used to access databases. MySQL is Open Source software and is freely available at www.mysql.com. Open Source software means that the source code can easily be manipulated and modified by anyone. It is very simple to use.
Read the rest of this entry »

• 0 Comments

Fulltext search QuickPoll
? have used MySQL Fulltext Search in production ?
- have at least tried using MySQL Fulltext search ?
- have used fulltext search in other products ?
? are interested in boolean fulltext search ?
- natural language search ?
- in our future plans for fulltext search ?
? are interested in how to tune and optimize your fulltext search application ?
? are interested in how MySQL Fulltext Search works internally?
- have contributed code to Open Source products ?
Read the rest of this entry »

• 0 Comments

The purpose of these tutorials is not to teach you Microsoft Access, but rather to teach you some generic information systems concepts and skills using Access. Of course, as a side effect, you will learn a great deal about the software enough to write your own useful applications. However, keep in mind that Access is an enormously complex, nearly- industrial-strength software development environ- ment. The material here only scrapes the surface of Access development and database programming.
Read the rest of this entry »

• 0 Comments

This tutorial is intended for computer science students who need a quick introduction to Microsoft Access, but it will be useful to anyone needing such an introduction. To get the full benefit of this tutorial, you will need a computer running one of Microsoft Windows 95 or higher, Microsoft NT 4.0 or higher, or Microsoft Windows 2000. You will also need to have a copy of Microsoft Access 2000/2002 installed. Introduction Though Microsoft Access is NOT synonymous with database systems, there are more copies of Microsoft Access in use than any other database system.
Read the rest of this entry »

• 0 Comments