[00:00] <ali1234> yeah i like webkit
[00:00] <ali1234> chrome/chromium sucks though
[00:01] <shauno> I'm curious to see what Opera do with it.  currently, I use chrome at work because safari's w32 implementation tries to drag too much of their rendering engine with it, which makes text look like a black sheep
[00:04] <shauno> but one engine winning doesn't seem any worse to me, than libjpeg or libpng being canonical.  the victory is in the dominant engine being free-for-all, rather than victory being no victor
[00:05] <ali1234> oh yeah i really hate apps that do that
[00:05] <ali1234> anything apple, anything nokia
[00:05] <ali1234> chrome to an extent, though not as badly
[00:06] <ali1234> oh and anything microsoft that deliberately brings over the "new" look of the next version of windows that i don't want
[00:06] <shauno> apple's windows ports are too faithful to the original.  I can see the logic, but it just feels out of place. and that really detracts from actually being able to read things
[00:06] <ali1234> but with chrome i miss rss bookmark folders and proper ad blocking
[00:06] <ali1234> and any other browser for that matter
[00:07] <shauno> lucily my ad-blocker functions as a http proxy, so it's as agnostic as possible
[00:10] <shauno> but this is why I still have firefox on every platform.  sometimes you actually need the kitchen sink
[00:10] <shauno> however, it's never my "daily driver"
[00:13] <shauno> it's suffered from a pretty basic problem.  the idea was sound enough.  mozilla was a monster, so they started from scratch
[00:13] <shauno> but it was driven by the same people with the same goals.  and we're meant to pretent it didn't turn into the same beast
[00:14] <ali1234> yeah i tend to agree
[00:14] <ali1234> but... i still prefer it for day to day use
[00:14] <ali1234> i don't actually want webpage to watch me most of the time
[00:17] <shauno> just to veer wildly on-topic, this is my current concern with Ubuntu.  It's going the same direction.
[00:18] <shauno> not being a desktop-linux user, I've basically treated Ubuntu like Debian with a sensible release schedule
[00:18] <shauno> a move to LTS+rolling is pretty much where I came from. stable+sid. a blessed release for production, and Sid for the desktop
[00:20] <shauno> I see the logic, but I'm not very cloudy.  This move really narrows the gap between debian-stable and ubuntu-lts
[00:20] <ali1234> not really
[00:20] <ali1234> ubuntu still has an advantage of actually caring about proprietary stuff
[00:21] <ali1234> for now anyway
[00:21] <shauno> my lack of desktop usage pretty much makes that irrelevant
[00:21] <ali1234> will be interesting to see how that goes with mir
[00:21] <shauno> for me, of course.  As they love to point out, I'm not their target market
[00:22] <ali1234> thn you've got stuff like indicators
[00:22] <ali1234> if you know how to get those working on debian stable i'm interested
[00:23] <ali1234> i'm really interested in juju and openstack too
[00:23] <shauno> I use OSX for the desktop.  my linux usage now is mainly down to VMs that we give to field techs to run on-site for 30 minutes, mail us the logs, destroy them and move on
[00:24] <ali1234> yeah i'll never use apple for desktop
[00:24] <ali1234> i'd rather use windows 8
[00:24] <shauno> I'm fairly open-minded. I don't look at masochists like they're crazy :)
[00:25] <aquarius> dsample, it does
[00:25] <aquarius> ah, you're offline
[00:25] <Myrtti> ill pass the message to him
[00:27] <Myrtti> aquarius, url? I mentioned it to a colleague and he wanted to try and do something similar for a meetup
[00:28] <aquarius> http://lugradio.org/live/2009/fstwittertag/fstwittertag.html?q=lrl2009&style=http://www.lugradio.org/live/2009/twitter.css
[00:28] <aquarius> Myrtti, ^
[00:29] <shauno> what I call desktop is almost entirely laptop.  I moved to OSX somewhere around Warty, when the laptop I had at the time had Suspend supported, but not Resume.  And it was a thinkpad, which are traditionally at the upper end of hardware support
[00:29] <ali1234> i don't use a laptop any more
[00:29] <ali1234> i just take a tablet
[00:29] <shauno> I can't use tablets for anything serious
[00:30] <ali1234> well, i can't use a laptop for anything serious either, so nothing lost :)
[00:31] <Myrtti> aquarius, cheers
[00:31] <ali1234> mainly because i need a mouse, not a touch pad, touch screen, or any of those other silly things
[00:32] <Myrtti> he hijacked my Nexus7
[00:32] <shauno> far too much of my usage ends up looking like https://dl.dropbox.com/u/23042/IMG_1486.jpg
[00:32] <ali1234> ah i can understand that i guess
[00:32] <ali1234> i don't ever deal with physical hardware
[00:33] <aquarius> um, I have a mouse with a laptop. I'm sitting here using it right now :)
[00:33] <shauno> UPSes are my day-job, we're nothing without phyisical
[00:34] <ali1234> yeah but i just hate carrying around a laptop and a mouse and a load of cables and then spending 10 minutes setting it all up
[00:34] <aquarius> ali1234, fine, but it's hard to see how carrying around a desktop computer and a mouse and a load of cables is easier ;)
[00:34] <ali1234> it isn't, but a tablet is
[00:34] <aquarius> um, "i need a mouse, not a touch pad, touch screen, or any of those other silly things"
[00:35] <ali1234> yeah
[00:35] <aquarius> or is your argument that you're fine to carry around a talet and a mouse, but not a laptop and a mouse
[00:35] <aquarius> ?
[00:35] <ali1234> so i end up just not doing stuff on the laptop
[00:35] <aquarius> *tablet, obviously
[00:35] <shauno> I'm used to carrying around a bag of extra kit, because no-one sells a laptop with 2-4 nics
[00:35] <ali1234> no, the argument is it's easier to carry a tablet than a laptop, and they are both easier than a laptop and mouse
[00:36] <aquarius> ali1234, sure, I agree with that, but I'm not the one who needs a mouse. ;)
[00:36] <ali1234> and tablet is equivalent in functionality to laptop without mouse
[00:36] <shauno> the dongle in that pic is an external nic, because I wanted to sit on the wire invisibly.  which I have no idea how to do on windows, and a desktop on a trolley is just a pain in the !ohmy
[00:36] <aquarius> not *sure* I agree, but I am aware that other people differ from me on this. I find an actual keyboard considerably easier to type on than a glass keyboard.
[00:37] <ali1234> yeah i don't really see much difference between tablet and a typical rubbish laptop keyboard
[00:37] <ali1234> i think i actually prefer tablet
[00:38] <ali1234> i man obviously they are different, but i think they are both pretty bad
[00:38] <shauno> I find with a tablet I have to watch the keys as I type.  or the output atleast.  not that my typing/spelling is stellar mechanically, but it's easier at least
[00:38] <ali1234> i have to do that on any keyboard
[00:38] <ali1234> i never learned to touch type
[00:39] <shauno> I'm not sure I did either. someone once commented that my typing had excelled 'hunt and peck' to 'search and destroy'.  I like this comparison
[00:39] <ali1234> lol yes
[00:40] <ali1234> i find tablet has better functionality for a small screen too
[00:40] <ali1234> i mean a tablet is not a much smaller screen than a netbook, but the browser has really easy zooming and other features to compensate, which a netbook doesn't have
[00:41] <shauno> screen doesn't both me so much.  but we don't have so many carts.  I like being mobile enough to squat in a corner.
[00:45] <shauno> but this leads back to my ubuntu usage being "not the target market".  most my usage is deploying VMs that try to script what I'd like to do in person, but someone decided it's not economical to send me to singapore
[00:47] <ali1234> well i don't like this "target market" stuff
[00:47] <ali1234> the only time you hear about it is when you're not it
[00:48] <shauno> same.  I understand it because somewhere down the line, you need some focus.  but it rarely works out well for me
[00:49] <shauno> to date, the biggest win for me has been a pretty reliable release schedule
[00:50] <shauno> I can't remember if it was woody or sarge, but this is where I've been burnt in the past
[00:50] <ali1234> maybe... but... mobile, easy desktop, and servers is a bit of a weird combination
[00:51] <shauno> servers are weird as hell.  but for non-cloud stuff, being told up-front that we'll be supported for 5 years is all we want
[00:52] <shauno> as long as I know the next release is roughly two years, and the current release is supported +2, it's golden
[00:55] <shauno> cloud is a whole different world, but the bearded market is quite happy if they have a good idea of when EOL is years before they hit it
[01:44] <ball> I just logged into ftp.ubuntu.com in search of iso images
[01:44] <ball> It occurs to me that I have no idea what the latest release is called.
[01:44] <ball> I'm used to version numbers :-)
[01:49] <stgraber> ball: ftp.ubuntu.com is the wrong place anyway. You want releases.ubuntu.com or cdimage.ubuntu.com (or really, just go on the website to download it)
[01:50]  * ball nods
[01:50] <ball> I've given up and gone to the Website.
[01:54] <ball> There we go.  I found some 12.10 .torrent files.
[01:56]  * sebsebseb remembers ball kind of
[01:57] <sebsebseb> uh cold night :(
[02:13] <ball> Remind me not to press that button...
[09:00] <diplo> Morning all
[09:08] <diplo> Anyone using owncloud in here ?
[09:13] <popey> marxjohnson is
[09:15] <diplo> Been debating moving my calendar/contacts over, not worried about the backup side but it's a nice plus
[09:15] <diplo> Will see if he pops up from your highlight, cheers :)
[09:16] <AlanBell> I installed it, but it got upset with me about file syncing
[09:17] <diplo> I tried it many many moons ago, before the had the commercial side
[09:17] <diplo> Thinking i ought to make more use of my VPS
[09:17] <diplo> https://github.com/tooxie/shiva-server - trying this as well
[09:23]  * redtape-renegade realises Gubuntu will run Epiphany as a Web browser, but it won't do Weppy,,
[09:24] <mungbean> i use owncloud diplo
[09:25] <mungbean> takes 10 mins to install
[09:25] <mungbean> already saved my butt when my colleague kicked my pc over and the disk died
[09:26] <diplo> mungbean: What do you use it for, just the syncing or for calendar/contacts?
[09:26] <redtape-renegade> http://en.wikipedia.org/w/index.php?title=WebP&diff=543477520&oldid=543263133 ^back#6
[09:27] <redtape-renegade> Errata ^back#5
[09:27] <mungbean> diplo: syncing only
[09:27] <mungbean> but the other features are easy
[09:27] <mungbean> they are webdav i think
[09:27] <diplo> I've been debating it for months, and to start doing my own email again
[09:28] <diplo> So I guess this is the time
[09:28] <mungbean> own email = zimbra
[09:28] <diplo> Bit heavy for a vps ?
[09:28] <diplo> Looked at that a long time ago as well
[09:28] <mungbean> no, a colleague of mine is doing it ok
[09:29] <diplo> OK, will take a look at that as well
[09:29] <mungbean> you can turn off certain services you dont need
[09:29] <mungbean> and has calendaring contacts etc for you
[09:29] <JamesTait> Happy Pi Day, everyone! (And happy birthday to Albert Einstein, if he were still around)
[09:29] <mungbean> my zimbra server had 100% uptime last few years
[09:29] <diplo> I want to integrate calendar/contacts into my phone is basically the main feature i want, I use my phone for everything like that ( forgetful! )
[09:29] <mungbean> pi day you say? would be good if my baby comes today
[09:30] <mungbean> diplo: zimbra paid edition has activesync which improves the integration further
[09:30] <mungbean> but yuo'd prob need a provider for that
[09:31] <mungbean> i have the paid one
[09:31] <mungbean> i should sell mailboxes :P
[09:32] <JamesTait> mungbean, it only works in US notation, unfortunately, but it's still a good date for a birthday. :)
[09:32] <mungbean> yeah, although 13/3/13 was a good day
[09:32] <diplo> mungbean: Expensive? Not to worried for paying for something if it works well
[09:34] <mungbean> diplo: pricey for individual licence from zimbra, since generally its for an etnerprise setup, hence the availiabilty of zimbra providers
[09:34] <mungbean> i mean that licence packs are in multiples of 25
[09:35] <directhex> owncloud doesn't scale.
[09:35] <kvarley-uni> Is it possible to read "Mac OS Extended (Case-Sensitive, Journaled)" filesystems in Ubuntu?
[09:35] <directhex> kvarley-uni, hfsplus? yes
[09:36] <kvarley-uni> directhex: Foolishly I bought a new external hard drive and formatted it to EXT4, then got to uni and realised that I can't use it
[09:36] <directhex> kvarley-uni, coulda told you that
[09:36] <kvarley-uni> hehe
[09:36] <kvarley-uni> I'm too used to having access to linux systems :)
[09:36] <directhex> in fact, didn't you ask which FS to use and you were told fat32?
[09:36] <directhex> someone did
[09:37] <directhex> #ubuntu-uk.10.log:10-03-2013 10:19:28 > directhex: kvarley, fat32, unless you need files >4GB
[09:37] <kvarley-uni> Yes, but I need > 4GB files
[09:37] <kvarley-uni> The drive is going to hold a HD video project
[09:37] <aquarius> ntfs for you, then :)
[09:38] <directhex> can you write ntfs from a mac?
[09:38] <kvarley-uni> No option for NTFS on these macs
[09:38] <directhex> trying to think which fs has write support on mac, windows, linux, and >4G files
[09:38] <directhex> UDF, assuming modern windows?
[09:38] <kvarley-uni> No option
[09:38] <kvarley-uni> FAT, ExFAT, or Mac OS Extended - that's all the options I have
[09:38] <jacobw> Hmm, Windows does UDF?
[09:38] <Laney> Apologies, your Amazon parcel 5333930057 has been delayed in the DPD network and is rescheduled for delivery 15 March.
[09:38] <Laney> even in disappointment DPD win
[09:39] <kvarley-uni> Laney: They're pretty good. :)
[09:39] <directhex> no option? mkudffs!
[09:40] <kvarley-uni> These macs are network booted from what I can tell, nothing is installed that should be for FS management
[09:40] <kvarley-uni> I've done it as Mac OS Extended, seems to work
[09:41] <kvarley-uni> Not the end of the world if it's mac only
[09:43] <popey> so format it on another machine which does ?
[09:43] <kvarley-uni> popey: I'm at uni, have a choice of Mac or PC - both of which are network booted and locked down / missing stuff
[09:43] <popey> sucks to be you ☺
[09:43] <kvarley-uni> Hey, if I had anything to do with it they'd all be running Linux ;)
[09:44] <popey> so format as whatever the mac loves, take stuff home, copy off, reformat, copy back on
[09:44] <kvarley-uni> Yup :)
[09:46] <kvarley-uni> Anyway, off to a lecture. Thanks for the help directhex aquarius popey
[09:48] <brobostigon> good morning everyone,
[09:48] <DJones> Morning all
[09:48] <brobostigon> morning DJones
[10:11] <redtape-renegade> AlanBell, Good luck at 8pm http://is.gd/G6RdVp #sdkmaintainers #days
[10:15]  * popey blinks
[10:17]  * AlanBell has nothing to do with that
[10:21]  * nperry hints it says popey :P
[10:24] <diplo> AlanBell: Hows the new member of staff getting on ?
[10:34] <SuperMatt> has anyone bought a licence for sublime2?
[10:38] <popey> I'm sure some people have
[10:39] <directhex> http://i.cr3ation.co.uk/dl/s1/gif/sublime.gif
[10:39] <directhex> oh, sublime 2.
[10:40] <directhex> http://i.cr3ation.co.uk/dl/s1/gif/sublime.gif http://i.cr3ation.co.uk/dl/s1/gif/sublime.gif
[10:41] <SuperMatt> is it worth it?
[10:42] <SuperMatt> directhex: funny you pick that site, cr3 is a friend of mine
[10:42] <popey> i thought you could test it for free?
[10:42] <popey> I certainly have it installed here
[10:42] <SuperMatt> You can
[10:43] <SuperMatt> I don't really know what I'm getting at here
[10:43] <SuperMatt> I just wonder if people feel that it really is a good editor or not
[10:44] <diplo> It seems good, sftp support is the bit I don't like so don't use it
[10:44] <diplo> Geany/Komodo Edit/Vi for me still
[10:45] <diplo> Notepad++ on windows a lot of the time
[10:46] <DJones> SuperMatt: Did you see the article on The register a day or so back about sublime
[10:46] <SuperMatt> I saw it, but I didn't read it
[10:47] <DJones> SuperMatt: http://www.theregister.co.uk/2013/03/11/verity_stob_text_editor/ It was comparing it with another text editor (on windows) but might be worth a read
[11:03] <davmor2> Morning all
[11:52] <hoover> hi folks
[12:10] <davmor2> morning hoover
[12:24] <nigelb> Hey davmor2
[12:27] <davmor2> nigelb: hey dude
[12:29] <davmor2> nigelb: how's life?
[12:31] <nigelb> Pretty good. How's yours?
[14:16] <Myrtti> awwww. Offbeat Home & Life has a cute article on taking chickens to a vet
[14:18] <AlanBell> chickens \o/
[14:27] <czajkowski> oh dear
[14:48] <davmor2> czajkowski: you can oh dear all you want you are a chicken carer now too :P
[14:50] <czajkowski> davmor2: http://exastack.com/webcam/
[14:50] <czajkowski> because one cam wasn't enough to make sure they were ok during the day
[15:05] <dwatkins> haha "So when we use the output of one yes command as the argument for another, the outer yes command fills up the computer’s memory with the output of the inner yes command. Then I have to restart my computer and feel stupid."
[15:07] <davmor2> czajkowski: muhahaha
[15:07] <davmor2> czajkowski: sadly I can see you having a tab open to it all day too :P
[15:07] <czajkowski> narp
[15:07] <czajkowski> need my machine to behave for you know that toher work I do :)
[15:09] <Myrtti> http://www.eenet.ee/EENet/saunja.html
[15:09] <Laney> bwaaaaaaaaak
[15:19] <Laney> there should be a button to make a loud noise so that that eagle does something
[15:19] <aquarius> the owncloud rss reader: I can't find any details about it or how to run it without running all of owncloud. Am I looking in the wrong place?
[15:19] <aquarius> marxjohn1on, ^ :)
[15:21] <Myrtti> my options seem to be either Feedly, if I want absolutely no fuss, Newsblur if my shellprovider installs it for all customers on their server, or TinyTinyRSS on the home server, if I really want to install and tweak.
[15:23] <popey> the old reader?
[15:23] <Myrtti> does it have an API to use it with other apps on other devices?
[15:24] <Myrtti> as they seem to not yet have a client app of their own
[15:37] <marxjohn1on> aquarius: it's an owncloud "app" i.e. runs on top of owncloud
[15:37] <marxjohn1on> so I dont think you can
[15:37] <directhex> owncloud is a big wobbly unstable php framework for stuff to time out on
[15:37] <aquarius> marxjohn1on, oh, it only runs on that one platform? ok, nm then, I shall continue looking.
[15:38]  * directhex might be bitter
[15:38] <directhex> if you make a stable version release that is impossible to install, you fail at computer
[15:38] <marxjohn1on> aquarius: whcre that one platform is any PHP webserver, yes
[15:39] <marxjohn1on> directhex:
[15:39] <aquarius> marxjohn1on, ah, that's not quite what I meant. I have a php webserver, but all I want is to try out an rss reader. I don't want or care about the rest of owncloud. :)
[15:40] <marxjohn1on> right you are
[15:41] <marxjohn1on> directhex, sync client is very dodgy but I find the rest stable enough for daily use
[15:42] <directhex> marxjohn1on, for what i was evaluating, sync was the important part
[15:42] <directhex> and now i don't trust it enough to use other pieces like calendar
[15:49] <Myrtti> aquarius: http://tt-rss.org/redmine/projects/tt-rss/wiki
[15:50] <aquarius> Myrtti, ttrss specifically says to not run it on shared hosting, which is what I've got.
[15:50] <Myrtti> aquarius: "might work"
[15:51] <aquarius> my days of fighting with stuff where the app's *creator* says "hey, this might work and might not" (and will doubtless say "we warned you" if I have questions) are long past.
[15:51] <Myrtti> newsblur seems to use Django, Mongo and Postgres
[16:20]  * redtape-renegade facepalms 
[16:20] <redtape-renegade> If only PG Tips wouldn't want me to use two teabags !
[16:27]  * dwatkins hands redtape-renegade a monkey to make tea
[16:27] <redtape-renegade> dwatkins, Is that a Sea Monkey ?
[16:28] <dwatkins> haha no
[16:28] <dwatkins> that makes your web pages for you
[16:48] <dogmatic69> installing an app and this happened http://i.imgur.com/O55VhHW.png
[16:56] <davmor2> dogmatic69: file a bug please, that shouldn't happen :)
[16:59] <redtape-renegade> Sorry for that dwatkins | Just listening to Back to the Sea off Christmas '11 playlist (??) :: http://open.spotify.com/track/34LYvEzYNeuDOhKnKBO8dl
[17:00] <dogmatic69> davmor2: about 30 min ago everything crashed so the display thing restarted. probably that.
[17:00] <dogmatic69> I think a restart and it would be normal again
[17:05] <neuro> pfsense woo
[17:39] <Myrtti> ooh
[17:39] <Myrtti> http://inhabitat.com/the-spamcam-is-a-clever-pinhole-camera-made-from-a-can-of-spam/
[17:55]  * neuro makes more pfsense woo noises
[17:55] <neuro> ipv6 ftw
[17:57] <davmor2> neuro: you still like your firewalls then :)
[17:57] <neuro> seems so
[17:57] <neuro> pfsense 2.1 running on a vmware esxi box
[17:58] <neuro> connected directly to 2x openreach fttc modems
[17:58] <neuro> (so in theory I can bin my sky and bt routers)
[17:58] <neuro> policy based routing lets me punt specific machines over specific gateways
[17:58] <neuro> ipv6 tunnel activated from he.net
[17:58] <neuro> qos to make sure my xbox traffic gets higher priority than p2p
[17:59] <neuro> i can't imagine a certain non-rough distro letting me do all that
[18:01] <neuro> being able ro run it on a vm as well though, that's the nicest bit of win
[18:02] <neuro> hardware-- :)
[18:08] <neuro> davmor2: in saying all that, i haven't actually poked at the innards of a firewall distro in many years
[18:41] <redtape-renegade> Where is a good place to buy a slot cover for a Pci-eXPRESS (soz for caps) for a desktop ?? They're all the same for HTPC's aren't they [??]
[18:47] <MartijnVdS> redtape-renegade: you mean low-profile PCI-e?
[18:48] <redtape-renegade> MartijnVdS, I'll PM you.. as I don't to goose this one..
[18:48] <MartijnVdS> redtape-renegade: google a picture of it, post a link here :)
[18:57]  * redtape-renegade looses MartijnVdS somewhere near i.imgur.com .. redtape-renegade should've used flickr instead  ^_^ :(
[19:00] <redtape-renegade> All I can hear from the search Party is "It's down there , somewhere !!" .. poor MartijnVdS . All they have is lights off their CigLite's.
[19:12] <MartijnVdS> Woo, Day of Defeat (+ DoD: Source) available for Steam-for-Linux
[19:12] <redtape-renegade> Someone's seen him .. http://3rdwiki.tumblr.com/private/45337715734/tumblr_mjjvidfc
[19:13] <redtape-renegade> ACTION: call off search party [phew].
[19:29] <redtape-renegade> What about 'Darkest Hour' .. is that available on | Oh what-da-ya-know :: http://store.steampowered.com/app/1280/  .. Any Zombie's tottling piano's on that one ?
[19:30] <redtape-renegade> Ghehe 'cos I can't get enough of that  _[!!]_
[20:58] <redtape-renegade> http://podcast.ubuntu-uk.org.uk .. is that the address ??
[20:58] <popey> !podcast
[20:59] <redtape-renegade> popey, Great, are they talking about the winblows new browser this week ?
[21:01] <popey> "they"?
[21:01] <directhex> the illuminati
[21:02] <directhex> majestic 12 are reviewing office 365
[21:02] <mgdm> 'winblows'
[21:02] <mgdm> there's a word I've not seen in ages
[21:03] <directhex> mgdm, dont forget micro$haft!
[21:03] <mgdm> blimey, it's like 2001 again!
[21:04] <redtape-renegade> mgdm, dont forget w$ndows !
[21:04] <directhex> i see "vista 8" a lot in certain corners of the idiotsphere
[21:05] <directhex> the parts that struggle to do up their own trousers
[21:05] <mgdm> About those colourful metaphors... I don't think you should use them any more. For one thing, you've not quite got the knack of it.
[21:06] <directhex> i'm fabulous at it
[21:06] <directhex> years of practice
[21:06] <directhex> now, on to more important issues. time for more far cry 3!
[21:06] <mgdm> I heard you're going for the postgraduate degree? :)
[21:07] <directhex> i have a degree of jerkology and jerkonomy
[21:38] <AlanBell> ooh an Ology \o/
[21:41] <daubers> Hmm... installing owncloud is remarkably easy
[21:49] <bittin> awesome with weekly podcast :)
[22:07] <redtape-renegade> Maego .. What a freudian slip up .. http://identi.ca/main/poll/d21c2bc5-4fd3-4c61-a547-2b5a8a922448
[22:12] <Myrtti> where is that?
[22:13] <popey> redtape-renegade: ??
[22:13] <Myrtti> seems quite random
[22:14] <popey> always is
[22:16] <bittin> facebook changed back my name to my real name after i scanned my ID card :p
[22:45] <bigcalm> I have a database table with meter readings taken every 5 mins. That's 288 records per day. I have 3 months worth of the data. How would I construct a SQL query to get the last meter reading per day?
[22:47] <AlanBell> as in the 23:55 reading of every day?
[22:47] <bigcalm> Yep
[22:47] <bigcalm> But it might not be at 23:55
[22:47] <bigcalm> It might be at 23:59
[22:48] <AlanBell> yup, just checking I understood "last"
[22:48] <bigcalm> Ok :)
[22:49] <bigcalm> I could add an extra clause that tested the formatted date is between 23:55 and 23:59
[22:49] <bigcalm> Thanks AlanBell :)
[22:50] <bigcalm> Now I need to work out how to write that as DQL
[22:50] <AlanBell> that would be a rough and ready way to do it :)
[22:50] <bigcalm> AlanBell: I'm open to better ideas :D
[22:51]  * AlanBell looks for a table with timestamps in it
[22:52] <bigcalm> Happy to send you a dump :)
[22:52] <bigcalm> MySQL
[22:52] <AlanBell> found one
[22:53] <AlanBell> select max(createdtime) from vtiger_crmentity group by date(createdtime)
[22:53] <AlanBell> that appears to work
[22:53] <bigcalm> Aha, yes, grouping by date
[22:54] <bigcalm> Though the datetime would need to be formatted to lack hh:mm
[22:54] <mgdm> You can do a date format thing to make it Y-m-d
[22:54] <AlanBell> this uses actual dates
[22:55] <AlanBell> select max(readingtime) from meterreadings group by date(readingtime)
[22:55] <AlanBell> then join it back to itself to read the rest of the fields
[22:55] <bigcalm> Humm
[22:59] <AlanBell> might want to create an index on that timestamp field
[23:03] <AlanBell> select * from readings inner join
[23:03] <AlanBell> (select max(readingtime) as timestamp from readings group by date(readingtime) ) readings2
[23:03] <AlanBell> on readingtime=readings2.timestamp
[23:03] <AlanBell> that should work
[23:04] <AlanBell> and create an index on the readingtiem column