iBoxDB Embeddable Object Document NoSQL Database Storage Engines Download

Project Description

iBoxDB is a fast transactional table style document NoSQL Application Database, easily store, process objects and documents, traditional table with unstructured data, zero configuration, pure JAVA and .NET engines, no dependencies.

iBoxDB has a well designed interface with great performance and capability for agile development. You can create applications with database services embedded and deploy it on mobiles, desktops, servers, to persist your data from anywhere.

Dual Core Application Database
For   JAVA   C#   Android   Unity   Xamarin   Mono   Nashorn   Linux   Windows

Features

• CRUD
• KeyValue and KeyOnly tables
• Unique and non-unique indexes
• Unique and non-unique composite indexes
• SQL like query language
• Transactions support
• Concurrency control, thread safe
• Memory management
• Scalable hot MasterSlave and MasterMaster replications
• On disk and in memory databases supported
• Automatically create databases
• Zero configuration, copy and run, purely managed code
• Dynamic columns
• Different types with different indexes can be stored in same table
• Persistence + ORM + Cache + Embeddable, ONE STOP solution
• ResultSet compatible with LINQ
• High performance, no dependencies
• Update Increment
• Selecting Tracer
• Snapshot-Serializable Isolation
• JAVA6+   .NET2+

Download

import iBoxDB.LocalServer.*;

static DB db; 
static AutoBox auto; 
synchronized static void onApplicationStart() { 
  db = new DB(1); 
  db.getConfig().ensureTable("Table", Member.class, "Id") 
                .ensureIndex("Table", Member.class, "Name"); 
  //Tree->Parts 
  db.getConfig().ensureTable("Node", Node.class, "Id") 
                .ensureIndex("Node", Node.class, "Parent"); 

  db.getConfig().ensureTable("Part", Part.class, "Id") 
                .ensureIndex("Part", Part.class, "Node");
  auto = db.open(); 
}        
                         
void anywhere1() { 
  auto.insert("Table", new Member()); 
} 

void anywhere2() { 
  try (Box box = auto.cube()) { 
    box.d("Table").insert(new Member()); 
    CommitResult cr = box.commit(); 
  } 
} 

boolean exists(Box box) { 
  return box.selectCount("from Table limit 0,1") > 0; 
} 

<V> Iterable<V> startsWith(Box box, Class<V> vClass, String prefix) { 
  String begin = prefix; 
  char[] cs = prefix.toCharArray(); 
  cs[cs.length - 1] = (char) ((short) cs[cs.length - 1] + 1); 
  String end = new String(cs); 
  return box.select(vClass,"from Table where Name>=? & Name<?",begin,end); 
}

void treeJoin(Box box, long nodeRoot, int maxLevel, StringBuilder result) { 
  if (maxLevel > 5) { return; } 
  char[] cs = new char[maxLevel * 2]; Arrays.fill(cs, ' '); 
  for (Node node : box.select(Node.class, "from Node where Parent==?", nodeRoot)) { 
    result.append(cs).append("NODE:")
          .append("->").append(node.Id).append("\r\n"); 
    for (Part part : box.select(Part.class, "from Part where Node==?", node.Id)) { 
      result.append(cs).append(" PART:")
            .append("->").append(part.Id).append("\r\n"); 
    } 
    treeJoin(box, node.Id, maxLevel + 1, result); 
  } 
}

synchronized static void onApplicationClose() { 
  auto.getDatabase().close(); 
} 

using iBoxDB.LocalServer;
using iBoxDB.LocalServer.IO;

public class ApplicationServer : LocalDatabaseServer 
{ 
  public static ApplicationServer App = new ApplicationServer(); 
  public static IDatabase DB(long address) 
  { 
    return App.GetInstance(address); 
  }

  abstract class Config : BoxFileStreamConfig 
  { 
    public Config() : base() 
    { 
      CacheLength = MB(512); 
      FileIncSize = (int)MB(4); 
      ReadStreamCount = 8; 
    } 
  } 
                
  class MainConfig : Config 
  { 
    public MainConfig() : base() 
    { 
      EnsureTable<Member>("Member", "Id"); 
      EnsureIndex<Member>("Member", "Name(20)");
      EnsureTable<Product>("Product", "Type", "UID"); 
    }
  }
  
  class InventoryConfig : Config 
  { 
    public InventoryConfig() : base() 
    { 
      EnsureTable<Item>("Item", "Id"); 
    } 
  } 
                
