Database Management Tool For Unity

• MongoDB

  Package Description

  This package is used to control mongodb database, collections and items. You are comfortable do CRUD operation this tool. This tool when connection your mongo atlas databases on this tool create a json file based your databases. If json file exist in your asset folder then open Mongolist View Window and you can crud operation on this window. When you want to send changes made locally to the cloud, you have to use " Send Json To Cloud " button on MongoList window or update MongoList windows json file then you have to use " Reset " button, if you want to update json file based your mongo atlas you have to use " Update Json File " button. I have explained in detail how to use this tool below. If you are catch any bug you can create an issue, send email or message to me.

  • Connection to MongoDB Atlas
  1. Click Database Management Menu
  
  2. Click Database Connection
  
  3. Choose MongoDb
  
  4. Write your MongoDB Atlas connection url and press connect button. If the connection url is not wrong, the databases connected to the mongodb atlas are created as json file.
  
  • Managemenet Database, Collection and items
  1. Database Management

  As you can see in the image below, your databases are listed in the left window. When you press any database, collections based on that database are listed in the middle window. If you click on any collection, all items based on that collection are listed in the right window.

  

  If you want to create a new database then click Create a new database button to left window and enter the database name. If you want to delete database click X button. Click "Restart" button.

  
  2. Collection Management

  If you want to create a new collection then click Create a new collection button to middle window and enter the collection name. If you want to delete collection click X button. Click "Restart" button.

  
  3. Items Management
  • Create

  If you want to create a new item then click Create a new item button to right window. If collection exist any item you have to create item based these items.

  But does not exist any item then you entry input field count and entry property name - property value. Click "Restart" button.

  • Update

  If you want to update item then click "✓" button below of item.

  • Delete

  If you want to delete item then click "X" button below of item.

  • Reset

  If you want to reset item then click "<->" button below of item.

• SQLite

  Package Description

  This package is used to control SQLite database, table and items. You are comfortable do CRUD operation this tool. I have explained in detail how to use this tool below.

  • Click Database Management Menu
  1. Click SQLite View Menu
  
  • Managemenet Database, Table And Items
  1. Database Management

  As you can see in the image below, your databases are listed in the left window. When you press any database, tables based on that database are listed in the middle window. If you click on any table, all items based on that tables are listed in the right window.

  

  If you want to create a new database then click Create a new database button to left window and enter the database name. You have to create datababse in this directory Assets/Scripts/SQLite/Databases/ if you are using DB Browser or like this programs. If you want to delete database click X button.

  
  
  2. Table Management

  If you want to create a new table then click Create a new table button to middle window and enter the table name. If you want to delete table click X button.

  
  
  3. Items Management
  • Create

  If you want to create a new item then click Create a new item button to right window. If table exist any item you have to create item based these items.
  
  

  But does not exist any item then you entry input field count and entry property type - property name and when click save then you can entry item values.
  
  
  

  IF YOU HAVE NOT ANY TABLE AND YOU TRY CREATE A NEW ITEM YOU GET THIS MESSAGE

  
  • Update

  If you want to update item then click "✓" button below of item.

  • Delete

  If you want to delete item then click "X" button below of item.

  • Reset

  If you want to refresh items then click "<->" button below of item.