Most MySQL indexes (PRIMARY KEY, UNIQUE, INDEX, and FULLTEXT) are stored in B-trees. Exceptions are that indexes on spatial column types use R-trees, and MEMORY (HEAP) tables support hash indexes.

This is the Reference Manual for the MySQL Database System. It documents MySQL up to Version 5.0.4-beta, but is also applicable for older versions of the MySQL software (such as 3.23 or 4.0-production) because functional changes are indicated with reference to a version number.

CREATE [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name
[USING index_type]
ON tbl_name (index_col_name,...)

index_col_name:
col_name [(length)] [ASC | DESC]

Carnuke's short and basic FAQ on Article module based on forum posts, Q&As and his own testing, as well as a brief introduction to "Article" template management

My first impressions of the module called 'Article' is that it provides an extensive and comprehensive article management system. Article has many features not found on other Xoops modules and possibly exceeds many other CMS article features sets. If you want a quick and easy 'get it up online article manager' this module will probably go well beyond your expectations, however if you need to present multi-page, multi-category professional documentation, Article will probably prove a delight to work with.

[b][size=large]Installation routine[/size][/b] 1- Install Article as per xoops standard module installation 2- In xoops Admin menu: select- modules>administration then click the Article install icon 3- Select Groups with Admi...

XOOPS is a program that allows administrators to easily create dynamic websites with great content and many outstanding features. It is an ideal tool for developing small to large dynamic community websites, intra company portals, corporate portals, weblogs and much more. It can be installed on an Internet host with a PHP-capable web server (e.g., Apache) and a database (e.g., MySQL).

open source refers to a program in which the source code is available to the general public for use and/or modification from its original design free of charge, i.e., open.

PHP is a widely-used general-purpose scripting language that is especially suited for Web development and can be embedded into HTML.

What is Ning? Ning is a free online service (or, as we like to call it, a Playground) for people to build and run social applications. Social apps are web applications that enable anyone to match, transact, and communicate with other people. Our goa...

This page lists some open source alternatives to software, primarily geared toward students. The goal is not to list every single piece of open source software, but only that which would be useful in an academic environment.