3 ms·
mm interesting... we have this open Postgres instance (read only) for covid19 research: https://covid19.eng.ox.ac.uk/ https://covid19.eng.ox.ac.uk/ we have it
by dariosalvi78 6y ago
mm interesting... we have this open Postgres instance (read only) for covid19 research: https://covid19.eng.ox.ac.uk/ https://covid19.eng.ox.ac.uk/
we have it running on our own (cheap) server, but we fear we may get overwhelmed by too much traffic if the project becomes very successful. Would this be a solution for us? Is it for free?
- chatmasta 6y agoVery cool! This is a great use case for Splitgraph. We'd be happy to help you deliver that data. The easiest method would probably be for us to proxy queries to your Postgres instance (you can't do this yourself from the website yet, but it's a planned feature, and we can work with you to set it up), and then you could benefit from our connection pooling and caching. Another option would be for you to push the data to Splitgraph as an image (to keep up to date, you can setup a local Splitgraph instance as a PG replication client and periodically `sgr commit` a new image [0]). If you'd like to chat details, feel free to email support@splitgraph.com or join the Discord (https://discord.gg/eFEFRKm https://discord.gg/eFEFRKm). In terms of price, we'll eventually add quotas (storage + server side query execution) on the public tier. But the main monetization will be private deployments. In an ideal world, the private deployments will be able to subsidize the costs of some of the open data on the platform. Certainly we'd like to be able to support projects like this one. [0] https://github.com/splitgraph/splitgraph/tree/master/examples/pg-replication https://github.com/splitgraph/splitgraph/tree/master/example...
- dariosalvi78 6y agoExcellent, thanks a lot for this! I will bring your suggestions to the rest of the team and come back to you via Discord.