On Monday, 12 November 2018 14:24:05 GMT Patrick Wigmore wrote:
> Last year, I used [Kexi](http://kexi-project.org/) to record an
> inventory of my personal hoard of electronic components.
So far so good.
> 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.
A clarification. When I said website, I didn't mean the database had to run on
a web page.
We just want to access it from various devices.
For example, my hosting provider includes MySQL as part of my package and I
have just
created one called 'WMT River System Inventory' The MySQL Control Panel
currently says
that I have '1 of 100000 used', although it is currently 'Setting Up', whatever
that means.
Presumably, once this is done, I'll be able add records for each item in our
Inventory and
then all need is a GUI tool to access it from Linux or a Mac.
> 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.
I don't think we need the functionality of a full-blown inventory solution;
presumably that
would have to be paid for. Our idea is to have a database which allows us to
hold records
for each component and then link the records to the build data for each
assembly. I think
we should be able to cobble something like that together, as long as the
interface is user
friendly.
--
Terry Coles
--
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
