Re: DB with list datatype?



Andreas Kochenburger wrote:

Hi, I am looking for a small embeddable database that allows lists as
datatype, similar to the internal database of a Prolog programming system.
I.e. the data are organized in tables, so it is a relational database. But
an element in a table can be a list of variable length, eg. a string list
or a number list
Any idea? Could SQlite do that with some magic tricky things?

PostgreSQL has an array data type and several language extensions to assist
in using them.

However, I would echo all of Bill's warning, with this conclusion about
putting lists into columns: "Abandon hope all ye who enter here."
--
Kenneth Downs
Secure Data Software, Inc.
(Ken)nneth@(Sec)ure(Dat)a(.com)
.



Relevant Pages

  • DB with list datatype?
    ... I am looking for a small embeddable database that allows lists as ... similar to the internal database of a Prolog programming system. ...
    (comp.databases)
  • Re: Split a list into two halfs
    ... between a spreadsheet and a relational database. ... as long as I do not scroll in one of the two lists it looks good. ... could synchronize both lists, so that both scroll simultaneouly, it would ...
    (microsoft.public.access.forms)
  • Re: A Succinctness Challenge
    ... I did not care about whether the spouses are lists or not. ... There isn't even SQL and/or a relational database ... Database objects in Pico Lisp are a first-class data type, ...
    (comp.lang.lisp)
  • Masterlist, everything on heap?
    ... Suppose I have a situation that's a bit like a relational database. ... stack and putting their pointers in lists, ... using those pointers in the construction of C objects.. ... the set of A's and B's, inserting them into the lists, and then using ...
    (comp.lang.cpp)