Hi, I used SQLite to move "data-cube" from server to client. The server hosts data in MS SQL databases. There is a server-app that run query based on some input send by client program. The server then run MSSQL query and generate a SQLite db consisting of some tables (fact, dimensions, etc), zip it and send back to the client. The client program then allows user to manipulate dimensions (to maybe slice/dice the result) without having to access the huge databases on the server anymore...
best regards, radzi. ----- Original Message ----- From: "Lars Aronsson" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Tuesday, February 12, 2008 1:51 AM Subject: [sqlite] Innovative examples / user stories > > Is there any documentation of how people use SQLite in odd ways in > their everyday activities? For example, do you e-mail SQLite DB > files between you, as if they were Excel spreadsheets? Or do you > distribute SQLite database files via BitTorrent? Even with multi > table databases? That would be a kind of database use that was > unheard of in the Oracle/DB2 era, but it certainly should be > possible with SQLite. SQLite databases files could be used in a > "seti @ home" kind of application, where a screensaver downloads > an existing DB file, processes it for some hours, and then uploads > the resulting DB file again. But are any such applications or > user stories known? Is there a list already? > > I've read the Wikipedia article and its list of Google Gears, > Android, Mac OS X Tiger, etc. I've also seen the "well-known > users of SQLite" page on sqlite.org/famous.html and the "When to > use SQLite" page. > > I've used Oracle since version 7 and MySQL since 3.23 (which isn't > very long at all, but anyway). The switch from Oracle to MySQL > was made possible for many people because their database was > embedded behind a web application anyway (look, no DBA!), so full > transaction handling wasn't really needed. That shift in usage > pattern opened up for a simpler and more affordable solution. > Many other such technology shifts are described in an old book > titled "The Innovator's Dilemma". > > > -- > Lars Aronsson ([EMAIL PROTECTED]) > Aronsson Datateknik - http://aronsson.se > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
