See Also: Home Links Personal Site Blogroll  FriendFeed CV

Topic Image

Project Ideas

Some project ideas I've had over the last few years, some that may never see the light of day, others that have since been superseded by recently released products, tools or technologies...

Others

Future Vote

Database of predictions concerning future technology and reports showing how people vote on each issue

Fun Stuff on the Web

Website of collection of games and tools (Java Script or flash based) that are easy for kids to play and have some educational value. e.g.

Generating CSS from XML

an XSLT file to handle transformation of an XML source file into CSS. The idea being to be able to manage the CSS through XML but render it conditionally out to multiple stylesheets. This way you don't have to manage common elements and can also mask out fields like comments when the CSS is generated.

An XML editor like XML-Spy gives you a nice spreadsheet like view of the elements so you can make search/replaces etc. down a column. An additional feature would be to produce a DTD which could then validate the XML (i.e. the CSS) before producing the CSS files).

Database Monitor Script

  • Perform "select count(*)"s on specified tables in mysql to check record numbers
  • flag warning if table size grows by certain %'ge or count
  • check binary database file-sizes and preform disk usage check
  • potentially lock-out CGI account access to tables/dbases in alarm state

X-App-erator

  • could provide Class::DBI like i/f and methods, e.g. create, delete, delete_all, retrieve, search, copy, validate_column_values, normalize_column_values etc
  • could look at an undo and discard_changes too by writing out to a temporary file until a change of foreign key record set is made
  • search might also be useful
  • see: http://search.cpan.org/~tmtm/Class-DBI-0.96/lib/Class/DBI.pm
  • user builds web i/f by pointing to an XML schema or SQL table
  • tool reads that and generates a form containing slots for all fields
  • user deletes or alters default assumed layout
  • i/f saved as XSLT files that are used to build i/f components
  • single controller script reads generated (or read) config file


See Also: Web Development | Notes Index