Articles in Python

Building OHLC Data in PostgreSQL

In this Write Stuff article, Lucero Del Alba illustrates the power of PostgreSQL's aggregate and date functions to analyze financial data, and shows you how to display the results in a web browser using TechanJS. OHLC charts (open, high, low, close)…

Continue reading »

Using PostgreSQL through SQLAlchemy

In this Write Stuff article, Gareth Dwyer writes about using SQLAlchemy, a Python SQL toolkit and ORM, discussing the advantages of using it while performing database operations. He shows the differences between using raw SQL and using an ORM, and gi…

Continue reading »

The Potency of Idempotent with RabbitMQ and MongoDB Upsert

Designing with possible failure in mind is a good strategy when building with distributed systems. The cloud is a distributed system. Latency, network failures, service end points changing and such are to be expected. If you don't expect them, well,…

Continue reading »

A tour of the Redis stars

On the Redis site is a page that lists Redis clients for various languages. It's very extensive, covering clients that work with languages as diverse as emacs lisp, GNU Prolog, Haskell and C#. Throughout the list, some clients have a star next to the…

Continue reading »

Formatted SQL in Python with Psycopg’s Mogrify

In this Compose Write Stuff Addon, Lucero Del Alba takes a look at the problem of viewing queries sent to a server, and how to solve this problem by using Psycopg's mogrify. Do you want to shed light on a favorite feature in your preferred database?…

Continue reading »

Getting Started with Compose's ScyllaDB

Getting started with ScyllaDB is easy since it is a drop in replacement for Apache's Cassandra database. For all intents and purposes, Scylla looks just like Cassandra to your code. So much so that Scylla even uses Cassandra's drivers. The main diffe…

Continue reading »

Compose's Little Bits 43 - PostgreSQL updates and beta, Markets, Queues, Fast.com, Open vSwitch and more

Security updates for PostgreSQL and a new 9.6 beta, what next for the database market, job queues for RethinkDB, how they made Fast.com fast, Open vSwitch's new home, PyPy gets Mozilla money, Linux's TCP Stack problem, are your secrets safe in a secu…

Continue reading »

Schema migrations with Alembic, Python and PostgreSQL

In his latest Write Stuff article, Gigi Sayfan takes a dive into database migrations with an Alembic Tour-de-Force. Database schema migrations are the bane of agile development and continuous deployment. Some migrations can be trivial if you just add…

Continue reading »

Building a dynamic configuration service with etcd and Python

A dive into etcd and the creation of a Python library to manage dynamic configuration are the subject of Gigi Sayfan's latest Write Stuff article. Building robust and performant distributed systems is hard. The main reason is that typically everythin…

Continue reading »

Loading Google Analytics data to PostgreSQL using Python

Do you have Google Analytics data you'd like to load to a database for better reporting and analysis? We do. Here's a proof-of-concept script for accessing Google Analytics data and loading it to PostgreSQL using Python. Join us on the journey. The S…

Continue reading »