Skip to content
Search

Pongo

lastmod 2024-07-11created 2024-07-111 edits

Pongo - Mongo but on Postgres and with strong consistency benefits

Mongo with Strong Consistency, built on Postgres

Features

  • Pongo uses JSONB support to treat PostgreSQL as a document database
    • JSONB stores JSON data in a binary format, improving performance and storage efficiency
  • PostgreSQL JSONB's binary format means data is pre-parsed, enabling fast reads and writes
    • JSONB supports advanced indexing options such as GIN and GiST indexes, improving search speed
    • JSONB lets you store semi-structured data while using PostgreSQL's powerful query features
  • Is Pongo an ORM?
    • No. It focuses on handling the characteristics of document data effectively
    • Node.js ORMs can handle JSONB, but advanced queries require using JSONPath or JSONB functions
    • Pongo handles this for you
  • Is it production ready?
  • Currently safe to use, but not 100% compatible with MongoDB
  • Pongo is a new project, so some features may be missing
  • It is a community project; if you find a problem, contributing extended support or test coverage via GH issues or Pull Requests is encouraged

GN⁺'s summary

  • Pongo is a tool that uses PostgreSQL as a document database by translating the MongoDB API into PostgreSQL queries
  • Uses the benefits of JSONB to improve performance and storage efficiency
  • Supports advanced queries and indexing, providing flexibility and consistency
  • Pongo is not an ORM; it focuses on handling the characteristics of document data effectively
  • A new project, so some features may be missing, but it can be extended through community contributions

See also

Favorite site

author Zer0 sitemap