In terms of reliable and production quality, you can find many people saying it works just fine for small to medium web services where the clients are mainly reading down data. It would just be something that might topple over if you use it on a render farm where all the nodes are pounding it for data on fast connections while other clients are trying to write to it. On Sep 7, 2013 6:59 PM, "Panupat Chongstitwattana" <[email protected]> wrote:
> For this specific task (storing ID and material relations) I think it will > be very read-heavy. But from what you said it probably will not scale well > if I expand it to cover other area... hmm > > Thanks again Justin :) > > > On Saturday, September 7, 2013 8:19:37 AM UTC+7, Justin Israel wrote: > > Is your application write heavy? If so, sqlite may be a significant > performance decrease over postgres, because of the database locking during > concurrent write access or a write happening in combination with readers. > > > > > > On Sep 7, 2013 12:48 PM, "Panupat Chongstitwattana" <[email protected]> > wrote: > > > > > > > > > > > > > > Hi everyone. > > > > I've been thinking about switching database of my pipeline tools from > PostgreSQL to SQLite but still uncertain how reliable it is? > > > > The reason is that we're having a co-production going on between a few > studio and to get PostgreSQL working on their end has not been easy... Most > studio in my country do not hire IT so there's no one to set up the > database nor install the necessary modules on client machines. > > > > > > > > > > I expect the maximum database users to be 60-70 at most. > > > > > > Thanks. > > > > ~Panupat. > > > > > > > > > > > > -- > > > > You received this message because you are subscribed to the Google > Groups "Python Programming for Autodesk Maya" group. > > > > To unsubscribe from this group and stop receiving emails from it, send > an email to [email protected]. > > > > > > To post to this group, send email to [email protected]. > > > > For more options, visit https://groups.google.com/groups/opt_out. > > -- > You received this message because you are subscribed to the Google Groups > "Python Programming for Autodesk Maya" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "Python Programming for Autodesk Maya" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
