StackShareStackShare
Follow on
StackShare

Discover and share technology stacks from companies around the world.

Follow on

© 2025 StackShare. All rights reserved.

Product

  • Stacks
  • Tools
  • Feed

Company

  • About
  • Contact

Legal

  • Privacy Policy
  • Terms of Service
  1. Stackups
  2. Application & Data
  3. Serverless
  4. Serverless Task Processing
  5. AWS Lambda vs PostgREST

AWS Lambda vs PostgREST

OverviewDecisionsComparisonAlternatives

Overview

AWS Lambda
AWS Lambda
Stacks26.0K
Followers18.8K
Votes432
PostgREST
PostgREST
Stacks59
Followers119
Votes8

AWS Lambda vs PostgREST: What are the differences?

Introduction: In comparing AWS Lambda and PostgREST, it is essential to highlight their key differences to determine which platform suits specific application requirements.

  1. Deployment Model: AWS Lambda operates on a serverless architecture, where the user only pays for the actual compute time used, while PostgREST is designed to be deployed on traditional servers or cloud infrastructure, requiring more management and maintenance overhead.
  2. Use Case: AWS Lambda is primarily used for running serverless functions and event-driven tasks, providing scalability and cost-effectiveness for small to medium applications, whereas PostgREST is ideal for creating RESTful APIs on top of PostgreSQL databases, catering to data-centric applications.
  3. Programming Language Support: AWS Lambda supports multiple programming languages such as Node.js, Python, and Java, allowing developers to choose their preferred language, while PostgREST is specifically designed to work with PostgreSQL, limiting language flexibility to SQL queries and functions.
  4. Scalability: AWS Lambda can scale automatically based on incoming traffic and workload, ensuring high availability and performance, while PostgREST scalability relies on the underlying infrastructure and database configurations, which may require additional optimization.
  5. Cost Structure: AWS Lambda follows a pay-as-you-go pricing model, enabling cost efficiency for sporadic workloads, whereas PostgREST may involve fixed infrastructure costs and database usage fees, making it less suitable for unpredictable or fluctuating workloads.
  6. Maintenance and Monitoring: AWS Lambda includes built-in monitoring and logging tools for tracking function performance and errors, simplifying maintenance tasks, while PostgREST users are responsible for implementing monitoring and logging solutions independently to ensure system health and reliability.

In Summary, the key differences between AWS Lambda and PostgREST lie in their deployment model, use case, programming language support, scalability, cost structure, and maintenance requirements, each catering to distinct application needs and preferences.

Share your Stack

Help developers discover the tools you use. Get visibility for your team's tech choices and contribute to the community's knowledge.

View Docs
CLI (Node.js)
or
Manual

Advice on AWS Lambda, PostgREST

Tim
Tim

CTO at Checkly Inc.

Sep 18, 2019

Needs adviceonHerokuHerokuAWS LambdaAWS Lambda

When adding a new feature to Checkly rearchitecting some older piece, I tend to pick Heroku for rolling it out. But not always, because sometimes I pick AWS Lambda . The short story:

  • Developer Experience trumps everything.
  • AWS Lambda is cheap. Up to a limit though. This impact not only your wallet.
  • If you need geographic spread, AWS is lonely at the top.

The setup

Recently, I was doing a brainstorm at a startup here in Berlin on the future of their infrastructure. They were ready to move on from their initial, almost 100% Ec2 + Chef based setup. Everything was on the table. But we crossed out a lot quite quickly:

  • Pure, uncut, self hosted Kubernetes — way too much complexity
  • Managed Kubernetes in various flavors — still too much complexity
  • Zeit — Maybe, but no Docker support
  • Elastic Beanstalk — Maybe, bit old but does the job
  • Heroku
  • Lambda

It became clear a mix of PaaS and FaaS was the way to go. What a surprise! That is exactly what I use for Checkly! But when do you pick which model?

I chopped that question up into the following categories:

  • Developer Experience / DX 🤓
  • Ops Experience / OX 🐂 (?)
  • Cost 💵
  • Lock in 🔐

Read the full post linked below for all details

357k views357k
Comments
Mark
Mark

