Difference between ThingWorx PostgreSQL(Thingworx comp) and ThingWorx Edge.

[Sri1]

What is the difference between ThingWorx-Platform-Postgres-8-3-9(Thingworx composer) and ThingWorx Edge?

Also if i need to connect Thingworx composer to Mysql server should i use "ThingWorx PostgreSQL" or is there and other version ideally suitable.

[eliotlandrum · Accepted solution]

Hello @Sri1 !

The Platform doesn't support MySQL for the back end data (all your configuration data about your model and application) at this time. However, it does support it as a relational database for SQL queries and interactions with Things. You can see how to set that up using this support article: How to connect MySQL with ThingWorx. You can install the Platform with PostgreSQL for the configuration data and then add the MySQL connectivity to access existing databases you might have.

Edge is a tool to run on Linux devices like a Raspberry Pi to connect to a Platform instance.