Preview: Database Editor

You can download the software at Download: Database Editor.

Features

Create/Edit/View SQLite databases
Create/Edit/View data entries
Data types: string, integer, binary (files)
Filter/Search data entries
Case-insensitive string search
Regex search
Integer-based range matching
Multi-column sorting of data entries
Keyboard shortcuts
Import/Export data entries from/as JSON
Export database as JSON file
Undo/Redo add/edit/delete actions
Unicode Support

If you need more information, please refer to the “README.txt”, which is part of the software package.

Images

The following screenshots will provide you with an overview of the software.

Main Window of the Application

Column Sorting and Data Filtering

Setting Column Width to Column Content

Edit Dialog

Description of Controls

Description of Advanced Controls

Configuration

The software includes configuration files with which you can set the log level, the language of the user interface, and the database schema, among other things.

The format of the configuration file to configure the database schema is documented within the software package. It is a JSON file that may look like this:

{
  "schema_version": {
    "major": 1,
    "minor": 0,
    "patch": 0
  },
  "tables": [
    {
      "type": "table",
      "name_tec": "table_1",
      "name_gui": "table 1",
      "fields": [
        {
          "type": "string",
          "name_tec": "author_pre",
          "name_gui": "Forename",
          "views": {
            "display": "ShortText",
            "edit": "ShortText",
            "filter": "StringContains"
          },
          "modifier": null
        },
        {
          "type": "string",
          "name_tec": "author_sur",
          "name_gui": "Surname",
          "views": {
            "display": null,
            "edit": "ShortText",
            "filter": "StringContains"
          },
          "modifier": {
            "type": "character_exclusive",
            "characters": "0123456789"
          }
        },
        {
          "type": "string",
          "name_tec": "genres",
          "name_gui": "Genres",
          "views": {
            "display": "ShortText",
            "edit": "ShortText",
            "filter": "StringRegex"
          },
          "modifier": {
            "type": "character_inclusive",
            "characters": "abcdefghijklmnopqrstuvwxyz ,"
          }
        },
        {
          "type": "i64",
          "name_tec": "year_bd",
          "name_gui": "Birthyear",
          "views": {
            "display": null,
            "edit": "ShortText",
            "filter": "IntegerPlusMinusRange"
          },
          "modifier": {
            "type": "character_inclusive",
            "characters": "+-0123456789"
          }
        },
        {
          "type": "i64",
          "name_tec": "col_5",
          "name_gui": "Books Written",
          "views": {
            "display": "TextArea",
            "edit": "TextArea",
            "filter": "StringContains"
          },
          "modifier": null
        },
        {
          "type": "files",
          "name_tec": "files",
          "name_gui": "Books",
          "views": {
            "display": "Files",
            "edit": "Files",
            "filter": null
          },
          "modifier": {
            "type": "character_inclusive",
            "characters": ""
          }
        }
      ]
    }
  ]
}