Projects and sharing

Organize databases in projects and share them.

Projects

Projects group your databases: one for a client, one for your own business, one for personal lists. Every database belongs to exactly one project.

  • You start with a Default Project. New databases go into your first project unless you or your agent name another one.
  • Create, rename and delete projects on your databases page, and move a database to another project from its menu. Agents can do the same with create_project, update_project, delete_project and update_database.
  • Project names are unique, so "Acme" means one thing.
  • Only an empty project can be deleted, and never your last one, so deleting a project never deletes data.

Sharing

You share projects, not single databases. Everyone you share a project with can open and work in every database in it, now and later: in the app, and through their own agents.

  1. Click Share on your databases page, then Invite.
  2. Enter their email address and pick all projects (including ones you create later) or only the projects you choose.
  3. They sign in to Airdash with that email and accept the invitation on their databases page. No email is sent, so tell them it is there.

Your agent can do it too:

Share the Acme project with sam@example.com.

A good agent shows you your projects and asks which to share before it invites anyone.

What collaborators can do

You (owner) Collaborator
Read, add, edit and delete rows Yes Yes
Add and change tables, fields and views Yes Yes
Download a database as SQL Yes Yes
Move a database, restore it, delete it Yes No
Create databases in the shared project Yes Not yet

Moving a database into or out of a shared project changes who can see it. Rows your collaborators write count toward your free plan, since the databases are yours.

Shared with you

Projects others share with you show on your databases page under Shared with you, with who shared them. Agents see these databases in list_databases, marked with shared_by, and get_account lists the invitations waiting for you.

Ending a share

Either side can end it at any time from the Sharing page (or with remove_collaborator). Nothing in the databases changes: the other person just can't open them anymore.