Re: [ZODB-Dev] Relstorage and MSQL
On 16/05/2012, at 3:24 AM, Alan Runyan wrote: Windows 2008 server standard. Python 2.6/2.7 I'm not sure. I think living without clustering and memcached for the moment is fine. I would agree. And what about blob storage? Are blobs inside the DB in little chunks enough, do you want them on the filesystem via shared network drive or new efficient filestream support in SQL server 2008+ I don't know enough to answer this but for our purposes support SQL Server in a basic capacity so Plone runs ok is enough to start with. This really depends on usage patterns and capacity. I would recommend keeping the BLOBs on the filesystem. Our need is to 'state' support for SQL server to our client. They have SQL server licenses and they'd prefer to use them. The job is for 3 plone sites, public, extranet and intranet but with no estimate yet of the data size. Availability concerns are an issue. In the case where the work goes ahead and if performance is an issue then we;d be in a better position to either implement greater support for sqlserver or recommend they switch to a more mature relstorage option. Hope that helps put things in context. If you can depend on mxODBC then I do not believe this is a huge problem. I would be skeptical of pyodbc stability/performance - its worked ok for us but we dont have anything 24x7 running with it. As someone said earlier it is not difficult just very time consuming to test. I would be more than happy to help test. Some more thoughts: - If you run mxODBC you will have much less adoption/testing by the community. due to license and pain to install mxODBC. - pyodbc i would skeptical of and test. you would get the most usage using this driver. - pywin32 is another candidate. it should work just fine but you may need to watch for scaling issues (you may have to add some smarts the mssql storage) I would love to see this support added. as would we. But it looks like there isn't someone with the time and licenses at the moment to make this happen so we'll go ahead without sql server support. but count this as a vote of support if anyone wants to give it a go. -- Alan Runyan Skype/Twitter:: runyaga Office:: 713.942.2377 ext 111 http://ploud.com/ Plone site in less than 10 seconds ___ For more information about ZODB, see http://zodb.org/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] Relstorage and MSQL
> Windows 2008 server standard. Python 2.6/2.7 > I'm not sure. I think living without clustering and memcached for the moment > is fine. I would agree. >> And what about blob storage? Are blobs inside the DB in little chunks >> enough, do you want them on the filesystem via shared network drive or new >> efficient filestream support in SQL server 2008+ > > > I don't know enough to answer this but for our purposes support SQL Server > in a basic capacity so Plone runs ok is enough to start with. This really depends on usage patterns and capacity. I would recommend keeping the BLOBs on the filesystem. > Our need is to 'state' support for SQL server to our client. They have SQL > server licenses and they'd prefer to use them. The job is for 3 plone sites, > public, extranet and intranet but with no estimate yet of the data size. > Availability concerns are an issue. > In the case where the work goes ahead and if performance is an issue then > we;d be in a better position to either implement greater support for > sqlserver or recommend they switch to a more mature relstorage option. Hope > that helps put things in context. If you can depend on mxODBC then I do not believe this is a huge problem. I would be skeptical of pyodbc stability/performance - its worked ok for us but we dont have anything 24x7 running with it. As someone said earlier it is not difficult just very time consuming to test. I would be more than happy to help test. Some more thoughts: - If you run mxODBC you will have much less adoption/testing by the community. due to license and pain to install mxODBC. - pyodbc i would skeptical of and test. you would get the most usage using this driver. - pywin32 is another candidate. it should work just fine but you may need to watch for scaling issues (you may have to add some smarts the mssql storage) I would love to see this support added. -- Alan Runyan Skype/Twitter:: runyaga Office:: 713.942.2377 ext 111 http://ploud.com/ Plone site in less than 10 seconds ___ For more information about ZODB, see http://zodb.org/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] Relstorage and MSQL
On 05/08/2012 06:34 PM, Dylan Jay wrote: I know it's not all about money but if we were to sponsor development of microsoft sql server support for relstorage, is there someone who knows how and has an estimated cost and available time? I don't have enough cycles now to do it myself, but I will happily assist anyone who wants to take on this project. The code already has 3 mature implementations to serve as a reference. I would plan to spend at least as much time on testing as on development. Like any database, ZODB storage bugs are often expensive to debug, so you really need a reliable storage before you can safely build layers on top of it. Shane ___ For more information about ZODB, see http://zodb.org/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] Relstorage and MSQL
On 09/05/2012, at 11:26 AM, Hanno Schlichting wrote: On 09.05.2012, at 02:34, Dylan Jay wrote: I know it's not all about money but if we were to sponsor development of microsoft sql server support for relstorage, is there someone who knows how and has an estimated cost and available time? It might be helpful if you could add more constraints. Which version of SQL server do you want to support? Just 2008 or 2012 or some Express Edition? Only 64bit servers and clients or 32bit? sql server 2008. not sure about 64/32bit. Are all clients also on Windows, which OS version, which versions of Python? Windows 2008 server standard. Python 2.6/2.7 What clustering options are you interested in if any? Do you want memcached support? I'm not sure. I think living without clustering and memcached for the moment is fine. And what about blob storage? Are blobs inside the DB in little chunks enough, do you want them on the filesystem via shared network drive or new efficient filestream support in SQL server 2008+ I don't know enough to answer this but for our purposes support SQL Server in a basic capacity so Plone runs ok is enough to start with. The fewer variables you have, the easier an estimate should be. And just stating something like the expected data size, number of clients and availability concerns might help. Our need is to 'state' support for SQL server to our client. They have SQL server licenses and they'd prefer to use them. The job is for 3 plone sites, public, extranet and intranet but with no estimate yet of the data size. Availability concerns are an issue. In the case where the work goes ahead and if performance is an issue then we;d be in a better position to either implement greater support for sqlserver or recommend they switch to a more mature relstorage option. Hope that helps put things in context. Hanno ___ For more information about ZODB, see http://zodb.org/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] Relstorage and MSQL
On 09.05.2012, at 02:34, Dylan Jay wrote: > I know it's not all about money but if we were to sponsor development of > microsoft sql server support for relstorage, is there someone who knows how > and has an estimated cost and available time? It might be helpful if you could add more constraints. Which version of SQL server do you want to support? Just 2008 or 2012 or some Express Edition? Only 64bit servers and clients or 32bit? Are all clients also on Windows, which OS version, which versions of Python? What clustering options are you interested in if any? Do you want memcached support? And what about blob storage? Are blobs inside the DB in little chunks enough, do you want them on the filesystem via shared network drive or new efficient filestream support in SQL server 2008+ The fewer variables you have, the easier an estimate should be. And just stating something like the expected data size, number of clients and availability concerns might help. Hanno ___ For more information about ZODB, see http://zodb.org/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
[ZODB-Dev] Relstorage and MSQL
Hi, Previous threads on this subject didn't seem to go anywhere. I know it's not all about money but if we were to sponsor development of microsoft sql server support for relstorage, is there someone who knows how and has an estimated cost and available time? --- Dylan Jay Technical Solutions Manager PretaWeb: Multisite Performance Support P: +612 80819071 | M: +61421477460 | twitter.com/djay75 | linkedin.com/ in/djay75 ___ For more information about ZODB, see http://zodb.org/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev