easydb 5 white paper

What is easydb ?

easydb is a flexibly configurable standard software for implementing object-relational database concepts.

easydb is used for the structured management of metadata and files. Working with the software is 100% web-based. esaydb is used as indexing, research and portal software.

Technical basis

easydb is based, among other things, on the open source components Linux, PostgreSOL, Apache and Elasticsearch.

Using the flexible data model, instances are defined according to individual requirements. The data model can be created via a graphical front end.

easydb consists of two server components that can be installed on different servers and the easydb web frontend as the third main component.

easydb runs on common Linux distributions and is delivered with Docker.

Programmfabrik easydb 5 overview

easydb Asset Server (EAS)

is a distributable storage system with HTTP API and JSON output without a graphical frontend. EAS is primarily written in Python. The EAS stores all file formats and can create derivative versions of most of them. The EAS can be stored locally as well as via SAS or NAS.

easydb server

is a C++ server with Python plugin extension. The HTTP Restful API supports all features of the server and can only be accessed via it.

easydb web frontend

is an HTML5/Javascript application written in CoffeeScript and Javascript. All features of the server can be used with the frontend.

Elasticsearch

is used for Search . The index for this is based on a SOL data copy. To increase performance, Elasticsearch can be installed on multiple machines.

Open source components

  • Linux
  • PostgreSQL
  • Apache
  • Elasticsearch

easydb main components

  • easydb Asset Server (EAS)
  • easydb server
  • easydb web frontend

Special features / USP

  • RESTful API
  • Plugin Support
  • Github repository
  • documentation

Basic functions

import

  • Upload single and multiple files or directories via the web browser
  • Optional metadata profiles for import
  • Import via drag and drop
  • Duplicate check during import
  • Template function in the new editor
  • CSV importer

Research and Search results

  • Selection of pools and object types to determine the search scope
  • Simple Search with autocomplete and suggestion lists
  • Search for empty fields and with combination of logical operators: AND; OR and NOT
  • Expert search for targeted Search in fields
  • Filter for faceting with number of hits per filter
  • Combination of simple Search , expert search and filter
  • Quick access and Search for saved Search , category browsers, folders
  • Search results as gallery, text or table
  • Sorting and marking of hits

folder

  • Manage your own compilations
  • Share folders with internal users and guests
  • Release folders for import
  • Split-screen view: Show folder contents and Search side by side
  • Drag & drop for local data and Search results

Display and output

  • Display next to the Search result and as a full screen
  • Zoom on images, player on video and
  • Audio files
  • Selection of masks to control displayed metadata
  • Convert and Download
  • Export including metadata in CSV, XML, JSON formats
  • Standardized print output

editor

  • Edit next to the Search result and in the full screen
  • Selection of masks to control editable metadata
  • Change history in full screen editor and display
  • Group editor with field selection, templates and
  • Search n & Replace 11
  • Tools: Rotate, crop and store your own versions

Rights management

  • Users and user groups
  • User profile editor
  • Assignment of create, read, write and delete rights
  • Rights for individual data sets, object types, masks, pools, tags, folders, lists
  • Workflow Support : Rights-dependent modification of data records using assigned tags
  • Watermark functionality for images
  • Use of rights preferences

Plugin Support

easydb server and easydb web frontend have plugin Support . Plugins for the server can be written in Python and plugins for the web frontend in Javascript or other browser languages.

Open source & ready-to-use plugins programmfabrik www.github.com/programmfabrik

documentation

For easydb complete documentation (de/en) is made available online and freely accessible. The documentation includes:

  • Release notes for every update
  • User Guide
  • Technical Documentation

docs. easydb .de

White paper as PDF

Making curated knowledge accessible for generations

easydb an innovative pioneer in the area of ​​web-based media repositories for 15 years Together with the latest version fylr , the successor to easydb 5, customers rely on our experience and know-how in over 200 installations. Due to the science-oriented and individual approach, the system is particularly established in educational and research institutions and has so far become indispensable in over 50 press offices.

Our team of experts is available to answer your individual inquiries.