PostgreSQL Optimisation Specialist Needed
Budget: $3,000 – $5,000 USD
1) We hade a PsgSQL database with ticker data. We need to create another streaming data table with 1 min aggregate. Data table should update constantly, ideally each time ticker dateable is added with data
2) We need to write ports to the SQL data table to allow LAN connection to SQL from local network (other virtual machines connected by VM Oracle). Including Python connection
3) We need to write ports to the SQL data table to allow internet connection
4) We need instrument to add historical 1 min data to the database created on stage 1
5) We need Python script that will connect to 1 min data base and get top 5 instilments by price change from all instruments present in 1 min database
Bot check: write price for each part from 1-5
2) We need to write ports to the SQL data table to allow LAN connection to SQL from local network (other virtual machines connected by VM Oracle). Including Python connection
3) We need to write ports to the SQL data table to allow internet connection
4) We need instrument to add historical 1 min data to the database created on stage 1
5) We need Python script that will connect to 1 min data base and get top 5 instilments by price change from all instruments present in 1 min database
Bot check: write price for each part from 1-5