Abdullah Alger

Articles by Abdullah Alger

Abdullah Alger is a content creator at Compose. Moved from academia to the forefront of cloud technology.

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 »

GeoFile: Everything in the Radius with MongoDB Geospatial Queries

GeoFile is a series dedicated to looking at geographical data, its features, and uses. In this article, we’ll continue our discussion of getting locations within a radius, but apply it to GeoJSON documents and MongoDB. We’ll be setting up 2dsphere in…

Continue reading »

Improved Performance for Redis Cache Mode on Compose

tl;dr - We've boosted the reliability of Cache Mode on Compose by disabling backups and persistence by default on all Redis deployments using that mode. But if you need them enabled, all you need to do is turn it on. We made some changes recently to…

Continue reading »

Database Management Tools and Compose for MySQL

Since the launching of Compose for MySQL, we’ve shown how to connect to your deployment using the command line and various connection drivers. However, there are times when you may want to dive deeper into your database without having to run a series…

Continue reading »

Connecting applications to Compose for MySQL

At Compose, we focus on making databases accessible and easy. Since launching Compose for MySQL in beta, we've discussed how to set up a MySQL deployment and connect to it from the command line. Now, we are going to look connecting your applications…

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 »

Connecting to Compose for MySQL

With Compose for MySQL now available as a beta, you'll be eager to get up and running with it. Here, we'll walk through how to set up a deployment and securely connect to it. We will take you from provisioning your own MySQL database to connecting to…

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 »