Re: [OT] Prepaid mobile plans with data, possibly roaming
On 23 August 2012 00:41, Anthony Lucas wrote: > They just want you to buy their tethering add-on and mifi products. It's probably simpler for me to just pay for the damn tethering add-on, but part of me is annoyed at the restriction and wishes to try to bypass it :) I'll try VPNing back to my shell account and see what happens.. can't be any slower than 3G already is.. TC
Re: How to retrieve a row, biased by populatity?
On Wed, Aug 22, 2012 at 10:15 AM, David Hodgkinson wrote: > > On 21 Aug 2012, at 21:54, Fahad Khan wrote: > > > SELECT * FROM band ORDER BY ranking - RAND() * $BIAS DESC LIMIT 1; > > > > Fahad. > > > I like this one best. I know I have 850k rows, just pick the n'th on > some form of log curve. > Ah the devil's in the detail. I'm not sure exactly what you mean. But... 1. You know you have 850k rows. We didn't. 2. Its not any form of a log curve. 3. Read what follows. I'm sure there's more detail. Bare in mind this Debian Lenny stock install on a pretty humble desktop. mysql> show create table bands; | bands | CREATE TABLE `bands` ( `name` text, `ranking` int(11) DEFAULT NULL, KEY `ranking_idx` (`ranking`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | mysql> SELECT COUNT(*) FROM bands; +--+ | COUNT(*) | +--+ | 85 | +--+ 1 row in set (0.01 sec) mysql> SELECT * FROM bands ORDER BY ranking - RAND() * 5000 DESC LIMIT 1; +-+-+ | name| ranking | +-+-+ | prompt socializes callus period | 849973 | +-+-+ 1 row in set (1.26 sec) mysql> show create table band; +---+-+ | Table | Create Table | +---+-+ | band | CREATE TABLE `band` ( `name` text, `ranking` int(11) NOT NULL, PRIMARY KEY (`ranking`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | +---+-+ 1 row in set (0.00 sec) mysql> SELECT COUNT(*) FROM band; +--+ | COUNT(*) | +--+ | 85 | +--+ 1 row in set (0.35 sec) mysql> SELECT * FROM band ORDER BY ranking - RAND() * 5000 DESC LIMIT 1; +-+-+ | name| ranking | +-+-+ | biscuit Egyptianizations Jamaica consequent | 849979 | +-+-+ 1 row in set (1.76 sec) $ pg_dump dave_test --schema-only -t band ... CREATE TABLE band ( name text, ranking integer NOT NULL ); ... ALTER TABLE ONLY band ADD CONSTRAINT band_pkey PRIMARY KEY (ranking); ... dave_test=> select count(*) from band; count 85 (1 row) dave_test=> SELECT * FROM band ORDER BY ranking - RANDOM() * 5000 DESC LIMIT 1; name | ranking --+- sank fission | 849994 (1 row) Time: 372.286 ms
Re: and this place ships bagels to the US!
On 08/22/2012 04:35 AM, Raphael Mankin wrote: On Wed, 2012-08-22 at 01:42 -0400, Uri Guttman wrote: http://www.stviateurbagel.com/products/?rand=1002335542 So what's the problem? Bagels are no more native to the US than they are to Canada. They are a European invention. never meant to send it here. address completion typo. uri
Re: [OT] Prepaid mobile plans with data, possibly roaming
They just want you to buy their tethering add-on and mifi products. I got through a gig of data before they caught on last time, in a fairly short space of time (as in hours, using it as a hotspot for my laptop, streaming, you name it) and put the temporary block and redirect page up. They probably block some ports, but I haven't noticed any. Most ports seemed fine the last time I was stuck without internet. -- Anthony Lucas Sent with Sparrow (http://www.sparrowmailapp.com/?sig) On Wednesday, 22 August 2012 at 06:52, Toby Wintermute wrote: > On 22 August 2012 02:15, Anthony Lucas (mailto:anthonyjlu...@gmail.com)> wrote: > > 3 can be quite good with the traffic detection if it's obvious. > > > > In my experience, 5 or so hours of usage (unauthorised tethering) and > > they're on to you. > > Pop it back in your phone, reboot or lose the tower, and you're back in > > business as far as internet access on the phone, > > but you're now on some kind of watch-list and they're a lot faster to catch > > on the second time. > > > > > > Ah, really? That's irritating that they bother.. I mean, I'm just > using the same bandwidth quota regardless of method :/ > > Do Three block outbound ports? > (ie. Can I just tunnel everything through an ssh or openvpn tunnel so > that no traffic inspection can be done..) > > > Toby
Re: [OT] Prepaid mobile plans with data, possibly roaming
The joys of corporate deals :) I think I (or my employer) was charged £1.80 a minute while i was in Pakistan last year. I dread to think how much it cost! On 22 Aug 2012, at 19:51, "David Cantrell" wrote: > On Mon, Aug 20, 2012 at 10:57:53PM +0800, Paul Weaver wrote: >> Just fyi, EU Data prices on my O2 phone dropped between may and July from >> £2.55+ vat per meg to £0.58+vat. £100 cap and 300MB max. > > Then you need to change your tariff. O2 charge me 8p per MB on the > mainland, 2 quid cap per day unless I authorise another 2 quid (and > another, and another, ...). > > It covers Switzerland too, despite that not being in the EU. I expect > it would also cover Norway. > > -- > David Cantrell | Hero of the Information Age > >Vegetarian: n: a person who, due to malnutrition caused by > poor lifestyle choices, is eight times more likely to > catch TB than a normal person
Re: [OT] Prepaid mobile plans with data, possibly roaming
On Mon, Aug 20, 2012 at 10:57:53PM +0800, Paul Weaver wrote: > Just fyi, EU Data prices on my O2 phone dropped between may and July from > £2.55+ vat per meg to £0.58+vat. £100 cap and 300MB max. Then you need to change your tariff. O2 charge me 8p per MB on the mainland, 2 quid cap per day unless I authorise another 2 quid (and another, and another, ...). It covers Switzerland too, despite that not being in the EU. I expect it would also cover Norway. -- David Cantrell | Hero of the Information Age Vegetarian: n: a person who, due to malnutrition caused by poor lifestyle choices, is eight times more likely to catch TB than a normal person
Re: How to retrieve a row, biased by populatity?
On 21 Aug 2012, at 21:54, Fahad Khan wrote: > On Tue, Aug 21, 2012 at 9:22 PM, Dave Hodgkinson wrote: > >> >> Possibly a perl question. SQL would do... >> >> Given a set of data, say bands, with each having a ranking, either a >> review metric or a sales ranking, how would you retrieve a random >> row, but biased towards the higher ranking? >> >> > SELECT * FROM band ORDER BY ranking - RAND() * $BIAS DESC LIMIT 1; > > Fahad. I like this one best. I know I have 850k rows, just pick the n'th on some form of log curve.
Re: and this place ships bagels to the US!
On Wed, 2012-08-22 at 01:42 -0400, Uri Guttman wrote: > http://www.stviateurbagel.com/products/?rand=1002335542 > So what's the problem? Bagels are no more native to the US than they are to Canada. They are a European invention.
and this place ships bagels to the US!
http://www.stviateurbagel.com/products/?rand=1002335542
Re: [OT] Prepaid mobile plans with data, possibly roaming
Just fyi, EU Data prices on my O2 phone dropped between may and July from £2.55+ vat per meg to £0.58+vat. £100 cap and 300MB max. Outside Europe it's still £6/mb. I tore through £50 between the airport and hotel in Delhi last week while checking the taxi driver was taking me the right way! Capped at £102.13 (??) but for 200MB. On 20 Aug 2012, at 22:47, "Toby Wintermute" wrote: > Hello all, > I'm making a whirlwind visit to London and bits of Europe soon, > although with awfully poor timing, just missing YAPC:EU :( > Hopefully I'll manage to run into a few of you while I'm in London though. > > The last time I visited, I picked up an Orange SIM that had "Unlimited > data" on the plan.. only to discover they meant "unlimited, but at > <5kb/sec". > > So this time around I thought I should get some local knowledge. Can > you suggest a mobile carrier who has: > * 3G support for prepaid SIMs > * Has reasonably priced data plans > * For bonus points -- will work while roaming in Germany. Although I > suspect I'll just have to buy yet another SIM over there.. > > Alternatively.. I'd be happy to just get a data-only SIM and use Skype > or similar the whole time. > I hope this isn't too off-topic! > > Thanks, > Toby > > -- > Turning and turning in the widening gyre > The falcon cannot hear the falconer > Things fall apart; the center cannot hold > Mere anarchy is loosed upon the world