Databases
StackOverflow2013
Postsdbo
PODjango Python create dynamic product and listings with easy filtering
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODjango Python create dynamic product and listings with easy filtering
    text
    copied!<p>This may be also to do with abit of database design, too. I have 4 tables,</p> <ul> <li>table 1: Product (product_id, product_description, product_category, date_created)</li> <li>table 2: Listing (price, quantity, user_id, product_id, date_created)</li> <li>table 3: User (user_id, user_type, address_line_1, state, city, postcode, date_created)</li> <li>table 4: Product_listing (product_listing_id, product_id, lowest_price, number_of_listings, date_created, date_updated)</li> </ul> <p>My front page shows each individual product with information on number of listings, the lowest price (simply retrieve data from product_listing linking to the product table). When click on the link of the product table, it will go to the detail page showing product information with all the listings from users. My search will also return results from the product_listing in conjunction with product table.</p> <p>Currently the way I designed my web app using Django is that every time a user adds or removes a listing, I update the Product_listing table, but this is really static and I am really stuck when comes down to filtering on both of front page and detail page. i creating product for software product. I want to be able to filter the front page and detail page by a particular user_type, product_category, state and city, I don't know what's the best way to optimize the design for easy and dynamic filtering via django. I still want to somehow keep the product_listing table so it's faster when displaying all products with the information on number of listings and the lowest price.. </p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload