From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00 autolearn=ham autolearn_force=no version=3.4.4 X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 103376,218b3332778031f X-Google-Attributes: gid103376,public X-Google-ArrivalTime: 2002-11-23 12:10:50 PST Path: archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!news-FFM2.ecrc.net!eusc.inter.net!news.eusc.inter.net!boavista.snafu.de!news From: Michael Erdmann Newsgroups: comp.lang.ada Subject: Re: A little database Date: Sat, 23 Nov 2002 21:13:07 +0100 Organization: gnade.sourceforge.net Message-ID: References: <3dd49c15$0$303$bed64819@news.gradwell.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit X-Trace: news.eusc.inter.net 1038082249 26651 213.73.71.87 (23 Nov 2002 20:10:49 GMT) X-Complaints-To: abuse@eusc.inter.net User-Agent: KNode/0.7.1 Xref: archiver1.google.com comp.lang.ada:31190 Date: 2002-11-23T21:13:07+01:00 List-Id: Victor Porton wrote: > I want to keep a little database (containing information about several > Web sites) on the disk. > > It is desirable (but not necessary) to have the file format > portable among platforms and compilers (however I use only GNAT). > > In your opinion, All, should I use XML or just 'Read/'Write etc. > attributes? Or may be there are a special Ada library for such small > databases in disk files? > > Well, the database shall be editable by the user with my GUI. It depends how dynamic your data will be and how complex your queries will be. If it is just 50 updates per day and you are doing retrieving you data based on simple pair queries using XML will be the best idea. If it comes to more complex queries and issues like concurent writing, record locking and transaction rates > 1 transaction per min. i would always recommend the usage of a real relational database like posesql via ODBC(e.g. see http://gnade.sourceforge.net). Regards M.Erdmann