RocksDB for desktop applications

[Casandra Armeanu]

Hi, 

I have a Windows desktop application that currently stores data in a custom file format - developed in-house. The data size on disk ranges from 300MB to 50GB.  
I am considering replacing the current data support file with RocksDB.
I need guidance from the expert community/ RocksDB gurus on assessing the feasibility of RocksDB as a solution for this case.  

I have some questions regarding my particular use case:
1. Is it feasbile to use Rocks DB as a storage for a Windows desktop application ?
- I noticed it is mainly used for server applications. Are there any known limitations for using it with Windows desktop application?
- Are there any examples of Windows desktop applications that use RocksDB as a data support?

2. In my scenario users transfer Rocks DB folders between their different machines, does RocksDB support this transfer action?
Are there any known risks/drawbacks?

Thanks, 

Casandra

[Dan Carfas]

Hi Casandra,

The answer is yes and yes. There are many implementations of RocksDB on Windows and you can copy RocksDB when the database is closed or else take a checkpoint and copy it.

Dan Carfas

Speedb Hive

--
You received this message because you are subscribed to the Google Groups "rocksdb" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rocksdb+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rocksdb/066f9bd5-16fe-408e-8e57-22ebdbf06134n%40googlegroups.com.

[Adam Retter]

I think the first question I would have is, what data structures are you working with that you are replacing? Are you specifically looking for a Key-Value (and column) store?

--

[Casandra Armeanu]

Hi Adam,

The app stores all data as key-binary value in a single binary file. The app needs only to read/write random objects at specific keys. Object binary data ranges from KB to MB in size. 

[Casandra Armeanu]

Hi Dan, 

Can you please share some examples of Desktop applications using RocksDB on Windows, and are any of them commercial apps?

[Adam Retter]

Sounds like RocksDB could work. For larger values you might want to look at the BlobDb interface 

[Casandra Armeanu]

Hi Jon, 

What do you mean by "it doesn't like to transfer the db file directories and continue to function properly"? Can you please share some examples? Have you encountered any issues when copying a db file directory from one computer to another? Thank you!

On Fri, Nov 10, 2023 at 1:33 AM Jon Groff <jonat...@earthlink.net> wrote:

I use it with Java in various embedded and server apps on multiple platforms (windows/ linux arm). I notice it doesnt like to transfer the db file directories and continue to function properly. Not sure if this is my use case or something inherent in the system.

Jon Groff

To view this discussion on the web visit https://groups.google.com/d/msgid/rocksdb/CAPK0iciXyosXUpxiAN%2BDeABBpzJ%2Bd2E-w_gcP0UOQMcY3dq7jQ%40mail.gmail.com.