How to make friends PostgreSQL and MS SQL on the same server?

Question

Python

Good time of the day. It is installed on the MS SQL 2008 + 2012 server. There was a task to install software with PostgreSQL embedded on the server. I wondered about their friendship and possible troubles. Can anyone advise?

Answer 1

In your specific case, then:

>>> test = "[{'tzid': '000000000', 'phone': '000000', 'service': 'test', 'status': 'TZ_NUM_PREPARE'}]"
>>> import json
>>> print(json.loads(test.replace("'", '"')))
[{'tzid': '000000000', 'phone': '000000', 'service': 'test', 'status': 'TZ_NUM_PREPARE'}]
>>> print(json.loads(test.replace("'", '"'))[0]['tzid'])
000000000

JSON is still incorrect.

Answer 2

It's not JSON. Double quotes in JSON

In [6]: x = '[{"tzid": "000000000", "phone": "000000", "service": "test", "statu
   ...: s": "TZ_NUM_PREPARE"}]'

In [7]: x
Out[7]: '[{"tzid": "000000000", "phone": "000000", "service": "test", "status": "TZ_NUM_PREPARE"}]'

In [8]: json.loads(x)
Out[8]: 
[{'tzid': '000000000',
  'phone': '000000',
  'service': 'test',
  'status': 'TZ_NUM_PREPARE'}]

Answer 3

what exactly is the problem?
they do not interact with each other and do not interfere with each other (except for the consumption of resources).

Answer 4

Trouble will be if, for example, postgres is given a non-standard port for some reason, and this port is used by ms sql. With the default settings, there shouldn't be any problems.