Alternatives to Airpal logo

Alternatives to Airpal

Superset, Slick, Sequel Pro, PostGIS, and Open PostgreSQL Monitoring are the most popular alternatives and competitors to Airpal.
15
54
+ 1
0

What is Airpal and what are its top alternatives?

A web-based query execution tool built on top of Facebook's PrestoDB.
Airpal is a tool in the Database Tools category of a tech stack.
Airpal is an open source tool with 2.6K GitHub stars and 457 GitHub forks. Here’s a link to Airpal's open source repository on GitHub

Airpal alternatives & related posts

related Superset posts

Julien DeFrance
Julien DeFrance
Principal Software Engineer at Tophatter · | 16 upvotes · 844.1K views
atSmartZipSmartZip
Rails
Rails
Rails API
Rails API
AWS Elastic Beanstalk
AWS Elastic Beanstalk
Capistrano
Capistrano
Docker
Docker
Amazon S3
Amazon S3
Amazon RDS
Amazon RDS
MySQL
MySQL
Amazon RDS for Aurora
Amazon RDS for Aurora
Amazon ElastiCache
Amazon ElastiCache
Memcached
Memcached
Amazon CloudFront
Amazon CloudFront
Segment
Segment
Zapier
Zapier
Amazon Redshift
Amazon Redshift
Amazon Quicksight
Amazon Quicksight
Superset
Superset
Elasticsearch
Elasticsearch
Amazon Elasticsearch Service
Amazon Elasticsearch Service
New Relic
New Relic
AWS Lambda
AWS Lambda
Node.js
Node.js
Ruby
Ruby
Amazon DynamoDB
Amazon DynamoDB
Algolia
Algolia

Back in 2014, I was given an opportunity to re-architect SmartZip Analytics platform, and flagship product: SmartTargeting. This is a SaaS software helping real estate professionals keeping up with their prospects and leads in a given neighborhood/territory, finding out (thanks to predictive analytics) who's the most likely to list/sell their home, and running cross-channel marketing automation against them: direct mail, online ads, email... The company also does provide Data APIs to Enterprise customers.

I had inherited years and years of technical debt and I knew things had to change radically. The first enabler to this was to make use of the cloud and go with AWS, so we would stop re-inventing the wheel, and build around managed/scalable services.

For the SaaS product, we kept on working with Rails as this was what my team had the most knowledge in. We've however broken up the monolith and decoupled the front-end application from the backend thanks to the use of Rails API so we'd get independently scalable micro-services from now on.

Our various applications could now be deployed using AWS Elastic Beanstalk so we wouldn't waste any more efforts writing time-consuming Capistrano deployment scripts for instance. Combined with Docker so our application would run within its own container, independently from the underlying host configuration.

Storage-wise, we went with Amazon S3 and ditched any pre-existing local or network storage people used to deal with in our legacy systems. On the database side: Amazon RDS / MySQL initially. Ultimately migrated to Amazon RDS for Aurora / MySQL when it got released. Once again, here you need a managed service your cloud provider handles for you.

Future improvements / technology decisions included:

Caching: Amazon ElastiCache / Memcached CDN: Amazon CloudFront Systems Integration: Segment / Zapier Data-warehousing: Amazon Redshift BI: Amazon Quicksight / Superset Search: Elasticsearch / Amazon Elasticsearch Service / Algolia Monitoring: New Relic

As our usage grows, patterns changed, and/or our business needs evolved, my role as Engineering Manager then Director of Engineering was also to ensure my team kept on learning and innovating, while delivering on business value.

One of these innovations was to get ourselves into Serverless : Adopting AWS Lambda was a big step forward. At the time, only available for Node.js (Not Ruby ) but a great way to handle cost efficiency, unpredictable traffic, sudden bursts of traffic... Ultimately you want the whole chain of services involved in a call to be serverless, and that's when we've started leveraging Amazon DynamoDB on these projects so they'd be fully scalable.

See more
Slick logo

Slick

