This article is providing the quick insight and get you started with ScimoreDB.
Are you looking for highly available, scalable database? Right, sounds like a lot of things to review. We will guide you how to install cluster of 3 machines, verify it works. Add 3 more machines, verify it scales. Unexpectedly stop machines, verify it failover's and continues operational. Please follow the distributed database example here.... You can also check the step by step guides:
Embedded database installation is simple. Just go to download page, download either x86/x64 MSI package and install. During installation, uncheck the "Server" feature. The MSI will install a manager GUI application and .NET provider. The .NET provider "scimore.data.scimoreclient.dll" package embeds database engine. The application, using ScimoreDB embedded database only need the provider. The provider works in 32 bit or 64 bit environment, depends of your application configuration. If your application is .NET and platform independent, the provider will utilize 64 bit engine in 64 bit OS, or, 32 in 32 bit OS.
Read how to connect to embedded or client/server database here.
A standalone server is a cluster with only one node. To register a single node cluster (server), execute (first time connecting after install):
CREATE CLUSTER ENDPOINT ('localhost:999'); COMMIT CLUSTER;
We assume you already have an existing SQL Server, MySQL or other database. ScimoreDB is aiming to be close to SQL Server, yet, we hope, importing some other database should be not that difficult.
ScimoreDB Distributed and Embedded databases are not secure, by default. This is not such a good idea when you ship your product. ScimoreDB has the mechanism to secure its data and integrity: sysusers and syspermissions tables. The tables are responsible for authenticating user access to the ScimoreDB server, and subsequently associating those users granted access with a set of privileges.
These permissions set what a user is capable of doing while connected to the ScimoreDB, controlling the user's activities on a server,database and table level. There are 3 types of users in ScimoreDB security model: Administrator, Users and Database Roles. The Administrator is almighty who creates users/roles and grants the permissions. To secure the database (you might already guessed), you need to create administrator. Click on the following example to learn how to secure the database, create users/roles, and, grant, deny or revoke the privileges.
Check step by step how to sample using free text search
Check the samples page and learn by example. There, you will find how to use ScimoreDB in C++, C# and VB.NET.
So you got running Scimore database. What's now? Well, you may start by checking out some useful links: