Alternatives to Open PostgreSQL Monitoring logo

Alternatives to Open PostgreSQL Monitoring

Slick, Sequel Pro, PostGIS, Flyway, and Spring Data are the most popular alternatives and competitors to Open PostgreSQL Monitoring.
137
109
+ 1
0

What is Open PostgreSQL Monitoring and what are its top alternatives?

Open PostgreSQL Monitoring is a free software designed to help you manage your PostgreSQL servers.
Open PostgreSQL Monitoring is a tool in the Database Tools category of a tech stack.
Open PostgreSQL Monitoring is an open source tool with 148 GitHub stars and 10 GitHub forks. Here’s a link to Open PostgreSQL Monitoring's open source repository on GitHub

Open PostgreSQL Monitoring alternatives & related posts

Slick logo

Slick

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

    Sequel Pro

    241
    169
    63
    241
    169
    + 1
    63
    MySQL database management for Mac OS X
    Sequel Pro logo
    Sequel Pro
    VS
    Open PostgreSQL Monitoring logo
    Open PostgreSQL Monitoring
    PostGIS logo

    PostGIS

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

    related Flyway posts

    Miguel Suarez
    Miguel Suarez
    Lead Developer · | 8 upvotes · 138.7K 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

    124
    76
    0
    124
    76
    + 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
      Open PostgreSQL Monitoring logo
      Open PostgreSQL Monitoring
      DataGrip logo

      DataGrip

      119
      55
      0
      119
      55
      + 1
      0
      A database IDE for professional SQL developers
        Be the first to leave a pro
        DataGrip logo
        DataGrip
        VS
        Open PostgreSQL Monitoring logo
        Open PostgreSQL Monitoring

        related Liquibase posts

        Miguel Suarez
        Miguel Suarez
        Lead Developer · | 8 upvotes · 138.7K 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
        MySQL WorkBench logo

        MySQL WorkBench

        111
        69
        0
        111
        69
        + 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
          Open PostgreSQL Monitoring logo
          Open PostgreSQL Monitoring
          Microsoft SQL Server Management Studio logo

          Microsoft SQL Server Management Studio

          110
          63
          0
          110
          63
          + 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
            Open PostgreSQL Monitoring logo
            Open PostgreSQL Monitoring

            related Knex.js posts

            Tim Nolet
            Tim Nolet
            Founder, Engineer & Dishwasher at Checkly · | 20 upvotes · 412.8K 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 · 74K 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

            79
            43
            3
            79
            43
            + 1
            3
            A free software, for MySQL and MariaDB
            phpMyAdmin logo
            phpMyAdmin
            VS
            Open PostgreSQL Monitoring logo
            Open PostgreSQL Monitoring
            GraphiQL logo

            GraphiQL

            62
            55
            4
            62
            55
            + 1
            4
            An in-browser IDE for exploring GraphQL
            GraphiQL logo
            GraphiQL
            VS
            Open PostgreSQL Monitoring logo
            Open PostgreSQL Monitoring

            related GraphiQL posts

            Jerome Dalbert
            Jerome Dalbert
            Senior Backend Engineer at StackShare · | 4 upvotes · 67.7K 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
            Android Room logo

            Android Room

            50
            44
            0
            50
            44
            + 1
            0
            Save data in a local database
              Be the first to leave a pro
              Android Room logo
              Android Room
              VS
              Open PostgreSQL Monitoring logo
              Open PostgreSQL Monitoring
              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
              Open PostgreSQL Monitoring logo
              Open PostgreSQL Monitoring
              MongoDB Compass logo

              MongoDB Compass

              44
              25
              0
              44
              25
              + 1
              0
              A GUI for MongoDB
                Be the first to leave a pro
                MongoDB Compass logo
                MongoDB Compass
                VS
                Open PostgreSQL Monitoring logo
                Open PostgreSQL Monitoring
                MongoDB Cloud Manager logo

                MongoDB Cloud Manager

                37
                42
                0
                37
                42
                + 1
                0
                A hosted platform for managing MongoDB
                  Be the first to leave a pro
                  MongoDB Cloud Manager logo
                  MongoDB Cloud Manager
                  VS
                  Open PostgreSQL Monitoring logo
                  Open PostgreSQL Monitoring
                  HeidiSQL logo

                  HeidiSQL

                  34
                  23
                  0
                  34
                  23
                  + 1
                  0
                  GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
                    Be the first to leave a pro
                    HeidiSQL logo
                    HeidiSQL
                    VS
                    Open PostgreSQL Monitoring logo
                    Open PostgreSQL Monitoring