Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 10-21-2015 18:44:31

ambassador
Member
Registered: 10-27-2003
Posts: 59

Using the Postgre Database with v9

Can v9 use the Postgre database as its only database?

Offline

 

#2 10-22-2015 11:25:16

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19715
Website

Re: Using the Postgre Database with v9

Yes, versions 5 and higher all support both MySQL and Postgre.  We may be dropping support for Postgre at some point, though, as it's not used very widely at all and it might be nice to go MySQL-only to open up a few more tools for us.


Nick Hendler

Offline

 

#3 12-30-2015 14:00:36

ambassador
Member
Registered: 10-27-2003
Posts: 59

Re: Using the Postgre Database with v9

Postgre remains an option for V9 - right?

Offline

 

#4 12-31-2015 08:26:41

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19715
Website

Re: Using the Postgre Database with v9

Yes.  The database support options have not changed for V9.


Nick Hendler

Offline

 

#5 12-31-2015 18:33:07

lgt
Member
Registered: 11-21-2010
Posts: 272
Website

Re: Using the Postgre Database with v9

Over the next two years we're going to have 25,000+ ASIN's tied to quite a number of multi-sites.  Of course each website is likely to have many product options on top of that.

How many ASIN's X Stores X Product Options do you think MySQL can handle before needing to go to something like Postgre?

Or do you think it is read/write volume that is relevant?









Offline

 

#6 01-01-2016 09:49:13

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19715
Website

Re: Using the Postgre Database with v9

Please be aware that V9 has two separate functionality additions:

(1) eCommerce Channels: The online store is considered the DEFAULT channel.  eBay and Amazon can be added as additional channels (EBAY and AMAZON).  Channels are used to present product offers for inventory items (browse online store, list on ebay, list on amazon) and to handle order management, which in the case of the eBay and Amazon channels means downloading the orders into the system, processing them, and supplying eBay and Amazon with final order updates and shipping info. 

(2) MultiSite: Allows you to run the online store (read: DEFAULT eCommerce Channel above) over multiple URLs with different skins, settings, products, categories, etc, etc, etc.  Effectively giving your online the ability to present itself as multiple different stores over different URLs.  The base URL/install is considered the DEFAULT MultiSite.

The eBay and Amazon eCommerce Channels run under the DEFAULT MultiSite.  They are tied into your eBay and Amazon accounts directly, so their storefronts are your eBay and Amazon storefronts.  For order processing, the orders are considered to have come from the DEFAULT MultiSite.

Please view this link for information on options.  I originally posted this here, but then moved it because it warrants a topic of it's own:

https://forum.kryptronic.com/viewtopic.php?id=32898

Now that it's clear what can be sold and how, an ASIN points to one or more Inventory Items in our system, like the package deal example above.  These may have options or may not.  So the question really is how many Inventory Items can the system handle under MySQL.  I would venture to guess the number is somewhere around 1.5 million before it would be time for something a little more heavy duty.  The same for ASINs, about 1.5 million, if you're selling at a 1:1 ratio.  You can have multiple ASINs pointing to a single inventory item, and multiple inventory items tied to a single ASIN, so it gets a little convoluted giving a real maximum number.


Nick Hendler

Offline

 

Board footer