Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I have several databases that I'd like to access from an API I'm deploying. The databases are stored in the following postgres table:
api-node-referenced-data
I currently have many different SQL queries that are used to access the tables, but I'd like to change them all to a parameterised query in Python to avoid repeated manual work. However, I can't find any documentation on this topic.
Is it possible to use Python to access the postgres SQL database from a deployed API?
I am not sure what you mean by โdatabases stored on Postgres tablesโ. In Postgres you can have databases and these databases can have tables which store data.
With regards to connecting to Postgres from a deployed API in the API node this can certainly be done. There are several ways to do this so it will depend on how you want to architecture it: