MonoSQLite SQLite for Unity

[jeanfabre]

Hi,
 
 Thanks I am actually looking for a c# book, because I just picked up c# without real education, so I am sure I am missing out on a lot of goodies and powerful key aspect of c# actually...

Bye,

 Jean

[jsking74]

Sounds good man, and thanks again for the quick response.

Hey jsking,

We have contacted Mr. Jean Fabre who wrote assetMaker and we came up with an agreement to have it fully integrated into MonoSQLite. He said he'll have it working before the Unite Conference begins! Does it meet your expectations? Please, let us know!

Att,
Eduardo Capanema

That will take MonoSQLite to the next level, Like I said before, I am not dissatisfied with MonoSqlite, but having prebuilt scripts integrated to work with datasets will make it not only useful but will signifigantly reduce the time to prototype anything dealing with a database. Kudos to both of you guys, keep up the good work.

[bioduds]

Great, man! Thank you very much!

When it's done I'll let you know!

Att,
Eduardo

[jeanfabre]

Hi,

 The way I see the integration between monosqlite and arrayMaker is the following:

1: A GameObject will be created solely to host the arrayLists of the dataset. so you'll have one arrayList for each column of the table you are querying, I think it will be a very good and flexible start.

2: The opposite could be true, I think I could take a gameObject, analyze its arrays and build/update the corresponding tables and data back to monoSqlite. So effectivly, you could load AND save datasets to monosqlite very easily.

2: The big issue I am having theoretically with monosqlite at the moment is that it doesn't support vectors, bool, etc etc. So a big part of the job will be to write a proxy that will allow users to store a vector3 for example without caring about how it's actually defined in the database. I think this will greatly increase the range of possibilities for monosqlite.

This is all very theoretical, I have yet to dive into all this properly.

bye,

 Jean

[Sjones]

I was wondering if someone from this thread could help me, I have recently looked into monosqlite, as I belive this is exactly what I need, however theres a few issues, one I have made several attempts to sign up to their forums and have failed. there has also been reports on their forum that a recent-ish build is incomparable with android os, further more the developers from the site have not posted on their forums in some time.

their next version 2.0 that was supposedly be out soon has also not been released yet, this was to contain the inventory system example using playmaker (from what I gather its the one that amy made / helped with)

can anyone confirm that the latest release is working for android?
and is there any tutorials on how to do inventory?
also does anyone know the status of the dev team over at mono?

[jeanfabre]

Hi,

 It's cooking, at least from my end, I don't know what will be included in the next release, but as far as I know, I am waiting for a small update on the api so that I can propose a fully fledge wizard to create the necessary actions needed for you to work with MonoSqlite within playmaker.

 I have attached few screenshots of the wizard. It's still in alpha, and would not work with the current version of monosqlite anyway, so as soon as it's out, it will all go then pretty quick.

bye,

 Jean

[Sjones]

the support on these forums are outstanding, have joined many communities and never had so much response or help, this is fantastic.

now I am ready to buy monosqlite as soon as 2.0 comes out as long as it works for android

one thing I am unsure about at the moment, that I was hoping the tutorials released by the mono team, is how to use the database in a save and load situation, say for an inventory, on level load it makes sure that all the items that was there at the end of the game are loaded and placed, this is not covered in their current tutorial list.

also it looks as if some people may have them on skype, any chance that someone could poke them (amy possibly if she is around still) find out what's happening over there?

[PIXELCRY]

someone who saved the actions can post them ? cant find them anywhere 

[PIXELCRY]

found it here

[gamedivision]

Hey has this asset been taken off the asset store I cant find it

[jeanfabre]

Hi,

 It seems so yes. too bad. There are plenty of other solutions tho.

bye,

 Jean

[vrgz]

Hey has this asset been taken off the asset store I cant find it

this sql plugins is dead.....

[gamedivision]

i spoke with the developer he is no longer working on this

[memetic arts]

This is sad.  I'd just "discovered" MonoSQLite, only to reach this thread and find that it's dead in the water . . .

Jean, you mentioned that there other solutions . . . could you name a few please?

Thank you!

[jeanfabre]

Hi,

 I am using sqliteKit as a replacement on my DataMaker tool, and now there are plenty different solutions on the asset store really.

there is the NoSql asset as well that has playmaker support, but I haven't tested this yet, so don't know how far it goes, but looks very good.

Bye,

 Jean