Skip to content
Pachurros Help

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 List Kanban Gallery Calendar Timeline Storyboard Map Chart Form
ViewBest used for
TableFull overview, many columns visible at once
ListCompact single-line overview with inline fields
KanbanWorkflow status, task management
GalleryImage-based content, visual overview
CalendarScheduling, shooting days
TimelineProject duration, phases and milestones
StoryboardImage sequences in order
MapLocation-based data, shooting locations
ChartAnalytics, status overviews, time series
FormStructured data entry, submissions

A content plan brings two views of its own: the Composer for writing posts and the Feed preview.

Creating a new database

Section titled “Creating a new database”
  1. + New → New table (or the + next to Tables in the sidebar)
  2. Give it a name and optionally choose a project
  3. Under Template, pick a starting point: Blank, a template from the categories, Copy from table (takes over the columns, without entries) or With Ølav (describe what you need)
  4. Click Create table

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

Large tables

Section titled “Large tables”

Tables with many thousands of rows (tested up to about 20,000) open and scroll smoothly. Pachurros always loads the whole table so that filters, totals, export, metrics, shares, calendar subscriptions and offline access stay complete, but only draws what you are looking at.

In list, gallery, kanban, storyboard, timeline, the calendar list and the content plan, entries arrive in sections: at the bottom you see something like “100 of 20,000 shown” with Show … more, and scrolling loads the next section by itself. Counts and totals in the headers still count everything.

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.

Exporting

Section titled “Exporting”

Under ⋯ → Export there are three ways:

WayResult
As Excel.xlsx: plain number columns stay numbers Excel can compute with
As CSV.csv with BOM so Excel reads umlauts correctly
With attachments (ZIP)bundle of Excel and CSV plus every file

What gets exported is what the active view shows: its filters, its sorting, its visible columns. References resolve to plain names: a relation becomes the linked row’s title, a person their name, a select its label.

With attachments

Section titled “With attachments”

Files and images attached to rows travel along as real files:

Invoices.zip
├── Invoices.xlsx
├── Invoices.csv
└── Anhänge/
    ├── 001 Invoice Meier/invoice.pdf
    ├── 001 Invoice Meier/receipt.jpg
    └── 002 Invoice Huber/contract.pdf

One folder per row, named after its title with a running number; that number is also the row number in the sheet, so you can get from row to file. If two attachments of the same row share a name, the column is added.

While bundling, the menu shows progress (“3/12”). If a file is missing the export still completes and adds a FEHLENDE-DATEIEN.txt list: an export that fails over one deleted file would be worse than one that brings 99 of 100.

Archiving a table

Section titled “Archiving a table”

⋯ → Archive table moves the table to the archive. You can bring it back from there at any time; if you open an archived table, a line at the top says since when it has been archived, with Restore.

Further topics

Section titled “Further topics”