PortaBase 2.1 Manual
previous | next

# Introduction

PortaBase is a small database program for creating, browsing, and editing custom tables of data. Typical uses are media inventories, reference charts, TODO lists, shopping lists, etc. Notable features include:

- String, Integer, Decimal, Boolean, Note (multi-line text), Date, Time, Calculation, Sequence, Image, and Enum column types
- Custom data views (subsets of the columns in any order)
- Filter the displayed rows using sets of conditions
- Sort the rows by any combination of columns, each in ascending or descending order
- Good performance even when browsing large tables; the display only loads data as needed
- Optional page navigation buttons, with custom number of rows per page
- Add, delete, rearrange, and rename columns at any time
- Specify default values for columns
- View summary statistics for columns (total, average, min, max, etc.)
- Import data from CSV, XML, and MobileDB files
- Export data to CSV, HTML, and XML files
- Command-line format conversions (to and from XML, to and from CSV, from MobileDB, to HTML)
- Print the data grid with view, sorting, and filter applied (not supported on Maemo)
- Fullscreen mode option
- Optional data file encryption
- Unicode support
- Pick any available font to use throughout the application (not supported on Mac OS X)
- User-specified alternating row background colors (Maemo Fremantle uses colors from the system theme instead)
- Simple calculator widget for entering numeric data