Mongo but on Postgres and with strong consistency benefits
The Pongo project on GitHub offers a tool for utilizing MongoDB-like syntax on Postgres with strong consistency benefits. It supports data operations in Postgres and provides a MongoDB-compatible shim. Visit the GitHub repository for details.
Read original article
The GitHub URL provided contains information about the Pongo project, which is described as a tool that enables using MongoDB-like syntax on Postgres with strong consistency advantages. Pongo supports features like data insertion, updating, deletion, and retrieval within a Postgres database using its syntax. Additionally, it includes a MongoDB compliant shim for compatibility purposes. For more in-depth information or to explore the project further, you can visit the Pongo GitHub repository at the specified link.
Related
Rust FSM-based Resumable Postgres tasks
The "pg_task" project on GitHub manages FSM-based Resumable Postgres tasks. It features granular state machines, error handling, single-table task scheduling, task definition, execution, stopping, and updating guidelines. Licensed under MIT.
Psycopg 3.2 released – PostgreSQL driver for Python
Psycopg 3.2 release brings Numpy scalar and PostgreSQL parameter format support, async enhancements, and PgBouncer interaction. It emphasizes maintaining crucial Python-PostgreSQL communication, aiding businesses and infrastructures with reliable interaction.
Show HN: WhoDB – Streamlined, Lightweight Database Management with a Sleek UI/UX
WhoDB is a database management tool on GitHub, developed in GoLang for speed. It includes interactive graphs for database schema visualization. Find more details on the WhoDB GitHub Repository.
WhoDB: Lightweight next-gen database explorer
WhoDB is a database management tool by Clidey, written in GoLang. It features interactive graphs for database schema visualization, supporting PostgreSQL, MySQL, SQLite3, MongoDB, and Redis. It aims for Adminer's simplicity with improved user experience and performance. Access the WhoDB GitHub Repository for details.
Just Use Postgres for Everything
The article promotes using Postgres extensively in tech stacks to simplify development, improve scalability, and reduce operational complexity. By replacing various technologies with Postgres, developers can enhance productivity, focus on customer value, and potentially cut costs.
30 commentshttps://gist.github.com/cpursley/c8fb81fe8a7e5df038158bdfe0f...
Postgres was awesome and handled this brilliantly, but the lack of schema and typing killed it. We just ended up fighting data quality the whole time. We couldn't assume that any document had all the required fields, or that they were in a format that made sense e.g. the Price column sometimes had currency symbols, and sometimes commas-and-periods in UK/US format and sometimes in Euro format - sorting by Price involved some complicated parsing of all the records first.
We moved back to relational tables.
I won't say I'd never do this again, but I would definitely not just throw JSON documents to a database and expect good things to happen.
https://blog.stuartspence.ca/2023-05-goodbye-mongo.html
Personally tho, I plan to just drop all similarity to mongo in future projects.
I'm sure there are use cases, I'm just struggling to grasp them. Especially if it's about reusing queries from other projects, AI is pretty good at that
Which is to say JSONB is useful, but I wouldn’t throw the relational baby out with the bath water.
Oracle has a similar library based documents/collections API named SODA, been around for years:
https://docs.oracle.com/en/database/oracle/simple-oracle-doc...
There are separate drivers for Java, node.js, python, REST, etc.
In addition to that, it has Mongo API, which is fully Mongo compatible - you can use standard Mongo tools/drivers against it, without having to change Mongo application code.
Both are for Oracle Database only, and both are free.
Oracle database has had a MongoDB compatible API for a few years now.
How does this handle large files? Is it enough to replace GridFS? One of main attraction for MongoDb is it's handling of large files.
Related
Rust FSM-based Resumable Postgres tasks
The "pg_task" project on GitHub manages FSM-based Resumable Postgres tasks. It features granular state machines, error handling, single-table task scheduling, task definition, execution, stopping, and updating guidelines. Licensed under MIT.
Psycopg 3.2 released – PostgreSQL driver for Python
Psycopg 3.2 release brings Numpy scalar and PostgreSQL parameter format support, async enhancements, and PgBouncer interaction. It emphasizes maintaining crucial Python-PostgreSQL communication, aiding businesses and infrastructures with reliable interaction.
Show HN: WhoDB – Streamlined, Lightweight Database Management with a Sleek UI/UX
WhoDB is a database management tool on GitHub, developed in GoLang for speed. It includes interactive graphs for database schema visualization. Find more details on the WhoDB GitHub Repository.
WhoDB: Lightweight next-gen database explorer
WhoDB is a database management tool by Clidey, written in GoLang. It features interactive graphs for database schema visualization, supporting PostgreSQL, MySQL, SQLite3, MongoDB, and Redis. It aims for Adminer's simplicity with improved user experience and performance. Access the WhoDB GitHub Repository for details.
Just Use Postgres for Everything
The article promotes using Postgres extensively in tech stacks to simplify development, improve scalability, and reduce operational complexity. By replacing various technologies with Postgres, developers can enhance productivity, focus on customer value, and potentially cut costs.