Alternatives to Preql logo

Alternatives to Preql

GraphQL, Oracle PL/SQL, Oracle PL/SQL, Prisma, and JSON API are the most popular alternatives and competitors to Preql.
1
6
+ 1
0

What is Preql and what are its top alternatives?

It is an interpreted, relational programming language, that specializes in database queries. It is designed for use by data engineers, analysts and data scientists.
Preql is a tool in the Query Languages category of a tech stack.
Preql is an open source tool with GitHub stars and GitHub forks. Here鈥檚 a link to Preql's open source repository on GitHub

Top Alternatives to Preql

  • 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. ...

  • Oracle PL/SQL

    Oracle PL/SQL

    It is a powerful, yet straightforward database programming language. It is easy to both write and read, and comes packed with lots of out-of-the-box optimizations and security features. ...

  • Oracle PL/SQL

    Oracle PL/SQL

    It is a powerful, yet straightforward database programming language. It is easy to both write and read, and comes packed with lots of out-of-the-box optimizations and security features. ...

  • Prisma

    Prisma

    Prisma is an open-source database toolkit. It replaces traditional ORMs and makes database access easy with an auto-generated query builder for TypeScript & Node.js. ...

  • JSON API

    JSON API

    It is most widely used data format for data interchange on the web. This data interchange can happen between two computers applications at different geographical locations or running within same hardware machine. ...

  • Graphene

    Graphene

    Graphene is a Python library for building GraphQL schemas/types fast and easily. ...

  • JsonAPI

    JsonAPI

    t is a format that works with HTTP. A main goal of the specification is to optimize HTTP requests both in terms of the number of requests and the size of data packages exchanged between clients and servers. ...

  • PostGraphile

    PostGraphile

    Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database ...

Preql alternatives & related posts

GraphQL logo

GraphQL

18.8K
15.1K
290
A data query language and runtime
18.8K
15.1K
+ 1
290
PROS OF GRAPHQL
  • 69
    Schemas defined by the requests made by the user
  • 62
    Will replace RESTful interfaces
  • 58
    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
    Type system
  • 2
    Easy setup
  • 2
    GraphiQL
  • 2
    Fetch different resources in one request
  • 2
    Ease of client creation
  • 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.js
GraphQL
MongoDB

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 | 42 upvotes 路 1.5M 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
Oracle PL/SQL logo

Oracle PL/SQL

460
339
6
It is a combination of SQL along with the procedural features of programming languages
460
339
+ 1
6
PROS OF ORACLE PL/SQL
  • 1
    Not mysql
  • 1
    Massive, continuous investment by Oracle Corp
  • 1
    Multiple ways to accomplish the same end
  • 1
    Extensible to external langiages
  • 1
    Pl/sql
  • 1
    Powerful
CONS OF ORACLE PL/SQL
  • 1
    High commercial license cost

related Oracle PL/SQL posts

Oracle PL/SQL logo

Oracle PL/SQL

460
339
6
It is a combination of SQL along with the procedural features of programming languages
460
339
+ 1
6
PROS OF ORACLE PL/SQL
  • 1
    Not mysql
  • 1
    Massive, continuous investment by Oracle Corp
  • 1
    Multiple ways to accomplish the same end
  • 1
    Extensible to external langiages
  • 1
    Pl/sql
  • 1
    Powerful
CONS OF ORACLE PL/SQL
  • 1
    High commercial license cost

related Oracle PL/SQL posts

Prisma logo

Prisma

288
474
31
Modern Database Access for TypeScript & Node.js
288
474
+ 1
31
PROS OF PRISMA
  • 6
    Open Source
  • 5
    Auto-generated query builder
  • 5
    Type-safe database access
  • 4
    Increases confidence during development
  • 4
    Productive application development
  • 4
    Built specifically for Postgres and TypeScript
  • 3
    Supports multible database systems
  • 0
    Supports multible RDBMSs
CONS OF PRISMA
  • 1
    Doesn't support downward/back migrations

related Prisma posts