  protected override DatabaseConfig BuildDatabaseConfig(long address) 
  { 
    switch (address) 
    { 
      case 1L: return new MainConfig(); 
      case 2L: return new InventoryConfig(); 
      default: return null; 
    } 
  } 
} 
                
void Anywhere1() 
{ 
  var auto = ApplicationServer.DB(1L).Get(); 
  auto.Insert("Member", new Member()); 
} 
                
void Anywhere2() 
{ 
  var db = ApplicationServer.DB(2L); 
  using (var box = db.Cube()) 
  { 
    box["Item"].Insert(new Item()); 
    CommitResult cr = box.Commit(); 
  } 
}

void OnApplicationClose() 
{ 
  ApplicationServer.App.Dispose(); 
}

<Project Sdk="Microsoft.NET.Sdk">
  <PropertyGroup>
    <OutputType>Exe</OutputType>
    <TargetFramework>netcoreapp2.0</TargetFramework>
  </PropertyGroup>
  <ItemGroup>
    <PackageReference Include="iBoxDB" Version="2.17.1" />
  </ItemGroup>
</Project>

//db.jsp
<%@page contentType="text/html" pageEncoding="UTF-8" session="false" %>
<%@page import="iBoxDB.LocalServer.*" %>
<%!
    public static AutoBox auto() {
        synchronized (DB.class) {
            if (DB.Tag != null) {
                return (AutoBox) DB.Tag;
            }

            String root = System.getProperty("user.home") + "/jsp_data/";
            new java.io.File(root).mkdirs();
            DB.root(root);
            DB db = new DB(1);
            db.getConfig().ensureTable(JSPUser.class, "JSPUser", "id");

            DB.Tag = db.open();
            return (AutoBox) DB.Tag;
        }
    }

    public static class JSPUser {
        public long id;
        public String name;
    }
%>

//index.jsp
<%@page contentType="text/html" pageEncoding="UTF-8" session="false"%>
<%@include file="db.jsp" %>

<%
    long id = auto().newId();

    JSPUser user = new JSPUser();
    user.id = id;
    user.name = "iBoxDB on JSP -" + user.id;
    auto().insert("JSPUser", user);
%>
<html>
    <body>
        <h1><%=auto().get(JSPUser.class, "JSPUser", id).name%> </h1>
    </body>
</html>

Start(){
    byte[] data = Convert.FromBase64String(PlayerPrefs.GetString("DB","")); 
    db = new DB(data);
    db.MinConfig().FileIncSize = 1; 
    ...
    auto = db.Open();
}  
Save() { 
    byte[] data = db.GetBuffer(); 
    PlayerPrefs.SetString("DB",Convert.ToBase64String(data)); 
    PlayerPrefs.Save(); 
}

if (GUI.Button(new Rect(0, 50, Screen.width / 2, 50), "Save")) { 
   Application.ExternalEval("FS.syncfs(false, function (err) {});"); 
}

DB db = new DB(DB.CacheOnlyArg);
//Heats engine up Before Application.Start()
//System.Threading.Tasks.Task.Run((Action)Hot);
new Thread(() => { Hot(); }).Start();
public static void Hot() { 
  var db = new DB(DB.CacheOnlyArg); 
  db.GetConfig().EnsureTable<Item>("Item", "Time", "Gid"); 
  var auto = db.Open(); 
  auto.Insert("Item", new Item()); 
  auto.Select("from Item"); 
  db.Close(); 
  MakeSureClassesAreLinked();
} 
private static void MakeSureClassesAreLinked() { 
  if (Object.ReferenceEquals(1, 2)) { 
    new System.IO.FileStream("", System.IO.FileMode.OpenOrCreate,
        System.IO.FileAccess.ReadWrite, System.IO.FileShare.ReadWrite, 1);
    System.IO.File.Exists(""); 
  } 
}

 sn -k kp.snk 
 ildasm A.dll /out:A.il 
 rename A.dll A.bak
 ilasm  A.il  /dll /key=kp.snk

//use a simple query to control search region
box.Select<User>("from User where Ver>? limit 0,1000", last) 
   //with a complex query to filter data
   .Where((u) => { 
       if ( u... )
        if ( u... )
          return u.Time > dt ;
   });

module newmodule { 
  //rename .jar 
  //cp iBoxDBv28.jar iBoxDB.jar 
  requires iBoxDB; 
                
  //The DB Classes package 
  exports app;   
} 

-XX:+UseConcMarkSweepGC 

License