Tag Archives: sql

MongoDB: MapReduce Functions for Grouping

Posted on October 4, 2010 by Geoff Lane

SQL GROUP BY allows you to perform aggregate functions on data sets; To count all of the stores in each state, to average a series of related numbers, etc. MongoDB has some aggregate functions but they are fairly limited in … Continue reading →

Posted in Code | Tagged , , , | 5 Comments

All Database Backed Web Apps are “Just CRUD Apps”

Posted on August 28, 2007 by Geoff Lane

It’s time to end the debate between “Just simple CRUD Apps” and “more complex” apps. Very complex behavior can be expressed through a small set of fairly simple rules. This is often described as emergent behavior or just emergence. The … Continue reading →

Posted in Web | Tagged , | Leave a comment

Using SQL Compact Edition Under ASP.NET

Posted on January 17, 2007 by Geoff Lane

What is SQLCE? SQL Compact Edition is the “low end” version of a SQL database solution from Microsoft. It is a single-file, application managed, database implementation. It doesn’t have all of the bells and whistles of the high end database … Continue reading →

Posted in .NET, Web | Tagged , , | 1 Comment