Reducing Network Chatter with Firebird Selectable Stored Procedures
Learn how to use Firebird's selectable stored procedures and the SUSPEND keyword to reduce network latency by moving complex business logic into the database layer.
Loading…
ReadMeFeed / Community knowledge
#psql
Real questions. Useful conversations. Find the people who know your stack.
firebirdFirebird PSQL Stored Procedures: Cut Network Round‑Trips and Keep ACID Compliance
Server‑side logic in Firebird with PSQL can replace costly client loops, cut network traffic, and keep ACID compliance. This post walks through a worked example, compares it to client‑side loops, and discusses trade‑offs.
Using Firebird Stored Procedures to Cut Network Traffic and Encapsulate Logic
Learn how Firebird stored procedures (PSQL) can encapsulate business logic, cut network round‑trips, and return multiple result sets—with a practical example and version notes.
Copying postgresql local to remote database (both with password) - ERROR: option "locale" not recognized
Working with Postgres 12 / Windows 10. Trying to copy a remote database to localhost with the following command: pg_dump -C -h remotehost -p 5432 -U postgres remotedb | psql -h localhost -p 5432 -U postgres localdb CMD requests for password 2x. Password for user postgres: Password: I input localhost first, hit ENTER, then input remotehost and hit ENTER again
How to check all roles/user/group_role have what privileges in postgres database?
I have postgres database. I want the list of users with access privileges they are being assigned. I tried to find query and also looked in to psql command line help. (\nu and all) but I haven't found any usefull information. Is anyone knows about that can help me out. Thanks.
postgresql