Question about where to deploy the business logics for data processing

2023-06-08 Thread Nim Li
Hello. We have a PostgreSQL database with many tables, as well as foreign table, dblink, triggers, functions, indexes, etc, for managing the business logics of the data within the database. We also have a custom table for the purpose of tracking the slowly changing dimensions (type 2). Currently

How To: A large [2D] matrix, 100,000+ rows/columns

2023-06-08 Thread Pat Trainor
Experts, A very high level question... Subject sums it up. I love PGSQL, but I don't know if it is a good fit for this back-end... I hope it is. Imagine something akin to stocks, where you have a row for every stock, and a column for every stock. Except where the same stock is the row & col, a