[RELEASED] Lightning Database - An easy database editor

Lightning Database​

Asset Store

Lightning Database is a tool for fast database creation without writing a single line of code. You will get your own database within a minute.

Key features:

1. Easy to use. With the few clicks, you will get your own powerful database.
2. Design database through user interface. You don't need to write a single line of code. All you need to do is click and click. Bam! Database is yours.
3. Support many field types. Field can be primitive type (int, string, float, ...) or Unity type (Texture2D, GameObject, ...). It covers your need.
4. Field can be list. If you need field to be a list or array. Yes! you can it with Lightning Database.
5. Custom field support. If you want to use your class in Lightning Database, you just write a few line of code. Please see documentation for more information.
6. Class field support. When you create new class, it can be a field.
7. Work with all platforms. It's based on ScriptableObject which support all platforms. You don't need to be worried about it anymore.
8. PlayMaker integration. Auto generate PlayMaker's custom actions for each class's fields.

Screenshots:


User Interface



Add new class, columns, support unity, system, and custom types.



Add/Remove/Reorder columns


PlayMaker integration

View attachment 204101


​

Changelogs

Version 1.4 (Waiting for approval)

• Column sorting.
• Sort classes automatically by alphabetical.
• Truncate class (reset ID auto increment).
• Support PlayMaker action for SpriteField.
• Spawn PlayMaker FSM.
• Fixes PlayMaker actions will be deleted when new class created.

Version 1.3

• More PlayMaker actions: Set Field, Save, Load.
• Be able to save and load at runtime.

Version 1.2

• Sprite and Texture preview.
• PlayMaker custom actions.

Version 1.1

• Support class field.
• Be able to reorder items.
• Add context menu to copy, paste, duplicate and remove item.

 

It seems not interesting at all. It would be great if you leave a comment which I can improve this asset to meet your need.

Thanks in advance.

 

Looks super-easy (and useful)!

..actually misread the topic title first as Lighting db, i though its just some list of ready made light settings.. : )
maybe add more keywords to the topic.. Easy Database something something.. and few screenshots,
because sometimes no time to watch videos.

 

Thank you so much. Your comment is very useful.

 

I just submit package. Current status is pending review. Let's see when it is available on Asset Store.

 

@rutz ,

Looks v tempting.

Some things would make it even more so:-

- playmaker actions and integration;

- creation, editing of databases and fields and values in runtime... tricky with scriptableobjects;

- preview of media like sprites and textures when entering data;

- multiple tables and multiple databases;

- encryption.

Just some ideas...

 

Thanks for valuable ideas.

 

Since package has been approved for a week. If you guys have downloaded the plugin and got any problem, please feel free to report here. Bugs, feature requests, suggestion are all welcome.

For alpha release version (not yet on AssetStore), currently support class reference which means you can add field which is the class you've created via Lightning Database. For the buyers, if you would like to test it, please feel to send me a private message with your invoice number. I will send you a link to download the latest package.

I'm working on feature "Reordering items" as @dawidsvk1 requested. I will keep you updated.

PS. Please rate the package and leave a comment. I really need to know what it is lacking of to make it better and make all buyers satify.

 

Version Updated!

Version 1.1 is submitted and waiting for review. If you have already purchased the asset and would like to try it, please send me a PM with your invoice number.

Don't forget to rate the asset

Notes:

