Recommendations for a lightweight database

Started 5 months ago | Questions thread
OP AnthonyL Veteran Member • Posts: 3,594
Re: Recommendations for a lightweight database

WryCuda wrote:

It's quite common for beginners to allocate a single field for names, making searches and sorting difficult, particularly if the name is J.R.R. Tolkien rather than Tolkien JRR.

Would that it were as simple as that.  How about J Tolkien, John Tolkien then Edith Tokien, Edith Bratt, Miss E M Bratt, Mrs EM Tolkien.  In many instances the name form has to be retained and ideally the first instance of a change in status noted as some of the information is many years old.  That's apart from spelling errors as no doubt there would be Tokien, Tolken etc.

And then a record may have Tolkien with a group of friends one date and a different group, maybe authors on another date, all of whom need to be recorded, as written, for each event.

And at the moment the people in the event are in a text blob.  Not going to be a trivial exercise to extract and normalise* them.

By normalise I mean give each entity a unique code which of course could be used as a key.

 AnthonyL's gear list:AnthonyL's gear list
Canon EOS 700D Canon EF-S 10-22mm F3.5-4.5 USM Canon EF-S 55-250mm f/4-5.6 IS Canon EF 40mm f/2.8 STM Canon EF-S 18-55mm f/3.5-5.6 IS STM +5 more
Post (hide subjects) Posted by
Keyboard shortcuts:
FForum PPrevious NNext WNext unread UUpvote SSubscribe RReply QQuote BBookmark MMy threads
Color scheme? Blue / Yellow