Local versus remote connectivity

This page is a capture in the next bucket of the product backlog — a pre-sprint idea, not yet pulled into a sprint as a story.

In some cases it makes sense to use the UI directly against the database - for example, users may just want to create a simple setup to play around and the complexity of having to have a server is not helpful. In addition, they may not even require a full blown postgres - sqlite is enough. It should be possible to setup a connection to a database in this manner. Ideally the client should support both at the same time.