The Future of Unity at today’s prices. A lot of people have been asking for native sqlite support.
Summary
UniSqlite is the first and only native SQLite database admin tool written in javascript with support of SQLite3. Set up is very simple. Download the script from the asset store, click on
“WINDOW” on top of the screen, and select UniSqlite. UniSqlite1.0 is the only Sqlite editor that can manage Prefabs,audio clips, Textures, and (x,y,z) Position, rotation, and scale without having to write a single line of code. Even if you have no experience with database management. You’ll be able to learn the system that will soon revolutionize Unity3D. You’ll be able to search Prefabs by name or by using a primary key. That’s just only the first innovation that users are hoping to see in future versions of Unity3d. This is beta version 1.0.
Features
Add,Delete,edit,Browse records.
Add,Delete,edit table columns
Manage table indexes
GUI tools to manage prefabs, audio clips, Textures, date,time,ints,doubles,Position, rotation, and scale.
The presentation is very intuitive, easy to use, so that non-technical developers can hit the ground running.
We are actively working on version 1.1.
I just finished today. I will submit tomorrow. The submission process is so annoying. I will have an early adopter discount. $75. You’ll be able to manage your prefabs, audio, Textures, Text, date and time, just like you do in iTunes and G-mail. The menus are context sensitive as you can see. The cells are able to calculate their own size. The cells are even smart enough not To take up too much space when the words get too long. For example: If you have three very long text: The screen will get divided three ways. The people have spoken, I’ve listened. I will have a Youtube demonstration soon. This is 4 months worth of work…
$75 is very cheap, when was the last time you went to the Asset Store Brother Curious. Some of the best stuff on there are at least $100. Android and IOS bothe have native Sqlite support. Sqlite works on PC/MAC, IOS, Android, Websites, PS3 and XBOX 360. This is an editor. So that people who don’t know anything about Sql syntax can hit the ground running and Create, Read, update, delete, create indexes for their content.
1)I’m laying the foundation for a evolved Unity Standard… Let me give you an example. At the present moment if you want to instantiate a prefab. You have to specify the name of the prefab. If you want to instantiate 10 prefabs, you have to specify all ten. This is known as Explicit Instantiation. I’m introducing a new term called Implicit Instantiation.
Sqlite Supports primary keys. So you are able to In a WYSIWYG formate attach primary keys to all of your prefabs. So if you have 10 prefabs with primary keys 1 through 10 you be able to say instantiate prefabs in such and such table with primary keys 1 through 10. It does not matter if you have 2,10, or 50 prefabs. Same about of code to instantiate them. You can see that in the attachment.
2) Take this one step further. In one Room you have prefabs with ids 1 through 20, next room you have primary keys 40-60, and so on. This has never been done b4 in the history on Unity. The reason it’s only $75 instead of $200 like other stuff in the Asset store is because I’m targeting people lwho don’t want to pay too much for a great product. Wait for the YouTube Video. You can attach ID to audio files, Texture2d, anything you want in a WYSIWYG fashion. Just do a search for SQlite in the forum and see how many frustrated people are looking for native SQlite support.
3)One last thing, you don’t sent the editor to any other platforms, you send the database files…
My current workflow with sqlite is to manipulate my databases with Firefox (SQLite Manger). Being able to see my game data directly in the Unity editor would be nice. Does your editor display blob data if a hint was given? For example i have png data in one column, would i be able to see those graphics displayed in table view/edit mode?
Bobs are very inefficient, they take up a lot of space and they slow the database because the picture is broken up into binary. We all know that unity support Texture, Texture2d, Texture3d. So I trained UniSqlite to support Texture2d, you can see it in the picture. I called it Texture3d_uni. It’s only a text reference to asset location. For example Asset/Resources/Texture2d_uni. I’ve invented a naming convention to educate Sqlite what to do with it. “@Texture2d@”. When UniSqlite notices the naming convention, it will load the Texture and format it correctly. So Texture2d_uni is UniSqlite efficient Blob format.
And that’s only one thing that other Editor’s don’t do. Firefox or any other Sqlite Editors don’t known what to do with a prefab, audio file, Texture2d… In one of the future versions I will add Video support. Video support in only available for Unity Pro.
Final note…This is the start of a new standard for Unity. I also have a date class and a time class. So if you’re writing a game like assassin’s Creed and you have all of these complicated dates and time you’ll be able to do everything without going outside of Unity. For example date will be formated like 04/14/2011 AD, if you have some like a very old date you can do 01/12/0250 BC. Before Christ.
The first picture shows you Textures with IDs. You can see the database effects in the rows. In the second picture when you left click on a texture, the Update Mono Sqlite Field window will appear, and when you hit the select button. The select texture window appear where you can change the texture in the cell. When you finish, you hit update. The third picture will show to you a live preview of what happens when you click on a new image. The forth images shows you what you’ll see when you are inserting a new line of data. The editor will guide you through the entire process.
Is there an easy way to set up a player’s account information with this? Like storing login , password, and unlocks they have for a game? Or is more just managing assets?
Whatever you can do in a Regular Sqlite database, you can do with UniSqlite. All the information you described Brother Kheng is nothing more than Text. If there’s a password involved you’ll have to implement some type of encryption for the password. The reason I don’t include encryption is because I would have to explain it to everybody. Then anybody would know how to hack-in and get the passwords. I’m finalizing the first Portion of the Youtube Vizio. I deal with Prefabs, audio, textures, and Integer Primary Keys… In the next Video I’ll deal with things like Text,Int,Float,Date,Time, Etc.
Hi great product. Do you know any webbased admin tools that you can use for this. I have a client that wants to be able to change values for a product catalog…
Unity3d is not web based. However, Sqlite dabases will work in the browser. A lot of companies are using sqlite databases to store the information for their websites. For people who don’t know. Adobe Acrobat uses SQlite. When you are searching the text in a PDF file. You’re searching an Indexed Database. Itunes also uses SQlite.Core data for IOS and Mac also use Sqlite. I’m loading a higher resolution video to Youtube, the video was not as clear as I would I liked.
It looks nice! Can you show how easy it is to have the data be generated by a player and have it be stored to the database? Like in run time you ask the player for their name and you store that in the database. And how can you access the database in code?
3)I submitted a very stable version of my code 04/17/2011 around 1:15PM eastern time. So now the Ball is in Unity’s court. The picture you see on top is what you should look for.
In response to why no C#, when I first started out back when were were still in Unity 2.6, I spent a month and a half looking for a way to get my code to work with C#. I contacted people, I even got in touch a person who worked on an older version of Mono. Back then, the only way I would have gotten a C# version was by using a DLL file. If I had used a DLL file I would have had to Upgrade to Unity Pro. So I asked a simple question. How can I get a database Management system to works with Unity Basic? I had given up for half a month. Unity 3.0 came out. Reviewing some of the update revealed some of the files I needed to get a javascript implementation. When the Asset Store became available, I had a lightbulb moment. I noticed everybody who was looking for the same thing. I became an Engineer so that I could solve complicated problems that other people run away from.
I put everything on hold so that I could work on the Future of Video games. As games get more complicated, we’re going to have at some point, “Database Driven Video games.” Users don’t invoke any of the Editor files directly. I’m working on public Javascript and C# functions that users will interact with. It may look simple on the Video. However, what you are seeing is, 4 month worth of work, boiled down to less than 10,000 lines of code. I had to invent the custom grid view, all the new naming conventions, and all of the other progress you’re seeing.
IOS, android, and Mac have Sqlite Built in. I know Sqlite can work on the web and Windows, How exactly, I don’t know yet. The key word, yet. The people in the community have been asking for this, for a long time. I’m the first person who listed. I wish Unity would work with me to bring about the change that everybody is looking for. Now, Unity is the 3rd best game Engine. If Unity Becomes a Database Driven Game Engine, Unity can become number 2 or number 1.
So basically you are saying it only works on platforms with inbuilt sqlite?
I agree with your point re: db driven. Would be great to also use http://developer.db4o.com but the licensing is either GPL or commercial/unit volume, so nothing really conducive to indy development…atm.
I did not say it only works on platforms with built-in sqlite. I know you can use sqlite on xbox 360, see this link for some games that uses sqlite. http://xbox360superstore.codeplex.com/. The Sqlite is only 100k in size. It’s lighting fast. I just say I don’t know how to do it yet. I’m on the outside trying to start a movement. So we have a big discount for people who want to support the movement. As I learn new things I add them to the database. On the video, you don’t see or hear me talking about managing script files in a database. However, on Saturday I made it happen. In the script I’ve added to the Asset store you’ll be able to manage all of you mono sqlite scripts in a database. So, I’m learning as I’m going. Think about it. When iPhone 1 came out it was great at the time. iPhone 4, blows iphone 1 out of the water. That’s how UniSqlite is. I had to rewrite the entire thing 7 times before I reached version that does not crash, that works correctly, can undo, same, and do everything visually. That’s why I have that eye shape in the design. You don’t use code Javascript or CSharp, you use the User Interface. I know if Unity works with me. We’ll be able to bring Sqlite Inside with all of the other files like:Audio,Textures,Javascript.
The promise of Unity is to Unite. Simple games work fine with Unity the way it is. However, if you have a big game like GTA, Assassin’s creed, you’ll need a database to manage all of that information. If there’s a legal way to do it. I’ll find it because that’s what I do. I’m the Engineer you call when you have a complicated problem and time is not an issue. I’ll post new videos with the remaining features this week.
After Brother sonicviz posted his good messages. I spent several hours investigating the missing links. I’m proud to say that I discovered the bug. I filled out a bug report today and submitted the problem to Unity. Let’s just hope that they do something soon to resolve the problem. Until they do. People will still be able to use my editor as if the error was not there. The problem only exits outside the editor folder. Not inside the editor folder. I sent several screen shots to Unity. It should be a simple fix, now that they know exactly what’s causing the problem.
