MySQL full indexed text search - just like a real database!! [relevance: 3.13]

2009-03-24

As of My Sql 3.something you can now add text indexes to your columns and do full text searches with relevance ranking! text indexes are fantastic and allow more efficient searching and categorisation of text. The relevance ranking feature is rather good too and gives you a much better idea of how your search performed.
Issues to note are, this example uses relevance ranking as the criteria for returning results, if you take that condition out you will return every result in the database with a relevance score of 0.
The default MySQL settings do not bother to index search terms of less than 4 characters therefore searching for anything less will bring back no results. This can be altered by setting "set ft_min_word_len =1" in your mysql config. This will result in a performance hit.
Text indexes in large data sets can be quite processor intensive so you might also consider limiting your result set.
ALTER TABLE `database`.`table_name`
ENGINE = MyISAM;
ALTER TABLE table_name
MODIFY column_name TEXT;
ALTER TABLE table_name
ADD FULLTEXT(column_name);
SELECT *,
MATCH(column_name)
AGAINST ('search term')
AS score
FROM table_name
HAVING score > 0
ORDER BY score DESC;

MySql code - left join group by [relevance: 1.71]

2007-08-06

SELECT
*
FROM
holiday_dates
LEFT JOIN
holiday_rentals
ON
holiday_rentals.week = holiday_dates.week
AND holiday_rentals.house_id = 3
GROUP BY holiday_dates.week

MYSQL UNION SELECT NULL [relevance: 1.5]

2007-08-27

SELECT * FROM
crh_houses
LEFT JOIN
crh_p_tags
ON
crh_houses.house_id = crh_p_tags.house_id
WHERE
crh_houses.house_id = 3
UNION DISTINCT
SELECT
*,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
FROM
crh_p_tags WHERE crh_p_tags.house_id = 3

Setting up JBOSS Seam [relevance: 0.96]

2007-11-30

from a command prompt/shell within the jboss-seam directory type the following:

