2

I have a REST API around a PostgreSQL database, the API was built using the Django REST Framework (python). I have access to the PostgreSQL database and the API, but I'm not allowed to modify the django/python code.

My first approach is to make, kind of, an HTTP POST request via a trigger every time a new record is created in PostgreSQL. I found this but seems like it's not the best way to do what I need.

In the Neo4j side, I'm thinking of a periodic HTTP GET request to the API from within a cypher function, but does not exist such thing.

Community
  • 1
  • 1
Jorge E. Hernández
  • 2,800
  • 1
  • 26
  • 50

1 Answers1

3

You should use the APOC procedures for integrating with other DBs via JDBC. PostgreSQL is supported.

You can also use APOC procedures like apoc.periodic.schedule or apoc.periodic.countdown to periodically execute a Cypher query in the background.

Sascha Wolf
  • 18,810
  • 4
  • 51
  • 73
cybersam
  • 63,203
  • 6
  • 53
  • 76