Articles in writestuff

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 »

Write Stuff about Databases into 2017

TL;DR - Write about databases for Compose, get writing, get better, get published, get visibility, get paid. That's the Write Stuff at Compose. There's a $1000 bonus up for grabs in this cycle of Write Stuff. The Write Stuff project is where we ask y…

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 »

Write about databases and earn with Compose's Write Stuff

Compose's Write Stuff is back for another cycle where you can write articles about databases for Compose's blog for cash and database credits. We're looking for writers, new or experienced, to create articles for us about databases and you'll be rewa…

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 »

How to Write Stuff (about Databases)

Compose has been running the Write Stuff program to find new writing and writers who want to write about databases. We're now at the point of asking why aren't you writing for the Write Stuff. There's a lot of expertise out there, people who know the…

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 »