- Laravel Bootstrap https://github.com/davzie/laravel-bootstrap
- TypiCMS https://github.com/sdebacker/TypiCMS
- Bootstrap starter site https://github.com/andrewelkins/Laravel-4-Bootstrap-Starter-Site
- Pongo CMS v1 (uses Laravel 3) http://pongocms.com
- Wardrobe CMS (blogging) https://github.com/wardrobecms/wardrobe
- CodeSleeve https://github.com/CodeSleeve/platform
Ryan Hayle hackel
kgaughan
/ first_day.sql
Created
November 13, 2012 13:34
Function to get the first day of the month. Why doesn't this already exist in MySQL?!
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE FUNCTION FIRST_DAY(dt DATE) | |
| RETURNS DATE DETERMINISTIC | |
| RETURN LAST_DAY(dt - INTERVAL 1 MONTH) + INTERVAL 1 DAY; |
chrisckchang
/ dupe-finder.js
Last active
February 16, 2017 15:11
Aggregation query to find duplicate key values
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Desired unique index: | |
| // db.collection.ensureIndex({ firstField: 1, secondField: 1 }, { unique: true}) | |
| db.collection.aggregate([ | |
| { $group: { | |
| _id: { firstField: "$firstField", secondField: "$secondField" }, | |
| uniqueIds: { $addToSet: "$_id" }, | |
| count: { $sum: 1 } | |
| }}, | |
| { $match: { |