Can CartoDB read from tables/data hosted on a local machine and not necessarily uploaded to CartoDB's website?
If you absolutely must host it yourself you will need a specific version of Ubuntu and very specific versions of Ruby, Python, Node, Postgres and GIS libraries. It's a huge hassle and the documentation ranges from non-existent to out of date.
I set it up for a client once who insisted that everything be in house, despite being warned of the complexity. Now a year later he has an out of date version of CartoDB and is realizing that he should've just paid for the service.
TLDR: Yes, you can host it locally, but it's a huge task.
CartoDB is primarly offered as SAAS (Software as a Service) and their basic offerings are hosted. This means that if you have any of these accounts: http://cartodb.com/pricing/ then you cannot host it on your own server.
However if you'd purchase Enterprise edition http://cartodb.com/enterprise/, then it is possible to host CartoDB on your own machine. This is called
- "On-premise" You can install CartoDB on your servers so all code is stored on machines that you manage yourself
hope this helps Radek
For example, I tried an automated OSM install script and it failed with PosgreSQL version conflicts (9.3 installed from CartoDB and the script assumed 9.1). I had to revert to installing OSM manually using other instructions that also had some issues with the instructions for Apache2.
It can be done. It is not easy. I have about 20 years of on and off Unix experience and have only rarely used Linux and it took me about 2 man weeks of effort to get it all working. The good thing is that I now have a VMWare image I can clone for production.
My motivation for the local solution is that I needed an in-flight data system in areas that I could not depend on an Internet connection.