Re: [libreoffice-users] Currently Using Spreadsheet for Personal Project - Thinking About Database

On Sun, 10 Aug 2014 16:48:31 -0600
Oogie McGuire <oogiem@desertweyr.com> wrote:

> We agree <G> I think my comments passed yours in the mail. 
>
> I hadn't done any relational database work until this current big
> project, thats why the database design book I recommended was so
> critical. It got me out of the spreadsheet mindset and into the
> database one. 
>
> Just because it's for one person for one reason doesn't mean you
> can't design it with proper database functions, after all the
> structure might be useful to someone else as well. 

Indeed, although without a background in it or someone who knows his
salt, it can be really difficult to figure out the best way to do
things.

Once the database structure is right, the rest should be pretty
straightforward, especially in Base. Coding is a set of best
practices all on its own, so if you were coding the frontend (like I
would probably do), that's another story completely, but with Base it
should be relatively simple, and there shouldn't be too many options,
so there won't be as much chance of making bad choices. The database
structure really is the foundation everything else builds upon.

Paul

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted