[solved] "All"-File management / database with text files in the directory tree for linux

Need help, or want to share a macro? Post here!
Forum rules
Be nice to others! Respect the FreeCAD code of conduct!
User avatar
onekk
Veteran
Posts: 6197
Joined: Sat Jan 17, 2015 7:48 am
Contact:

Re: File management / database with text files in the directory tree for linux

Post by onekk »

user1234 wrote: Tue Nov 16, 2021 7:41 pm ...
Greetings
user1234
Yes and No.

I doubt that FreeCAD will become a tools for "big industries", seeing the evolution, I think this will remain a tools for "Small Shops" and "Small Industries" but even the term "Small" is different if spoken in different side of the Atlantic Ocean (and Maybe even for Pacific Ocean).

So having to manage say database of million of parts, maybe in a centralized way it is not properly a task for a CAD/CAE but more for some other tools.

More realistic is the scenario in which FreeCAD is used with 10 or 20 workstations in a "relatively small" enterprise, where there is need to maintain a "historical database" of drawings, and 3d Models, as the OP has specified through the discussion.

More complex things should involve I think many other modification to FreeCAD to be useful and usable, and maybe such things are done already in different ways, maybe only the CAD part is involved, and drawings are "served" by a "dedicated server" that expose to every workstation only the drawings the user id "authorized" to view, and maybe manage also the "read, write" access table to these drawings.

As Not necessarily a single program has to manage the entire "production chain" of a Product.

Maybe the "upholstery department" is only authorized to have "read access" the the "seat model" to make as example the fabric part of the seat, and maybe to the "airbag model" only to take dimensions.

or the "assembly line" is authorized only to see schematics that show the assembly position of some pieces.

The fact that these information are "centralized" do not mean that the data exposed is the same, there is usually some "intermediate program" that prepare the data for each user and this is not surely a relational database, nor a CAD system.

Regards

Carlo D.
GitHub page: https://github.com/onekk/freecad-doc.
- In deep articles on FreeCAD.
- Learning how to model with scripting.
- Various other stuffs.

Blog: https://okkmkblog.wordpress.com/
user1234
Veteran
Posts: 3475
Joined: Mon Jul 11, 2016 5:08 pm

Re: [solved] "All"-File management / database with text files in the directory tree for linux

Post by user1234 »

onekk wrote: Wed Nov 17, 2021 4:49 pm So having to manage say database of million of parts, maybe in a centralized way it is not properly a task for a CAD/CAE but more for some other tools.
I never said, that should included in FreeCAD. Makes of course no sense, since either people do not need it or the have their database and their specification they need.

What i wanted to mention is:

- if you need a sort of PDM, then you need a database like sql, which is maintainable, easy extendable and modifiable

- if you transfer old datas in a new database, it must be done pretty clean and the datas must before (or while) the migrations filtered, maintained and uniformed, else you get while live working in serious trouble

- also small companies have big PDM databases


Greetings
user1234
User avatar
onekk
Veteran
Posts: 6197
Joined: Sat Jan 17, 2015 7:48 am
Contact:

Re: [solved] "All"-File management / database with text files in the directory tree for linux

Post by onekk »

user1234 wrote: Thu Nov 18, 2021 9:15 pm - if you need a sort of PDM, then you need a database like sql, which is maintainable, easy extendable and modifiable
- if you transfer old datas in a new database, it must be done pretty clean and the datas must before (or while) the migrations filtered, maintained and uniformed, else you get while live working in serious trouble
- also small companies have big PDM databases

Yes I agree with this vision.

From my point of view it is not important to have too many things integrated in FreeCAD, it suffice to have some stability in methods and some way to operate on model data (and FreeCAD is quite mature to do so even now).

As usual, words sometimes don't express clearly concepts but some plain discussion will certain do.

Regards

Carlo D.
GitHub page: https://github.com/onekk/freecad-doc.
- In deep articles on FreeCAD.
- Learning how to model with scripting.
- Various other stuffs.

Blog: https://okkmkblog.wordpress.com/
User avatar
thomas-neemann
Veteran
Posts: 11893
Joined: Wed Jan 22, 2020 6:03 pm
Location: Osnabrück DE 🇩🇪
Contact:

Re: [solved] "All"-File management / database with text files in the directory tree for linux

Post by thomas-neemann »

onekk wrote: Fri Nov 19, 2021 10:13 am ....FreeCAD is quite mature to do so even now..
+1
Gruß Dipl.-Ing. (FH) Thomas Neemann

https://www.youtube.com/@thomasneemann5 ... ry=freecad
Post Reply