Pinned Loading

1. MongoDB equivalent of an SQL query t... MongoDB equivalent of an SQL query to get the distinct values of a field in a collection including the count of documents which have each distinct value (distinct with count)

   1

   //equivalent of MySQL SELECT COUNT(*) AS cnt, fieldName FROM someTable GROUP BY fieldName;

   2

   db.someCollection.aggregate([{"$group" : {_id:"$fieldName", cnt:{$sum:1}}}]);

   3

   4

   //as above but ordered by the count descending

   5

   //eg: SELECT COUNT(*) AS cnt, fieldName FROM someTable GROUP BY fieldName ORDER BY cnt DESC;

2. ezstream ezstream Public

   Forked from xiph/ezstream

   command line source client for Icecast streaming server

   C

3. p5.js-sound p5.js-sound Public

   Forked from processing/p5.js-sound

   p5.sound brings the Processing approach to Web Audio and p5.js. Demos:

   JavaScript

4. TSV file containing zip codes and th... TSV file containing zip codes and the DMA they fall in to. Method: calculate the centre point of every zip code geo boundary, plot those points on a DMA boundary map, find the containing DMA of each zip centroid

   1

   zip_code	dma_code	dma_description

   2

   01001	543	SPRINGFIELD - HOLYOKE

   3

   01002	543	SPRINGFIELD - HOLYOKE

   4

   01003	543	SPRINGFIELD - HOLYOKE

   5

   01004	543	SPRINGFIELD - HOLYOKE