Awesome post on how to write SQL:

StrictYAML is a type-safe YAML parser built atop ruamel.yaml that parses a restricted subset of the YAML specificaton.

According to the strictyaml author (https://github.com/crdoconnor/strictyaml/blob/master/FAQ.rst#why-is-strictyaml-built-upon-ruamelyaml): “ruamel.yaml is probably the best spec-adhering YAML parser for python.

Unlike pyyaml it does not require the C yaml library to be installed, and it is capable of loading, editing and saving YAML while preserving comments, which pyyaml does not.”

In Python: enjoy the ease of working with your data as ordinary objects in memory.

Data are moved in and out of memory as needed, so databases can be as large as needed.

In Postgres: index and search your data using PostgreSQL, from within your application and externally.

Within your application, search results may be returned as application objects, or as data, depending on your needs.

Transactional and built on mature technology for reliability.

boltons should be builtins.

Boltons is a set of pure-Python utilities in the same spirit as — and yet conspicuously missing from — the the standard library, including:

    Atomic file saving, bolted on with fileutils
    A highly-optimized OrderedMultiDict, in dictutils
    Two types of PriorityQueue, in queueutils
    Chunked and windowed iteration, in iterutils
    A full-featured TracebackInfo type, for representing stack traces, in tbutils
    A lightweight UTC timezone available in timeutils.
    Recursive mapping for nested data transforms, with remap

pyquery allows you to make jquery queries on xml documents. The API is as much as possible the similar to jquery. pyquery uses lxml for fast xml and html manipulation.

This is not (or at least not yet) a library to produce or interact with javascript code. I just liked the jquery API and I missed it in python so I told myself “Hey let’s make jquery in python”. This is the result.

Mopidy is an extensible music server written in Python.

Mopidy plays music from local disk, Spotify, SoundCloud, Google Play Music, and more. You edit the playlist from any phone, tablet, or computer using a range of MPD and web clients.

HTTPie (pronounced aych-tee-tee-pie) is a command line HTTP client. Its goal is to make CLI interaction with web services as human-friendly as possible. It provides a simple http command that allows for sending arbitrary HTTP requests using a simple and natural syntax, and displays colorized output. HTTPie can be used for testing, debugging, and generally interacting with HTTP servers.

Replace cURL with httpie: Thanks to Hening for the hint @PyBerlin!