On 15 Sep 2012, at 12:08pm, Elefterios Stamatogiannakis <est...@gmail.com> 
wrote:

> What i would really like to have in SQLite concerning OLAP, would be bigger 
> pages,

You can set pagesize for a new database using a PRAGMA:

<http://www.sqlite.org/pragma.html#pragma_page_size>

The maximum allowed pagesize is 65536 bytes.  Create a new database file, then 
issue the PRAGMA before any CREATE commands.  If you have an existing database 
and want to change it you have to export the data, make a new database and 
import the data again, but this can all be done in two commands to the shell 
tool.

> and internal page compression in a similar manner that column stores do [^]. 
> This would greatly alleviate the storage pain of using denormalized DBs which 
> is a must for OLAP.

This feature would indeed be suitable for a server-client database engine 
designed to run on multipurpose computers.  But SQLite is designed more in 
embedded machines in a single-processor environment.  For example, my TV 
recorder uses it to list the TV channels and meta-data about its recordings, 
and I have an extremely low-power GPS device which uses it for Positions of 
Interest.  The fact that SQLite turns out to be so useful as an embedded DBMS 
inside, for example, a web browser is just a bonus.  As the documentation says, 
if you need network-savvy client-server stuff, look elsewhere.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to