Tired of those hard to use, long learning curve database packages for Unity? Need something quick and easy, that can store almost anything you can think of?
ZDatabase supports:
Saving strings, int, float, Guid, Vector2, Vector3, Vector4, and more
Read / Write functions that are easy to use. No pre-setup required
Works on all platforms (including Consoles!). PC, Android, iOS, Wii, XBox 360, and PS3
Encryption functions available as well. Every functions has an encrypted alternative as well. Encryption uses Rijndael 128 bit encryption
Demo scene included.
If you need any additional data types added, feel free to send a PM or post in the forum, and I will include in the next release.
Quite interested in this. I have a project which is going to have to do some data visualisation of integer data recorded every day for an Android and iOS app. I was wondering what sort of performance limitations i’m going to have when it comes to long term use…
e.g. how many records can it store and ‘SELECT * from recordedInts WHERE data > start and date < finish’ and whats sort of response times will say 1000 records take to pull out?
Sorry for the crappy SQL pseudo but its easier to convey my need.
That is a very good question. I put together a quick test to demonstrate write / read speed. I had it insert 100,000 records, then read the first, middle, and last records.
Insert speed does decrease as the number of record increases. I noticed the insert speed decrease around 60K records. At this time, it was inserting 150 records in about 800ms.
I ran this test on an Android Samsung Galaxy S2 phone. Speed should be comparable on a iPhone 4S.
Total time to insert 100,000 records: 402,085ms (40.2 seconds)
Read time for first record: 0ms
Read time for 50,000th record: 15ms
Read time for 100,000th record: 33ms
The issue with the inserts is that the database has to be expanded to handle new records. All databases have to handle this, and I’ve done my best to optimize this for mobile devices.
Ok I went through the documentation.
Aside from offering encryption, which is fairly trivial to implement, what does this package offer over simply using playerprefs to read and write data values?
The advantages are being able to quickly save / retrieve objects of different data types, without having to write your own custom serializers (since PlayerPrefs only gives you Int, Float, and String). The same advantages you will have with almost every PlayerPref alternative on the asset store.
If you need to use SQL statements, there are a few good embedded SQL databases on the asset store. I’m providing ZDatabase as an alternative to PlayerPrefs, and to make it easier for people to save/retrieve objects.
As I’ve already previously stated (and demonstrated above), if you need additional object types to be included, I’m happy to add them into new releases.
I just bought this thinking it was a full database but it looks like you can only store one field per record. Is that correct? Is there any way that I can store a bunch of fields in each record? (other that faking it by encoding it myself).
