Skip to content

Instantly share code, notes, and snippets.

View randomradio's full-sized avatar
🎯
Focusing

i.an randomradio

🎯
Focusing
View GitHub Profile
@hest
hest / gist:8798884
Created February 4, 2014 06:08
Fast SQLAlchemy counting (avoid query.count() subquery)
def get_count(q):
count_q = q.statement.with_only_columns([func.count()]).order_by(None)
count = q.session.execute(count_q).scalar()
return count
q = session.query(TestModel).filter(...).order_by(...)
# Slow: SELECT COUNT(*) FROM (SELECT ... FROM TestModel WHERE ...) ...
print q.count()
@lucacioria
lucacioria / domains_api_tutorial.markdown
Last active December 21, 2015 10:29
Google+ Domains API with Service Accounts (Quick Start Tutorial in Python on App Engine)

Google+ Domains API - Quick Start

introduction

Google+ Domains API are meant to interact with your G+ accounts in the domain. With these APIs you can manage circles, read and write posts, shares, and comments etc.. more informations here

This tutorial is for creating an application that uses the Domains API, running on Google App Engine with python.

create GAE (Google App Engine) app

@dypsilon
dypsilon / frontendDevlopmentBookmarks.md
Last active January 10, 2026 01:41
A badass list of frontend development resources I collected over time.
@miohtama
miohtama / gist:5389146
Created April 15, 2013 15:56
Decoding emails in Python e.g. for GMail and imapclient lib
import email
def get_decoded_email_body(message_body):
""" Decode email body.
Detect character set if the header is not set.
We try to get text/plain, but if there is not one then fallback to text/html.
:param message_body: Raw 7-bit message body input e.g. from imaplib. Double encoded in quoted-printable and latin-1
@MohamedAlaa
MohamedAlaa / tmux-cheatsheet.markdown
Last active February 6, 2026 21:35
tmux shortcuts & cheatsheet

tmux shortcuts & cheatsheet

start new:

tmux

start new with session name:

tmux new -s myname
@pake007
pake007 / WordPress on Mac OS X.md
Created December 20, 2011 03:35
Install and Configure WordPress on Mac OS X Snow Leopard Step-By-Step

It is very convenient to install and configure WordPress on Max OS X Snow Leopard or higher version like Lion, because it already builds an apache2 server and php5 in the system, you just need to configure them and your wordpress site can be run!

Install WordPress

  • Download the latest version of WordPress (3.3 as of this writing)

  • Extract and copy the "wordpress" folder to your "Sites" folder. So, in my case the full path to WordPress is: /Users/jimmy/Sites/wordpress you can rename the folder as your wanted.