| From: | Kurt R Marquardt <marqkdsade(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Storing products in multiple, deeply nested category tables. |
| Date: | 2016-03-23 11:37:18 |
| Message-ID: | CABtkwHVyXsJacH5wz9wYaiHiAj1cUK=fdFvY1FbFrN64XtYcCg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
I apologize but I am truly a noob with Postgresql.
I am using the following platform~
Apache 2.4.18
Postgresql 9.4.6-1
PHP 7.0.4
PHPPgAdmin 5.1
Image Magic 6.9.2-0
ModSecurity 2.9.0
git 2.5.1
I am developing an e-commerce site with a very dynamic vendor. They
provide an XML datafeed to completely update inventory twice per day and
update inventory status every 15 minutes. The first part of the file is a
list of 200+ categories (all parent). I need to convert that to about eight
deeply nested (five to six deep in some cases) categories. An example
would be Men's>Accessories>Jewelry>Watches>Sport>Aviator. Almost all
products fall into two categories and some five or six. What is the best
way to set up the tables to support this? If I have six category fields in
my catalogue file there would be a lot of empty fields. I am thinking
about creating different "parent" tables but that would require more joins
and I am trying to make this as efficient and fast as possible. Any
suggestions would be greatly appreciated.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sándor Daku | 2016-03-23 12:29:20 | Re: Storing products in multiple, deeply nested category tables. |
| Previous Message | Merlin Moncure | 2016-03-23 00:43:58 | Re: Help with text(decimal) to hex conversion |