We at adjust recently started to use Elixir. We built a couple of small services using the Phoenix framework which successfully went live. In this blogpost I’d like to talk about, I’d say, the most undiscussed topic when it comes to Elixir — deployment.
In the mobile world, deeplinking is a technology that launches an app and opens a specific page once a user clicks a URL on a web page or in another app. We will dive into the details of implementing deeplinking for your app in this article.
Inspired by the PostgreSQL key/value data-type
hstore, we developed the
istore extension with
support for operators like
+ and aggregates like
SUM for semi-structured integer-based data.
hstore allows arbitrary textual-data as its keys and values, in an
both keys and values are represented and stored as integers. Therefore
istore fits nicely in an
analytical workload. User journeys, cohort or funnel data, distributional data and many other
scenarios can be efficiently modeled and stored in PostgreSQL using
The extension comes with two data types:
bigistore, the former having
int and the
bigint as values; keys being
int for both. This article demonstrates the efficiency of
istore and some of its applications through two examples - aggregating logs and analyzing event
In Part III about Writing Postgres Extensions we fixed a serious bug
using LLDB debugger and completed the
base36 type by using type casts.
Now it’s time to recover what we’ve actually achieved – and to do some more testing.
In the last post about Writing Postgres Extensions we created a new data type
base36 from ground up. However we left with a serious bug causing our server to crash.
Now let’s hunt that bug down with a debugger and complete the testsuite.
In the last post about Writing Postgres Extensions, we covered the basics of extending PostgresSQL with extension. Now it’s time for the fun part – developing our own type.
Postgres has a ton of features and offers a wide range of data types, functions, operators, and aggregates. But sometimes it’s just not enough for your use case. Luckily, it’s easy to extend Postgres’ functionality through extension. So why not write your own?
One of Postgres’ most powerful features is its extensibility. Although Postgres offers a large number of data types, functions, operators, and aggregates, sometimes you may still want more. Postgres itself already comes with a large amount of additional extensions. Even more can be installed through the PostgreSQL Extension Network and if that is not enough for you, you can also write your own.
However, there isn’t a standard tool for managing Postgres dependencies in applications. To avoid falling into the dependency hell and to enable lean extension development, we developed pgbundle - the Postgres extension management tool.
This article will show you how to create a network with 5 virtual machines which have public IP addresses and can be accessed via Internet. Virtual machines will run on Gentoo.