From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from nez-perce.inria.fr (nez-perce.inria.fr [192.93.2.78]) by yquem.inria.fr (Postfix) with ESMTP id 20D82BB81 for ; Wed, 28 Dec 2005 10:04:30 +0100 (CET) Received: from pauillac.inria.fr (pauillac.inria.fr [128.93.11.35]) by nez-perce.inria.fr (8.13.0/8.13.0) with ESMTP id jBS94TKv030709 for ; Wed, 28 Dec 2005 10:04:29 +0100 Received: from concorde.inria.fr (concorde.inria.fr [192.93.2.39]) by pauillac.inria.fr (8.7.6/8.7.3) with ESMTP id KAA04226 for ; Wed, 28 Dec 2005 10:04:29 +0100 (MET) Received: from mail.enyo.de (mail.enyo.de [212.9.189.167]) by concorde.inria.fr (8.13.0/8.13.0) with ESMTP id jBS93ww5014724 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=NO) for ; Wed, 28 Dec 2005 10:04:28 +0100 Received: from deneb.vpn.enyo.de ([212.9.189.177] helo=deneb.enyo.de) by mail.enyo.de with esmtp id 1ErXDu-0002VK-73; Wed, 28 Dec 2005 10:03:54 +0100 Received: from fw by deneb.enyo.de with local (Exim 4.60) (envelope-from ) id 1ErXDp-0003AO-Kk; Wed, 28 Dec 2005 10:03:49 +0100 From: Florian Weimer To: David MENTRE Cc: caml-list@inria.fr Subject: Re: [Caml-list] Persistent storage and stability of Marshal? References: <87wthruedp.fsf@linux-france.org> <87hd8uwa65.fsf@mid.deneb.enyo.de> <87k6dptx38.fsf@linux-france.org> Date: Wed, 28 Dec 2005 10:03:49 +0100 In-Reply-To: <87k6dptx38.fsf@linux-france.org> (David MENTRE's message of "Wed, 28 Dec 2005 10:00:43 +0100") Message-ID: <87oe31r3t6.fsf@mid.deneb.enyo.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Miltered: at nez-perce with ID 43B2551D.000 by Joe's j-chkmail (http://j-chkmail.ensmp.fr)! X-Miltered: at concorde with ID 43B254FE.000 by Joe's j-chkmail (http://j-chkmail.ensmp.fr)! X-Spam: no; 0.00; caml-list:01 ocaml:01 bindings:01 integers:01 reals:01 integers:01 writes:01 marshal:01 strings:01 strings:01 data:02 florian:02 florian:02 binding:02 binding:02 X-Spam-Checker-Version: SpamAssassin 3.0.3 (2005-04-27) on yquem.inria.fr X-Spam-Level: X-Spam-Status: No, score=0.0 required=5.0 tests=none autolearn=disabled version=3.0.3 * David MENTRE: > Hello, > > Florian Weimer writes: > >> Have a look at SQLite. I like it a lot. During the past couple of >> months, even a few Ocaml bindings have sprung into existence. > > Yes, I looked at it through Dbi[1]. There is however an issue: it seems > that everything is stored as a string in an SQLite base. Returned data > after Dbi query are typed as string. > > It might be an issue with Dbi itself (I haven't looked to the SQLite > binding themselves) but after looking at SQLite documentation, it does > not seem to be the case[2]. It's got manifestant types. There are strings, integers, reals and BLOBs (and NULL, of course). You need a binding which stores integers as integers, and not as strings, though. SQLite mostly ignores column types and uses on;y the type of the value you insert into the database.