Technical Specifications

Your data is safe

cubeSQL is fully ACID compliant. ACID stands for atomic, consistent, isolated, and durable and it deals with reliability of database transactions. This is important because it means that you don't have to worry about users accessing the database in an unfinished state. Users can't see changes that are being made but have not been committed. If the server loses power or crashes in the middle of a transaction, the server is restored to its untouched state automatically. ACID compliance is critical to any database you depend on.

Triggers help keep the integrity of your data intact

Database triggers enable DBSA's (Database Administrators) to create additional relationships between separate tables. For example, the modification of a record in one table could trigger the modification of a record in a second table. cubeSQL supports the creation of triggers that can execute when rows are inserted, updated or deleted on a table by table basis.

Save time on administrative tasks

The cubeSQL Admin application has an all new, easy to use and intuitive interface with far more functionality than ever before. Schedule and restore backups, examine performance statistics, view logs and more.

More Responsive

cubeSQL uses the state of the art socket technology provided by each supported platform to maximize performance. Thanks to its powerful architecture cubeSQL is able to work on all operations at the same time preventing large and time-consuming operations from slowing down other users.

SQLite Extensions

cubeSQL supports all SQLite extensions allowing you to take advantage of all kinds of new functionality that others have added to SQLite, the database engine of cubeSQL.

Your data is secure

The Advanced Encryption Standard (AES), also known as Rijndael, is a block cipher adopted as an encryption standard by the U.S. government. It has been analyzed extensively and is now used worldwide. cubeSQL supports AES encryption for writing data to the database and in all the network communication between the server and all the connected clients.

Simple file structure makes managing your database easy

Some database servers tend to store data as a large collection of files. Often these files are in a standard location that only the database engine itself can access. This makes the data harder to access and manage. Some SQL database engines provide the option of writing directly to disk and bypassing the filesystem all together. This provides considerable setup and maintenance complexity. cubeSQL keeps things simple. A cubeSQL database is a single ordinary disk file that can be located anywhere in the directory hierarchy. Database files can easily be copied onto a USB memory stick or emailed for sharing.

You can stay flexible because cubeSQL is cross-platform

cubeSQL is available for Mac OS X (x86 and PowerPC), Windows and Linux (x86). All the databases created by the server are cross-platform. A database file written on one machine can be copied to and used on a different machine with a different architecture; big-endian or little-endian, 32-bit or 64-bit does not matter. All machines use the same file format. Furthermore, we have pledged to keep the file format stable and backwards compatible, so new releases of cubeSQL can read and write older database files.

Restore Points

In the unlikely event of a disaster, your database will only be as good as your last backup. But what about the operations that happened AFTER the backup? No worries. With Restore Points, cubeSQL can now log every operation and allowing you to restore your database right up to a specific operation of your choosing.

Full-Text Searching

cubeSQL supports full-text searching making it possible to build a new class of database applications not possible with previous versions. You can now store huge amount of text-based data and search through it in seconds.

A server that will grow as you grow

cubeSQL can handle up to 10,000 concurrent connections from a single server installation! No need to install multiple servers and configure them for concurrency and load balancing. cubeSQL remains as simple to install and as easy to manage as ever while providing extraordinary scalability. Finally, cubeSQL is fully multi-core aware so it will take advantage of all the computing power you give it.

Faster access with automatic data compression

cubeSQL automatically compresses all data between the server and the client to greatly improve response time.

JSON

cubeSQL supports a custom lightweight protocol but in order to be as open as possible to third party clients, we added support for the widely used JSON protocol, so you can access the server using any client that supports JSON.

Plugins support

cubeSQL has a modular plug-in architecture and you can use it to extend the SQL language, change how your results are sorted or even create your own custom server commands. The plug-in architecture gives you the ability to enhance the power of cubeSQL in ways limited only by your imagination. A native plug-in SDK is included within each server's installation. MonkeyBread Software uses our official SDK to develop some useful plugins for the server.