ON DUPLICATE KEY UPDATE

INSERT ON DUPLICATE KEY UPDATE - MySQL Performance Blog
http://www.mysqlperformanceblog.com/2006/05/29/insert-on-duplicate-key-update-and-summary-counters/

example:
      CREATE TABLE ipstat(ip int UNSIGNED NOT NULL PRIMARY KEY,
                                hits int UNSIGNED NOT NULL,
                                last_hit timestamp);
      INSERT INTO ipstat VALUES(inet_aton('192.168.0.1'),1,now())
                             ON duplicate KEY UPDATE hits=hits+1;
info: If there is no such IP address in the table it will be added with hits=1 if it is already where (note ip is PRIMARY KEY) it would be just incremented and last visit timestamp updated.

performance boost: 30% speedup should be typical.

more: This example actually shows one more neat feature of MySQL - inet_aton  and inet_ntoa functions which can convert IP address strings to integers and back. This allows to save on field length significantly by using 4 bytes instead of 15

INSERT ON DUPLICATE Syntax
http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html

Nice Forms, Web portfolio - First Born

Portfolio: wonderful: First Born
http://www.firstbornmultimedia.com/#/who-we-are/history/

cf: a-r-t: Nice forms
http://www.emblematiq.com/projects/niceforms/

Disk Cloning, Photoshop Brushes, Brain Power, Air applications, Music Search Engine

Fileupload: script: cf:
http://www.galaxyscripts.com/

create hard disk image: wiki: comparison: Disk Cloning software
http://en.wikipedia.org/wiki/Comparison_of_disk_cloning_software

renil: brushes: photoshop: Grungy lines
http://www.brushking.eu/96/grungey-lines.html

Boost Brain Power
http://www.stumbleupon.com/toolbar/#topic=Self%20Improvement&url=http%253A%252F%252Flitemind.com%252Fboost-brain-power%252F

RegExr: Online Regular Expression Testing Tool
http://gskinner.com/RegExr/

Music Search Engine
mixturtle.com

27 Adobe air applications handy for web designers
http://www.webresourcesdepot.com/27-adobe-air-applications-handy-for-web-designers/#more-537

Skrbl - online whiteboard, RMS Quotes, Getsatisfaction usability forum

skrbl - online whiteboard
http://www.skrbl.com/blog.html

Richard Stallman's Quotes
http://en.thinkexist.com/quotes/richard_stallman/

ubiquity: usability getsatisfaction.com
http://getsatisfaction.com/participatoryculturefoundation

Clustering, Display multiple categories, subcategories using PHP/mysql-html-js, INSERT IGNORE, SWFObject

How to display infinite depth expandable categories using php and javascript.
http://codeassembly.com/How-to-display-infinite-depth-expandable-categories-using-php-and-javascript/

MySQLi vs MySQL (benchmarks)
http://www.johnjawed.com/benchmarks/

How to delete table name with special character
http://halisway.blogspot.com/2008/02/how-to-delete-object-with-special.html

