Wols Lists wrote: > On 12/12/10 00:29, Darren Duncan wrote: >> Nonsense. An information schema is a *good* thing, and is generally the >> *best* >> tool for introspecting a database. It lets you use all the power features >> you >> have when querying data, anything a SELECT can do, and you can query the >> database structure likewise. This is the way a relational database is >> supposed >> to work. -- Darren Duncan >> _______________________________________________ > Okay, I'm not describing a relational database ... > > But one of the very nice features of Pick is it is self-describing. The > top level is a pick "table" called MD. This is described by a Pick > "table" called the dictionary. Everything in Pick is a FILE (the Pick > name for a table), from the top down. Even indices. > > Dunno how well that approach translates into a relational engine, > because Pick has several very non-relational quirks (every "row" MUST > have a primary key, the dictionary DEscribes, not PREscribes the FILE, > etc etc).
Can you say more about this last paragraph. These last couple items don't necessarily mean that Pick is non-relational given how they can be interpreted. (I don't know anything about Pick.) > But it means you can use your standard query tools to query EVERYTHING. -- Darren Duncan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users