From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: X-Original-To: caml-list@yquem.inria.fr Delivered-To: caml-list@yquem.inria.fr Received: from concorde.inria.fr (concorde.inria.fr [192.93.2.39]) by yquem.inria.fr (Postfix) with ESMTP id C93CDBB81 for ; Wed, 28 Dec 2005 10:00:23 +0100 (CET) Received: from pauillac.inria.fr (pauillac.inria.fr [128.93.11.35]) by concorde.inria.fr (8.13.0/8.13.0) with ESMTP id jBS90Nwc014160 for ; Wed, 28 Dec 2005 10:00:23 +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 KAA05024 for ; Wed, 28 Dec 2005 10:00:22 +0100 (MET) Received: from smtp1.wanadoo.fr (smtp1.wanadoo.fr [193.252.22.30]) by concorde.inria.fr (8.13.0/8.13.0) with ESMTP id jBS90Mt0014157 for ; Wed, 28 Dec 2005 10:00:22 +0100 Received: from me-wanadoo.net (localhost [127.0.0.1]) by mwinf0107.wanadoo.fr (SMTP Server) with ESMTP id 42EB9A00015C for ; Wed, 28 Dec 2005 10:00:22 +0100 (CET) Received: from morgana (ARennes-257-1-77-153.w81-53.abo.wanadoo.fr [81.53.156.153]) by mwinf0107.wanadoo.fr (SMTP Server) with ESMTP id 133D6A000157; Wed, 28 Dec 2005 10:00:22 +0100 (CET) X-ME-UUID: 20051228090022789.133D6A000157@mwinf0107.wanadoo.fr Received: from david by morgana with local (Exim 4.50) id 1ErXAp-0001GV-O8; Wed, 28 Dec 2005 10:00:43 +0100 To: Florian Weimer 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> From: David MENTRE Organization: none Date: Wed, 28 Dec 2005 10:00:43 +0100 In-Reply-To: <87hd8uwa65.fsf@mid.deneb.enyo.de> (Florian Weimer's message of "Tue, 27 Dec 2005 21:35:14 +0100") Message-ID: <87k6dptx38.fsf@linux-france.org> User-Agent: Gnus/5.1006 (Gnus v5.10.6) Emacs/21.4 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Miltered: at concorde with ID 43B25427.000 by Joe's j-chkmail (http://j-chkmail.ensmp.fr)! X-Miltered: at concorde with ID 43B25426.000 by Joe's j-chkmail (http://j-chkmail.ensmp.fr)! X-Spam: no; 0.00; caml-list:01 ocaml:01 bindings:01 modcaml:01 datatypes:01 datatype:01 writes:01 marshal:01 integer:01 strings:01 data:02 data:02 awkward:02 florian: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 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]. I could work around this small issue by easily converting strings to integer, float, etc. but it seems a bit awkward to me. Beside that, you are right the SQLite is quite interesting: full SQL database but without the need to setup an SQL server. Best wishes, david Footnotes: [1] http://download.savannah.nongnu.org/releases/modcaml/ [2] http://www.sqlite.org/datatypes.html "" SQLite is "typeless". This means that you can store any kind of data you want in any column of any table, regardless of the declared datatype of that column. "" -- pub 1024D/A3AD7A2A 2004-10-03 David MENTRE 5996 CC46 4612 9CA4 3562 D7AC 6C67 9E96 A3AD 7A2A