From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from mail1-relais-roc.national.inria.fr (mail1-relais-roc.national.inria.fr [192.134.164.82]) by walapai.inria.fr (8.13.6/8.13.6) with ESMTP id q0T9uecf013642 for ; Sun, 29 Jan 2012 10:56:40 +0100 X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AmkBAI0XJU9KfVI0imdsb2JhbABCgk2sBAgiAQEBCgkNBxIGIYILAhMZARseAxIJB10BEQEFASIbGqBkgl0Ki2qCb4N0P4hxAgULiFsDBAE7A4QhGAEBAQEBAQECAgUBgzkElRqOFT2EAA X-IronPort-AV: E=Sophos;i="4.71,587,1320620400"; d="scan'208";a="141909904" Received: from mail-ww0-f52.google.com ([74.125.82.52]) by mail1-smtp-roc.national.inria.fr with ESMTP/TLS/RC4-MD5; 29 Jan 2012 10:56:25 +0100 Received: by wgbdq12 with SMTP id dq12so3993088wgb.9 for ; Sun, 29 Jan 2012 01:56:25 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; bh=Krke/ngZ4/WRbdsJ6NjRFM0yuoxuy3xMQ8bh9oWm5bw=; b=QZEb0IslbCHRufZcNtImr+O1KWgwUc7zzvVE/qklkum/irhiF6Ak/9ukxLHgyLLw4E jauGkQkERl/mNZVuXTnpWTfXhAMor/ayasu5IcGQtXnI+QDguFzQH/xeAiUDbNnF/YOS Fd6228C5ck0v/x8HRv1lFktVc2fZcg89umJ7Q= MIME-Version: 1.0 Received: by 10.180.101.101 with SMTP id ff5mr21691098wib.14.1327830985731; Sun, 29 Jan 2012 01:56:25 -0800 (PST) Received: by 10.216.51.207 with HTTP; Sun, 29 Jan 2012 01:56:25 -0800 (PST) Date: Sun, 29 Jan 2012 10:56:25 +0100 Message-ID: From: Diego Olivier Fernandez Pons To: caml-list Content-Type: multipart/alternative; boundary=f46d0442829c39eccc04b7a7be2c Subject: [Caml-list] SQL engine in OCaml with client side cache --f46d0442829c39eccc04b7a7be2c Content-Type: text/plain; charset=ISO-8859-1 Caml-list, I need an SQL server that a web-client can query and send the results to some JavaScript graphic package. My problem is that the bandwidth and server power are limited and paid per usage. On the other hand, the data I am working with has good properties - read only - client always looking at the same subset of data from "different angles" - easy to compute a subset of data the client will work on For instance the database contains 5 years of sales of a company in all their stores. Some clients will want to investigate all the products of a given store, other will want to compare a single product on all the stores, others the sales evolution per department per year, etc. Therefore I thought I could add a "cache" on the client side, meaning an in-memory SQL database that would receive a big block of data from the server and work on it till the client writes a query that needs some data that is not available locally in which case it would request it from the server, etc. I haven't found anything like that ready-to-use, so I was considering reengineering existing OCaml code (database + web) and maybe compile it to JavaScript. I have control on the client so I can afford installing an OCaml runtime if needed albeit impractical though. Does anyone has an SQL engine written in OCaml ? I can only find bindings. Also, has anyone tested the OCaml -> JavaScript on projects with significant computation work ? Diego Olivier --f46d0442829c39eccc04b7a7be2c Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
=A0 =A0 Caml-list,

I need an SQL server that a web= -client can query and send the results to some JavaScript graphic package.<= div>My problem is that the bandwidth and server power are limited and paid = per usage.

On the other hand, the data I am working with has good prope= rties
- read only
- client always looking at the same s= ubset of data from "different angles"
- easy to compute= a subset of data the client will work on

For instance the database contains 5 years of sales of = a company in all their stores. Some clients will want to investigate all th= e products of a given store, other will want to compare a single product on= all the stores, others the sales evolution per department per year, etc.

Therefore I thought I could add a "cache" on = the client side, meaning an in-memory SQL database that would receive a big= block of data from the server and work on it till the client writes a quer= y that needs some data that is not available locally in which case it would= request it from the server, etc.

I haven't found anything like that ready-to-use, so= I was considering reengineering=A0existing OCaml code (database + web) and= maybe compile it to JavaScript. I have control on the client so I can affo= rd installing an OCaml runtime if needed albeit impractical though.

Does anyone has an SQL engine written in OCaml ? I can = only find bindings. Also, has anyone tested the OCaml -> JavaScript on projects with significant computation wo= rk ?

=A0 =A0 =A0 =A0 Diego Olivier
--f46d0442829c39eccc04b7a7be2c--