[RELEASED] Lightning Database - An easy database editor

Please be patient. I submitted previous update (without sort classes) last week and still waiting for approve. Once it is approved, next update would include sort classes.

 

Excellent thanks rutz...

 

@rutz ,

I am plenty patient - but thought I'd share some other ideas for enhancements with this database with you...

Firstly, it suddenly occurred to me - a massive enhancement to this Asset would be, when editing rows within a Lightning Database class, would be to have effectively one 'page' of the editor per row (with columns displayed vertically and in some sensible format) - where, as is often the case, you have hundreds of columns in each row, perhaps including things like Sprites - and with a < and > (to change row or + to add a row) and a vertical scroll to move up and down the displayed columns of the row?

Secondly, another big enhancement would be to have an optionally hidden 'start' row with 'defaults' for each column field?

Thirdly, if you could select one (or perhaps more than one) row and could click a 'copy' button so it copy copy the row to a new row that would massively speed up development and input of data?

Fourthly, when adding rows to a Lightning Database class, and inspecting that class, it would be great if you could (in the conventional horizontal view for rows, with columns left to right) left click your mouse on a named column to A-Z / Z-A filter the rows by that column?

Finally, it would be really useful (when editing rather than deleting a Lightning Database class) to be able to edit/change the actual name of the class too (and I suppose reference to it would also though have to change in other Lightning Database classes that referenced it...?).

Anyway, some good enhancement ideas for you.

 

Yes, you are right. It is a massive enhancement and very interesting but I'm pretty sure that it won't finish in near future.

I don't quite understand what you mean. Please explain more.

Yes, sure.

Did you mean sorting by column?

I've already planned to this feature for a long time since first release and thank you to remind me of this.

By the way, thank you @Duffer123 for great ideas.

 

@rutz,

First idea - understood.

Second idea - so optionally hidden row 0 could set optional default values for columns in rows 1+ or leave them by default as null.

Third idea - great.

Fourth idea - yes, sorting by columns.

Final idea - great.

Thanks for considering these ideas!

 

Your website link is broken... are any of the editor upgrades in v1.3?

 

Sorry for convenience. I will get it work as soon as possible. Thanks for informing.

 

Hi. I would like to support modding in my game and I want the players to be able to add/create a new items and the the game imports them. Is it possible to do this using this tool? If it is a scriptable object based, can I give the modders a sample of the such object and then they export it as an asset bundle so that the game can load it? Or can it export to json or cvs file and then the runtime API can import them to add or override the values?

 

I'm not sure I understand what you're going to do correctly but I believe it is possible to do that. You may need a button to call a method which read database and save at runtime from downloaded asset bundle.

FYI, save/load runtime API could provide a string for a slot which means you can have a multiple version of save games. Maybe you could use this to apply to your game.

 

can fields be loaded with strings on runtime (like name), and byte[] (picture data)? I am bit worried since it did not mention string as able to be used in runtime on the store page.

 

I don't quite understand what you would like to do. Please clarify more. Give an example would be nice.

 

let's say I want to put save file into the database in runtime, can I do it? In the store page you mentioned "Save or load at runtime: Support only int, long, float, double, bool, Vector2, Vector3, Vector4, Color, and Rect fields. " which does not include strings, which makes it unusable.

 

Blame on me. String is also supported as well.

 

@rutz, I have question. I try to create 2 clases (Characters and ShopItems). at first the playmaker action shows Characters Action. After I create the second class, the playmaker action only show ShopItems. If I delete ShopItems, the playmaker doesn't show anything. I edit one field of Character class and then it shows the Characters playmaker action again. It seems that the playmaker action auto generate script only working for the latest edited classes. Is this bug or this database can only do 1 action playmaker auto generate script? Thank you.

 

@rutz ,

How goes development of this Asset? Are you developing it and what sort of things are you looking at next?

 

Version 1.4 is submitted (waiting for approve).

Change logs

• 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.

 

This bug has been resolved in version 1.4. Thanks for bug report.

 

Hi Rutz,

Can you explain me how to use a sprite element in database and playmaker ?
I have a table with a sprite object, i can drop in some slice picture.
I'd like to read an element and put the result in a image object.

I can read the element, but i don't have sprite variable avaiblable in Playmaker. It works with an object variable.
How to transform an object variable in a texture or sprite element ?

Thanks for your help.

Fab

 

Hi,

Me again, i find the solution :

Get name sprite field and put in an object variable
Get FSM Object with previous variable name and a new variable (object type also)
Set Property on an image, property sprite, put the previous new variable

I don't understand the logic but it works

 

Hi again,

I'd like to use the link database functionnality (a link between an order table and a detail order list for example). When i create a table, i can set a table link inside a manual record. But i don't see playmaker function associated (Something like Set Link or an element in the add fonction generated). Is it an issue ?

Also, is it possible to reset the ID number when i remove all records ?


Thanks for your help.

 

is this now dead?

i saw someone recommending it, but the link they provided said it had been depreciated