a-r-t: MySQL - query to ingnore duplicate insertion (where there's a unique key field)
INSERT IGNORE INTO
more:


MySQl 5.0 Reference Manual 12.2.5 INSERT Syntax
http://dev.mysql.com/doc/refman/5.0/en/insert.html

info: If you use the IGNORE keyword, errors that occur while executing the INSERT statement are treated as warnings instead. For example, without IGNORE, a row that duplicates an existing UNIQUE index or PRIMARY KEY value in the table causes a duplicate-key error and the statement is aborted. With IGNORE, the row still is not inserted, but no error is issued.

more: You can use REPLACE instead of INSERT to overwrite old rows. REPLACE is the counterpart to INSERT IGNORE in the treatment ofnew rows that contain unique key values that duplicate old rows: The new rows are used to replace the old rows rather than being discarded

How to do an "insert ignore" in Oracle
http://halisway.blogspot.com/2007/04/how-to-do-insert-ignore-in-oracle.html

php: in_array() - Checks if a value exists in an array
http://us.php.net/in_array

Writing SQL queries in XMl - A support intensive approach
http://www.codeproject.com/KB/database/SQLInXML.aspx?df=100&forumid=203933&exp=0&select=1181052&tid=1180595

php: tutorial: Email System
http://www.tutorialized.com/tutorials/PHP/Email-Systems/1

php: tutorial: Mailing list management
http://www.tutorialized.com/tutorials/PHP/Mailing-List-Management/1

Building your own Myspace.com with PHP Part 1
http://www.upgradetheweb.com/2007/07/31/building-your-own-myspacecom-with-phppart-i-introduction/

good: Creating a simple PHP forum tutorial
http://www.phpeasystep.com/workshopview.php?id=12

Discussion board tutorials
http://www.chipmunk-scripts.com/board/index.php?forumID=43&ID=9268

SourceCodeOnline - Python - Discussion Boards - Free Source Code and Scripts Downloads
http://www.sourcecodeonline.com/sources/python/discussion_boards.html

Scriptmob - World's Biggest Script Resource
http://www.scriptmob.com/PHP/Tips_and_Tutorials/Discussion_Boards/

good: webmonkey tutorials
http://www.webmonkey.com/codelibrary/

Vanilla Discussion Forum documentation
http://lussumo.com/docs/doku.php

PHPbb3 Documentation
http://area51.phpbb.com/docs/code/

Stackless Python - an enchanced version of Python programming language . (Beneifts of thread based programming without the complexitiy problems associated with conventional threads.)
http://zope.stackless.com/

Microwulf: A personal, portable beowulf Cluster
http://www.calvin.edu/~adams/research/microwulf/

[ closed as of March 1, 2008. ] openMosix - An Open Source Linux Cluster Project
http://openmosix.sourceforge.net/

Building your first cluster
http://ask.slashdot.org/article.pl?sid=06/07/27/001201

Rocks Cluster
http://www.rocksclusters.org/wordpress/

SWFObject v2.0 HTML and Javascript Generator
http://www.swffix.org/swfobject/generator/

SWFObject Documentation - Embedding Adobe Flash Player Content using SWFObject
http://code.google.com/p/swfobject/wiki/documentation

Social Networking Software, Open source CRM, PHP Treeviews, Javascript Multiple Drop down

Brain raiser: Dutch: BarnRaiser: Social Network:
http://barnraiser.org/
Richard Stallman's views on cloud computing
http://www.guardian.co.uk/technology/2008/sep/29/cloud.computing.richard.stallman
Open Source: CRM
http://www.compiere.com

Pandora Th OMAP3 owered Handheld Linux Console
http://openpandora.org/

MIT: Artificial Nose
http://www.breitbart.com/article.php?id=080929220055.ix27ph89&show_article=1


PHP: TreeViews
http://www.berthou.com/us/2008/03/27/phptliste-an-opensource-treeview-in-php/
http://www.download.com/PHP-TreeView/3000-7957_4-10524225.html
http://www.phpclasses.org/browse/package/4112.html

ROR: Ruby on Rails: Loved/Lovd by Less - open source social networking platform
http://lovdbyless.com/
http://www.webappers.com/2008/03/20/first-ever-open-source-social-network-platform/

resolved: printer: issues: 1068 the dependency service or group failed to start
http://www.the-pc-guru.com/Print_spooler_service_failed.php

js: dd: Multiple select - Chained select menu:
http://www.dynamicdrive.com/dynamicindex1/chainedmenu/index.htm

Javascript Triple drop down menu using select
http://www.trans4mind.com/personal_development/JavaScript/tripleMenu.htm

Greek alphabets, free font Diavlo

Greek alphabets
http://en.wikipedia.org/wiki/Greek_alphabet

Free Font Diavlo
http://www.josbuivenga.demon.nl/diavlo.html