In the past I run it manually on Google cloud I've tested this script on a Ubuntu 16.04 virtual machine (running on Oracle VM Virtual Box) as well as an AWS EC2 instance. If you like the idea of this article, you have some IT basic knowledge (running Linux, virtual machines, cloud computing.)and you'd love to have your own built Open Source Inventory Management system, check this link And follow the instructions for a seamless PartKeepr server installation. After built several of those systems I saw the possibility to help others to build seamlessly their own Cloud-based Open Source Inventory Management system and contribute as much as I can to the Open Source community which helped me enormously when I need it. Whatever it is but, also have to take care of the auxiliary things that makes our job more organized and efficient, in this case IT infrastructure.īuilding an IT system could be out of budget (specially for starters) or time consuming as it was on my case. Making a great coffee, repairing cars, doing engineering or repairing electronics. Running a company is hard, you must focus on the main value chain of your business. I'm pretty sure that there's a very wide spectrum of solutions out there on the market, but as a person who combines passion about technology and a 'doer' personality I just enjoy getting in trouble with things like doing the oil change to my car and of course building 'my own' PartKeepr Cloud based Open Source Inventory Management System to keep well organized and inventoried the electronics components involved in the business that I've been in charge. Relationships between tables are shown with dashed lines.Along my professional career, in my time as an entrepreneur, and also as an employee I had to face several times the problem of how to deal with electronic components organization and inventory. By hovering the mouse over various items, you can see tool tips about those items. Each box represents a database table and each item in a box represents a column of that table. Open the EER Diagram to view it and you will be presented with the PartKeepr schema in graphical form. At this point, you will be presented with physical schemas and EER Diagrams. Enter it as required and continue clicking Next until the process is completed. During this process you may be asked to enter the appropriate password once or twice. Click Next and enter any required information until you are asked to "Select the schemas below you want to include." Be sure there is a check mark next to PartKeepr and click next. In the menu bar, select "Database" -> "Reverse Engineer." In the dialog box that appears, be sure to select the correct database instance (under Stored Connection) with the correct hostname, port, username, password, and other settings. Here are the steps to examine the schema graphically with MySQL Workbench (preliminary): Connect to the database instance that houses your PartKeepr data. When your PartKeepr installation is backed by a MySQL database, you can use MySQL Workbench. The easiest way to examine the structure of the PartKeepr database schema is with a graphical tool. If you are proficient with databases and SQL and wish to contribute to this wiki, please contact the authors for a wiki account. We would like similar documentation for PostgreSQL. Note: This page assumes you have a MySQL-backed PartKeepr installation. Better yet, you should create a separate PartKeepr installation (perhaps in its own virtual machine) where you can experiment without risking damage to your "real" PartKeepr data. Before you begin, be sure you have a valid, working, and up-to-date backup of your database. Warning: Bypassing PartKeepr and accessing the database comes with the risk of damaging information already stored there. Do not apply any of the steps described here without fully understanding what they do, how they work, and whether they are correct for your particular situation! Warning: This page is very much a work in progress! Some suggestions are made and SQL statements are given as examples. To do so, you must know some database concepts and be comfortable with SQL. Or perhaps you have thought of some other reason to access the underlying database directly. For example, you might have part information stored in another format, such as a spreadsheet, and you wish to import those parts in bulk rather than to enter them manually one at a time. Perhaps you have reasons to bypass the PartKeepr web application and interact with the database directly. The data subdirectory of the PartKeepr tree contains images and attachment files. The database contains numerous tables which describe your parts, manufacturers, distributors, etc. PartKeepr stores information in two places: in your database (MySQL or PostgreSQL) and in the data subdirectory of the PartKeepr tree.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |