It is a good point Chi. We did say PostgresSQL, but honestly we will look at other databases as well. SQLite is much easier.
Regards, Bill. On 2011-10-23, at 1:58 AM, Chi Chan wrote: > Someone told me Univa is bringing back the PostgreSQL spooling which was > deleted by Sun in SGE 6.2, and will release it with an upcoming version of > UGE. > > > Can someone clarify why PostgreSQL is used again, instead of an embedded > database like SQLite as mentioned by Hung-Sheng & Rayson in this thread? > IMHO, SQLite seems to be easier to maintain and far better as a spooling > database. > > > --Chi > > > > > ----- 原始信件 ---- > 寄件者： Ron Chen <[email protected]> > 收件者： [email protected]; Rayson Ho <[email protected]> > 副本： > 寄件日期： 2011/9/27 (二) 11:35 AM > 主旨： Re: [gridengine users] SQL spooling > > --- On Tue, 9/27/11, Rayson Ho <[email protected]> wrote: >> I just did a very quick test with SQLite 3.6.22, some of >> the SQL >> statements used by SGE were able to run against an SQLite >> DB without >> any changes - in the end, we are doing simple >> INSERT/UPDATE/DELETE >> SQL, plus some table maintenance code & table/index >> creation code... > > And SELECT statements as well! Luckily, the SELECT statements are also > simple, not nested queries. > > -Ron > > >> most SQL DBs could be used as the SGE spooling backend with >> min. changes to the SQL spooling code. >> >> (BTW, talking about Andy, I exchanged emails with him >> earlier this >> month, he and the Oracle Grid Engine team are doing good at >> Oracle.) >> >> Rayson >> >> >> >> On Fri, Sep 9, 2011 at 3:42 PM, "Hung-Sheng Tsao (Lao Tsao >> 老曹) Ph.D." >> <[email protected]> >> wrote: >>> >>> recently oracle introduce a SQLlite frontend to >> berkleyDB >>> not sure you can take advantage this new FE to query >> the berkleyDB in GE >>> regards >>> >>> On 9/9/2011 2:51 PM, Chi Chan wrote: >>>> >>>> It is good that Ron Chen said that there is new >> features (IPV6, GPU >>>> integration) -- but any forks working on SQL >> spooling? >>>> >>>> We don't need GPU integration now (with AMD >> bulldozer shipping soon, the >>>> need for a seperate GPU for handling GPGPU type of >> workload may be even >>>> less), and our clusters will not be migrated to >> IPV6 any time soon. >>>> >>>> However, SQL spooling is really useful, and I can >> query the job DB and >>>> find out what is there. In 2003 the code was in >> the source tree, but I >>>> looked at the SGE forks yesterday and found that >> the code is gone. >>>> >>>> So what has happened to SQL spooling, and any one >> planning to get it back >>>> to life? >>>> >>>> >>>> --Chi >>>> >>>> _______________________________________________ >>>> users mailing list >>>> [email protected] >>>> https://gridengine.org/mailman/listinfo/users >>> >>> _______________________________________________ >>> users mailing list >>> [email protected] >>> https://gridengine.org/mailman/listinfo/users >>> >>> >> >> _______________________________________________ >> users mailing list >> [email protected] >> https://gridengine.org/mailman/listinfo/users >> > > _______________________________________________ > users mailing list > [email protected] > https://gridengine.org/mailman/listinfo/users > > > _______________________________________________ > users mailing list > [email protected] > https://gridengine.org/mailman/listinfo/users William Bryce | VP of Products Univa Corporation - 1001 Warrenville Road, Suite 100 Lisle, Il, 65032 USA Email [email protected] | Mobile: 512.751.8014 | Office: 416.519.2934 _______________________________________________ users mailing list [email protected] https://gridengine.org/mailman/listinfo/users
