CRM Web App
Drag & drop query builder
An experimental project, this web app is my rudimentary implementation of CRM software.
The user is able to import data from CSV files, interactively build queries (which the server compiles into SQL queries), build email mail-merge templates, and send emails.
Built for maximum speed, every page is a simple static cacheable HTML page. Client-side script makes AJAX calls to a C# Web Service which returns JSON data. Using jQuery and a little magic, the pages are populated with data.
Because the only traffic that actually needs to cross the wire is JSON requests, page load times can be measured in the millisecond range – even when the app is used over slow connections, like a 3G cellular connection.