7.9K
58
0
7.9K
58
+ 1
0
Database query and access library for Scala
    Be the first to leave a pro
    Slick logo
    Slick
    VS
    Airpal logo
    Airpal
    Sequel Pro logo

    Sequel Pro

    240
    169
    63
    240
    169
    + 1
    63
    MySQL database management for Mac OS X
    Sequel Pro logo
    Sequel Pro
    VS
    Airpal logo
    Airpal
    PostGIS logo

    PostGIS

    194
    143
    28
    194
    143
    + 1
    28
    Open source spatial database
    PostGIS logo
    PostGIS
    VS
    Airpal logo
    Airpal
    Open PostgreSQL Monitoring logo

    Open PostgreSQL Monitoring

    136
    109
    0
    136
    109
    + 1
    0
    Oversee and Manage Your PostgreSQL Servers
      Be the first to leave a pro
      Open PostgreSQL Monitoring logo
      Open PostgreSQL Monitoring
      VS
      Airpal logo
      Airpal

      related Flyway posts

      Miguel Suarez
      Miguel Suarez
      Lead Developer · | 8 upvotes · 125.5K views
      atJobsrepublicJobsrepublic
      Flyway
      Flyway
      Liquibase
      Liquibase
      PostgreSQL
      PostgreSQL
      #Migration
      #Backwards-compatible

      Flyway vs Liquibase #Migration #Backwards-compatible

      We were looking for a tool to help us integrating the migration scripts as part of our Deployment. At first sight both tools look very alike, are well integrated with Spring, have a fairly frequent development activity and short release cycles.

      Liquibase puts a lot of emphasis on independence with the DB, allowing you to create the scripts on formats like JSON and YML, abstracting away from SQL, which it's also supported. Since we only work with one DB type across services we wouldn't take much advantage of this feature.

      Flyway on the other hand has the advantage on being actively working on the integration with PostgreSQL 11, for it's upcoming version 6. Provides a more extensive set of properties that allow us to define what's allowed on what's not on each different environment.

      Instead of looking for a tool that will allow us to rollback our DB changes automatically, we decided to implement backwards-compatible DB changes, for example adding a new column instead of renaming an existing one, postponing the deletion of the deprecated column until the release has been successfully installed.

      See more
      DataGrip logo

      DataGrip

      113
      53
      0
      113
      53
      + 1
      0
      A database IDE for professional SQL developers
        Be the first to leave a pro
        DataGrip logo
        DataGrip
        VS
        Airpal logo
        Airpal
        Liquibase logo

        Liquibase

        112
        122
        33
        112
        122
        + 1
        33
        Source control for your database
        Liquibase logo
        Liquibase
        VS
        Airpal logo
        Airpal

        related Liquibase posts

        Miguel Suarez
        Miguel Suarez
        Lead Developer · | 8 upvotes · 125.5K views
        atJobsrepublicJobsrepublic
        Flyway
        Flyway
        Liquibase
        Liquibase
        PostgreSQL
        PostgreSQL
        #Migration
        #Backwards-compatible

        Flyway vs Liquibase #Migration #Backwards-compatible

        We were looking for a tool to help us integrating the migration scripts as part of our Deployment. At first sight both tools look very alike, are well integrated with Spring, have a fairly frequent development activity and short release cycles.

        Liquibase puts a lot of emphasis on independence with the DB, allowing you to create the scripts on formats like JSON and YML, abstracting away from SQL, which it's also supported. Since we only work with one DB type across services we wouldn't take much advantage of this feature.

        Flyway on the other hand has the advantage on being actively working on the integration with PostgreSQL 11, for it's upcoming version 6. Provides a more extensive set of properties that allow us to define what's allowed on what's not on each different environment.

        Instead of looking for a tool that will allow us to rollback our DB changes automatically, we decided to implement backwards-compatible DB changes, for example adding a new column instead of renaming an existing one, postponing the deletion of the deprecated column until the release has been successfully installed.

        See more
        Spring Data logo

        Spring Data

        111
        68
        0
        111
        68
        + 1
        0
        Provides a consistent approach to data access – relational, non-relational, map-reduce, and beyond
          Be the first to leave a pro
          Spring Data logo
          Spring Data
          VS
          Airpal logo
          Airpal
          MySQL WorkBench logo

          MySQL WorkBench

          106
          58
          0
          106
          58
          + 1
          0
          A unified visual tool for database architects, developers, and DBAs
            Be the first to leave a pro
            MySQL WorkBench logo
            MySQL WorkBench
            VS
            Airpal logo
            Airpal
            Microsoft SQL Server Management Studio logo

            Microsoft SQL Server Management Studio

            101
            51
            0
            101
            51
            + 1
            0
            An integrated environment for managing any SQL infrastructure
              Be the first to leave a pro
              Microsoft SQL Server Management Studio logo
              Microsoft SQL Server Management Studio
              VS
              Airpal logo
              Airpal
              Knex.js logo

              Knex.js

              82
              97
              20
              82
              97
              + 1
              20
              SQL query builder for Postgres, MySQL, MariaDB, SQLite3, and Oracle
              Knex.js logo
              Knex.js
              VS
              Airpal logo
              Airpal

              related Knex.js posts

              Tim Nolet
              Tim Nolet
              Founder, Engineer & Dishwasher at Checkly · | 20 upvotes · 380.7K views
              atChecklyHQChecklyHQ
              Heroku
              Heroku
              Docker
              Docker
              GitHub
              GitHub
              Node.js
              Node.js
              hapi
              hapi
              Vue.js
              Vue.js
              AWS Lambda
              AWS Lambda
              Amazon S3
              Amazon S3
              PostgreSQL
              PostgreSQL
              Knex.js
              Knex.js
              vuex
              vuex

              Heroku Docker GitHub Node.js hapi Vue.js AWS Lambda Amazon S3 PostgreSQL Knex.js Checkly is a fairly young company and we're still working hard to find the correct mix of product features, price and audience.

              We are focussed on tech B2B, but I always wanted to serve solo developers too. So I decided to make a $7 plan.

              Why $7? Simply put, it seems to be a sweet spot for tech companies: Heroku, Docker, Github, Appoptics (Librato) all offer $7 plans. They must have done a ton of research into this, so why not piggy back that and try it out.

              Enough biz talk, onto tech. The challenges were:

              • Slice of a portion of the functionality so a $7 plan is still profitable. We call this the "plan limits"
              • Update API and back end services to handle and enforce plan limits.
              • Update the UI to kindly state plan limits are in effect on some part of the UI.
              • Update the pricing page to reflect all changes.
              • Keep the actual processing backend, storage and API's as untouched as possible.

              In essence, we went from strictly volume based pricing to value based pricing. Here come the technical steps & decisions we made to get there.

              1. We updated our PostgreSQL schema so plans now have an array of "features". These are string constants that represent feature toggles.
              2. The Vue.js frontend reads these from the vuex store on login.
              3. Based on these values, the UI has simple v-if statements to either just show the feature or show a friendly "please upgrade" button.
              4. The hapi API has a hook on each relevant API endpoint that checks whether a user's plan has the feature enabled, or not.

              Side note: We offer 10 SMS messages per month on the developer plan. However, we were not actually counting how many people were sending. We had to update our alerting daemon (that runs on Heroku and triggers SMS messages via AWS SNS) to actually bump a counter.

              What we build is basically feature-toggling based on plan features. It is very extensible for future additions. Our scheduling and storage backend that actually runs users' monitoring requests (AWS Lambda) and stores the results (S3 and Postgres) has no knowledge of all of this and remained unchanged.

              Hope this helps anyone building out their SaaS and is in a similar situation.

              See more
              Tim Nolet
              Tim Nolet
              Founder, Engineer & Dishwasher at Checkly · | 10 upvotes · 64.5K views
              atChecklyHQChecklyHQ
              PostgreSQL
              PostgreSQL
              Heroku
              Heroku
              Heroku Postgres
              Heroku Postgres
              Node.js
              Node.js
              Knex.js
              Knex.js

              PostgreSQL Heroku Heroku Postgres Node.js Knex.js

              Last week we rolled out a simple patch that decimated the response time of a Postgres query crucial to Checkly. It quite literally went from an average of ~100ms with peaks to 1 second to a steady 1ms to 10ms.

              However, that patch was just the last step of a longer journey:

              1. I looked at what API endpoints were using which queries and how their response time grew over time. Specifically the customer facing API endpoints that are directly responsible for rendering the first dashboard page of the product are crucial.

              2. I looked at the Heroku metrics such as those reported by heroku pg:outlier and cross references that with "slowest response time" statistics.

              3. I reproduced the production situation as best as possible on a local development machine and test my hypothesis that an composite index on a uuid field and a timestampz field would reduce response times.

              This method secured the victory and we rolled out a new index last week. Response times plummeted. Read the full story in the blog post.

              See more
              phpMyAdmin logo

              phpMyAdmin

              78
              41
              3
              78
              41
              + 1
              3
              A free software, for MySQL and MariaDB
              phpMyAdmin logo
              phpMyAdmin
              VS
              Airpal logo
              Airpal
              GraphiQL logo

              GraphiQL

              61
              54
              4
              61
              54
              + 1
              4
              An in-browser IDE for exploring GraphQL
              GraphiQL logo
              GraphiQL
              VS
              Airpal logo
              Airpal

              related GraphiQL posts

              Jerome Dalbert
              Jerome Dalbert
              Senior Backend Engineer at StackShare · | 4 upvotes · 58.5K views
              GraphQL
              GraphQL
              GraphiQL
              GraphiQL
              Insomnia REST Client
              Insomnia REST Client
              #REST
              #Api

              Postman is a nice desktop #REST #API client that allows you to save requests for later use. But it does not really support GraphQL, which I use everyday at work. So it was time to look for something else.

              GraphiQL is a nice toy that has a desktop client, but you cannot save requests in any organized way. Most other clients I tried were either sluggish, didn't save requests, or didn't support cookies. Lack of cookie support is a no-no for work because we use session-based authentication in our internal API.

              Then I stumbled upon Insomnia REST Client, and it clicked! Cookies work, GraphQL support is pretty good, UI looks nice and goes straight to the point. The only thing it lacks is a schema explorer, but I can always use GraphiQL if I ever need one, which is almost never.

              Overall, I am very happy with it, and would recommend it to anyone seriously working with GraphQL. Insomnia is a godsend!

              See more
              Active Admin logo

              Active Admin

              50
              39
              12
              50
              39
              + 1
              12
              The administration framework for Ruby on Rails applications
              Active Admin logo
              Active Admin
              VS
              Airpal logo
              Airpal
              Android Room logo

              Android Room

              48
              43
              0
              48
              43
              + 1
              0
              Save data in a local database
                Be the first to leave a pro
                Android Room logo
                Android Room
                VS
                Airpal logo
                Airpal
                Postico logo

                Postico

                43
                30
                12
                43
                30
                + 1
                12
                A modern PostgreSQL client for OS X
                Postico logo
                Postico
                VS
                Airpal logo
                Airpal
                MongoDB Compass logo

                MongoDB Compass

                42
                22
                0
                42
                22
                + 1
                0
                A GUI for MongoDB
                  Be the first to leave a pro
                  MongoDB Compass logo
                  MongoDB Compass
                  VS
                  Airpal logo
                  Airpal
                  MongoDB Cloud Manager logo

                  MongoDB Cloud Manager

                  37
                  36
                  0
                  37
                  36
                  + 1
                  0
                  A hosted platform for managing MongoDB
                    Be the first to leave a pro
                    MongoDB Cloud Manager logo
                    MongoDB Cloud Manager
                    VS
                    Airpal logo
                    Airpal