You can subscribe to this list here.
2005 |
Jan
|
Feb
|
Mar
|
Apr
(41) |
May
(353) |
Jun
(133) |
Jul
(534) |
Aug
(401) |
Sep
(219) |
Oct
(86) |
Nov
(144) |
Dec
(61) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2006 |
Jan
(200) |
Feb
(130) |
Mar
(345) |
Apr
(153) |
May
(247) |
Jun
(338) |
Jul
(222) |
Aug
(70) |
Sep
(39) |
Oct
(27) |
Nov
(76) |
Dec
(30) |
2007 |
Jan
(81) |
Feb
(44) |
Mar
(9) |
Apr
|
May
(3) |
Jun
(2) |
Jul
(34) |
Aug
(2) |
Sep
(1) |
Oct
|
Nov
|
Dec
(6) |
2008 |
Jan
|
Feb
|
Mar
(5) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2009 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
(7) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: Matthew B. <mat...@ou...> - 2006-03-01 13:09:43
|
Adam Marshall wrote: > I think it would be an absolute winner if we could have a windows explorer > type interface showing only the resources that one can see. This would > remove many of the gripes that people have about navigation. Not being able to get "all the resources which I have manage rights" doesn't preclude the ability to have an explorer style interface as you wouldn't want to send all the resources to the client at once (too big). -- -- Matthew Buckett, VLE Developer -- Learning Technologies Group, Oxford University Computing Services -- Tel: +44 (0)1865 283660 http://www.oucs.ox.ac.uk/ltg/ |
From: Matthew B. <mat...@ou...> - 2006-03-01 13:08:14
|
Peter Crowther wrote: >>From: Matthew Buckett >>Does something >>like this work anywhere apart from PostgreSQL? >> >> ALTER TABLE uploaded_files ALTER COLUMN mime_type DROP NOT NULL; > > > It's not standard. MSSQL throws a fit over it, worse luck. Can you do it on one line is MSSQL? If so what is it as the SQL mangler should be able to cope as it does variable substitution. -- -- Matthew Buckett, VLE Developer -- Learning Technologies Group, Oxford University Computing Services -- Tel: +44 (0)1865 283660 http://www.oucs.ox.ac.uk/ltg/ |
From: Adam M. <ada...@co...> - 2006-03-01 13:07:21
|
-- Adam Marshall: OUCS, 13, Banbury Rd. Oxford OX2 6NN. Shameless plug 1: Use the Bodington VLE http://bodington.org Shameless plug 2: Use the LUSID PDP system, http://www.lusid.org.uk/ Blog: http://ramble.oucs.ox.ac.uk/blog/adamm/ Cheese of the month: Korbacik - Slovakian String Cheese | -----Original Message----- | From: bod...@li... [mailto:bodington- | dev...@li...] On Behalf Of Paul Davis | Sent: 01 March 2006 12:53 | To: bod...@li... | Subject: RE: [Bodington-developers] History and performance of acl_entries | and permission_coded | | I think we have this with the tree - but it confuses people so it's | generally turned off! I presume you want something showing just the | title, | with clickable link down to the description/next layer? Or is there a | better outline spec? I'm talking about a LHS panel navigator just like windows explorer - ie, little + signs next to containers, double click on the container to move into the "folder", and the whole tree being able to be represented. You wouldn't get the description; just the resource title. Currently a full enumeration of all resources is prohibitively costly that we cant do it. I think, anyway! adam | Paul | | ------------------------------------------------------------------------- | Dr Paul V Davis | Acting Head, Learning Technologies Group | Project Manager, WebLearn ( Oxford's version of Bodington.org) | Oxford University Computing Services | 13 Banbury Road, Oxford, OX2 6NN | Tel: 01865 283414 | | | | | | -----Original Message----- | From: bod...@li... | [mailto:bod...@li...] On Behalf Of | Adam | Marshall | Sent: 01 March 2006 12:45 | To: bod...@li... | Subject: RE: [Bodington-developers] History and performance of acl_entries | and permission_coded | | I think it would be an absolute winner if we could have a windows explorer | type interface showing only the resources that one can see. This would | remove many of the gripes that people have about navigation. | | adam | | -- | Adam Marshall: OUCS, 13, Banbury Rd. Oxford OX2 6NN. | Shameless plug 1: Use the Bodington VLE http://bodington.org | Shameless plug 2: Use the LUSID PDP system, http://www.lusid.org.uk/ | Blog: http://ramble.oucs.ox.ac.uk/blog/adamm/ | Cheese of the month: Korbacik - Slovakian String Cheese | | | -----Original Message----- | | From: bod...@li... | [mailto:bodington- | | dev...@li...] On Behalf Of Matthew Buckett | | Sent: 01 March 2006 12:38 | | To: bod...@li... | | Subject: Re: [Bodington-developers] History and performance of | acl_entries | | and permission_coded | | | | Adam Marshall wrote: | | > 'show me all the resources to which I have manage access to' would be | a | | > really neat function if it were able to be performed efficiently. | | | | We can get close by doing something like 'show me all the resources I am | | the owner for' | | | | -- | | -- Matthew Buckett, VLE Developer | | -- Learning Technologies Group, Oxford University Computing Services | | -- Tel: +44 (0)1865 283660 http://www.oucs.ox.ac.uk/ltg/ | | | | | | ------------------------------------------------------- | | This SF.Net email is sponsored by xPML, a groundbreaking scripting | | language | | that extends applications into web and mobile media. Attend the live | | webcast | | and join the prime developer group breaking into this new coding | | territory! | | http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 | | _______________________________________________ | | Bodington-developers mailing list | | Bod...@li... | | https://lists.sourceforge.net/lists/listinfo/bodington-developers | | | | | ------------------------------------------------------- | This SF.Net email is sponsored by xPML, a groundbreaking scripting | language | that extends applications into web and mobile media. Attend the live | webcast | and join the prime developer group breaking into this new coding | territory! | http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 | _______________________________________________ | Bodington-developers mailing list | Bod...@li... | https://lists.sourceforge.net/lists/listinfo/bodington-developers | | | | | ------------------------------------------------------- | This SF.Net email is sponsored by xPML, a groundbreaking scripting | language | that extends applications into web and mobile media. Attend the live | webcast | and join the prime developer group breaking into this new coding | territory! | http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 | _______________________________________________ | Bodington-developers mailing list | Bod...@li... | https://lists.sourceforge.net/lists/listinfo/bodington-developers |
From: Matthew B. <mat...@ou...> - 2006-03-01 13:07:16
|
Adam Marshall wrote: > RDBMS-specific scripts - there's already a precedent for this isn't there? No, at the moment all the scripts are generic and then they get mangled by the installer into RDBMS specific ones. -- -- Matthew Buckett, VLE Developer -- Learning Technologies Group, Oxford University Computing Services -- Tel: +44 (0)1865 283660 http://www.oucs.ox.ac.uk/ltg/ |
From: Jon M. <jo...@te...> - 2006-03-01 13:05:09
|
I use netbeans as a development tool and that has a reformatting tool. Do other editors have the same kind of thing? Perhaps, a standard format based on common capabilities of the main editors could be agreed. I would suggest that systematic reformatting of the source files be delayed until the next major release. This will avoiding muddying diffs of files versions within the current development cycle. How about this; 1) Agree now a standard format and describe the settings required for main editors to auto format. 2) Use that for all new classes. 3) Complete development cycle up to release which is tagged. 4) Immediately implement a code tidying cycle and tag that version too. Jon the next major version is labelled in the CVS Peter Crowther wrote: >>From: Matthew Buckett >>Tab size is set to 4. >> >> > >That's the one I invariably miss. Sorry Matthew. > >On a side note, we do have a migration problem here. If the advice was >to use tabs consistently *or* spaces consistently, we'd be fine. But >it's not. The whole formatting thing is starting to be a sufficiently >large annoyance (to me at least) that I would now back a proposal to >'big bang' the formatting over to one or the other at the instant a >release was declared, and accept the impact on the SourceForge version >history. However, unlike Oxford, I don't maintain a separate CVS >repository for Bodington. > > - Peter > > >------------------------------------------------------- >This SF.Net email is sponsored by xPML, a groundbreaking scripting language >that extends applications into web and mobile media. Attend the live webcast >and join the prime developer group breaking into this new coding territory! >http://sel.as-us.falkag.net/sel?cmd=k&kid0944&bid$1720&dat1642 >_______________________________________________ >Bodington-developers mailing list >Bod...@li... >https://lists.sourceforge.net/lists/listinfo/bodington-developers > > > |
From: Andrew B. <a.g...@le...> - 2006-03-01 13:04:56
|
Yes - We have our own CVS at Leeds. Aggie -----Original Message----- From: bod...@li... [mailto:bod...@li...] On Behalf Of Matthew Buckett Sent: 01 March 2006 12:57 To: bod...@li... Subject: Re: [Bodington-developers] Code Formatting Peter Crowther wrote: >>From: Matthew Buckett >>Tab size is set to 4. >=20 >=20 > That's the one I invariably miss. Sorry Matthew. It's not just you and I do it too. > On a side note, we do have a migration problem here. If the advice = was > to use tabs consistently *or* spaces consistently, we'd be fine. I'd prefer spaces, but yes if it was documented then hopefully things would get better. > But > it's not. The whole formatting thing is starting to be a sufficiently > large annoyance (to me at least) that I would now back a proposal to > 'big bang' the formatting over to one or the other at the instant a > release was declared, and accept the impact on the SourceForge version > history. However, unlike Oxford, I don't maintain a separate CVS > repository for Bodington. I think if Bodington did Big Bang then we (I think) would do a Big Bang on our tree so merging changes across wouldn't be so difficult. Does anyone else have a Bodington tree? Leeds? UHI do I think. But as you say it does impact on the history. It doesn't preclude checking changes, it just means that if you want to look over the reformat you need to checkout the old version, format it, then do the diff which means only in extreme instances would most people bother. --=20 -- Matthew Buckett, VLE Developer -- Learning Technologies Group, Oxford University Computing Services -- Tel: +44 (0)1865 283660 http://www.oucs.ox.ac.uk/ltg/ ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting = language that extends applications into web and mobile media. Attend the live = webcast and join the prime developer group breaking into this new coding = territory! http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=3D= 121642 _______________________________________________ Bodington-developers mailing list Bod...@li... https://lists.sourceforge.net/lists/listinfo/bodington-developers |
From: Peter C. <Pet...@me...> - 2006-03-01 13:03:50
|
> From: Matthew Buckett > I noticed that there is some nice new stuff on Bodington HEAD from > Peter. Although the commit comment signals the intention=20 > (sorting of MCQ > results and Anonymous marking of pigeon holes) is there any more > documentation about these changes (requirements,specs)? I passed these around the Bod meeting in Oxford on 18 Jan - the requirements came from Leeds, and the Oxford and UHI folks there were happy for them to go on HEAD. The original requirements were as follows: Pigeon hole development =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Make pigeon holes easier to use, and in particular make it easier to use them with the JISC Plagiarism Service. Provide the facility to return submissions to the student after feedback has been added. Enable blind marking. a) Provide a facility to download all uploaded files in a single zip file. Each file will be named with the student id of the submitter. b) Provide facility to upload and return the files to the students (after changes have been made externally). A meaningful error message will be given if files are missing or have been renamed, with an indication of which files are missing/incorrect). c) Provide option to list the submitted files to the owner/marker listed against student id rather than name, to enable blind marking. Add informational message on front page of pigeon hole that indicates if a pigeon hole is created to blind mark or not. This must be optional on creation of the pigeon hole and it should not be possible to change this option once the resource has been created. MCQ Results =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Make MCQs easier to use for staff. a) Add the option to sort the results page by student id or surname (not including initial) Also expect to see the following, unless there are howls of protest from the floor: Questionnaire development =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= Provide a mechanism to monitor completion of module feedback questionnaires without infringing anonymous submission. a) Allow a deadline to be set after which the owner can view a standard HTML list of all students that have record access to the questionnaire who have not completed it. This list will not be displayed if less than 50% of the students who have "record" access have not completed it. [This is currently under revision; expect to see an email on this list from Michael Thomas] Addition to all deadline date resources (eg. MCQs, Short Answer, Pigeon Holes) =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=3D Increase flexibility and clarity of deadline resources. a) Allow a time as well as a date to be set for deadlines. Access right addition =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Dramatically simplify granting access for QA or external examiner reviews. a) Addition of a new access right for reviewers. This will work identically to Administer, but will only provide cascaded See and View access. This will be called "Evaluate" View Access addition =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Simplify resource/teacher management for Floor Managers and others. Addition to the Visual Access Rights tool, that displays information about the owners and editors. This will: a) list the names and usernames of those people in the owners group b) display the name and username of the person who created the resource, along with the date of creation c) display the name and username of the last person to edit the resource as well as the date/time of the edit. [Matthew - are any of these already present in the tool as it stands?] - Peter |
From: Adam M. <ada...@co...> - 2006-03-01 13:01:12
|
Would your ASK 'rewrite' be able to be used by Bodington? Adam=20 --=20 Adam Marshall: OUCS, 13, Banbury Rd. Oxford OX2 6NN. Shameless plug 1: Use the Bodington VLE http://bodington.org Shameless plug 2: Use the LUSID PDP system, http://www.lusid.org.uk/ Blog: http://ramble.oucs.ox.ac.uk/blog/adamm/ Cheese of the month: Korbacik - Slovakian String Cheese | -----Original Message----- | From: bod...@li... = [mailto:bodington- | dev...@li...] On Behalf Of Peter Crowther | Sent: 01 March 2006 12:47 | To: bod...@li... | Subject: RE: [Bodington-developers] History and performance of = acl_entries | and permission_coded |=20 | > We could fake the "inherit access" behind the scences | > although it makes | > some permission changes expensive. |=20 | Yes. But, as you pointed out, permissions change rarely; large | recursive changes are even more rare. Paying the time to update a = cache | table when they change is, to my mind, a worthwhile tradeoff. It's | similar to the way NTFS stores permissions (inherited ACEs are added = to | each ACL) rather than the old NetWare approach that maintained a = central | list and calculated on each access. If you assume that space is = cheaper | than time and that reads are much more common than writes, you can = make | very large savings. |=20 | [Aside: I'll be writing a very similar system for ASK] |=20 | - Peter |=20 |=20 | ------------------------------------------------------- | This SF.Net email is sponsored by xPML, a groundbreaking scripting | language | that extends applications into web and mobile media. Attend the live | webcast | and join the prime developer group breaking into this new coding | territory! | http://sel.as-us.falkag.net/sel?cmd=3Dk&kid=110944&bid$1720&dat=121642 | _______________________________________________ | Bodington-developers mailing list | Bod...@li... | https://lists.sourceforge.net/lists/listinfo/bodington-developers |
From: Matthew B. <mat...@ou...> - 2006-03-01 12:57:12
|
Peter Crowther wrote: >>From: Matthew Buckett >>Tab size is set to 4. > > > That's the one I invariably miss. Sorry Matthew. It's not just you and I do it too. > On a side note, we do have a migration problem here. If the advice was > to use tabs consistently *or* spaces consistently, we'd be fine. I'd prefer spaces, but yes if it was documented then hopefully things would get better. > But > it's not. The whole formatting thing is starting to be a sufficiently > large annoyance (to me at least) that I would now back a proposal to > 'big bang' the formatting over to one or the other at the instant a > release was declared, and accept the impact on the SourceForge version > history. However, unlike Oxford, I don't maintain a separate CVS > repository for Bodington. I think if Bodington did Big Bang then we (I think) would do a Big Bang on our tree so merging changes across wouldn't be so difficult. Does anyone else have a Bodington tree? Leeds? UHI do I think. But as you say it does impact on the history. It doesn't preclude checking changes, it just means that if you want to look over the reformat you need to checkout the old version, format it, then do the diff which means only in extreme instances would most people bother. -- -- Matthew Buckett, VLE Developer -- Learning Technologies Group, Oxford University Computing Services -- Tel: +44 (0)1865 283660 http://www.oucs.ox.ac.uk/ltg/ |
From: Paul D. <pau...@ou...> - 2006-03-01 12:53:37
|
I think we have this with the tree - but it confuses people so it's generally turned off! I presume you want something showing just the title, with clickable link down to the description/next layer? Or is there a better outline spec? Paul ------------------------------------------------------------------------- Dr Paul V Davis Acting Head, Learning Technologies Group Project Manager, WebLearn ( Oxford's version of Bodington.org) Oxford University Computing Services 13 Banbury Road, Oxford, OX2 6NN Tel: 01865 283414 -----Original Message----- From: bod...@li... [mailto:bod...@li...] On Behalf Of Adam Marshall Sent: 01 March 2006 12:45 To: bod...@li... Subject: RE: [Bodington-developers] History and performance of acl_entries and permission_coded I think it would be an absolute winner if we could have a windows explorer type interface showing only the resources that one can see. This would remove many of the gripes that people have about navigation. adam -- Adam Marshall: OUCS, 13, Banbury Rd. Oxford OX2 6NN. Shameless plug 1: Use the Bodington VLE http://bodington.org Shameless plug 2: Use the LUSID PDP system, http://www.lusid.org.uk/ Blog: http://ramble.oucs.ox.ac.uk/blog/adamm/ Cheese of the month: Korbacik - Slovakian String Cheese | -----Original Message----- | From: bod...@li... [mailto:bodington- | dev...@li...] On Behalf Of Matthew Buckett | Sent: 01 March 2006 12:38 | To: bod...@li... | Subject: Re: [Bodington-developers] History and performance of acl_entries | and permission_coded | | Adam Marshall wrote: | > 'show me all the resources to which I have manage access to' would be a | > really neat function if it were able to be performed efficiently. | | We can get close by doing something like 'show me all the resources I am | the owner for' | | -- | -- Matthew Buckett, VLE Developer | -- Learning Technologies Group, Oxford University Computing Services | -- Tel: +44 (0)1865 283660 http://www.oucs.ox.ac.uk/ltg/ | | | ------------------------------------------------------- | This SF.Net email is sponsored by xPML, a groundbreaking scripting | language | that extends applications into web and mobile media. Attend the live | webcast | and join the prime developer group breaking into this new coding | territory! | http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 | _______________________________________________ | Bodington-developers mailing list | Bod...@li... | https://lists.sourceforge.net/lists/listinfo/bodington-developers ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Bodington-developers mailing list Bod...@li... https://lists.sourceforge.net/lists/listinfo/bodington-developers |
From: Matthew B. <mat...@ou...> - 2006-03-01 12:51:55
|
I noticed that there is some nice new stuff on Bodington HEAD from Peter. Although the commit comment signals the intention (sorting of MCQ results and Anonymous marking of pigeon holes) is there any more documentation about these changes (requirements,specs)? -- -- Matthew Buckett, VLE Developer -- Learning Technologies Group, Oxford University Computing Services -- Tel: +44 (0)1865 283660 http://www.oucs.ox.ac.uk/ltg/ |
From: Peter C. <Pet...@me...> - 2006-03-01 12:47:08
|
> From: Matthew Buckett > I know permission checks are caches for a little while (~5 seconds) so > once permission have been calculated for a request they should stick > around for a while. Resource.storeRecentPermission() is used. Ah! Thanks. > With the recursive > nature of the permissions (inherit) I don't see an easy way=20 > todo this in > the database without store procedures (please don't go there). Awww, can I? Please? > select resource.id from users, groups, resources, acls,=20 > acl_entrys where > [join all tables together] and acl_entry.manage =3D true; Assuming manage is broken out into its own column, is positive... > Do we want permissions to be calculatable in the database? Would the > previous SQL ever run acceptably? With appropriate indexing, yes it would - at least on the RDBMSs I use. > We could fake the "inherit access" behind the scences=20 > although it makes > some permission changes expensive. Yes. But, as you pointed out, permissions change rarely; large recursive changes are even more rare. Paying the time to update a cache table when they change is, to my mind, a worthwhile tradeoff. It's similar to the way NTFS stores permissions (inherited ACEs are added to each ACL) rather than the old NetWare approach that maintained a central list and calculated on each access. If you assume that space is cheaper than time and that reads are much more common than writes, you can make very large savings. [Aside: I'll be writing a very similar system for ASK] - Peter |
From: Adam M. <ada...@co...> - 2006-03-01 12:44:48
|
I think it would be an absolute winner if we could have a windows explorer type interface showing only the resources that one can see. This would remove many of the gripes that people have about navigation. adam -- Adam Marshall: OUCS, 13, Banbury Rd. Oxford OX2 6NN. Shameless plug 1: Use the Bodington VLE http://bodington.org Shameless plug 2: Use the LUSID PDP system, http://www.lusid.org.uk/ Blog: http://ramble.oucs.ox.ac.uk/blog/adamm/ Cheese of the month: Korbacik - Slovakian String Cheese | -----Original Message----- | From: bod...@li... [mailto:bodington- | dev...@li...] On Behalf Of Matthew Buckett | Sent: 01 March 2006 12:38 | To: bod...@li... | Subject: Re: [Bodington-developers] History and performance of acl_entries | and permission_coded | | Adam Marshall wrote: | > 'show me all the resources to which I have manage access to' would be a | > really neat function if it were able to be performed efficiently. | | We can get close by doing something like 'show me all the resources I am | the owner for' | | -- | -- Matthew Buckett, VLE Developer | -- Learning Technologies Group, Oxford University Computing Services | -- Tel: +44 (0)1865 283660 http://www.oucs.ox.ac.uk/ltg/ | | | ------------------------------------------------------- | This SF.Net email is sponsored by xPML, a groundbreaking scripting | language | that extends applications into web and mobile media. Attend the live | webcast | and join the prime developer group breaking into this new coding | territory! | http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 | _______________________________________________ | Bodington-developers mailing list | Bod...@li... | https://lists.sourceforge.net/lists/listinfo/bodington-developers |
From: Adam M. <ada...@co...> - 2006-03-01 12:43:28
|
RDBMS-specific scripts - there's already a precedent for this isn't = there? Ada. --=20 Adam Marshall: OUCS, 13, Banbury Rd. Oxford OX2 6NN. Shameless plug 1: Use the Bodington VLE http://bodington.org Shameless plug 2: Use the LUSID PDP system, http://www.lusid.org.uk/ Blog: http://ramble.oucs.ox.ac.uk/blog/adamm/ Cheese of the month: Korbacik - Slovakian String Cheese | -----Original Message----- | From: bod...@li... = [mailto:bodington- | dev...@li...] On Behalf Of Peter Crowther | Sent: 01 March 2006 12:37 | To: bod...@li... | Subject: RE: [Bodington-developers] Gotcha with facility/session split |=20 | > From: Adam Marshall | > There's prob an equivalenmt in MSSQL though. Peter - I | > thought you'd know. |=20 | Yes. But it doesn't work in Postgres. So we either start writing a | macro language on top of SQL in which we write our database scripts, = or | we go for RDBMS-specific scripts or script fragments. |=20 | - Peter |=20 |=20 | ------------------------------------------------------- | This SF.Net email is sponsored by xPML, a groundbreaking scripting | language | that extends applications into web and mobile media. Attend the live | webcast | and join the prime developer group breaking into this new coding | territory! | http://sel.as-us.falkag.net/sel?cmd=3Dk&kid=110944&bid$1720&dat=121642 | _______________________________________________ | Bodington-developers mailing list | Bod...@li... | https://lists.sourceforge.net/lists/listinfo/bodington-developers |
From: Andrew B. <bm...@go...> - 2006-03-01 12:38:11
|
I now have a working version of the peer-marking tool. If anyone is interested in seeing it, I can let you have a quickstart war file = containing a Bodington set up with demo locations, data and users, so you can play around with it. Aggie ___________________________________________________ Andrew G Booth Professor of On-Line Learning and Associate Professor of Biochemistry Garstang Building Faculty of Biological Sciences University of Leeds Leeds LS2 9JT U.K. Tel: +44-113-343-3142 Fax: +44-113-343-3167 email: a.g...@le... personal email should be sent to: an...@ag... ___________________________________________________ Support open source Virtual Learning Environments The Bodington System Project http://bodington.org ___________________________________________________ |
From: Matthew B. <mat...@ou...> - 2006-03-01 12:38:01
|
Adam Marshall wrote: > 'show me all the resources to which I have manage access to' would be a > really neat function if it were able to be performed efficiently. We can get close by doing something like 'show me all the resources I am the owner for' -- -- Matthew Buckett, VLE Developer -- Learning Technologies Group, Oxford University Computing Services -- Tel: +44 (0)1865 283660 http://www.oucs.ox.ac.uk/ltg/ |
From: Peter C. <Pet...@me...> - 2006-03-01 12:37:27
|
> From: Adam Marshall > There's prob an equivalenmt in MSSQL though. Peter - I=20 > thought you'd know. Yes. But it doesn't work in Postgres. So we either start writing a macro language on top of SQL in which we write our database scripts, or we go for RDBMS-specific scripts or script fragments. - Peter |
From: Matthew B. <mat...@ou...> - 2006-03-01 12:37:02
|
Peter Crowther wrote: > Has anyone ever benchmarked Bodington's permission system? I'm delving > into this for the first time, and the present system of storing ACEs > with the permissions encoded as a single string looks like it's flexible > but could be slow in use. I know permission checks are caches for a little while (~5 seconds) so once permission have been calculated for a request they should stick around for a while. Resource.storeRecentPermission() is used. When an AclEntry is loaded from the database the permissions are parsed from the string into a hashmap and as long as the AclEntry stays in the cache you never have to repeat the parsing. What with the cache and the fact that permissions don't change all that much I don't think this is a severe problem in the Java world. Although it makes it very difficult todo permission calculations without the Java objects. > Are there particular design principles behind this part of the system > that mean that theoretical slownesses don't arise in reality? For > example, I'd expect 'show me all the resources to which I have manage > access' to be crippling. Indeed. In effect it's a enumeration of all resources and then performing a checkPermission (done in Java) on them. With the recursive nature of the permissions (inherit) I don't see an easy way todo this in the database without store procedures (please don't go there). If the permission checks could be done at the database layer then this becomes possible with SQL such as: select resource.id from users, groups, resources, acls, acl_entrys where [join all tables together] and acl_entry.manage = true; Do we want permissions to be calculatable in the database? Would the previous SQL ever run acceptably? We could fake the "inherit access" behind the scences although it makes some permission changes expensive. -- -- Matthew Buckett, VLE Developer -- Learning Technologies Group, Oxford University Computing Services -- Tel: +44 (0)1865 283660 http://www.oucs.ox.ac.uk/ltg/ |
From: Adam M. <ada...@co...> - 2006-03-01 12:34:39
|
There's prob an equivalenmt in MSSQL though. Peter - I thought you'd = know. adam --=20 Adam Marshall: OUCS, 13, Banbury Rd. Oxford OX2 6NN. Shameless plug 1: Use the Bodington VLE http://bodington.org Shameless plug 2: Use the LUSID PDP system, http://www.lusid.org.uk/ Blog: http://ramble.oucs.ox.ac.uk/blog/adamm/ Cheese of the month: Korbacik - Slovakian String Cheese | -----Original Message----- | From: bod...@li... = [mailto:bodington- | dev...@li...] On Behalf Of Peter Crowther | Sent: 01 March 2006 12:28 | To: bod...@li... | Subject: RE: [Bodington-developers] Gotcha with facility/session split |=20 | > From: Matthew Buckett | > Does something | > like this work anywhere apart from PostgreSQL? | > | > ALTER TABLE uploaded_files ALTER COLUMN mime_type DROP NOT NULL; |=20 | It's not standard. MSSQL throws a fit over it, worse luck. |=20 | - Peter |=20 |=20 | ------------------------------------------------------- | This SF.Net email is sponsored by xPML, a groundbreaking scripting | language | that extends applications into web and mobile media. Attend the live | webcast | and join the prime developer group breaking into this new coding | territory! | http://sel.as-us.falkag.net/sel?cmd=3Dk&kid=110944&bid$1720&dat=121642 | _______________________________________________ | Bodington-developers mailing list | Bod...@li... | https://lists.sourceforge.net/lists/listinfo/bodington-developers |
From: Adam M. <ada...@co...> - 2006-03-01 12:33:33
|
'show me all the resources to which I have manage access to' would be a really neat function if it were able to be performed efficiently.=20 We could use it in MyWebLearn (MyBodington) as a navigation option. adam --=20 Adam Marshall: OUCS, 13, Banbury Rd. Oxford OX2 6NN. Shameless plug 1: Use the Bodington VLE http://bodington.org Shameless plug 2: Use the LUSID PDP system, http://www.lusid.org.uk/ Blog: http://ramble.oucs.ox.ac.uk/blog/adamm/ Cheese of the month: Korbacik - Slovakian String Cheese | -----Original Message----- | From: bod...@li... = [mailto:bodington- | dev...@li...] On Behalf Of Peter Crowther | Sent: 01 March 2006 12:13 | To: bod...@li... | Subject: [Bodington-developers] History and performance of acl_entries = and | permission_coded |=20 | Has anyone ever benchmarked Bodington's permission system? I'm = delving | into this for the first time, and the present system of storing ACEs | with the permissions encoded as a single string looks like it's = flexible | but could be slow in use. |=20 | Are there particular design principles behind this part of the system | that mean that theoretical slownesses don't arise in reality? For | example, I'd expect 'show me all the resources to which I have manage | access' to be crippling. |=20 | - Peter |=20 |=20 | ------------------------------------------------------- | This SF.Net email is sponsored by xPML, a groundbreaking scripting | language | that extends applications into web and mobile media. Attend the live | webcast | and join the prime developer group breaking into this new coding | territory! | http://sel.as-us.falkag.net/sel?cmd=3Dk&kid=110944&bid$1720&dat=121642 | _______________________________________________ | Bodington-developers mailing list | Bod...@li... | https://lists.sourceforge.net/lists/listinfo/bodington-developers |
From: Peter C. <Pet...@me...> - 2006-03-01 12:27:38
|
> From: Matthew Buckett > Does something > like this work anywhere apart from PostgreSQL? >=20 > ALTER TABLE uploaded_files ALTER COLUMN mime_type DROP NOT NULL; It's not standard. MSSQL throws a fit over it, worse luck. - Peter |
From: Peter C. <Pet...@me...> - 2006-03-01 12:25:17
|
> From: Matthew Buckett > Tab size is set to 4. That's the one I invariably miss. Sorry Matthew. On a side note, we do have a migration problem here. If the advice was to use tabs consistently *or* spaces consistently, we'd be fine. But it's not. The whole formatting thing is starting to be a sufficiently large annoyance (to me at least) that I would now back a proposal to 'big bang' the formatting over to one or the other at the instant a release was declared, and accept the impact on the SourceForge version history. However, unlike Oxford, I don't maintain a separate CVS repository for Bodington. - Peter |
From: Matthew B. <mat...@ou...> - 2006-03-01 12:19:04
|
We've had some discussions about this before but could we have the a small set of guidelines about code formatting on Bodington HEAD please. Wherever possible you try to use the existing majority code style in the file. I believe there has been some discussion of the two major "Jon" styles and summaries of these should be in the file. Tab size is set to 4. New indentation is done with spaces and indented 4 spaces. I'm just having problems with the indentation of some of the incoming changes and the indentation being a little out. -- -- Matthew Buckett, VLE Developer -- Learning Technologies Group, Oxford University Computing Services -- Tel: +44 (0)1865 283660 http://www.oucs.ox.ac.uk/ltg/ |
From: Matthew B. <mat...@ou...> - 2006-03-01 12:17:48
|
Peter Crowther wrote: >>From: Matthew Buckett >>Maybe we should change this so that the database layer deals >>with nulls? >>This would simplify some of the code but as you mentioned requires >>dropping the constraint that mime_type of uploaded_files >>can't be null. > > > That seems like a better approach to me, but the SQL for the migration > code is probably hairy. Indeed, this was why I didn't do it in the first place. Does something like this work anywhere apart from PostgreSQL? ALTER TABLE uploaded_files ALTER COLUMN mime_type DROP NOT NULL; -- -- Matthew Buckett, VLE Developer -- Learning Technologies Group, Oxford University Computing Services -- Tel: +44 (0)1865 283660 http://www.oucs.ox.ac.uk/ltg/ |
From: Peter C. <Pet...@me...> - 2006-03-01 12:12:51
|
Has anyone ever benchmarked Bodington's permission system? I'm delving into this for the first time, and the present system of storing ACEs with the permissions encoded as a single string looks like it's flexible but could be slow in use. Are there particular design principles behind this part of the system that mean that theoretical slownesses don't arise in reality? For example, I'd expect 'show me all the resources to which I have manage access' to be crippling. - Peter |