Nov 2, 2020

Needs adviceonMicrosoft AzureMicrosoft Azure

Need advice on what platform, systems and tools to use.

Evaluating whether to start a new digital business for which we will need to build a website that handles all traffic. Website only right now. May add smartphone apps later. No desktop app will ever be added. Website to serve various countries and languages. B2B and B2C type customers. Need to handle heavy traffic, be low cost, and scale well.

We are open to either build it on AWS or on Microsoft Azure.

Apologies if I'm leaving out some info. My first post. :) Thanks in advance!

133k views133k
Comments

Detailed Comparison

AWS Lambda
AWS Lambda
PostgREST
PostgREST

AWS Lambda is a compute service that runs your code in response to events and automatically manages the underlying compute resources for you. You can use AWS Lambda to extend other AWS services with custom logic, or create your own back-end services that operate at AWS scale, performance, and security.

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.

Extend other AWS services with custom logic;Build custom back-end services;Completely Automated Administration;Built-in Fault Tolerance;Automatic Scaling;Integrated Security Model;Bring Your Own Code;Pay Per Use;Flexible Resource Model
-
Statistics
Stacks
26.0K
Stacks
59
Followers
18.8K
Followers
119
Votes
432
Votes
8
Pros & Cons
Pros
  • 129
    No infrastructure
  • 83
    Cheap
  • 70
    Quick
  • 59
    Stateless
  • 47
    No deploy, no server, great sleep
Cons
  • 7
    Cant execute ruby or go
  • 3
    Compute time limited
  • 1
    Can't execute PHP w/o significant effort
Pros
  • 4
    Fast, simple, powerful REST APIs from vanilla Postgres
  • 2
    JWT authentication
  • 1
    Declarative role based security at the data layer
  • 1
    Very fast

What are some alternatives to AWS Lambda, PostgREST?

dbForge Studio for MySQL

dbForge Studio for MySQL

It is the universal MySQL and MariaDB client for database management, administration and development. With the help of this intelligent MySQL client the work with data and code has become easier and more convenient. This tool provides utilities to compare, synchronize, and backup MySQL databases with scheduling, and gives possibility to analyze and report MySQL tables data.

dbForge Studio for Oracle

dbForge Studio for Oracle

It is a powerful integrated development environment (IDE) which helps Oracle SQL developers to increase PL/SQL coding speed, provides versatile data editing tools for managing in-database and external data.

dbForge Studio for PostgreSQL

dbForge Studio for PostgreSQL

It is a GUI tool for database development and management. The IDE for PostgreSQL allows users to create, develop, and execute queries, edit and adjust the code to their requirements in a convenient and user-friendly interface.

dbForge Studio for SQL Server

dbForge Studio for SQL Server

It is a powerful IDE for SQL Server management, administration, development, data reporting and analysis. The tool will help SQL developers to manage databases, version-control database changes in popular source control systems, speed up routine tasks, as well, as to make complex database changes.

Liquibase

Liquibase

Liquibase is th leading open-source tool for database schema change management. Liquibase helps teams track, version, and deploy database schema and logic changes so they can automate their database code process with their app code process.

Sequel Pro

Sequel Pro

Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases.

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.

Azure Functions

Azure Functions

Azure Functions is an event driven, compute-on-demand experience that extends the existing Azure application platform with capabilities to implement code triggered by events occurring in virtually any Azure or 3rd party service as well as on-premises systems.

Google Cloud Run

Google Cloud Run

A managed compute platform that enables you to run stateless containers that are invocable via HTTP requests. It's serverless by abstracting away all infrastructure management.

dbForge SQL Complete

dbForge SQL Complete

It is an IntelliSense add-in for SQL Server Management Studio, designed to provide the fastest T-SQL query typing ever possible.

Related Comparisons

Bootstrap
Materialize

Bootstrap vs Materialize

Laravel
Django

Django vs Laravel vs Node.js

Bootstrap
Foundation

Bootstrap vs Foundation vs Material UI

Node.js
Spring Boot

Node.js vs Spring-Boot

Liquibase
Flyway

Flyway vs Liquibase