Articles in postgresql

NewsBits - PostgreSQL Tips, RethinkDB post-mortem, Go IDE, and more

NewsBits for the week ending January 20th: Some PostgreSQL tips and SSL news, the RethinkDB post-mortem, a JetBrains Go IDE announced, and a brief comparison of some Functional Javascript systems. NewsBits is database news, developer news, cloud news…

Continue reading »

NewsBits - MongoDB ransoms, Python and PostgreSQL, Eagles and Beams and more

NewsBits for the week ending January 13th: MongoDB ransoms continue, picking the right PostgreSQL/Python driver, Apache Eagle and Beam are now full Apache projects, the best of The Morning Paper, Go 1.8 RC1 is here, automatically making your JavaScri…

Continue reading »

Metrics Maven: Calculating a Weighted Average 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 look at how to calculate a weighted average. Building on one of our…

Continue reading »

Store Result Sets with Materialized Views in PostgreSQL

Lucero Del Alba talks about using PostgreSQL's materialized views to process large amounts of data without slowing down your database in this new Write Stuff article, showing how to efficiently create, access, update, and delete them. In this article…

Continue reading »

DataLayer: Partial Indexing for Improved Query Performance

PostgreSQL is able to let you index just a subset of your data if that's what your application in interested in. The feature is called partial indexes and it allows you to essentially add a where clause to your indexes. Chris Erwin shares some of his…

Continue reading »

NewsBits - MySQL, Redis, Elasticsearch, PostgreSQL, CentOS, CoreOS and more

NewsBits for the week ending December 16 - MySQL Group Replication is now GA, Redis 4.0 RCs, Modules and Loglog changes, GoRethink needs a new maintainer, Elasticsearch's Java REST, PostgreSQL indexes, CentOS Linux 7 lands, CoreOS changes name, Linux…

Continue reading »

NewsBits- RethinkDB, PostgreSQL 10, Elastic 5.1.1, Database Security, Python 3.6, TypeScript 2.1 and 4-bit Z80s

NewsBits for the week ending December 9th - An update on RethinkDB's new world, developments in PostgreSQL 10, ElasticSearch jumps to 5.1.1, a reminder as to why you should secure your application and database, the latest in Python 3, why TypeScript…

Continue reading »

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 »