Search Unity

[Released] RsDb - Local RDBMS with SQL support - 100% C#

Discussion in 'Assets and Asset Store' started by heparo, Dec 8, 2016.

  1. heparo

    heparo

    Joined:
    Mar 22, 2013
    Posts:
    13
    Hello everyone,

    I am very pleased to present RsDb to the community available in the store !



    RsDb stands for "Really simple Database" : a lightweight RDBMS (Relational Database Management System) designed for Unity 3D.

    As much as possible, RsDb provides the functionalities of a classical RDBMS with SQL support with some particularities :

    • User : mono user - no identification nor authentification managment
    • Data : in memory database with file oriented storage for portability (1 local file = 1 database, offline)
    • Model : data is organized in tables (1 table = 1 collection of rows and columns)
    • Integrity : no duplicate rows in a table, type of a column is restricted, NULL is recognized, read-only mode
    • Constraints : not null, default value, identity, foreign key
    • Transactions : data modification can be committed or rolled back (if autocommit mode is off)
    • Information : content is described through system tables (all tables, all columns, all constraints)
    • SQL : data manipulation and query (SELECT, INSERT, UPDATE, DELETE, CREATE, SET, ALTER)
    • Instanciation : through a proxy class with synchronous / asynchronous executions
    • Studio : complete graphical client for an enhanced experience
    • No dependency : RsDb is 100% coded using C# and do not rely on any third party librairie
    • Compatible with Unity 4 and 5 - No DLL, cs files only !!!

    <Version 20161117120000>
    • Initial released version
    In complement to a user request, the documentation included in the asset is now accessible from my website at www.heparo.com/img/portfolio/rsdb/documentation/rsdb_manual.html

    <Version 20170118120000>
    • RsDb studio : EditorWindow.GetWindow is now handled properly avoiding taskbar flashings and other focus problems
    • Serializer : using UNITY_5_0_OR_NEWER all databases will now be compressed using GZipStream (normal decompression mode is used if file is not a GZip one)
     
    Last edited: Nov 30, 2017
    heparo, Dec 8, 2016
    #1

  2. heparo

    heparo

    Joined:
    Mar 22, 2013
    Posts:
    13
    New update available

    <Version 20171127160000>
    • RsDb studio : while in play mode, launching the editor is now blocked and a dialog informs the user
    • RsDb studio : the instance of the EditorWindow could sometimes be lost and it is now better handled (OnDisable and OnEnable)
    • RsDb studio : an empty result now explicitly generates an empty result grid with a "No result found" message
    • RsDb studio : the case of executed statements are not uppered any more
    • RsDb parser : an horrible mystake is now corrected with the right handling of double quoted in a string value (documentation of 'Term' is updated )
     
    heparo, Nov 30, 2017
    #2