Alternatives to PostgREST logo

Alternatives to PostgREST

GraphQL, Slick, Spring Data, DataGrip, and Microsoft SQL Server Management Studio are the most popular alternatives and competitors to PostgREST.
50
100
+ 1
8

What is PostgREST and what are its top alternatives?

PostgREST serves a fully RESTful API from any existing PostgreSQL database. It provides a cleaner, more standards-compliant, faster API than you are likely to write from scratch.
PostgREST is a tool in the Database Tools category of a tech stack.
PostgREST is an open source tool with 18.1K GitHub stars and 832 GitHub forks. Here’s a link to PostgREST's open source repository on GitHub

Top Alternatives to PostgREST

  • GraphQL

    GraphQL

    GraphQL is a data query language and runtime designed and used at Facebook to request and deliver data to mobile and web apps since 2012. ...

  • Slick

    Slick

    It is a modern database query and access library for Scala. It allows you to work with stored data almost as if you were using Scala collections while at the same time giving you full control over when a database access happens and which data is transferred. ...

  • Spring Data

    Spring Data

    It makes it easy to use data access technologies, relational and non-relational databases, map-reduce frameworks, and cloud-based data services. This is an umbrella project which contains many subprojects that are specific to a given database. ...

  • DataGrip

    DataGrip

    A cross-platform IDE that is aimed at DBAs and developers working with SQL databases. ...

  • Microsoft SQL Server Management Studio

    Microsoft SQL Server Management Studio

    It is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. It provides tools to configure, monitor, and administer instances of SQL Server and databases. Use it to deploy, monitor, and upgrade the data-tier components used by your applications, as well as build queries and scripts. ...

  • PostGIS

    PostGIS

    PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL. ...

  • DBeaver

    DBeaver

    It is a free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc. ...

  • MySQL WorkBench

    MySQL WorkBench

    It enables a DBA, developer, or data architect to visually design, model, generate, and manage databases. It includes everything a data modeler needs for creating complex ER models, forward and reverse engineering, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort. ...

PostgREST alternatives & related posts

GraphQL logo

GraphQL

22.7K
18.4K
292
A data query language and runtime
22.7K
18.4K
+ 1
292
PROS OF GRAPHQL
  • 69
    Schemas defined by the requests made by the user
  • 62
    Will replace RESTful interfaces
  • 59
    The future of API's
  • 47
    The future of databases
  • 12
    Self-documenting
  • 11
    Get many resources in a single request
  • 5
    Ask for what you need, get exactly that
  • 4
    Query Language
  • 3
    Evolve your API without versions
  • 3
    Fetch different resources in one request
  • 3
    Type system
  • 2
    GraphiQL
  • 2
    Ease of client creation
  • 2
    Easy setup
  • 1
    Good for apps that query at build time. (SSR/Gatsby)
  • 1
    Backed by Facebook
  • 1
    Easy to learn
  • 1
    "Open" document
  • 1
    Better versioning
  • 1
    Standard
  • 1
    1. Describe your data
  • 1
    Fast prototyping
CONS OF GRAPHQL
  • 3
    Hard to migrate from GraphQL to another technology
  • 3
    More code to type.
  • 1
    Works just like any other API at runtime
  • 1
    Takes longer to build compared to schemaless.

related GraphQL posts

Shared insights
on
Node.jsNode.jsGraphQLGraphQLMongoDBMongoDB

I just finished the very first version of my new hobby project: #MovieGeeks. It is a minimalist online movie catalog for you to save the movies you want to see and for rating the movies you already saw. This is just the beginning as I am planning to add more features on the lines of sharing and discovery

For the #BackEnd I decided to use Node.js , GraphQL and MongoDB:

  1. Node.js has a huge community so it will always be a safe choice in terms of libraries and finding solutions to problems you may have

  2. GraphQL because I needed to improve my skills with it and because I was never comfortable with the usual REST approach. I believe GraphQL is a better option as it feels more natural to write apis, it improves the development velocity, by definition it fixes the over-fetching and under-fetching problem that is so common on REST apis, and on top of that, the community is getting bigger and bigger.

  3. MongoDB was my choice for the database as I already have a lot of experience working on it and because, despite of some bad reputation it has acquired in the last months, I still believe it is a powerful database for at least a very long list of use cases such as the one I needed for my website

See more
Nick Rockwell
SVP, Engineering at Fastly · | 44 upvotes · 1.7M views

When I joined NYT there was already broad dissatisfaction with the LAMP (Linux Apache HTTP Server MySQL PHP) Stack and the front end framework, in particular. So, I wasn't passing judgment on it. I mean, LAMP's fine, you can do good work in LAMP. It's a little dated at this point, but it's not ... I didn't want to rip it out for its own sake, but everyone else was like, "We don't like this, it's really inflexible." And I remember from being outside the company when that was called MIT FIVE when it had launched. And been observing it from the outside, and I was like, you guys took so long to do that and you did it so carefully, and yet you're not happy with your decisions. Why is that? That was more the impetus. If we're going to do this again, how are we going to do it in a way that we're gonna get a better result?

So we're moving quickly away from LAMP, I would say. So, right now, the new front end is React based and using Apollo. And we've been in a long, protracted, gradual rollout of the core experiences.

React is now talking to GraphQL as a primary API. There's a Node.js back end, to the front end, which is mainly for server-side rendering, as well.

Behind there, the main repository for the GraphQL server is a big table repository, that we call Bodega because it's a convenience store. And that reads off of a Kafka pipeline.

See more
Slick logo

Slick

8.7K
694
0
Database query and access library for Scala
8.7K
694
+ 1
0
PROS OF SLICK
    Be the first to leave a pro
    CONS OF SLICK
      Be the first to leave a con

      related Slick posts

      Spring Data logo

      Spring Data

      453
      315
      0
      Provides a consistent approach to data access – relational, non-relational, map-reduce, and beyond
      453
      315
      + 1
      0
      PROS OF SPRING DATA
        Be the first to leave a pro
        CONS OF SPRING DATA
          Be the first to leave a con

          related Spring Data posts

          Остап Комплікевич

          I need some advice to choose an engine for generation web pages from the Spring Boot app. Which technology is the best solution today? 1) JSP + JSTL 2) Apache FreeMarker 3) Thymeleaf Or you can suggest even other perspective tools. I am using Spring Boot, Spring Web, Spring Data, Spring Security, PostgreSQL, Apache Tomcat in my project. I have already tried to generate pages using jsp, jstl, and it went well. However, I had huge problems via carrying already created static pages, to jsp format, because of syntax. Thanks.

          See more
          DataGrip logo

          DataGrip

          373
          396
          14
          A database IDE for professional SQL developers
          373
          396
          + 1
          14
          PROS OF DATAGRIP
          • 4
            Works on Linux, Windows and MacOS
          • 2
            Wide range of DBMS support
          • 1
            Code completion
          • 1
            Generate ERD
          • 1
            Quick-fixes using keyboard shortcuts
          • 1
            Code analysis
          • 1
            Database introspection on 21 different dbms
          • 1
            Export data using a variety of formats using open api
          • 1
            Import data
          • 1
            Diff viewer
          CONS OF DATAGRIP
            Be the first to leave a con

            related DataGrip posts

            Microsoft SQL Server Management Studio logo

            Microsoft SQL Server Management Studio

            366
            282
            0
            An integrated environment for managing any SQL infrastructure
            366
            282
            + 1
            0
            PROS OF MICROSOFT SQL SERVER MANAGEMENT STUDIO
              Be the first to leave a pro
              CONS OF MICROSOFT SQL SERVER MANAGEMENT STUDIO
                Be the first to leave a con

                related Microsoft SQL Server Management Studio posts

                Kelsey Doolittle

                We have a 138 row, 1700 column database likely to grow at least a row and a column every week. We are mostly concerned with how user-friendly the graphical management tools are. I understand MySQL has MySQL WorkBench, and Microsoft SQL Server has Microsoft SQL Server Management Studio. We have about 6 months to migrate our Excel database to one of these DBMS, and continue (hopefully manually) importing excel files from then on. Any tips appreciated!

                See more
                PostGIS logo

                PostGIS

                315
                309
                29
                Open source spatial database
                315
                309
                + 1
                29
                PROS OF POSTGIS
                • 24
                  De facto GIS in SQL
                • 5
                  Good Documentation
                CONS OF POSTGIS
                  Be the first to leave a con

                  related PostGIS posts

                  DBeaver logo

                  DBeaver

                  311
                  394
                  51
                  A Universal Database Tool
                  311
                  394
                  + 1
                  51
                  PROS OF DBEAVER
                  • 14
                    Free
                  • 11
                    Platform independent
                  • 8
                    Automatic driver download
                  • 6
                    Import-Export Data
                  • 4
                    Simple to use
                  • 4
                    Wide range of DBMS support
                  • 4
                    Move data between databases
                  • 1
                    SAP Hana DB support
                  • 1
                    Themes
                  CONS OF DBEAVER
                    Be the first to leave a con

                    related DBeaver posts

                    Manikandan Shanmugam
                    Software Engineer at Blitzscaletech Software Solution · | 4 upvotes · 191.6K views
                    Shared insights
                    on
                    AzureDataStudioAzureDataStudioDBeaverDBeaver

                    Which tools are preferred if I choose to work on more data side? Which one is good if I decide to work on web development? I'm using DBeaver and am now considering a move to AzureDataStudio to break the monotony while working. I would like to hear your opinion. Which one are you using, and what are the things you are missing in dbeaver or data studio.

                    See more
                    MySQL WorkBench logo

                    MySQL WorkBench

                    296
                    472
                    22
                    A unified visual tool for database architects, developers, and DBAs
                    296
                    472
                    + 1
                    22
                    PROS OF MYSQL WORKBENCH
                    • 6
                      Simple
                    • 5
                      Easy to use
                    • 5
                      Free
                    • 4
                      Clean UI
                    • 2
                      Administration and monitoring module
                    CONS OF MYSQL WORKBENCH
                      Be the first to leave a con

                      related MySQL WorkBench posts

                      I'm learning SQL thru UDEMY and I'm trying to DL My SQL onto my machine, but when I get to the terminal, that's where I encounter my issues- nothing can be found. If I use SQLPro Studio for the course, is it better? I ask because MySQL WorkBench integrates with SQLPro Studio. I just want to get certified and start working again.

                      See more
                      Kelsey Doolittle

                      We have a 138 row, 1700 column database likely to grow at least a row and a column every week. We are mostly concerned with how user-friendly the graphical management tools are. I understand MySQL has MySQL WorkBench, and Microsoft SQL Server has Microsoft SQL Server Management Studio. We have about 6 months to migrate our Excel database to one of these DBMS, and continue (hopefully manually) importing excel files from then on. Any tips appreciated!

                      See more