AnchorTag Development

Indexed Queries of Nested Object Arrays in ArangoDB

ArangoDB supports indexed nested object arrays, but without some planning and profiling, it may not use your indices.

Configuring PostgreSQL Backups Using pg_dump and AzCopy

A good backup strategy is essential to any database. Recently, we implemented a simple PostgreSQL backup using pg_dump and AzCopy on Ubuntu 18.

Databases

Self Hosting PostgreSQL 12.x on Azure

AWS RDS and Azure Database for PostgreSQL are excellent offerings, but can quickly escalate in price as databases grow. Hosting Postgres on VMs takes effort, but may be a valuable cost-saving alternative with greater flexibility to customize the database.

Databases

Relational Query With Joins Performance in PostgreSQL vs ArangoDB

ArangoDB outperformed Postgres in our relational join tests by an order of magnitude

DevOps

Accessing IP Restricted Azure Databases from CircleCI

CircleCI is a simple, yet powerful Continuous Integration platform, but it doesn't provide any guarantees or even tight ranges on outbound traffic IP addresses.

Databases

Installing PostgreSQL 12 on Ubuntu

Postgres is an excellent database, but, as of now, version 12 is two months old and the Installation Instructions are still based on Postgres 11.