News for hackers. Stuff that matters.
Re:FedNow Is Live by iknownothow on Thursday July 20, 2023 @03:46PM (#36805760)
The problem is, which "database"? If you know the data is always going to be in the range of ~1TB, use Postgres or some other ACID database. But I don't know of any petabyte scale ACID compliant database.

Also I'm not sure if ACID is sufficient or not for banking systems.

Re:FedNow Is Live by ZeroCool2u on Thursday July 20, 2023 @04:02PM (#36805948)
BigQuery is ACID compliant and easily handles petabytes.

https://cloud.google.com/bigquery/docs/introduction

Re:FedNow Is Live by ibains on Thursday July 20, 2023 @04:07PM (#36806002)
Yes, but in addition to being ACID compliant (serializable ANSI), you need to support a million transactions per second - it’s not just about data size.
Re:FedNow Is Live by moneywoes on Thursday July 20, 2023 @06:54PM (#36807878)
What’s the cloud infra like?
Re:FedNow Is Live by 89vision on Thursday July 20, 2023 @04:51PM (#36806581)
Nobody in their right mind is using BQ for oltp workloads
Re:FedNow Is Live by chaxor on Thursday July 20, 2023 @05:49PM (#36807208)
Any database easily handles terabytes, idk why that's a condition.

DuckDB and SQLite easily handle terabytes of data. They're just not so much for cloud based apps, or things that need multiusers and access control junk. They're the best choice for just about everything else though.

Re:FedNow Is Live by sjdmdlakziggy on Thursday July 20, 2023 @07:14PM (#36808080)
Generally speaking, you won't find financial institutions using Postgres for core line of business databases.
Re:FedNow Is Live by joeblubaugh on Thursday July 20, 2023 @11:02PM (#36809525)
What will they be using? A similar SQL database that has a big vendor behind it like Oracle, or something else?