Searching \ for '[OT] Which database to use?' in subject line. ()
Make payments with PayPal - it's fast, free and secure! Help us get a faster server
FAQ page: www.piclist.com/techref/mems.htm?key=data
Search entire site for: 'Which database to use?'.

Exact match. Not showing close matches.
PICList Thread
'[OT] Which database to use?'
2000\01\24@042447 by Nebelong Bjarne

flavicon
face
Sorry for this Off Topic mail, but I don't know anyone else to ask.

Background:
I need to document the boards in some products we manufacture.

On several searches on the web I've only found flat databases, but I need
something with a structure in it. I.e.

Machine: Calvin Article 12345678
Contains:
       Board1  Article 23456789
       Board2  Article 34567890
       Board3  Article 45678901
       Cable1  Article 56789012
       Cable2  Article 67890123

The Board1 (Article 23456789) contains
       Resister        R1      10k     0603    Art. 78901234
       Processor       U1      PIC16C505       SOIC14  Art. 89012345

And so on, I think that you get the idea.

Any on the list got a recommendation?

Best Regards
/Bjarne Nebelong

2000\01\24@153713 by Tom Handley

picon face
  Bjarne, assuming you are running MS Windows, MS Access is the
most popular data base on the planet. It's an `overkill' for
many applications but it's nice to have the capability when you
need it. You don't have to buy the full MS Office suite, just get
MS Access. If you have MS Word and/or Excel, they all integrate
seamlessly. Gawd, I hate to promote MS but it is good software...

  - Tom

At 10:26 AM 1/24/00 +0100, Nebelong Bjarne wrote:
{Quote hidden}

------------------------------------------------------------------------
Tom Handley
New Age Communications
Since '75 before "New Age" and no one around here is waiting for UFOs ;-)

2000\01\24@161211 by steve

flavicon
face
> I need to document the boards in some products we manufacture.
> On several searches on the web I've only found flat databases, but I need
> something with a structure in it. I.e.
>
> Machine: Calvin Article 12345678
> Contains:
>         Board1  Article 23456789
>         Board2  Article 34567890
>         Board3  Article 45678901
>         Cable1  Article 56789012
>         Cable2  Article 67890123
>
> The Board1 (Article 23456789) contains
>         Resister        R1      10k     0603    Art. 78901234
>         Processor       U1      PIC16C505       SOIC14  Art. 89012345
>
> And so on, I think that you get the idea.

I use "Parts & Vendors" from Trilogy Design
(http://www.trilogydesign.com).
It's a stand-alone program specifically for this with multilevel
BOMs, RFQ generation, stock management, etc.
It doesn't go as far as MRP but it's the next best thing.
Importantly for us, it can cope with buying the same part from
several sources without requiring different part numbers (which most
inventory s/w does) so you can buy pre-production quantities from
one source and volume from somewhere else. It also allows you to link
your hex files, cad data, etc into the BOM structure and launch apps
if you need to. My only complaint would be that it runs so slowly.

Steve.
======================================================
Steve Baldwin                Electronic Product Design
TLA Microsystems Ltd         Microcontroller Specialists
PO Box 15-680, New Lynn      http://www.tla.co.nz
Auckland, New Zealand        ph  +64 9 820-2221
email: spam_OUTstevebTakeThisOuTspamtla.co.nz      fax +64 9 820-1929
======================================================

2000\01\24@222232 by Mitchell D. Miller

picon face
Bjarne,

> On several searches on the web I've only found flat databases, but I need
> something with a structure in it. I.e.

Are you looking for a specific program with the details of how to handle
your data already defined, or a generic database program that allows you to
define the data your store, and it's relationship to other data?

-- Mitch


Mitch Miller, Omaha, NE
.....mdmiller2KILLspamspam@spam@home.com

2000\01\25@093159 by Thomas McGahee
flavicon
face
Any decent RELATIONAL DATABASE will do the job. As Tom Handley
mentioned, Microsoft Access will do the job quite nicely.
For the sort of database useage mentioned, Access is a good
choice, as it makes it very easy for you to define the
relationships. Note that for the application mentioned,
internally there will be several database files created
which are related through ID CODE "keys".

My own personal preference for relational databases is
FOXPRO, also marketed by Microsoft. It has a somewhat
richer supporting language and can do some tricks that
Access cannot do. For example, I use it to do things like
generate tables that will be placed in EPROM. With
FOXPROW it is easy to have the program create a BIN
file on disk that my EPROM programmer can use directly.

FOXPRO is available in DOS and Windows versions. There
is also a Windows-only version called VISUAL FOXPRO
that has greater support for mouse-clicks and the like.

To learn ANY relational database *well* requires some
serious learning. However, for the kind of application
mentioned, you would only have to learn a bare
minimum of specialized information, as the task is
quite generic and the database examples used in teaching
ACCESS all apply in a very straight-forward manner.

A helpful hint: create a separate subdirectory for each
major application. This allows you to easily move the
application to another computer later. If you dump
everything into the default directory you will not
be able to easily discern later what files belong to
what applications.

Fr. Tom McGahee

{Original Message removed}

2000\01\25@223143 by Russell McMahon

picon face
T

>My own personal preference for relational databases is
>FOXPRO,

The uncanny coincidences continue.
I am / was a Foxpro fanatic.
Not much used just recently, but it used to arguably be my major tool in a
previous lifetime.
.
Started on DBase ?2, DBase 3, Foxbase, Foxpro

Still have various versions lying around.


R

2000\01\25@234545 by Rian Wisandanu

flavicon
face
how about the new one ... microsoft access, i think the softare very
firendly

{Quote hidden}

2000\01\30@194236 by Howard McGinnis

flavicon
face
Thumbs up on Trilogy Design's Parts and Vendors - If it's still $99 for the
SE version, it'll do what you're looking for and you'd have a hard time
developing any thing close for less than what they're asking!

Howard
Howard McGinnis
EraseMEhmcginnispam_OUTspamTakeThisOuTdigital.net
Electronic Visions, Inc.
1650 Barrett Drive
Rockledge FL 32955
(321) 632-7530
http://ddi.digital.net/~hmcginni
mcginnisspamspam_OUTe-visions.com

2000\01\31@034121 by Nebelong Bjarne

flavicon
face
Steve Baldwin suggested it.
I tried it AND bought it, you know the MasterCard crack solution ;-)
Now you recommend it and I really agree, for $99 there are NO way I can
setup Access to have all the features as Parts & Vendors. $99 means that I
have to do it in about 3 hours, if I don't want to waste company money.

Best regards
/BjarneNebelong


                       -----Ursprungligt meddelande-----
                       FrŒn: Howard McGinnis
[@spam@hmcginniKILLspamspamDIGITAL.NET]
                       Skickat:         den 31 januari 2000 01:40
                       Till:   KILLspamPICLISTKILLspamspammitvma.mit.edu
                       €mne: Re: [OT] Which database to use?

                       Thumbs up on Trilogy Design's Parts and Vendors - If
it's still $99 for the
                       SE version, it'll do what you're looking for and
you'd have a hard time
                       developing any thing close for less than what
they're asking!

                       Howard
                       Howard McGinnis
                       RemoveMEhmcginniTakeThisOuTspamdigital.net
                       Electronic Visions, Inc.
                       1650 Barrett Drive
                       Rockledge FL 32955
                       (321) 632-7530
                       http://ddi.digital.net/~hmcginni
                       spamBeGonemcginnisspamBeGonespame-visions.com

More... (looser matching)
- Last day of these posts
- In 2000 , 2001 only
- Today
- New search...