Proof of concept for notifications from postgresql implemented in different languages with performance comparison.
Prerequisities and setup Running posgreSQL with this parameters
Username: postgres Password: password port: 5432 database name: postgres
Run Notifications\PostgreSQL\SchemaAndTrigger.sql
Start C#, Java or python server (or combination)
Open Notifications\Frontend\dist\index.html
Click to icon for connection to websocket
Run massive data test:
Notifications\PostgreSQL\MassiveDataTestScript.sql
Or soak test: Use of DBInsertion utility
- You need to have maven running on your computer
- open command line
- find the directory DBInsertion
- mvn package (to build the project)
- mvn exec:java -Dexec.args=""