[path...]\jboss-seam-2.0.0.GA>seam setup
Buildfile: [path...]\jboss-seam-2.0.0.GA\seam-gen\build.xml
init:
setup:
[echo] Welcome to seam-gen :-)
[input] Enter your Java project workspace (the directory that contains your Seam projects) [c:/development/eclipse_w orkspace/] [[path...]/workspace/]
[input] Enter your JBoss home directory [[path...]/jboss-seam-2.0.0.GA] [[path...]/jboss -seam-2.0.0.GA]
[input] Enter the project name [systemadmin] [systemadmin]
[echo] Accepted project name as: systemadmin
[input] Select a RichFaces skin (not applicable if using ICEFaces) [blueSky] ([blueSky], classic, ruby, wine, deepMa rine, emeraldTown, sakura, DEFAULT)
[input] Is this project deployed as an EAR (with EJB components) or a WAR (with no EJB support) [ear] ([ear], war, )
[input] Enter the Java package name for your session beans [uk.co.iblocks.projectName.data] [uk.co.iblocks.projectName.data]
[input] Enter the Java package name for your entity beans [uk.co.iblocks.projectName.data] [uk.co.iblocks.projectName.data]
[input] Enter the Java package name for your test cases [uk.co.iblocks.projectName.test] [uk.co.iblocks.projectName.test]
[input] What kind of database are you using? [mssql] (hsql, mysql, oracle, postgres, [mssql], db2, sybase, enterpri sedb, h2)
[input] Enter the Hibernate dialect for your database [org.hibernate.dialect.SQLServerDialect] [org.hibernate.dialec t.SQLServerDialect]
[input] Enter the filesystem path to the JDBC driver jar [[path...] \jtds-1.2.jar] [[path...]\jtds-1.2.jar]
[input] Enter JDBC driver class for your database [net.sourceforge.jtds.jdbc.Driver] [net.sourceforge.jtds.jdbc.Driv er]
[input] Enter the JDBC URL for your database [jdbc:jtds:sqlserver://dbserver:8080/projectName] [jdbc:jtds:sqlserver://dbserver:8080/projectName]
[input] Enter database username [username] [username]
[input] Enter database password [password] [password]
[input] Enter the database schema name (it is OK to leave this blank) [databaseName] [databaseName]
[input] Enter the database catalog name (it is OK to leave this blank) [databaseTable] [databaseTable]
[input] Are you working with tables that already exist in the database? [y] ([y], n, )
[input] Do you want to drop and recreate the database tables and data in import.sql each time you deploy? [n] (y, [ n], )
[input] Enter your ICEfaces home directory (leave blank to omit ICEfaces) [] []
[delete] Deleting: [path...]\jboss-seam-2.0.0.GA\seam-gen\build.properties
[propertyfile] Creating new property file: [path...]\jboss-seam-2.0.0.GA\seam-gen\build.properties
[echo] Installing JDBC driver jar to JBoss server
[echo] Type 'seam create-project' to create the new project
BUILD SUCCESSFUL
Total time: 2 minutes 26 seconds

seam new-project

seam generate-entities

dbPHP - Object Relational Mapping for PHP [relevance: 0.67]

2009-05-16

dbPHP is a lightweight framework allowing object relational mapping between (at present) mySQL and PHP.
dbphp project home
dbphp twitter
Google Code Home
SourceForge Code Home
dbphp manual

Object relational mapping is the process of creating a structural relationship between the classes/data objects used in the logic layer and the database itself.
One of the most successfully implemented exampled of an object relational/persistence frame work in the world of open source software is Seam with Hibernate. Seam is a framework for Java that allows one to run a generation script against a database and return an entire class frame work mirroring the structure of the database.
It allows for information to be directly loaded from the database into memory, view/altered/removed, and these changes saved without the user ever having to interact directly with the database through structured query language.
dbPHP is not designed to be commercial - if you want a hardcore resilient server with tons of functionality then you would never even consider PHP. what dbPHP aims to do is speed up the development times of quick and dirty PHP.
PHP allows users to develop code in incredibly shoddy ways with no regard for performance or re-usability and dbPHP tries to steer the developer towards a more structured object-oriented style of development.
Existing Frameworks
Zend Framework
WACT
Prado
ZooP Framework
eZ Components
CodeIgniter
CakePHP*
Symfony Project*
Seagull Framework*
PHP on TRAX*
My research has lead me to believe that only 4 of the existing main frameworks have object relational mapping capability *.
Object Relational Mapping
The importance of object relational mapping in scalable designs is clear. Maintaining a cross-platform relationship between data structures underpins many concepts which form the future of the internet - using an ORM Java example, a table can be taken from a database, loaded into memory and then directly output in XML - allowing for easy transfer of information retaining all of the semantic meaning using an open and widely available transport standard.
Lightweight.
The lightweight element of dbPHP is the key to its strength. PHP is free, it runs on cheap nasty hosting and it can provide a reasonable degree of functionality in relation the the manipulation and display of data for the web. dbPHP requires no installation other than being present in a directory. It is a series of classes that can be extended allowing child classes to map their internal structure to database objects and inheriting a number of useful SQL commands such as update, delete, findAll.
PHP Limitations
PHP has severe memory and performance limitations when it comes to handling large amounts of data or highly recursive tasks (default time out is set to 30 secs). It also has no ability to run threads and the only time it ever bothers to execute anything is if someone or something requests a page be served up. Global variables are seriously dodgy as you never really know what has access to them meaning that whenever you are requesting something from memory you have no way of knowing who set it, what's in it or if it will change.
PHP will quite happily work in a similar way to a well laid out java class model with private variables and get/set functions if one spends the time to do this.
Creative context.
When you want to make a project on the web, unless you love code, you don't really want to be spending half your time reinventing the wheel and rewriting code for boring banal stuff like update databases or other such stuff. Taking this to the extreme you can make all your projects in word press and totally abstract yourself from the process - if however your project involves some low-level elements, you're doing something clever with data, you want to incorporate a piece of flash that requires the storage of persisted data or you want to create a custom photo gallery of your own design - you probably want to focus on your own project and program logic. What dbphp does is allow you to treat your database and table as another area of memory and store and retrieve without extra hassle.
framework comparison chart
http://www.phpit.net/demo/framework%20comparison/chart.php