Hi Terry, Last year, I used [Kexi](http://kexi-project.org/) to record an inventory of my personal hoard of electronic components.
But Kexi does not fulfil your requirements, in that the database would not be hosted on a website somewhere, and that it would not run on Mac or Windows (support for those platforms being "in development"). The database itself can either be a local Sqlite file, or a database server (MySQL or PostgreSQL). It is, however, open source and it is a GUI-based tool for the development and use of the database. Kexi is limited in terms of the types of constraints you can apply to the tables, and I found I had to write some of the queries in SQL instead of using the graphical query designer. It's also somewhat limited in terms of what kinds of forms you can create, and scriptability. I found Kexi to be at least one step above a spreadsheet and entirely satisfactory for my use case, but for a multi-user environment I would want more enforcement of constraints built into the database application, and more flexible and scriptable form design to improve usability. I don't doubt that there might be a nice, open source, web GUI for designing and using database applications, but since I have not used such a thing I will refrain from recommending anything! I suppose you are probably looking either for an off-the-shelf inventory database solution, or something broadly equivalent to Oracle's "APEX" software, except open source and perhaps a little easier to use. Patrick. -- Next meeting at *new* venue: Bournemouth, Tuesday, 2018-12-04 20:00 Check if you're replying to the list or the author Meetings, mailing list, IRC, ... http://dorset.lug.org.uk/ New thread, don't hijack: mailto:dorset@mailman.lug.org.uk
