Software Alternatives, Accelerators & Startups

PostgREST VS ProxySQL

Compare PostgREST VS ProxySQL and see what are their differences

PostgREST logo PostgREST

Automatic REST API for Any Postgres Database

ProxySQL logo ProxySQL

ProxySQL: high-performance, GPL licensed MySQL proxy. It supports hundreds of thousands of concurrent connections and can be multiplexed to hundreds of servers.
  • PostgREST Landing page
    Landing page //
    2022-11-07
  • ProxySQL Landing page
    Landing page //
    2023-05-23

PostgREST videos

[Part 2] Building a Contacts List with PostgREST and Vue.js: The Vue.js App

ProxySQL videos

#ProxySQL Use Case Scenarios - #ProxySQL #Database Tutorial - René Cannaò - #Percona Live 2017

More videos:

  • Review - ProxySQL Use Case Scenarios / Alkin Tezuysal (Percona)
  • Review - Inexpensive Datamasking for MySQL with ProxySQL - data anonymization for developers

Category Popularity

0-100% (relative to PostgREST and ProxySQL)
Databases
37 37%
63% 63
MySQL Tools
0 0%
100% 100
API Tools
100 100%
0% 0
Database Management
32 32%
68% 68

User comments

Share your experience with using PostgREST and ProxySQL. For example, how are they different and which one is better?
Log in or Post with

Social recommendations and mentions

Based on our record, ProxySQL seems to be more popular. It has been mentiond 11 times since March 2021. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.

PostgREST mentions (0)

We have not tracked any mentions of PostgREST yet. Tracking of PostgREST recommendations started around Mar 2021.

ProxySQL mentions (11)

  • PostgreSQL High Availability Solutions – Part 1: Jepsen Test and Patroni
    We use proxysql (https://proxysql.com) which works very well. We have not seen any downtime for years. We wrote our own master promotion code a very long time ago; it has proven to be very robust. - Source: Hacker News / 6 months ago
  • Save Cost on RDS Data Transfer - Internet - Out
    Another option could be ProxySQL, where you can cache queries on the ProxySQL server. Source: about 2 years ago
  • Is replication between v5.1 and v8 possible?
    Also, if you're not using it yet, I can recommend looking at ProxySQL to do your read-write/read-only failover controls. Source: over 2 years ago
  • SSL Termination for SQL
    What are the recommendations here? I took a look into ProxySQL and it looks like since v2, it can do frontend and backend SSL connections. I have it locally working on a docker setup. Source: over 2 years ago
  • Business complexity with performance
    DB: Split you write-read operations. You may scale read as needed. Write operations can be slow if you have too many indices, so make sure to use only the ones you really need. Your DBMS may have some configuration to optimise, for example in MySQL if you do NOT need ACID compliance you can set innodb_flush_log_at_trx_commit = 2 to achieve better write speed. For MySQL you should also look into https://proxysql.com/. Source: over 2 years ago
View more

What are some alternatives?

When comparing PostgREST and ProxySQL, you can also consider the following products

GraphQL - GraphQL is a data query language and runtime to request and deliver data to mobile and web apps.

MariaDB MaxScale - We are the company behind #MariaDB, the fastest growing #opensource #database. Download MariaDB at https://t.co/DtYwuH0FOl.

IntegrateDB.org - The integration database that doesn't smell.

Gonarch Tech - MySQL High Availability as a service

FastAPI - FastAPI is an Open Source, modern, fast (high-performance), web framework for building APIs with Python 3.6+ based on standard Python type hints.

PGLoader - Continuous Migration to PostgreSQL