5 ms·
Ask HN: Are there any SaaS services that access your database directly?
For example, you have a Postgres database and for some reason you also need data from some third-party app elsewhere, say, GitHub.
For practical reasons you need the GitHub data inside your database, so you need to build system that fetches the data periodically, or a system that handles GitHub webhooks, and update your database accordingly.
Now we can imagine that could be a service that handled this "sync" part for you, fetching data from GitHub and updating it directly in your database.
The question is: is it a normal practice to do this? Does it exist somewhere? What are the problems of this approach?
- benologist 12y agoI came across this this morning: http://www.tray.io http://www.tray.io via an article on TC: http://techcrunch.com/2015/04/16/tray-io-raises-2-2m-for-an-ifttt-style-integration-marketplace-to-connect-enterprise-apps/ http://techcrunch.com/2015/04/16/tray-io-raises-2-2m-for-an-... I'm guessing there are some annoying problems around 3rd party quality / stability / undocumented or unofficial APIs.
- dkasper 12y agoLooker is a good example http://www.looker.com/product/data http://www.looker.com/product/data
- Avalaxy 12y agoThis is what enterprise application integration is all about.
- anthony_franco 12y agoKISSMetrics does the reverse, they bring your DB data into their service directly. But it's essentially the same setup. http://support.kissmetrics.com/integrations/mysql/index.html http://support.kissmetrics.com/integrations/mysql/index.html
- jackgolding 12y agoLooking at doing the same thing with GA and a few other sources.
- fiatjaf 12y agoDo you want to provide a service that fetches data from GA API and saves it at others' databases? Or are you looking for this service?
- iroot 12y agoMake sure to grant only select privileges on the database. Don't grant any privileges on sensitive information tables.