This documentation will focus on NodeJS code, however all objects and functions are directly transferrable to C, Vala and Python.
SpinoDB was originally created to power a web crawler and discord bot. The bot had to reply to people in real timewhile doing complex queries on collections that contained millions of documents. After much frustration with an enterprise grade database (and also for self interest), SpinoDB was developed and introduced. Queries that were taking several seconds were now taking only a few milliseconds, server CPU useage was lower, though unsuprisingly RAM useage increased.
SpinoDB integrates nicely with Node & Express. By switching from an enterprise grade solution to SpinoDB, small/medium websites might notice improvements in website responsiveness and lower server CPU useage.
Bots and online services that require fast document retrieval may find SpinoDB a more appropriate solution than a fully fledged enterprise system.
SpinoDB may also be used as a fast cache to complement a traditional database.
Desktop applications can use SpinoDB as an alternative to creating an ad-hoc format for application specific data.
- application settings
- data logging
- application specific data
The practical limits are determined by
- how much RAM your system has. It is an in memory database.
- loading / saving time. If your system is reasonably spec'd you could budget ~100MB/s to load and save the database to a file.
As a rule of thumb, if the size of your data is greater than 50% of your available RAM, or if the save time is unmanageable, then this isn't for you.