Database — Overview
The database is the structured core of Pachurros. It works for anything you can think of in rows and columns — shot lists, equipment lists, contacts, tasks, budget overviews, image sequences, and more.
What makes up a database
Section titled “What makes up a database”Rows
Entries
Each row is a record — a subject, a task, an appointment, or a contact.
Columns
Properties
Status, date, assignee, file — 30 column types for every use case.
Views
Presentations
Same data shown as a Table, Kanban, Gallery, Calendar, Timeline, Storyboard, Map, Chart, or Form.
You can create as many views of the same database as you like and switch between them freely. The data is always the same — only the presentation changes.
Views at a glance
Section titled “Views at a glance”
Table
Kanban
Gallery
Calendar
Timeline
Storyboard
Map
Chart
Form
| View | Best used for |
|---|---|
| Table | Full overview, many columns visible at once |
| Kanban | Workflow status, task management |
| Gallery | Image-based content, visual overview |
| Calendar | Scheduling, shooting days |
| Timeline | Project duration, phases and milestones |
| Storyboard | Image sequences in order |
| Map | Location-based data, shooting locations |
| Chart | Analytics, status overviews, time series |
| Form | Structured data entry, submissions |
Creating a new database
Section titled “Creating a new database”- Click + New Database in the sidebar
- Give it a name
- Optionally select a starter template
Adding an entry
Section titled “Adding an entry”- In Table view: Click + New Row at the bottom
- In Kanban view: Click + below a column
- In Gallery: Click + New Entry
Opening a row
Section titled “Opening a row”Click on a row (or the open icon) to see the detail view — all fields, comments, and attached media.
Further topics
Section titled “Further topics”- Column types — all 27 types explained
- Configure views — filters, sorting, grouping
- Comments & cells — collaboration at the row level
- Automations — automate workflows (6 triggers, 6 actions, conditions)
- Chart view — bar, donut and line charts
- Form view — structured data entry and submissions
- Calendar subscription (iCal) — subscribe to calendar views
- Upload link — external uploads without an account
- Version history — restore earlier data states