| |||||||||||||
|
| |||||||||||||
Berkeley DB 4.5 availableBerkeley DB 4.5 availablePosted Sep 27, 2006 20:36 UTC (Wed) by mikov (subscriber, #33179)In reply to: Berkeley DB 4.5 available by yodermk Parent article: Berkeley DB 4.5 available
SQLite version 3 stores integers, floats and BLOBs as binary. Version 2 used to store everything as ASCII; while that incurred (usually small) overhead, it was a very simple and ellegant design.
In any case, unless you are manipulating large chunks of data, the overhead of conversion to and from ASCII is often quite negligible compared to everything elese that has to happen.
You also fail to consider the fact that reading a binary integer from disk in Java (HSQL is written in pure Java) requires reading the bytes separately and combining them - that is not that different from converting ASCII to string - both operations have negligible overhead. PostgreSQL's JDBC driver also transmits almost all values as text 9even though the wire protocol allows binary) and so far this isn't seen as a serious limitation.
At one time in the past I looked at HSQL and from their website and documentation I couldn't get a good idea of the internal design. That discouraged me from looking further. By comparison SQLite has several in depth document explaining all aspects of the architecture in complete detail.
Of course, if you language is Java, SQLite is not a serious option - there is a JDBC driver for SQLite, but AFAIK it is not very complete.
(Log in to post comments)
|
|
||||||||||||