Articles in guest

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 »

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 »

Powering social feeds and timelines with Elasticsearch

Evolving from MongoDB and Redis to Elasticsearch, Campus Discounts' founder and CTO Don Omondi talks about how and why the company made the switch to power their user recommendation feeds. Campus Discounts is a social network where students find and…

Continue reading »

Faster Performance with Unlogged Tables in PostgreSQL

In the first "Addon" article of this cycle of Compose's Write Stuff, Lucero Del Alba takes a look at how to get better performance with PostgreSQL, as long as you aren't too worried about replication and persistence. Do you want to shed light on a f…

Continue reading »

PostgreSQL, Backups and everything you need to know

In his latest Write Stuff article Robert Wysocki explains PostgreSQL backups, how to pick which ones to do and what the pros and cons are. Could you write about databases? Do you need a writing mentor? Would you like to do it with a reward? Check out…

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 »

Introducing Meteor Toys 3, Because Toys Make Life Better

Today we turned over the reins to Max Savin, the creator of Meteor Toys and Aqua. To further help you with your journey of building apps with Meteor, Compose is giving you a 45-day free trial for your hosting your MongoDB database. Introducing Meteor…

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 »

PostgreSQL Bloat: origins, monitoring and managing

In Robert M. Wysocki's latest Write Stuff article, he looks at the wider aspects of monitoring and managing the bloat in PostgreSQL. PostgreSQL's MVCC model provides excellent support for running multiple transactions operating on the same data set.…

Continue reading »