Unity Community


Page 1 of 5 123 ... LastLast
Results 1 to 20 of 96

  1. Location
    Brazil
    Posts
    79

    MonoSQLite is up and running! SQLite universal solution for Unity3D

    Links to: OUR BLOG, OUR FORUM and OUR WIKI

    MonoSQLite is a plugin developed for Unity3D C# programmers in order to allow them to use SQLite database capabilities from within their Unity3D projects and up to almost any output device. It works seamlessly in both Editor and iOS devices using iOS Basic or Pro Licenses, in Android devices, also using iOS Basic or Pro Licenses as well as PC & Mac Standalone builds. Additionally, and most significantly, it allows the users to ship their databases “as is” up to the targeted devices, thus eliminating the effort of recreating programmatically all DB’s data structures.



    The best feature of MonoSQLite plugin for Unity3D is, however, the simplicity. Borrowing a famous quote from Steve Jobs: “We must strive to reach the simplicity that lies beyond sophistication”. That’s how we chose to develop and deliver MonoSQLite. All databases (if your game or application uses more than one db) can be queried from the C# scripts using simple SQL syntax, allowing the users to get full access and control over the SQLite databases within their game using only two very simple methods: ExecuteFreeQuery() and ExecuteVoidQuery(). Only two methods to administer your database and build up your game or application only once!

    Additionally, Unity itself has been constructed through a minimalist paradigm which, in terms, reaches the most significant level of usability pursuing the least effort or shortest-path to accomplish any goal. That is also one of our intentions herein. By providing the simplest and most direct tool to achieve what is expected to be done, we sincerely believe we can touch the very core of technology which should, by concept, turn everyone’s life easier.

    ASSET STORE DIRECT LINK
    Last edited by MonoSapiens; 06-12-2012 at 11:56 PM. Reason: added links


  2. Posts
    1,550
    this looks really very useful and i could well be looking at it carefully in future so i hope you get enough support and interest in this endeavour to maintain development!


  3. Location
    Brazil
    Posts
    79
    Thank you very much for your kind words, LazyGunn.

    It is truly a very useful asset. We're using it now to build all our games in all platforms using Basic Licenses and, since it made our lifes so easy, we have decided to share through the Asset Store [ASSET STORE LINK]

    This is our first product available at the Asset Store and, of course there is still (and always) room for improvement and so we do ask for every single client to give us any feedback possible. Therefore, our Contact Form is available or you can simply send us an email using mono@monosapiens.com.br

    Please, whenever you feel like taking the special look you said you could take in the future, contact us. We will be happy and proud to give you any support and hear all you have to say about our product.

    Video Tutorials are available in our YouTube Channel and you can also find us by Twitter or Facebook.


  4. Posts
    11
    I'm using monosqlite. I can't run an INSERT statement on the iphone. SELECT works fine but INSERT just does nothing, yet in the Editor INSERT works just fine. I'm trying to sort this out but I can't find any forums or support sites for this product so I am asking here.


  5. Location
    Brazil
    Posts
    79
    Thank you very much ozRocker for finding us here.

    We are working currently on our forum to make these requests easier and faster to be worked with. Meanwhile, we have sent you full support via email to have all your questions answered exactly the way you need. We'll also extend our support with FAQs and clients considerations to get the best out of our product and full satisfaction from our clients.


  6. Posts
    11
    hello monosapiens, thanx for helping me sort out this problem. That was super-quick response! Great product btw, saves me a lot of time with my apps. I only have to watch 2 youtube videos and I know how to use it properly.


  7. Location
    Brazil
    Posts
    79
    Thank you so much, ozRocker.

    We are very pleased to see that you really liked MonoSQLite and to know that it does what it has been built to do: make your life much easier. Please, don't hesitate to contact us whenever you feel like it. We are bringing a Playmaker extension to MonoSQLite pretty soon to turn what was easy into something even easier! Forum is also on its way as soon as we migrate our blog to our new server.

    Thanks!
    MS


  8. Location
    Los Angeles, CA
    Posts
    191
    Is there no way to create a database? I'm trying to create a database from an editor script (by just NEW'ing the object with a filename that doesn't exist in the filesystem yet) but when I try to execute queries in it I always get this error:


    SqliteSyntaxException: file is encrypted or is not a database
    Mono.Data.SqliteClient.SqliteCommand.GetNextStatem ent (IntPtr pzStart, System.IntPtr& pzTail, System.IntPtr& pStmt)
    Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (CommandBehavior behavior, Boolean want_results, System.Int32& rows_affected)
    Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (CommandBehavior behavior)
    Mono.Data.SqliteClient.SqliteCommand.ExecuteDbData Reader (CommandBehavior behavior)
    System.Data.Common.DbCommand.ExecuteReader ()
    System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader ()
    MonoSQLite.MonoSQLiteDB.ExecuteFreeQuery (System.String query)
    ChunkExporter.Export () (at Assets/Mobile Test Stuff/Scripts/Editor/ChunkExporter.cs:23)


  9. Location
    Brazil
    Posts
    79
    Hello, quitebuttery.

    Thank you very much for your post.

    Here's the deal: when you're using SQLite, the databases are the very files which are holding the tables. This is different from MySQL and SQL Server that allow you to create databases on the run (I believe you do know this). This way, if you need to create a database, you'll need to, either copy a file with a seed database you must initially provide to the file system (since you're trying to do it in the Editor, I would advise you to check for the FileUtil class. Perhaps CopyFileOrDirectory() might do your trick.) or, create a .sqlite file from scratch which would require adding some namespaces and using sqlite classes like this:


    Create a c# file inside the Editor folder. Edit it:

    Code:  
    1. using UnityEditor;
    2. using UnityEngine;
    3. using Mono.Data.Sqlite;
    4.  
    5. static class MenuSQLiteHandler {
    6.  
    7.     [MenuItem("My Menu/Create SQLite DB")]
    8.     static public void CreateSQLiteDB() {
    9.        
    10.         SqliteConnection.CreateFile( Application.streamingAssetsPath + "/db.sqlite" );
    11.        
    12.         EditorUtility.DisplayDialog("Success!", "Success!" +
    13.             "DB created successfully in the Streaming Assets folder", "OK!" );
    14.        
    15.        
    16.     }
    17.  
    18.  }


    Then, refresh the StreamingAssets folder to see the db or wait a few seconds.

    Anyhow, if your intention is to have only another database, I advise you get Navicat or SQLite browser and create the seed db inside StreamingAssets Folder. Please, watch for our next updates of MonoSQLite because things are going to get even easier for the user in a near future.

    Also, please register to our forum if you will and tell me if this is the answer you need. Our goal is to provide the best support ever for our clients.

    Thanks,
    Eduardo Capanema
    Last edited by MonoSapiens; 06-26-2012 at 06:02 PM.


  10. Location
    Los Angeles, CA
    Posts
    191
    Yeah, I can just use a blank one from Navicat. But now I'm having a problem telling your plug-in where the database is. It seems to append the user's profile path to any path I pass to New. Is there any way to get it to pick up the sqlite database from a folder I specify? I want to put it in StreamingAssets or Resources.


  11. Location
    Brazil
    Posts
    79
    Great.

    So let me see if I can help you. First, put all databases in the StreamingAssets folder. It's the only folder it will work.

    Now, grab this file here: http://www.monosapiens.com.br/monosq...oSQLiteMenu.cs

    and put it inside the Assets/Editor folder or create the c# there and copy and paste inside.

    Now, on the Menu, you'll see MonoSQLite, choose Builds and click Sync DBs.

    Then, try to execute your code. Tell me if it worked.

    If this does not work, please, send me the code through mono@monosapiens.com.br or post it here or in the forum, i've created a post just for you there: POST.


  12. Location
    Los Angeles, CA
    Posts
    191
    Well if I just New with the filename, it's not looking in StreamingAssets.

    When I execute this line:

    MonoSQLiteDB db = new MonoSQLiteDB("chunk.sqlite");

    I get this error:

    Stablishing connection to: URI=file:/Users/ralph/Library/Caches/xxx_yyyy_com/GameProject/chunk.sqlite


  13. Location
    Brazil
    Posts
    79
    Excellent! So, just get this code I sent you, do the Sync DB and it will work. Please, tell me if it worked.


  14. Location
    Los Angeles, CA
    Posts
    191
    Like I said above, this doesn't work. It's not looking in streaming assets, look at that error message.

    I'm calling this from an editor script, is that a problem with the pathing?


  15. Location
    Brazil
    Posts
    79
    Correct! In the editor, it does not look in the StreamingAssets folder, it looks in that path you just sent. You must copy it to this path like the tutorial video says. But this code I just sent you with the Sync DB will do it for you. And it will work.


  16. Location
    Los Angeles, CA
    Posts
    191
    I get it now. This seems unnecessary though. Why not make it work in StreamingAssets in the editor as well? The path is accessible.


  17. Location
    Brazil
    Posts
    79
    Because the asset is universal. It must work in the editor, the android, the iOS and Standalone. The way it can work is by putting in the StreamingAssets folder but, also, persisting in the PersistentDataPath. Specially for Android. But, in the editor, the db must be copied to that path. With the script I sent you it is being done by simply clicking Sync DB but, at the time we launched, this functionality wasn't available.

    Please, tell me if it is working now.

    Att,


  18. Location
    Los Angeles, CA
    Posts
    191
    Yeah it works now.


  19. Location
    Brazil
    Posts
    79
    Excellent!

    I'm so very happy to "hear" that! I'm really truly engaged in putting up the best support ever. Anything else, just contact us.
    If you will, register in the forum as well.

    Thankfully,
    Eduardo Capanema
    Mono Sapiens


  20. Location
    Brazil
    Posts
    79
    The Asset Store is reviewing our current update that is bringing this solution I just sent you. When you update it, just simply remove this script from your Editor's so you won't have a duplicate.

    Att,
    Eduardo Capanema

Page 1 of 5 123 ... LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •