Skip to content

Instantly share code, notes, and snippets.

version: '3'
services:
mariadb:
container_name: mariadb
image: mariadb:10.4
restart: unless-stopped
ports:
- '3306:3306'
expose:
SELECT
DATE_TRUNC('week', timestamp))::date as week,
COUNT(*)
FROM whatever
GROUP BY week
ORDER BY week asc;

Keybase proof

I hereby claim:

  • I am teich on github.
  • I am teich (https://keybase.io/teich) on keybase.
  • I have a public key whose fingerprint is BBD0 5CA6 BF67 A2B8 54FD A326 E391 52C6 AEA3 45F6

To claim this, I am signing this object:

@teich
teich / stuff.md
Last active August 29, 2015 13:56
April 2014 Internet Garage Sale
@teich
teich / gist:1000964
Created May 31, 2011 17:53
May 31st Heroku Updates
oren@illogical ~/Sites/heroku/hbi (master)$ heroku releases
Rel Change By When
---- ---------------------- ---------- ----------
v40 Deploy oren@heroku.com 1 minute ago
v39 Deploy oren@heroku.com 1 minute ago
v38 Deploy oren@heroku.com Fri Sep 10 13:32:14 -0700 2010
v37 Deploy oren@heroku.com Fri Sep 10 13:28:12 -0700 2010
v36 Deploy oren@heroku.com Fri Sep 10 13:26:43 -0700 2010
v35 Deploy oren@heroku.com Fri Sep 10 13:26:30 -0700 2010
v34 Deploy oren@heroku.com Fri Sep 10 13:26:14 -0700 2010
module Core
def self.included(mod)
url = ENV['CORE_URL'] ? URI.parse(ENV['CORE_URL']) : URI.parse('postgres://postgres@localhost/heroku')
mod.establish_connection(
:adapter => "postgresql",
:host => url.host,
:username => url.userinfo.split(':')[0],
:password => url.userinfo.split(':')[1],
:database => url.path[1..-1]
)
teich@Orens-Unibody ~/Sites/zed9 (master)$ heroku addons
Activated addons:
Custom Domains http://docs.heroku.com/custom-domains
Memcached http://docs.heroku.com/memcached
Single Bundle
Piggyback SSL
Delayed Job (DJ) http://docs.heroku.com/background-jobs
Available addons:
Hourly Cron http://docs.heroku.com/cron