Articles in postgresql

Metrics Maven: Mode d'Emploi - Finding the Mode in PostgreSQL

In our Metrics Maven series, Compose's data scientist shares database features, tips, tricks, and code you can use to get the metrics you need from your data. In this article, we'll have a look at mode to round out our series on mean, median, and mod…

Continue reading »

PostGraphQL: PostgreSQL meets GraphQL

GraphQL is a data query language that provides a flexible syntax for client applications to describe how data is consumed. The basic idea behind GraphQL is that, rather than consuming the data specified by the server, it's the client that specifies t…

Continue reading »

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 »

DataLayer: Storage Wars - The Art Genome Project

As you can see DataLayer Conf was full of great talks and this next one is no exception. Daniel Doubrovkine, CEO of Artsy.net and 2016 Ruby prize award nominee, took the stage. Daniel presented Artsy.net's Art Genome Project, a classification system…

Continue reading »

NewsBits - SQL Server on Linux, CockroachDB, Citus 6.0, PostgreSQL parallelism, Linux entryism and more

The Compose NewsBits for the week ending November 18th - Microsoft's SQL Server is surprising on Linux, CockroachDB talks stability, Citus 6.0 is ready for multiple occupants, PostgreSQL serialization trips parallelisation, Linux gets opened with the…

Continue reading »

NewsBits - Not Yet MongoDB 3.4, Encrypted PostgreSQL, SQLPad, Rust, Ruby, Go and more

Compose NewsBits for the week ending November 11th - No, MongoDB 3.4 hasn't been released, encrypting PostgreSQL instances, a pad for your SQL, the latest in Rust, Ruby 2.4 progresses, Go is seven years old, Homebrew gets an update, Lagom starts to t…

Continue reading »

NewsBits - Scylla 1.4 released, Datastax/Cassandra diverge, pgAdmin 4 updated, Amazon Linux for all and more

Compose NewsBits for the week ending November 4th - Scylla 1.4 builds on monitoring and tracing, Datastax unhooks itself from the Cassandra development train, pgAdmin 4's first update, Amazon's Linux AMI for all, updated curl, npmjs.org vs Microsoft'…

Continue reading »

Metrics Maven: Meet in the Middle - Median in PostgreSQL

In our Metrics Maven series, Compose's data scientist shares database features, tips, tricks, and code you can use to get the metrics you need from your data. In this article we'll cozy-up to calculating a median in PostgreSQL. To set the stage for m…

Continue reading »

GeoFile: Everything in the Radius with PostGIS

GeoFile is a series dedicated to looking at geographical data, its features and uses. In this article, we build upon our last discussion of getting the distance between two points, and now move to getting all data points within a specified radius. On…

Continue reading »