SQLite
Moderator: Moderator
-
Omega Blue
- Thalore
- Posts: 190
- Joined: Sun Oct 31, 2010 2:50 pm
SQLite
Would be be feasible or better to store the database in SQLite? I see that bindings for Lua is available.
Re: SQLite
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?
- 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?
[tome] joylove: You can't just release an expansion like one would release a Kraken XD
--
[tome] phantomfrettchen: your ability not to tease anyone is simply stunning
--
[tome] phantomfrettchen: your ability not to tease anyone is simply stunning