Apologies if this is something of a 'noob' question - databases where never my strong point.
I have the need to for a lightweight database where the data is ideally mapped to a file. My DB needs to store some predefined values and a set of arbitrary user defined values: I see this as a table with some user defined columns i.e.
% key, name, size, type, user1, user2, etc 001, f1.txt, 235, xml, x, y, z, ... 002, f3.txt, 675, xml, a, b, c, ... %
I need to be able to search for any entry on any column value.
Would the Jx9 interface allow this?