Relational and non-relational database notes: Revision history

23 January 2016

• curprev 16:4916:49, 23 January 2016‎ Helpful talk contribs‎ m 63,637 bytes −38‎ →‎select a fraction of rows
• curprev 16:4716:47, 23 January 2016‎ Helpful talk contribs‎ m 63,675 bytes −135‎ →‎order by random

22 June 2015

• curprev 13:3213:32, 22 June 2015‎ Helpful talk contribs‎ m 63,810 bytes −5‎ →‎select a fraction of rows
• curprev 13:3013:30, 22 June 2015‎ Helpful talk contribs‎ m 63,815 bytes +61‎ →‎Fetching random items and samples

15 April 2015

• curprev 18:4418:44, 15 April 2015‎ Helpful talk contribs‎ m 63,754 bytes +468‎ →‎Anti-join
• curprev 18:3218:32, 15 April 2015‎ Helpful talk contribs‎ m 63,286 bytes +1,307‎ →‎Join types
• curprev 18:0018:00, 15 April 2015‎ Helpful talk contribs‎ m 61,979 bytes −94‎ →‎SQL
• curprev 17:2717:27, 15 April 2015‎ Helpful talk contribs‎ m 62,073 bytes −5‎ →‎CROSS JOIN
• curprev 17:2717:27, 15 April 2015‎ Helpful talk contribs‎ m 62,078 bytes +14‎ →‎INNER join

2 February 2014

• curprev 16:5116:51, 2 February 2014‎ Helpful talk contribs‎ m 62,064 bytes +438‎ →‎select next ID
• curprev 16:4216:42, 2 February 2014‎ Helpful talk contribs‎ m 61,626 bytes +82‎ →‎random offset
• curprev 16:4116:41, 2 February 2014‎ Helpful talk contribs‎ m 61,544 bytes +43‎ →‎select a fraction of rows
• curprev 16:3916:39, 2 February 2014‎ Helpful talk contribs‎ m 61,501 bytes +209‎ →‎random offset

28 January 2014

• curprev 19:5019:50, 28 January 2014‎ Helpful talk contribs‎ m 61,292 bytes +149‎ →‎Isolation levels
• curprev 19:4319:43, 28 January 2014‎ Helpful talk contribs‎ m 61,143 bytes +965‎ →‎Isolation levels
• curprev 18:4818:48, 28 January 2014‎ Helpful talk contribs‎ m 60,178 bytes +18‎ →‎Considerations to allowing dirty reads
• curprev 18:4618:46, 28 January 2014‎ Helpful talk contribs‎ m 60,160 bytes −1‎ →‎random offset
• curprev 18:4618:46, 28 January 2014‎ Helpful talk contribs‎ m 60,161 bytes +1,031‎ →‎Semi-sorted

14 October 2013

• curprev 18:1718:17, 14 October 2013‎ Helpful talk contribs‎ m 59,130 bytes +456‎ →‎Fetching random items and samples
• curprev 18:0418:04, 14 October 2013‎ Helpful talk contribs‎ m 58,674 bytes +350‎ →‎order by random
• curprev 17:5917:59, 14 October 2013‎ Helpful talk contribs‎ m 58,324 bytes +1,172‎ →‎Semi-sorted
• curprev 01:4701:47, 14 October 2013‎ Helpful talk contribs‎ m 57,152 bytes +36‎ →‎Fetching random items and samples

13 August 2013

• curprev 16:1416:14, 13 August 2013‎ Helpful talk contribs‎ m 57,116 bytes −5‎ →‎CROSS JOIN
• curprev 16:1416:14, 13 August 2013‎ Helpful talk contribs‎ m 57,121 bytes −189‎ →‎Join types

4 March 2013

• curprev 15:0715:07, 4 March 2013‎ Helpful talk contribs‎ m 57,310 bytes −12‎ No edit summary

3 May 2012

• curprev 17:3317:33, 3 May 2012‎ Helpful talk contribs‎ m 57,322 bytes +71‎ →‎Specific to...

2 May 2012

