easydb 5 Whitepaper

What is easydb?

easydb is a flexibly configurable standard software for the implementation of object-relational database concepts.

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

Technical basis

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

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

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 easydb5 overview

easydb Asset Server (EAS)

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

easydb Server

is a C++ server with a Python plugin extension. The HTTPRestfulAPI supports all of the server's features and can only be accessed through it.

easydb web frontend

is an HTML5/JavaScript application written in CoffeeScript and JavaScript. The frontend allows you to use all of the server's features.

Elasticsearch

is used for Search . The index 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 & 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 area
  • Simple Search with auto-completion 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 browser, folders
  • Search results as gallery, text or table
  • Sorting and marking hits

folder

  • Manage your own compilations
  • Share folders with internal users and guests
  • Release folders for import
  • Split-screen view: Display 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 full screen
  • Zoom for images, player for video and
  • Audio files
  • Selecting 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 full screen
  • Selecting masks to control editable metadata
  • Change history in full-screen editor and display
  • Group editor with field selection, templates and
  • Search & Replace 11
  • Tools: Rotate, crop and save your own versions

Rightsmanagement

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

Plugin Support

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

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

documentation

Complete documentation (German/English) for easydb is available online and freely accessible. The documentation includes:

  • Release notes for each update
  • User manual
  • Technical documentation

easydb

Whitepaper as PDF

Making curated knowledge accessible for generations

For 15 years, we have been an innovative pioneer in the field of web-based media repositories easydb fylr , the successor to easydb 5, customers rely on our experience and expertise in over 200 installations. Due to its scientifically oriented and customized approach, the system is particularly well-established in educational and research institutions and has become indispensable in over 50 press offices.

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