chebago's Bookmarks About "sql"

me talking out loud - JOIN DIAGRAMM

Great post using Venn Diagrams to demonstrate how SQL joins work.

by chebago 2008-03-25 07:10 sql · join · reference

http://www.khankennels.com/blog/index.php/archives/2007/04/20/getting-joins - cached - mail it - history

Untitled

by chebago 2008-03-12 01:34 sql · sqlite · code · programming · db

http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers - cached - mail it - history

jonasjohn.de: htmlSQL - a PHP class to query the web by an SQL like language

by chebago 2008-02-26 04:36 html · php · code · programming · sql

http://www.jonasjohn.de/lab/htmlsql.htm - cached - mail it - history

PHP REST SQL: A HTTP REST interface to MySQL written in PHP

by chebago 2008-01-08 23:56 sql · db · php · programming · coding

http://phprestsql.sourceforge.net/ - cached - mail it - history

ONLamp.com -- MySQL FULLTEXT Searching

by chebago 2007-12-19 06:11 sql · code · programming

http://www.onlamp.com/pub/a/onlamp/2003/06/26/fulltext.html - cached - mail it - history

Untitled

I settled on the UNION ALL method for my problem, though there are other examples. See also this site

by chebago 2007-12-13 05:48 sql · programming · code

http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/ - cached - mail it - history

Tags: Database schemas

by chebago 2007-11-14 05:05 db · sql · programming

http://www.pui.ch/phred/archives/2005/04/tags-database-schemas.html - cached - mail it - history

Minq Software / Products / DbVisualizer

Looks like a pretty solid database tool to help visualize the databases and run queries etc.

by chebago 2007-06-03 14:28 sql · db · programming

http://www.minq.se/products/dbvis/ - cached - mail it - history

I'm Mike » Blog Archive » How not to optimize a MySQL query

by chebago 2007-04-27 01:17 sql · code · programming · optimize

http://immike.net/blog/2007/04/09/how-not-to-optimize-a-mysql-query/ - cached - mail it - history

10 Tips for Optimizing MySQL Queries (That dont suck) 20bits

by chebago 2007-04-11 20:06 sql · code · programming · optimize

http://20bits.com/2007/04/10/10-tips-for-optimizing-mysql-queries-that-dont-suck/ - cached - mail it - history

ADOdb Database Abstraction Library for PHP (and Python) for MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Firebird, Interbase, LDAP, Access, VFP, DB2 and many other databases

by chebago 2007-02-25 16:36 db · sql · code · programming · php · python

http://adodb.sourceforge.net/ - cached - mail it - history

Articles and Tutorials - How To add paging (Pagination) with PHP and MySQL

by chebago 2007-02-08 12:03 sql · php · prgramming · code · tutorial

http://www.weberdev.com/ViewArticle/466 - cached - mail it - history

Articles and Tutorials - Succinct descriptions of Common Data Types

by chebago 2007-02-08 11:59 sql · programming · definition

http://www.weberdev.com/ViewArticle/72 - cached - mail it - history

Articles and Tutorials - Using Transactions In MySQL (part 2), follow up to the excellent first tutorial on using transactions in sql

by chebago 2007-02-02 07:48 sql · programming

http://www.weberdev.com/ViewArticle/456 - cached - mail it - history

Implementing Additional Methods with mysqli and PHP 5

by chebago 2007-02-02 07:46 sql · programming

http://www.devshed.com/c/a/MySQL/Implementing-Additional-Methods-with-mysqli-and-PHP-5/ - cached - mail it - history

Zend | Using ext/mysqli: Part II - Extending mysqli

by chebago 2007-02-01 09:11 sql · programming · db

http://devzone.zend.com/node/view/id/687 - cached - mail it - history

Tutorial - Using Transactions In MySQL (part 1) - great article on transactions for the beginner to novice mysql programmer

by chebago 2007-02-01 08:07 programming · sql

http://www.weberdev.com/ViewArticle-453.html - cached - mail it - history