Skip to content

Instantly share code, notes, and snippets.

@hnuzhoulin
hnuzhoulin / sqlalchemy_engine.md
Last active August 29, 2015 14:21
使用sqlalchemy连接各类数据库时engine格式

通用格式

dialect+driver://username:password@host:port/database

Postgresql

The Postgresql dialect uses psycopg2 as the default DBAPI. pg8000 is also available as a pure-Python substitute;详情见

# default
    engine = create_engine('postgresql://scott:tiger@localhost/mydatabase')
# psycopg2
@hnuzhoulin
hnuzhoulin / python_resources.md
Created May 10, 2015 05:40 — forked from jookyboi/python_resources.md
Python-related modules and guides.

Packages

  • lxml - Pythonic binding for the C libraries libxml2 and libxslt.
  • boto - Python interface to Amazon Web Services
  • Django - Django is a high-level Python Web framework that encourages rapid development and clean, pragmatic design.
  • Fabric - Library and command-line tool for streamlining the use of SSH for application deployment or systems administration task.
  • PyMongo - Tools for working with MongoDB, and is the recommended way to work with MongoDB from Python.
  • Celery - Task queue to distribute work across threads or machines.
  • pytz - pytz brings the Olson tz database into Python. This library allows accurate and cross platform timezone calculations using Python 2.4 or higher.

Guides

@hnuzhoulin
hnuzhoulin / 0_reuse_code.js
Last active August 29, 2015 14:20
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console