Re: Large scale reliable software system

2023-06-27 Thread Avin Kavish
Well, seeing as postgres isn't designed to serve http requests or to run general purpose code that doesn't involve databases, which you can express elegantly in python, to answer OP's question - my vote is on the original answer - Django. It's got everything out of the box - authentication. file

Re: bug or lacking doc hint

2023-06-25 Thread Avin Kavish
Sounds like the problem you are having is, the server is running out of temporary resources for the operation that users are trying to do. So according to Tom, on the postgres side, the operation cannot be optimized further. I think you have few choices here, - See if increasing the resources

Accessing referential constraint information with minimal permissions

2023-06-24 Thread Avin Kavish
Hello, I want to programmatically read all the references in a database. Ideally, I want to do it with read-only permissions to the table. Is it possible? I know the information is in `information_schema.referential_constraints`, but apparently reading that information requires having write