EasyCSV is a windows application that lets you run SQL quieres against any csv file. The output is stored in another csv file. This means you can do data manipulation on the fly without going through the tedioum of importing it into a real data base, and exporting it out again from a temp table.

Gotchas: EasyCSV doesn't like CAST( field as varchar(255)). Use CSTR(field) instead. This is because the underlying ODBC text driver doesn't fully support SQL-89 (thanks microsoft!).

Download EasyCSV

profile for Byron Whitlock at Stack Overflow, Q&A for professional and enthusiast programmers

Downloadable Tools

EasyCSV - Run SQL queries against CSV files (windows).

FastCrawl - PHP web crawling framework.

Creative Commons License

Fun Stuff

DOM Benchmarks - So you think simple html dom is the greatest thing since sliced bread? Think again. The PHP built in libraries DOM(inate).

Craigslist Gigfinder - Find gigs in the computer section. No need to click over multiple cities any more, the gigfinder puts it all in one place!

Online image resizer - Quick and dirty image resizer

Plate Techtonics - A fun way to show off jquery transitions.