Rise of the Phantom

Beta Release - April 6, 2019

v0.1-beta.0

Phantom DBM is an open source database manager created to make it easier to manage database scripts and the process of how data is uploaded to a database. It's a program that allows the user to manage and keep track what is uploaded into their database as well as keep record of who is storing this data*. It also makes it possible to automate where the data come from without having to specify this information whenever you wish to upload data such as: data from other collection or database, information from the internet (web scraping)*, or user entered formulas. This also allows data to be shared and provides a way for the user to save a compressed record/backup of their database that can be easily altered and/or restored if needed.

Currently Phantom only supports MongoDB but plans to support more NoSQL databases ( and maybe SQL) in the future.

Features:

• The Basics:

  • Create group where scripts are saved.
    • Theses groups are saved in a phm file and contain information about the data and database such as:
      • Connection information (host, port, auth, etc)
      • Data Schema (JSON)
      • Data Automation Script (XML)
  • Upload Script to Database.
    • Run one script at a time, all scripts or all script from a certain point
  • Export and Import Scripts.
  • Edit Script
  • Stop or Pause running uploads
  • Validate scripts before uploading to database

• The Not So Basic But Not Rocket Science:

  • Data Automation Scripts or Data Manipulation Instructions (DMI):
    • This is custom XML markup language where the user chooses what happens when they tell the program to run their script.
    • Documentation and Wiki coming soon.
  • Data Schema:
    • Schemas are largely based MongoEngine and I simplified so the user is able to create their own schemas
    • Information on MongoEngines can be found here: http://docs.mongoengine.org/index.html
    • Documentation and Wiki coming soon.

• UI:

  • The left side of the application displays relevant information to the user as well as other features to be implemented later.
    • This will provide users with detailed information that should not be saved in logs
    • Also provides status of runs and connection to database.
  • Add script by right clicking on the script tree on the right side of the main window, by clicking the plus icon on the side toolbar or in the file menu.
  • Editor are show when scripts are added
  • Information about a selected script is displayed below the script tree
  • Comes with 5 themes with a simple way of adding more