wiz.bin question

[wayner]

What type of database is wiz.bin? Why is it this type and what are the advantages vs something like SQLite or MySQL?

[Narflex]

It's "Jeff's Custom Object Database" format.

I wanted to have a true Object database where everything in it corresponded to an actual Java object that I could just use normally and not have to worry about making actual database queries throughout the source code. It also allowed me to write logic which keeps it synchronized between all the clients & server simultaneously without having to do server RPCs for every database query on the client (although there's likely replication logic in SQLite/MySQL that could do the same thing).

There's a huge amount of work to replacing it at this point...all the core SageTV code has been written expecting that all of the database items are actually just in memory Java objects that can be treated that way. Theoretically it could all have been done with Java object serialization...but that doesn't have the client/server sync, and 'delta transactions' that are part of what SageTV has.

[wnjj]

Originally Posted by Narflex

It's "Jeff's Custom Object Database" format.

Is that why the class is called Wizard?

[Narflex]

Originally Posted by wnjj

Is that why the class is called Wizard?

Yup.