• If reorder does not work, please try to drag something (game object in hierarchy, project's file) first. It will trigger drag and drop function. I don't know why it happens. It just work around now.
• When you use copy and paste function, you might found the dialog which ask you to rebuild. As to the message, please backup all your Lightning Database files before to click Rebuild. Normally, I work just fine but just in case it doesn't.

PS. Please rate the package and leave a comment. I really need to know what it is lacking of to make it better and make all buyers satify.

 

Just looked at your post, and wanted to ask, is the Asset Store link not working only for me ? (Wanted to mention that in case you didn't notice)


Elroi

 

Yea, link on the top of this page doesn't work. Its missing : character after http

 

Fixed. Thanks for point it out. I hope this asset may be your choice.

Download link: http://u3d.as/xYb

 

Version 1.1 is now on Asset Store. Please update and feel free tell me how good or bad it is. I would love to have feedbacks from you.

 

I'm working on features listed below. I hope these will finish by the end of the week. If you guys interested in, please send me a PM with invoice number (which I can verify that you are a buyer). In the very near future, I plan to make a website for you (exclusive only for the buyers) to make a feature request, vote, bug report, download beta version (before get approved from Unity Asset Store).

Version 1.2 (Work in progress)

• Sprite and Texture preview.
• Playmaker integration.

 

Sprite and Texture preview.

 

PROGRESS UPDATE!!!

PlayMaker Integration







​

 

Version 1.2 is submitted and waiting for review.

Features

• Sprite and Texture preview.
• Playmaker integration.

PS. Don't hesitate rate the package and leave a comment. I really need to know what it is lacking of to make it better and make all buyers satify.

Thanks for your support.

 

Dear @Duffer123,

- playmaker actions and integration;
It will be available in version 1.2 which now submitted, just wait for review.

- creation, editing of databases and fields and values in runtime... tricky with scriptable objects;
Normally, ScriptableObject cannot edit in runtime. The way to do that is to save to disk which may need encryption.

- preview of media like sprites and textures when entering data;
It is available since version 1.1.

- multiple tables and multiple databases;
It is a very good idea but Lightning Database is not designed for this This might be included in the other major version.

- encryption.
I'm not quite sure. I think it safes enough if it is not accessible (not in Resources folder). Please correct me if I'm wrong.

I hope you like it.

 

@rutz , brilliant thx!

 

Version 1.2 is now live on Asset Store with PlayMaker support.

Next release would be: Be able to save modified value to disk at runtime.

 

Right now, I am working on feature "Be able to save modified value to disk at runtime". Let's see how it goes.

 

There is possible to create row in game with playmaker?
Also if there is possible for save this DB outside the project like in .txt file and load from file?

 

There is possible to create row in game with playmaker?
>> For now, there is only the set and get actions BUT there will be in the future release. Please be patience.

Also if there is possible for save this DB outside the project like in .txt file and load from file?
>> Do you mean you would like to modify database and be able to save in runtime (during playmode)? If so, I'm working on it. Please be patience.

Thanks for interesting in Lightning Database. It would be great if give me a change to get your rate on the asset store page Asset Store.

 

Loving what I see. Bought your asset and am enjoying the Playmaker functionality.

Hope you come through with run time saving and modifying.

I would really like to be able to change values in the database via playmaker.

 

Thanks for purchased and I hope you happy with it. If there is any update, I will let you know.

 

Very Happy =)

 

Happy to say that runtime saving is avaiable in version 1.3. Please update and try it.

 

PROGRESS UPDATE!!!

More PlayMaker actions!!!

• Add item.
• Remove item.
• Set field.
• Save at runtime.
• Load at runtime.

​

 

@rutz,
Just bought this. Just how much can you now do at runtime? How do you use Save and Load? Could yiu use this to manage SaveGames and different players inventories? In runtime?

 

Hi @Duffer123,

Thanks for your support.

Sorry for inconvenience. Documentation is outdated but it will be updated in couple days.

Runtime saving support multiple slot by number provided. In your case, you could use player index instead of slot number. Please see code example below. You may get some ideas how it works.

Code (CSharp):

1. public class Inventory : MonoBehaviour
2. {
3.     public InventoryDatabase database;
4.  
5.     public int playerIndex;
6.  
7.     private void Start()
8.     {
9.         // playerIndex = GetPlayerIndexFromSomewhereYouCanGet();
10.         Load();
11.     }
12.  
13.     public void Load()
14.     {
15.         database.Load(playerIndex);
16.         // Do stuff after load.
17.     }
18.  
19.     public void Save()
20.     {
21.         // Do stuff before save.
22.         database.Save(playerIndex)
23.     }
24. }

 

Think I'm getting it a little... although the new documentation sounds good too!

If you could perhaps post some example code snippets with the new documentation showing how this asset can be used to create item lists and then runtime inventories, load and save players with stats etc (skeleton vode)?

 

Sure! I've plan to create more examples. I will keep you posted.

 

@rutz ,

It would be useful if you rename classes and reorder them too in the Lightning editor?

It would also be useful if you could have a system/string (memo) do you got a scrollable edit text window....

 

It would be a great for usability. Thanks.

Do you mean "textarea"? If yes, it is a very cool idea, user will love it I guest. Otherwise, please explain.

 

@ rutz,
You guessed correctly. Textarea.
Any chance of support for dictionaries (hard to serialise, i know)? Key and value, with either being system, unity variable or class?
Also, support for Mesh and Animation Clip?
Another special class that would be useful is diceroll value ie. xDy+/-z... ?

 

Hello,
how can i connect two databases together ?
For example:
I have a databse called Item with name, id, and rarity
then i have a database for rarity with the color of the raritytype.
When i make a row rarity in the item database i am getting a null reference exception from RutCreate.LightningDatabase.BaseItemDatabase.OnEnable () and it's just -None- to select and not the fields of the rarity database.
Is there a way to connect ?
Thanks in advance

Astha

 

Yes, we could serialize dictionary in our system. In the next release, it will be built in.

Animation Clip - Yes, it is already in the field list.
Mesh - No, it could not because it extends from UnityEngine.GameObject.

By the way, the classes that extends from UnityEngine.GameObject or UnityEngine.ScriptableObject cannot be saved which means you cannot use Database.Save() to save the value.

I'm not sure what are you talking about but I guest you mean random class? Could you please explain more for the use case of this class inside the Lightning Database?

 

Sorry for inconvience. I'm trying to figure it out what is happening but it would be super useful if you could show me a exact the step to reproduce which cause this error.

 

@rutz,

Great thx. I mean say 3 custom fields to input dice values.

 

Of course a step by step example:
1: Make a new database called Item
2: Make a second database called Durability
3: Add in Durability two columns like (int maxDurability and Color representColor)
4: Add in Item the column Durability
And there i get the error. Or how can i use one database in another ?
Sorry for my english, I hope you get what i try to explain. I can also send you a email...
Astha

 

I've made a picture to show what i mean...

 

Please see your email for bugs fixed version and keep me posted.

For others, bugs fixed version is also submitted to the store. Be patient.

 

Did you mean this? https://www.critdice.com/how-to-roll-dice/

 

With the help of @rutz I've found the solution for the problem about connecting databases.
Don't put the asset folder in a costum folder, just in "Assets/Lightning Database".
Again thanks rutz

 

Something liike, yes

 

Please forgive me. This is first time I know this . Give me sometime to get into it.

 

You're welcome.

 

Ctrl +f WebGL :-(

 

@rutz,
Similar suggestion to one further above - ability to sort classes in Database editor alphabetically?

 

Could you please explain more? What is the problem?