Divine Bawa
at PayHub Ghana Limited | 15 upvotes 路 277.7K views

I just finished a web app meant for a business that offers training programs for certain professional courses. I chose this stack to test out my skills in graphql and react. I used Node.js , GraphQL , MySQL for the #Backend utilizing Prisma as a database interface for MySQL to provide CRUD APIs and graphql-yoga as a server. For the #frontend I chose React, styled-components for styling, Next.js for routing and SSR and Apollo for data management. I really liked the outcome and I will definitely use this stack in future projects.

See more
Munkhtegsh Munkhbat
Software Engineer Consultant at LoanSnap | 9 upvotes 路 109.3K views

In my last side project, I built a web posting application that has similar features as Facebook and hosted on Heroku. The user can register an account, create posts, upload images and share with others. I took an advantage of graphql-subscriptions to handle realtime notifications in the comments section. Currently, I'm at the last stage of styling and building layouts.

For the #Backend I used graphql-yoga, Prisma, GraphQL with PostgreSQL database. For the #FrontEnd: React, styled-components with Apollo. The app is hosted on Heroku.

See more
JSON API logo

JSON API

145
129
0
One of many data formats that is often applied to REST
145
129
+ 1
0
PROS OF JSON API
    Be the first to leave a pro
    CONS OF JSON API
      Be the first to leave a con

      related JSON API posts

      Graphene logo

      Graphene

      86
      117
      0
      GraphQL framework for Python
      86
      117
      + 1
      0
      PROS OF GRAPHENE
      • 0
        Will replace RESTful interfaces
      • 0
        The future of API's
      CONS OF GRAPHENE
        Be the first to leave a con

        related Graphene posts

        Malthe J酶rgensen

        We recently switched from MongoDB and the Python library MongoEngine to PostgreSQL and Django in order to:

        • Better leverage GraphQL (using the Graphene library)
        • Allow us to use the autogenerated Django admin interface
        • Allow better performance due to the way some of our pages present data
        • Give us more a mature stack in the form of Django replacing MongoEngine, which we had some issues with in the past.

        MongoDB was hosted on mlab, and we now host Postgres on Amazon RDS .

        See more
        Michael Mota
        Founder at AlterEstate | 6 upvotes 路 44.3K views

        We recently implemented GraphQL because we needed to build dynamic reports based on the user preference and configuration, this was extremely complicated with our actual RESTful API, the code started to get harder to maintain but switching to GraphQL helped us to to build beautiful reports for our clients that truly help them make data-driven decisions.

        Our goal is to implemented GraphQL in the whole platform eventually, we are using Graphene , a python library for Django .

        See more
        JsonAPI logo

        JsonAPI

        73
        70
        0
        A specification for building apis in json
        73
        70
        + 1
        0
        PROS OF JSONAPI
          Be the first to leave a pro
          CONS OF JSONAPI
            Be the first to leave a con

            related JsonAPI posts

            PostGraphile logo

            PostGraphile

            69
            159
            35
            Instant GraphQL API for your PostgreSQL database; use standalone or as a Node.js middleware; MIT-licensed OSS
            69
            159
            + 1
            35
            PROS OF POSTGRAPHILE
            • 7
              Postgres based authentication
            • 5
              Great developer support
            • 4
              Simple to set up and scale
            • 4
              Bye bye Resolvers
            • 4
              Lightning fast
            • 4
              Database first with no braking changes
            • 2
              Back to database first
            • 2
              Instant production ready GraphQL
            • 1
              9 Automatically generates your GraphQL schema
            • 1
              Easy setup of relationships and permissions
            • 1
              Works with new and existing databases
            CONS OF POSTGRAPHILE
              Be the first to leave a con

              related PostGraphile posts

              Obsaa Abdalhalim
              CEO, Founder at Kafali PAY inc. | 1 upvote 路 242.1K views

              React Native NativeBase redux-saga Apollo GraphQL Node.js PostGraphile PostgreSQL PubNub . @PLAID Dwolla.js . Zube GitHub Yarn npm AWS Elastic Beanstalk

              See more