SQLite
Posted: Mon Dec 27, 2010 11:48 am
Would be be feasible or better to store the database in SQLite? I see that bindings for Lua is available.
That was one option when I started but I decided against it for a few reasons:
- there is no way to make sqlite use the physfs layer for write functions (or ratehre I suppose it's possible; but too cumbersome)
- the current format allows for total liberal data structure; this means modules can create new kind of data structures without even thinking about it. Using a SQL* would mean that authors would need to define schemas & dump/load layers for each class/subtable/... or that the SQL schema would need to be so generic it would be meaningless to use SQL at all :/
Why do you ask BTW ? Is the current saving still too slow?