Using JustOneDB

JustOneDB is a general purpose database designed and built for the cloud.

You can interact with your JustOneDB database using either a REST API (documentation is found on the JustOneDB web site) or though a PostgreSQL-compatible interface.

We a full sample ASP.NET MVC application using JustOneDB available here: https://github.com/appharbor/PostgreSQL-Sample-MVC-Application

To generate a valid connectionstring for use with JustOneDB, you can use this snippet:

var uriString = ConfigurationManager.AppSettings["JUSTONEDB_DBI_URL"];
var uri = new Uri(uriString);
var connectionString = string.Format("Server={0};Port={1};Database={2};User Id={3};Password={4};",
    uri.Host, uri.Port, uri.AbsolutePath.Trim('/'), uri.UserInfo.Split(':').First(),
    uri.UserInfo.Split(':').Last());