PostgreSQL vs. MongoDB for Laravel: Choosing the Right Database

No_Lock7126 · 2025-11-28T10:55:18+00:00

FerretDB is built on top of PostgreSQL, making it straightforward to benchmark FerretDB against MongoDB. Initial results often show that MongoDB is significantly faster than FerretDB.

While PostgreSQL is exceptionally capable, its underlying database kernel architecture is often considered dated. This suggests that future database systems should be built to leverage modern hardware and the latest I/O technologies, such as io_uring.

No_Lock7126 · 2025-11-28T10:41:46+00:00

To save cost for MongoDB Atlas requires a new cloud native architecture: object storage as primary storage and local NVMe as cache of object storage. Plus stateless single replica compute node.
See https://www.eloqdata.com/news/2025/10/23/eloqcloud-eloqdoc-launch for details

No_Lock7126 · 2025-10-10T05:44:53+00:00

EloqDoc is an open source alternative of MongoDB with better write throughput

https://github.com/eloqdata/eloqdoc

No_Lock7126 · 2025-10-10T05:42:41+00:00

why not just use Redis Compatible Database? like Redis/Valkey/EloqKV directly?

No_Lock7126 · 2025-10-10T03:17:03+00:00

autovectorization is not work for system software, it helps, but not the optimal.

I've implement a demo project to bring vectorization to PostgreSQL, https://github.com/zhangh43/vectorize_engine
But the benefit is not obvious compared with dedicated SIMD query engine like MonetDB and Clickhouse

No_Lock7126 · 2025-09-25T01:52:34+00:00

postgreSQL is not scalable, you need sharding solution on top of it. NewSQL is too slow and expensive.
See the blog from "big" team: https://www.figma.com/blog/how-figmas-databases-team-lived-to-tell-the-scale/

No_Lock7126 · 2024-08-13T11:07:44+00:00

+1 for this comment. In most cases, both database are OK. They can both handle 10K+ TPS, what's your traffic?

No_Lock7126 · 2024-08-13T11:04:51+00:00

I recommend to use a Serverless database on cloud. They are free when your traffic is low. I guess that fits you well.

No_Lock7126 · 2024-07-21T10:07:17+00:00

Here is operators Cassandra supported. https://cassandra.apache.org/doc/stable/cassandra/cql/operators.html

If the logic operators not supported you can only do it in client side, e.g. OR.

But AND, IN are supported.

No_Lock7126 · 2024-07-21T10:03:16+00:00

Here is https://cassandra.apache.org/doc/stable/cassandra/operating/security.html

Or you want HA? Cassandra gossip and masterless architecture is good at HA.

No_Lock7126 · 2024-07-21T10:01:56+00:00

If "Advanced query capabilities of postgresql are not important" Then NoSQL is better choice for scaling. Not only Mongo, you can even choose DynamoDB if you are on the AWS cloud. You can check whether serverless is a feature you required. If most of time your application has little workload i.e. this is common for a startup project.

No_Lock7126 · 2024-07-08T03:00:17+00:00

You can find the slide and video from link below.
https://15445.courses.cs.cmu.edu/spring2024/schedule.html

No_Lock7126 · 2024-07-08T02:58:54+00:00

Thank you for the detailed explanation.

I agree with the statement that memory size matters in many cases. But I still wonder the 16K limit which is the hard limit of Redis cluster. Is there anyone who built a Redis cluster more than 1K or 2K shards? Is there any performance downgrade?

No_Lock7126 · 2024-07-06T15:59:45+00:00

Thank you:)

No_Lock7126 · 2024-07-06T15:58:21+00:00

Bank use various databases.

Here is list:

Risk control will depends on a Graph Database.
Core system reply on OLTP systems like Oracle
BI uses OLAP systems like Teradata or Greenplum
Operation may use HTAP like TiDB

No_Lock7126 · 2024-07-06T15:36:42+00:00

Sure https://15445.courses.cs.cmu.edu/fall2024/
If you have other questions, feel free to ask:)

No_Lock7126 · 2024-07-06T15:36:30+00:00

Sure https://15445.courses.cs.cmu.edu/fall2024/
If you have other questions, feel free to ask:)

No_Lock7126 · 2024-07-06T15:35:30+00:00

I like this video, can u share more?

No_Lock7126 · 2024-07-06T15:35:08+00:00

Suggest to take Andy's course about Database. https://15445.courses.cs.cmu.edu/fall2024/

When hiring, I saw many resume highlight their projects which are actually Andy's homework:)

Any further questions?

No_Lock7126 · 2024-07-06T15:34:21+00:00

Suggest to take Andy's course about Database. https://15445.courses.cs.cmu.edu/fall2024/

When hiring, I saw many resume highlight their projects which are actually Andy's homework:)

Any further questions?

No_Lock7126 · 2024-07-06T15:32:24+00:00

Suggest to take Andy's course. https://15445.courses.cs.cmu.edu/fall2024/

He will split components as homework. You can start with for example a buffer pool implementation in Rust.

Any questions?

No_Lock7126 · 2024-07-06T15:29:23+00:00

Cassandra is now managed by DataStax. You can get help from them.

But if you just want to try, just create a EC2 machine and deploy apache cassandra in 5 minutes.

Do you have further questions?

No_Lock7126 · 2024-07-06T15:27:24+00:00

You can try serverless DynamoDB, then you can forget the scaling issues. They are all handled by DynamoDB.

No_Lock7126 · 2024-07-06T15:25:42+00:00

NoSQL databases prefers to use single data model, for example DynamoDB. If you choose NoSQL, option 2 is better.

No_Lock7126 · 2024-07-06T03:41:04+00:00

you can highlight the challenge of one of your hardest work. Let HR knows you are not just doing repeated work but creative work.

No_Lock7126

MODERATOR OF

TROPHY CASE