• curprev 19:4219:42, 2 May 2012‎ Helpful talk contribs‎ m 57,251 bytes −1‎ →‎Critical notes on MySQL, Postgres, etc.

5 February 2012

• curprev 03:2803:28, 5 February 2012‎ Helpful talk contribs‎ m 57,252 bytes +21,916‎ No edit summary

4 February 2012

• curprev 04:5404:54, 4 February 2012‎ 111.93.40.13 talk‎ 35,336 bytes +9‎ KsPdk8 I couldn�t resist commenting.
• curprev 04:5004:50, 4 February 2012‎ 85.214.84.104 talk‎ 35,327 bytes −21,911‎ KsPdk8 I couldn�t resist commenting.

2 February 2012

• curprev 00:2700:27, 2 February 2012‎ Helpful talk contribs‎ m 57,238 bytes +21,919‎ Reverted edits by 98.228.41.77 (talk) to last revision by Helpful

1 February 2012

• curprev 23:0223:02, 1 February 2012‎ 98.228.41.77 talk‎ 35,319 bytes −21,919‎ jqs7TF great this on this blog
• curprev 22:5322:53, 1 February 2012‎ Helpful talk contribs‎ m 57,238 bytes +35,954‎ No edit summary
• curprev 19:1519:15, 1 February 2012‎ 188.116.3.38 talk‎ 21,284 bytes −14,028‎ Looking forward to now
• curprev 17:4717:47, 1 February 2012‎ 41.190.16.17 talk‎ 35,312 bytes −21,926‎ g00d info as usual here
• curprev 15:3615:36, 1 February 2012‎ Helpful talk contribs‎ m 57,238 bytes +5‎ →‎Things a database writes; Disk vs. SSD
• curprev 15:1515:15, 1 February 2012‎ Helpful talk contribs‎ m 57,233 bytes +21‎ →‎Databases: IO bound
• curprev 15:1515:15, 1 February 2012‎ Helpful talk contribs‎ m 57,212 bytes +18‎ →‎Configuring to use
• curprev 15:1415:14, 1 February 2012‎ Helpful talk contribs‎ m 57,194 bytes +2‎ →‎Speed and tweaking
• curprev 15:1415:14, 1 February 2012‎ Helpful talk contribs‎ m 57,192 bytes −1‎ →‎Speed and tweaking
• curprev 15:1115:11, 1 February 2012‎ Helpful talk contribs‎ m 57,193 bytes +21,885‎ Reverted edits by 200.32.70.2 (talk) to last revision by Helpful
• curprev 06:1106:11, 1 February 2012‎ 200.32.70.2 talk‎ 35,308 bytes −21,885‎ thxx for dat postje
• curprev 00:0600:06, 1 February 2012‎ Helpful talk contribs‎ m 57,193 bytes +21,887‎ Reverted edits by 207.219.7.136 (talk) to last revision by Helpful

31 January 2012

• curprev 23:3523:35, 31 January 2012‎ 207.219.7.136 talk‎ 35,306 bytes −21,887‎ what is love then
• curprev 12:3512:35, 31 January 2012‎ Helpful talk contribs‎ m 57,193 bytes +35,903‎ actually, that was several successive destructive edits, but thanks for bringing it up :)
• curprev 06:3706:37, 31 January 2012‎ CasaShea talk contribs‎ 21,290 bytes +6,331‎ Undo revision 38255 by 202.185.32.12 (talk).

30 January 2012

• curprev 02:5602:56, 30 January 2012‎ 202.185.32.12 talk‎ 14,959 bytes −6,331‎ just some random thoughts

28 January 2012

• curprev 20:0820:08, 28 January 2012‎ 82.134.72.203 talk‎ 21,290 bytes −14,036‎ kaaj i luuv it

11 January 2012

• curprev 09:2209:22, 11 January 2012‎ 4.79.231.188 talk‎ 35,326 bytes −21,867‎ WfT9Nv hmm what them is that? custom?

24 January 2011

• curprev 20:1820:18, 24 January 2011‎ Helpful talk contribs‎ m 57,193 bytes +57,193‎ No edit summary