Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 52860 invoked from network); 4 Feb 2009 21:20:18 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 4 Feb 2009 21:20:18 -0000 Received: (qmail 47517 invoked by uid 500); 4 Feb 2009 21:20:15 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 47487 invoked by uid 500); 4 Feb 2009 21:20:15 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 47472 invoked by uid 99); 4 Feb 2009 21:20:15 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Feb 2009 13:20:15 -0800 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [209.85.198.235] (HELO rv-out-0506.google.com) (209.85.198.235) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Feb 2009 21:20:05 +0000 Received: by rv-out-0506.google.com with SMTP id g37so2583405rvb.35 for ; Wed, 04 Feb 2009 13:19:42 -0800 (PST) Received: by 10.141.29.21 with SMTP id g21mr3893428rvj.44.1233782382470; Wed, 04 Feb 2009 13:19:42 -0800 (PST) Received: from ?10.0.1.205? ([67.159.148.212]) by mx.google.com with ESMTPS id c20sm7496853rvf.8.2009.02.04.13.19.41 (version=TLSv1/SSLv3 cipher=RC4-MD5); Wed, 04 Feb 2009 13:19:42 -0800 (PST) Message-Id: From: Troy Kruthoff To: user@couchdb.apache.org In-Reply-To: Content-Type: multipart/signed; boundary=Apple-Mail-131--75373573; micalg=sha1; protocol="application/pkcs7-signature" Mime-Version: 1.0 (Apple Message framework v929.2) Subject: Re: _rev for random view??? Date: Wed, 4 Feb 2009 13:19:40 -0800 References: X-Mailer: Apple Mail (2.929.2) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail-131--75373573 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Math.random() is avail, at least in 0.9.0a712819 and I hope it stays, most RDBMS have support for generating random numbers as well. I realize this could be done @ the app level, but it's so much cleaner to me to have a view called random and be done with it. -- troy On Feb 4, 2009, at 12:47 PM, Chris Anderson wrote: > On Wed, Feb 4, 2009 at 12:41 PM, Paul Davis > wrote: >> On Wed, Feb 4, 2009 at 3:18 PM, Chris Anderson >> wrote: >>> On Wed, Feb 4, 2009 at 11:15 AM, Troy Kruthoff >>> wrote: >>>> >>>> Anyone have thoughts on the best way to create a view of random >>>> documents? >>>> I'm thinking a view with emit(doc._rev,null) would be sufficient >>>> for my >>>> needs, but thought I'd ping the list for collective knowledge ;) >>>> >>> >>> I'm not sure how _rev works for randomness. >>> >>> Math.random() >>> >> >> Though you should *NEVER* use Math.random() in a view. Not sure if >> it's even in the sandbox, but just in case. > > I don't think there's anything wrong with using it. If what you want > is a random order. > > More efficient might be to take the seqid of the db, and generate a > random # smaller than it. Then chose the docid based on the seq. > however, that will bias for frequently updated docs. > > -- > Chris Anderson > http://jchris.mfdz.com --Apple-Mail-131--75373573 Content-Disposition: attachment; filename=smime.p7s Content-Type: application/pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGJTCCAt4w ggJHoAMCAQICEHKIybH1HP4FdtiEIfNXD9UwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkEx JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA4MTAwMjA0MDQyNVoXDTA5MTAwMjA0MDQy NVowRDEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEhMB8GCSqGSIb3DQEJARYSdGty dXRob2ZmQGJsaXQuY29tMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA0JAcYw+sWUeE w9cMbH744cJCJEG0yJbPsPLAnQt6XaQk1jisgW4wUICpkKg5MY9JVUzDGDHLExcoIQS4/smHGiec f00YDdLCEn+YA9hN33GJ9PLdmxlgzb9bNIT2MdMBW/FUP7Cp/wlV9O5salmwhzAXrfIQ+tzKC2t5 K/xxdlzoxH/j0SBEIt5D5qrHPHpJxysYHFPLx+Tby9+9QvEdGrQ/ORjGB1sQdwlPiJo08xiOflsJ b7215PWbqTxWX6Ayp4t8vOUGm07PjPGNhD84rX5U9NE4diy99SCb662xxjPqgG1xrei+zjDPDZVv 2bb3GjtUUZtWGdQxZqU+YVJaWwIDAQABoy8wLTAdBgNVHREEFjAUgRJ0a3J1dGhvZmZAYmxpdC5j b20wDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQUFAAOBgQCaZdORqI9158q+aaALNfiDGqY6rUU+ Vinca1MpT/Tkew5LJF5DDXjCLTlHxqsUAOaQQ16yMy5vJkh77zDjd6/pnXpwSTzSLx0SCRgUm0oy Q84zZoGvWSbjmlZLwYZIoA8g3ak7eP/xeDhshY1R+Ok2NIetV48vGSPK8QfUcBsFyDCCAz8wggKo oAMCAQICAQ0wDQYJKoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJu IENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAm BgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQ ZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhh d3RlLmNvbTAeFw0wMzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpBMSUw IwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVy c29uYWwgRnJlZW1haWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKY8 VXNV+065yplaHmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7dyfAr hVqqP3FWy688Cwfn8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUPSAR/p7bR PGEEQB5kGXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8MDowOKA2 oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWlsQ0EuY3JsMAsG A1UdDwQEAwIBBjApBgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0xMzgwDQYJ KoZIhvcNAQEFBQADgYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYfqi2fNi/A9BxQ IJNwPP2t4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa9/eH1sYITq72 6jTlEBpbNU1341YheILcIRk13iSx0x1G/11fZU8xggMQMIIDDAIBATB2MGIxCzAJBgNVBAYTAlpB MSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUg UGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIQcojJsfUc/gV22IQh81cP1TAJBgUrDgMCGgUA oIIBbzAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wOTAyMDQyMTE5 NDBaMCMGCSqGSIb3DQEJBDEWBBSenMwpQgsitq0h5GbFXfzmAWpP5zCBhQYJKwYBBAGCNxAEMXgw djBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEs MCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEHKIybH1HP4FdtiE IfNXD9UwgYcGCyqGSIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3Rl IENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWls IElzc3VpbmcgQ0ECEHKIybH1HP4FdtiEIfNXD9UwDQYJKoZIhvcNAQEBBQAEggEAIyxUMKsQ8jkm O+sTBFsWOx31qk1I2OmXbL1yGzt+fHg5sCoZ9qm83j97skmWEu5z+6R32F0WG1JtkqZE5IznAWbz cSNit/D/4+qB/iw3GbwLuSgqwWGR3h+rmiyHCu2sSCJ76JgLGoiDnbe1V5Dv5FG1Y0iKGg/Q5h8+ P8fHiUeJR+aHe3ke3+lcoC8XaCTwin09POSPK5Guha6IISFDg+mz37cXW9hTfYAdaw8SWv1ZVMML YhiQ48nLuW54WyLCnPKUU0iRiK6vekbMP/i/S74SLVcnvFLbaDpABe5OrGi3SE1trvj7x4P2e9vb aPfMNlzqCAkRs1fm5wTEAuEvXgAAAAAAAA== --Apple-Mail-131--75373573--