John Cox

Blogs · @wyome · Now · Shelf

Tagged tutorial · everything

Interesting

Hypertext Markup Language - 2.0 - The HTML Coded Character Set

I can't write a summary of this document because it's a technical reference table, not an article that argues or reports something. It's a listing of HTML character entity codes and their corresponding characters from the ISO-8859-1 character set—a reference guide rather than a piece with a narrative position or journalistic content to summarize.

Permalink

CSS Hacks

This article documents CSS hacks and filters—exploits of browser bugs and inconsistencies—that target specific browser versions, primarily Internet Explorer 6 and 7, with varying levels of reliability and validity. It categorizes recommended techniques like selector-based hacks (`* html {}`, `*:first-child+html {}`), attribute selector quirks, and the `!important` identifier abuse, alongside unrecommended methods using invalid CSS prefixes (`_property`, `*property`) and malformed pseudo-classes. The article emphasizes that while hacks should be avoided when possible, understanding these options allows developers to weigh consequences and choose the least harmful workarounds for cross-browser layout challenges.

Permalink

MySQL to SQL data types

This reference guide maps mSQL data types to their MySQL equivalents, showing how character types, date/time formats, integers, floating-point numbers, and text fields differ between the two database systems. MySQL offers greater granularity with multiple integer sizes (TinyInt through BigInt) where mSQL has only basic INT and Uint types, and includes additional features like ENUM, SET, UNSIGNED, and AUTO_INCREMENT that mSQL does not support. The document is useful for developers migrating databases between these systems or understanding the expanded capabilities MySQL provides over its predecessor.

Permalink

DB Normalization

Database normalization—organizing data into multiple related tables with fewer columns each—improves performance through faster sorting, more efficient indexes, and reduced null values, though excessive joins across many tables can become counterproductive. Key design principles include giving each table a unique primary key identifier, storing data for only one entity type per table, minimizing nullable columns, and avoiding repeating values by using separate linked tables instead. When complete redesign isn't feasible, selective normalization of large tables or the use of views can achieve better design without disrupting existing applications.

Permalink

Stu Nicholls | CSSplay | CSS only menus

This page catalogs dozens of CSS-based navigation menu implementations spanning from 2014 to 2026, ranging from simple dropdowns to complex tree menus using various CSS techniques like :focus-within, :has(), details/summary elements, and the newer popover API. The author notes that older implementations from 2005 have been removed as outdated, and while the menus work in current browsers, compatibility varies across older versions and different platforms, with some Mac-specific issues reported.

Permalink

Painless JavaScript Using Prototype [JavaScript & DHTML Tutorials]

Dan Webb introduces Prototype, a JavaScript library that simplifies DOM scripting and underpins Rails' JavaScript helpers, offering utilities like the $ function for element selection, getElementsByClassName for class-based queries, and the newer $$ function for CSS selector syntax. The article covers Prototype's core features including helper functions for common tasks, Ruby-inspired object-oriented approaches through Class.create and Object.extend, and form handling capabilities. Webb emphasizes that while Prototype's documentation was historically sparse, the library provides practical shortcuts that make JavaScript development more convenient, particularly for developers familiar with Ruby's syntax and conventions.

Permalink

AJAX Tutorial with Prototype

This is a tutorial demonstrating a practical AJAX implementation using the Prototype JavaScript library, where a zip code input field triggers real-time server lookups to display the corresponding city and state. The example walks through the complete setup—including HTML form structure, client-side JavaScript that fires on each keystroke using Prototype's Ajax.Updater, and server-side ColdFusion code that queries a zip code database and returns formatted results or error messages. The tutorial illustrates core AJAX concepts like asynchronous requests, DOM manipulation, and error handling in a simple, accessible way suitable for beginners.

Permalink

http://www.sanisoft.com/ziploc/

phpZipLocator is a PHP class that calculates distances between zip codes and identifies all zip codes within a specified radius by querying a database of zip code geographic data. Installation requires downloading the class files, setting up a MySQL database with the provided zip code table, and configuring database credentials in a configuration file. The tool outputs distance measurements in miles and can return lists of nearby zip codes, making it useful for location-based web applications.

Permalink

Mouse wheel programming in JavaScript

This guide explains how to detect and handle mouse wheel events in JavaScript across different browsers, accounting for their varying implementations—IE and Opera report wheelDelta while Firefox uses detail with inverted sign—and provides annotated code for capturing scroll direction as positive or negative delta values. The author notes that delta values typically fall between -1 and +1 but can vary with mouse sensitivity and scrolling speed, and emphasizes usability principles like keeping wheel behavior intuitive and not making it a required interaction. The code works in IE6, Firefox 1.0+, Opera 9+, and Safari, though the page itself is somewhat outdated and the author recommends modern JavaScript frameworks for new projects.

Permalink

Comparison of different SQL implementations

This page compares how different database management systems (PostgreSQL, DB2, MS SQL Server, MySQL, Oracle, and Informix) implement various SQL features and operations, showing which products follow the SQL standard and where they diverge. It covers everything from basic SELECT and INSERT syntax to data types, functions, metadata queries, and command-line operations, serving as a practical guide for developers porting SQL code between different database platforms. The author acknowledges the page is no longer actively maintained but provides extensive side-by-side feature comparisons with code examples for each DBMS's approach to standard SQL functionality.

Permalink

Library of Free Data Models

I appreciate you sharing this content, but this appears to be promotional copy for a database design educational website rather than a saved article to summarize. If you have a specific article you'd like me to summarize, please paste the actual article text and I'll be happy to write a two-to-three sentence summary explaining what it argues or reports.

Permalink