siaqodb - local database for Unity3D

Hello ,
We want to announce game developers that we released Siaqodb- object oriented database for Unity3D.
if you want a local storage solution for your games that just works without nightmares, without knowledge of SQL, without any configuration, a strong solution that is used already by a lot of customers for different platforms then take a look and test it: GitHub - morecraf/Siaqodb: Siaqodb

Hi,

One question… last time I checked, I think it didn’t supported relationships between classes, only basic types, so I couldn’t persist (easily) something like this:

public class Book{
     public int OID{ get; set; }
     public string title;
     public User author;
     public List<Chapter> chapters;
}

Would be posible to persist something like that with a single “localDB.StoreObject()” call (EDIT: updating objects in cascade if necessary)?

Would be posible to retrieve the user who created the book or the list of chapters without having to do the equivalent to a SQL JOIN statement? (EDIT: I would prefer accessing to the desired property directly)

Autoreply:
I have downloaded the trial from your website and I have made a quick test… receiving the following exception:

NotSupportedTypeException: Unsupported type, following member types are accepted:int,uint,short,string,ushort,byte,sbyte,long,ulong,float,double,decimal,char,bool,TimeSpan,DateTime,Guid, enum

Do you plan to add support for any kind of object? Do you have any roadmap about the inclusion of this functionality?

Indeed David, nested objects are not yet supported, but we already have an Alpha version that support it. We will release first Beta somewhere in August. so very soon…

In that case, I’m going to purchase your product.

Not having support for nested objects was a deal-breaker for me, but if you are going to add support for them so soon, then I prefer purchasing your product now using the discount code.

Thank you David, we’ve got your purchase, indeed as it is specified in our blog post, we offer 20% discount for first 10 orders.

Congrats cristoph! Will definitely give it a try. Just thinking about porting stsdb/ninjia lite over unity last week, now we get siaqodb :slight_smile:
Do you have any comparison chart with other .net base object database product regarding performance and features?

@tintin we have some comparisons (especially about performance, the performance was always our first prio), we did not made them public yet, but we will do it soon.

Brother tintin. Only one Database will take care of all of your database needs for Unity Basic and Unity Pro. That’s UniDDatbase. It will work with Texture,Audio,Prefabs, and now It’s getting an advanced audio system for in game audio management. Don’t get me wrong brother cristoph1. your product will work for Unity Pro users who need online and offline data management like you said. However,UniDDatbase and UniSqlite only focus on offline data at the moment. So if people want both online and offline. That’s where you come in. However, when it comes to offilne. I’m king. Here is the latest Video demo of an update I’m releasing for Edy’s physics. The user will write Zero lines of code to manage all Audio effects. It’s the beta version so it’s not perfect yet.

https://vimeo.com/26732571

Again, nice work brother cristoph1 on your product.

@namoricoo congrats for your product, however I don’t see any similarities with our product. Your product is more for design-time to store game objects and related stuff , Siaqodb is something else, Siaqodb can be used as local (offline) database, so you can save at runtime .NET/Mono objects to Siaqodb database like Game stats, Level info, Players info,etc and all related data you would need to persist.

Brother cristoph1, my product also does all of the things you’re saying. My post was trying to help you how, the current version of your product is for Unity Pro users only. A Unity basic users reading thing might buy it by accident.

“System.core.dll” is only available for Unity Pro. Along that line, Network access is only for Unity Pro. So non-unity Pro users who are not able to use your system will be able to see my system. I didn’t use System.Core.dll because it was not available to non-unity basic users. I wish you well. I hope we both sell 20,000 units.

From where did you get this wrong info? :slight_smile: Only limitation in Basic version regarding Mono is that .NET Sockets are not available. Siaqodb not need .net sokets, System.Core.dll is available for all platforms (iOS, Android, Mac, PC) and for all Unity editions.

I test all my product on Unity basic before I try Unity Pro. You can check the attachment to see the errors I get when I try to invoke system.core. It does not appear in the drop down,I get error messages. If you know a secret way to make it work. You’ll have to share it with your users. I see your getting upset, I was trying trying to help you out. So I won’t say anything else. If you want to keep giving out false information.

638363--22805--$Screen shot 2011-07-23 at 10.31.23 AM.png
638363--22806--$Screen shot 2011-07-23 at 10.30.49 AM.png

@namoricoo, I don’t think cristoph was upset, he’s giving the smile face, right? :slight_smile:
System.core do available since unity 3 released, I guess the reason that you getting the error is because you are still using unity2.6 which only got mono 1.2x. System.core didn’t exist before mono 1.9( or 2.0, don’t remember exactly), and with unity3, we got mono 2.6 ( on par with .net 3.5).

@cristoph, looping forward thé comparaison data. And thé nested object feature.

I’m in Unity 3.3…Let me try adding it manually from inside mono and see if it works. When I was working with UniSqlite. I had to manually add the Sqlite library. We developers have to work together, learn from each other. That why I was posting this. Other people will run into this same problem too.

I do see if as a reference. It does work on Unity Pro. However, Unity Basic only support .Net 2.0, System.core is for .Net 3.5 and it does not show up even when it’s checked.

638442--22808--$Screen shot 2011-07-23 at 12.44.46 PM.png

No, both unity basic and pro support .net 3.5. Check http://unity3d.com/unity/whats-new/unity-3.

@namoricoo first of all I’m really not upset :slight_smile: , why should I? I just wanted to correct you and repeat again that System.Core.dll can be used in Unity 3.X any edition as @tintin said. In your first screenshot you can see at intellisense that IDE hint you System.Linq this is part of System.Core.dll (btw System.Core namespace does not exits, only assembly is called like that).

hello I’m looking for a simple way to use Linq with basic type of data, excel docs.
I tried linq to excel, odbc sample for the forum :
How-can-I-get-data-from-excel?
and siaqodb. And every time after a succefull try of demo projects appears an internal compiler error with

System.TypeLoadException: Could not load type ‘System.Reflection.AssemblyTrademarkAttribute’

-should I modify AssemblyInfo.cs ?
-is it Mono related ? (I’m in U3.40f5 Pro )
www.go-mono.com
-or is this worth a bug report ?

I am using Siaqodb for Unity and I am very happy about it. It is being actively developed and supported. I highly recommend it to anyone who is struggling with setting up a databaes for Unity on Android. Sqlite not working for Unity on Android is a MonoDroid issue. Don’t count on them fixing it.