Back to Home / #mythtv / 2007 / 02 / Prev Day | Next Day
#mythtv IRC Logs for 2007-02-18

---Logopened Sun Feb 18 00:00:25 2007
00:03|-|cattelan [n=cattelan@c-24-118-241-119.hsd1.mn.comcast.net] has quit ["This computer has gone to sleep"]
00:16|-|czth_ [i=dbrobins@nat/microsoft/x-215e5314f417be74] has joined #mythtv
00:25|-|t0ny-p40 [n=tony@67.60.43.42] has joined #mythtv
00:25|-|Agrajag-_ [n=filip@c211-30-185-177.artrmn2.nsw.optusnet.com.au] has joined #mythtv
00:27<xris>monkeyBox: "asking for experts" != "talking about mythtv code"
00:28|-|xri1 [n=xris@xris.forevermore.net] has joined #mythtv
00:28|-|xri1 [n=xris@xris.forevermore.net] has left #mythtv []
00:28<briand>g'evening, xris
00:28<xris>evening
00:29<monkeyBox>xris, I know, but this is a "last resort" for me
00:29<briand>well, I *think* i've added the artist sort to mythmusic... need to modify the edit metadata screen to allow changing it, then i'll submit it
00:29<briand>monkeyBox: this is not a resort. it is a workplace.
00:29<xris>monkeyBox: doesn't make this the right place to ask, esp. when you prefix it with the fact that you KNOW it's not the right place to ask
00:31<xris>briand: cool
00:31<xris>I'm still mucking with channel icon search/lookup via the web
00:31<monkeyBox>where else do you suggest I go for help? Every discussion I've seen on this issue ends up at a dead end. I'm just asking if you've heard anything about it, or if you know whether it's been resolved. I'm not asking for you to hold my hand through fixing it.
00:31<briand>even easier than i thought, actually!
00:31<briand>monkeyBox: #mythtv-users
00:32<xris>monkeyBox: #mythtv-users, mythtv-users mailing list, or one of the unofficial forums.
00:32<briand>xris: i even figured out the 'protocol' for updating dbcheck.cpp for the db changes
00:32<xris>cool
00:32[~]xris is jealous that Captain_Murdoch gets to go to brazil for free
00:33|-|monkeyBox [n=bdavis@cpe-76-185-4-217.tx.res.rr.com] has left #mythtv ["Leaving"]
00:33<briand>i'm just now installing phpMyAdmin so i can change around some sort keys and see if my changes actually work... :)
00:33|-|czth__ [i=dbrobins@nat/microsoft/x-cb8dc5fbb30c5a15] has quit [Connection timed out]
00:35<xris>heh
00:35<xris>I don't think I've spent more than 30 secs total in phpmyadmin
00:35<briand>heh
00:35<briand>well, i figured that'd be a bit easier than typing out tons of selects and updates at the mysql prompt.
00:35<briand>;)
00:35<xris>yeah
00:36<xris>definitely a time-saver
00:40<t0ny-p40>What table is the recording profiles saved in?
00:40<xris>t0ny-p40: record, among others
00:41<briand>there's also one called "recordingprofiles"
00:41<t0ny-p40>ahh I missed that one some how :)
00:41<xris>briand: you're more correct. I was thinking schedules.
00:42<briand>that makes twice in one day. :)
00:43<t0ny-p40>is it safe to delete a profilegroup I made from there?
00:49|-|Agrajag-_ [n=filip@c211-30-185-177.artrmn2.nsw.optusnet.com.au] has quit [Read error: 110 (Connection timed out)]
00:50<Captain_Murdoch>anything is safe as long as you have a backup. :) should be ok as long as you know what you're doing. I think you also want to get rid of the corresponding entries from the codecparams table.
00:57<Captain_Murdoch>cool.... I just disconnected from a running LiveTV session, fixed a bug, recompiled mythfrontend, fired mythfrontend back up and reattached to the LiveTV session resuming at the exact point I left off watching.
00:58<xris>heh
01:11|-|gnome42 [n=obi@dsl-155-91.aei.ca] has quit [Remote closed the connection]
01:26|-|czth__ [i=dbrobins@nat/microsoft/x-32be04c6f199b865] has joined #mythtv
01:43|-|czth_ [i=dbrobins@nat/microsoft/x-215e5314f417be74] has quit [Read error: 110 (Connection timed out)]
02:05|-|adante_ [n=adante@203-206-2-201.dyn.iinet.net.au] has joined #mythtv
02:20|-|adante [n=adante@203-206-2-201.dyn.iinet.net.au] has quit [Read error: 110 (Connection timed out)]
02:20|-|adante_ changed nick to adante
02:32|-|jtmoney [n=jtmoney@ip72-196-124-106.ga.at.cox.net] has joined #mythtv
02:54|-|notregistered [i=overload@tinfoilhat.net] has joined #mythtv
03:14|-|purserj [n=purserj@k-sit.com] has quit [Read error: 104 (Connection reset by peer)]
03:14|-|purserj [n=purserj@k-sit.com] has joined #mythtv
03:15|-|blackest [n=john@cpc4-linc4-0-0-cust684.nott.cable.ntl.com] has joined #mythtv
03:16|-|jtmoney [n=jtmoney@ip72-196-124-106.ga.at.cox.net] has quit [Remote closed the connection]
03:18|-|blackest [n=john@cpc4-linc4-0-0-cust684.nott.cable.ntl.com] has left #mythtv []
04:03|-|Agrajag-_ [n=filip@c211-30-185-177.artrmn2.nsw.optusnet.com.au] has joined #mythtv
04:11|-|eskil [n=eskil@adsl-66-120-85-205.dsl.snfc21.pacbell.net] has quit ["Leaving"]
04:15|-|t0ny-p40 [n=tony@67.60.43.42] has quit ["Leaving"]
04:16|-|stuarta [n=stuarta@unaffiliated/stuarta] has joined #mythtv
04:18|-|benlake [n=benlake@cpe-76-184-92-90.tx.res.rr.com] has joined #mythtv
04:19|-|benlake [n=benlake@cpe-76-184-92-90.tx.res.rr.com] has left #mythtv []
04:29|-|stoffel [n=sfr@p57B4EDB1.dip.t-dialin.net] has joined #mythtv
04:29|-|xris [n=xris@xris.forevermore.net] has quit ["Leaving."]
04:54|-|notregistered [i=overload@tinfoilhat.net] has quit ["Leaving"]
05:14|-|S2 [n=s2@host246-230-dynamic.5-87-r.retail.telecomitalia.it] has joined #mythtv
05:58|-|Agrajag-_ [n=filip@c211-30-185-177.artrmn2.nsw.optusnet.com.au] has quit [Read error: 110 (Connection timed out)]
06:06|-|hads [n=hads@reef80.anchor.net.au] has quit [Read error: 145 (Connection timed out)]
06:30|-|hads [n=hads@reef80.anchor.net.au] has joined #mythtv
06:34|-|aevil [n=aevil@i59F56875.versanet.de] has joined #mythtv
07:00|-|noddan [n=noddan@noddan-birger.brj.sgsnet.se] has quit []
07:06|-|noddan [n=noddan@noddan-birger.brj.sgsnet.se] has joined #mythtv
07:10|-|levon [n=levon@85.182.160.122] has joined #mythtv
07:12|-|S2 [n=s2@host246-230-dynamic.5-87-r.retail.telecomitalia.it] has quit [Remote closed the connection]
07:33|-|Schlumpf [n=schumpf@dslb-084-057-130-066.pools.arcor-ip.net] has joined #mythtv
08:32|-|r10 [n=r10@gw.obelnet.dk] has joined #mythtv
08:43|-|madfactor [i=madfacto@74-138-57-179.dhcp.insightbb.com] has quit []
08:51|-|ivor [n=ivor@kde/developer/ivor] has quit [Read error: 110 (Connection timed out)]
08:55|-|Schlumpf [n=schumpf@dslb-084-057-130-066.pools.arcor-ip.net] has quit [Remote closed the connection]
09:04|-|aevil^aw [n=aevil@i59F54113.versanet.de] has joined #mythtv
09:11|-|Agrajag-_ [n=filip@c211-30-185-177.artrmn2.nsw.optusnet.com.au] has joined #mythtv
09:12|-|aevil [n=aevil@i59F56875.versanet.de] has quit [Read error: 110 (Connection timed out)]
09:17|-|jduggan [n=jduggan@89-145-233-57.xdsl.murphx.net] has joined #mythtv
09:19|-|E-bola [i=bola@rbii-valhalla.mrseb.co.uk] has joined #mythtv
09:22|-|E-bola [i=bola@rbii-valhalla.mrseb.co.uk] has left #mythtv []
10:14|-|JoeyBorn [n=rootmeis@adsl-75-2-244-255.dsl.chcgil.sbcglobal.net] has quit ["Leaving"]
10:16<GreyFoxx>~
10:20|-|JoeBorn [n=rootmeis@adsl-75-2-244-255.dsl.chcgil.sbcglobal.net] has joined #mythtv
10:27|-|Agrajag-_ [n=filip@c211-30-185-177.artrmn2.nsw.optusnet.com.au] has quit [Connection timed out]
10:38|-|r3z [n=r3z@unaffiliated/r3z] has joined #mythtv
10:45|-|cattelan [n=cattelan@c-24-118-241-119.hsd1.mn.comcast.net] has joined #mythtv
10:46|-|r3z` [n=r3z@unaffiliated/r3z] has quit [Read error: 145 (Connection timed out)]
10:55|-|madfactor [i=madfacto@74-138-57-179.dhcp.insightbb.com] has joined #mythtv
11:08|-|asdfr [n=sjr@spc2-fare3-0-0-cust93.cosh.broadband.ntl.com] has joined #mythtv
11:10|-|asdfr [n=sjr@spc2-fare3-0-0-cust93.cosh.broadband.ntl.com] has left #mythtv ["Leaving"]
11:17|-|aevil^aw [n=aevil@i59F54113.versanet.de] has quit [Read error: 110 (Connection timed out)]
11:24|-|gnome42 [n=obi@dsl-155-91.aei.ca] has joined #mythtv
11:54|-|cattelan [n=cattelan@c-24-118-241-119.hsd1.mn.comcast.net] has quit [Read error: 110 (Connection timed out)]
12:11|-|mike__ [n=mike@c-69-247-30-249.hsd1.tn.comcast.net] has joined #mythtv
12:11|-|mike__ [n=mike@c-69-247-30-249.hsd1.tn.comcast.net] has quit [Client Quit]
12:22|-|r10 [n=r10@gw.obelnet.dk] has quit [Remote closed the connection]
12:43|-|cattelan [n=cattelan@c-24-118-241-119.hsd1.mn.comcast.net] has joined #mythtv
12:51|-|offset [n=off@ool-44c00371.dyn.optonline.net] has quit ["Leaving"]
12:58|-|stuarta [n=stuarta@unaffiliated/stuarta] has quit ["i'm off to see the wizard"]
13:06|-|Agrajag-_ [n=filip@c211-30-185-177.artrmn2.nsw.optusnet.com.au] has joined #mythtv
13:44|-|clars [n=clars@81.161.167.16] has joined #mythtv
13:45|-|clars [n=clars@81.161.167.16] has left #mythtv ["På gensyn"]
14:08|-|cattelan [n=cattelan@c-24-118-241-119.hsd1.mn.comcast.net] has quit ["This computer has gone to sleep"]
14:11|-|Agrajag-_ [n=filip@c211-30-185-177.artrmn2.nsw.optusnet.com.au] has quit [Read error: 110 (Connection timed out)]
14:13|-|xris [n=xris@xris.forevermore.net] has joined #mythtv
14:13<briand>afternoon, xris... how goes it?
14:14<xris>not sure. just woke up
14:14<briand>ah. :) almost thinking about lunch, right about now.
14:26<briand>argh! I'm *this* > < close...
14:27<briand>i guess i shouldn't complain. I was _this_ > < close, earlier today.
14:31<janneg>does anyone know why the recordedseek table schema is the way it is?
14:33<janneg>using a int for a variable which can have two different values does matter for 12,366,305 entries
14:34<xris>janneg: as opposed to tinyint?
14:34<janneg>varchar for the offset takes also more space for position greater then 10MB
14:34<janneg>xris: yes
14:35<xris>which field are you talking about, btw?
14:35<janneg>type
14:35<xris>yeah, weird
14:35<xris>unsigned tinyint would be much better
14:35<xris>it's not like we have more than 256 types
14:36<xris>same in recordedmarup
14:36<xris>offset should be int, too.
14:36<xris>using varchar slows down mysql
14:37<janneg>bigint since we have files greater 4gb
14:37<xris>well, yes.
14:37<xris>I just meant int vs string
14:37<xris>or rather "fixed length" vs "variable length"
14:38<xris>ALTER TABLE recordedseek MODIFY type TINYINT UNSIGNED NOT NULL DEFAULT 0;
14:38<janneg>type is signed. and we have less than 20 values
14:38<xris>we have negative types?
14:39<janneg>yes, see programinfo.h
14:40<xris>ah. good enough. just woke up, brain's not working right.
14:40<xris>so signed it is.
14:41<xris>conversion seems to work fine. testing now
14:43<xris>yup, works fine for me.
14:43<xris>that should really speed up deletes, etc.
14:43<xris>and I know that those were some of the slow queries.
14:43<janneg>updating the offset is unfortunately not so easy
14:44<xris>why?
14:44<xris>ALTER TABLE recordedmarkup MODIFY type TINYINT NOT NULL DEFAULT 0;
14:44<xris>ALTER TABLE recordedmarkup MODIFY offset BIGINT UNSIGNED;
14:44<janneg>you have to convert the string
14:44<xris>(and recordedseek)
14:44<xris>no, you don't
14:45<janneg>I didn't know that that's supposed to work
14:45<xris>mysql has basic string-to-int conversion
14:46<xris>I'll leave it like this for awhile if you want, but I concur that there's no need for the larger fields.
14:46|-|cattelan [n=cattelan@c-24-118-241-119.hsd1.mn.comcast.net] has joined #mythtv
14:47<xris>is "mark" something that we could change to another type, too? my largest value is 226530
14:47<xris>seems like unsigned smallint or mediumint would suffice
14:47<janneg>for recordedseek it's the frame number
14:47<xris>er, mediumint
14:48<xris>how does that differ from offset? (which it does)
14:48<janneg>offset is the byte offset of the file
14:51<xris>ah, gotcha
14:51<xris>should at least make it unsigned, then
14:53<xris>although I'm going to guess that an unsigned mediumint would be enough for just about anything
14:53<janneg>mediumint is 3 bytes?
14:53<xris>y
14:54<xris>that leaves a max of over 77 hours at 60fps
14:54<janneg>77 hours at 60 fps
14:54<janneg>lol
14:55<xris>yeah. it's a signed bigint now.
14:55<xris>ick
14:55<xris>ALTER TABLE recordedmarkup MODIFY MARK MEDIUMINT UNSIGNED NOT NULL DEFAULT 0;
14:55<xris>oops, typo
14:57<xris>wonder how much that changes the size on disk.
14:57<xris>I forgot to measure. heh
14:57|-|S2 [n=s2@host246-230-dynamic.5-87-r.retail.telecomitalia.it] has joined #mythtv
14:59<janneg>8 byte * no. entries for type and mark + maybe 1.5-2 byte for offset
14:59<xris>ok, found my backup. recordedseek went from 13M + 9.1M to 6M + 7.1M
15:00<xris>(myd + myi)
15:00<xris>markup was in k, but went from 35+38 to 19+22
15:01<xris>so that's pretty significant. should speed up searches/deletes/etc significantly.
15:01|-|purserj [n=purserj@k-sit.com] has quit [Read error: 104 (Connection reset by peer)]
15:05<xris>ok, I think it's definitely time that I hooked user-job support into mythweb. I keep finding programs that think they've been commflagged, but don't show any marks.
15:17|-|r10 [n=r10@gw.obelnet.dk] has joined #mythtv
15:25|-|levon [n=levon@85.182.160.122] has quit ["Leaving"]
15:29|-|rtsai1111 [n=rtsai@208-201-231-158.dsl.dynamic.sonic.net] has quit [Read error: 60 (Operation timed out)]
15:32|-|rtsai [n=rtsai@208-201-231-158.dsl.dynamic.sonic.net] has joined #mythtv
15:50|-|quants [i=applesee@any1can.net] has joined #mythtv
15:57<quants>just a thought, anyone ever considered a software tuner for mythtv to make our own broadcasts?
15:59<quants>guess I'm not gonna hang around to get an answer
16:00<quants>have fun, and thanks
16:00|-|quants [i=applesee@any1can.net] has left #mythtv []
16:03|-|Agrajag-_ [n=filip@c211-30-185-177.artrmn2.nsw.optusnet.com.au] has joined #mythtv
16:03|-|r10 [n=r10@gw.obelnet.dk] has quit [Remote closed the connection]
16:13|-|jmk_ [n=jmk@vrnawihed51-pool4-a235.vrnawi.tds.net] has joined #mythtv
16:15[~]xris wonders what he meant by that
16:17|-|r10 [n=r10@gw.obelnet.dk] has joined #mythtv
16:30|-|jmk [n=jmk@vrnawihed51-pool5-a211.vrnawi.tds.net] has quit [Read error: 110 (Connection timed out)]
16:32|-|S2 [n=s2@host246-230-dynamic.5-87-r.retail.telecomitalia.it] has quit [Remote closed the connection]
16:38|-|stoffel [n=sfr@p57B4EDB1.dip.t-dialin.net] has quit ["leaving"]
16:44|-|_gnome42 [n=obi@dsl-145-177.aei.ca] has joined #mythtv
16:44|-|gnome42 [n=obi@dsl-155-91.aei.ca] has quit [Read error: 110 (Connection timed out)]
16:56<janneg>xris: I have the commit ready but can it test in about one hour
16:58<gbee>fwiw I had planned to make those changes when I split recordedmarkup into recordedseek, but I completely forgot
17:09|-|czth__ changed nick to czth
17:25|-|purserj [n=purserj@k-sit.com] has joined #mythtv
17:48|-|r10 [n=r10@gw.obelnet.dk] has quit [Remote closed the connection]
18:03|-|xris [n=xris@xris.forevermore.net] has quit ["Leaving."]
18:07|-|robthebob [n=rn114@82-46-18-118.cable.ubr02.bath.blueyonder.co.uk] has quit [Read error: 104 (Connection reset by peer)]
18:09<janneg>and the schema update runs and runs ...
18:11<janneg>and runs
18:12|-|cattelan_ [n=cattelan@c-24-118-241-119.hsd1.mn.comcast.net] has joined #mythtv
18:12|-|Agrajag-_ [n=filip@c211-30-185-177.artrmn2.nsw.optusnet.com.au] has quit [Read error: 110 (Connection timed out)]
18:13|-|ahbritto [n=ahbritto@adsl-64-161-117-110.dsl.snfc21.pacbell.net] has joined #mythtv
18:19|-|cattelan [n=cattelan@c-24-118-241-119.hsd1.mn.comcast.net] has quit [Read error: 110 (Connection timed out)]
18:25<janneg>and runs
18:30<_gnome42>janneg: That's a long time! My recordedseek is 90M + 60M :) How big is your's?
18:31<briand>aha!! finally got it right.
18:31|-|e7c|home [n=e@S0106001346a3fd15.wp.shawcable.net] has joined #mythtv
18:31|-|e7c|home [n=e@S0106001346a3fd15.wp.shawcable.net] has left #mythtv []
18:31<briand>lemme whip up a diff file and type up a ticket.... then we'll have a 'sort artist' field in mythmusic.
18:31<briand>:)
18:32<janneg>474M + 419M
18:32<janneg>and it still runs
18:32<briand>holy cow.
18:32<briand>no wonder it's taking a while
18:33<janneg>yes, and my db update might be not optimal
18:33<_gnome42>ha, lol
18:33<_gnome42>would it help to drop the indexes first?
18:34<janneg>3 alter table statements == 3 complete table copies
18:34<janneg>probably
18:39<janneg>`2007-02-19 01:05:20.862 Upgrading to schema version 1181
18:39<janneg>2007-02-19 01:38:43.471 New DB connection, total: 4
18:39<janneg>33 minutes
18:39<janneg>244M of 891M saved
18:40<_gnome42>very nice savings!
18:42<janneg>27%. let's see if mysqloptimize can save more space
18:42<briand>gbee: you still around?
18:42<_gnome42>I recently put together a small script to locate non-existant files in the recordedseek table. I was able to shave off 10-15M I think.
18:43<janneg>non-existant how? no matching recorded entry or missing file?
18:44<_gnome42>missing files, ideally there wouldn't be any of course, but over time with my testing they built up :)
18:44<janneg>190M saving for the data file but only 60M for the index
18:44<GreyFoxx>I've seen the same in my livetv history. 39 entries yet there are no files since I don'ty use it except for testing :)
18:47<_gnome42>GreyFoxx: the tvchain table? Yeah, I regularily 'empty' that one as well
18:47<GreyFoxx>yup
18:49<_gnome42>janneg: would it make sense to have 'offset' be last in the table because it is the only field not indexed? more efficient?
18:49|-|Agrajag- [n=filip@c211-30-185-177.artrmn2.nsw.optusnet.com.au] has joined #mythtv
18:59<janneg>_gnome42: I don't know much about mysql internals
18:59<_gnome42>janneg: how much memory do you have in you DB? How did it perform on seeking with that big of a table?
19:00<_gnome42>janneg: yeah, me neither but I thought I might have read somewhere that it made sense to pay attention to the order of the fields.
19:01<janneg>one gigabyte and seeking doesn't depend on the database. the position map is read into memory on playback start
19:01<_gnome42>janneg: since you are doing 3 complete table copies I thought it might be a good time to work that in. Just a thought.
19:01<_gnome42>ah, right
19:02|-|eskil [n=eskil@adsl-66-120-85-205.dsl.snfc21.pacbell.net] has joined #mythtv
19:06|-|ahbritto [n=ahbritto@adsl-64-161-117-110.dsl.snfc21.pacbell.net] has quit [Client Quit]
19:10|-|jams [n=jams@CPE-72-131-6-174.wi.res.rr.com] has quit [Read error: 54 (Connection reset by peer)]
19:11|-|jams [n=jams@CPE-72-131-6-174.wi.res.rr.com] has joined #mythtv
19:12<janneg>I hope mysql does only one table copy if I have all three modify statements in one ALTER TABLE command
19:14|-|russellb [n=russell@12-214-191-64.client.mchsi.com] has joined #mythtv
19:23|-|bzbb [n=john@68-118-186-229.dhcp.nwtn.ct.charter.com] has quit [Read error: 104 (Connection reset by peer)]
19:24|-|bzbb [n=john@68.118.186.229] has joined #mythtv
19:38<_gnome42>janneg: I can't find the reference I was thinking of. Field order is important in indexes and queries but I can't find anything on the field-order-in-table <-> index relationship.
19:38<janneg>recorded normalisation and replacing chanid,starttime with some sort of recordedid is the next optimization
19:39<_gnome42>sounds good
19:39<janneg>_gnome42: I doubt that it matters
19:40<janneg>it should give us 8 bytes per entry
19:40<_gnome42>yeah, I agree
19:42|-|bzbb [n=john@68.118.186.229] has quit ["Leaving"]
19:44|-|PointyPumper1 [i=Pintlezz@OL221-67.fibertel.com.ar] has quit [Read error: 104 (Connection reset by peer)]
19:44|-|PointyPumper [i=Pintlezz@OL221-67.fibertel.com.ar] has joined #mythtv
20:01|-|eskil [n=eskil@adsl-66-120-85-205.dsl.snfc21.pacbell.net] has quit [Read error: 113 (No route to host)]
20:02|-|eskil [n=eskil@adsl-66-120-85-205.dsl.snfc21.pacbell.net] has joined #mythtv
20:18|-|cattelan_ [n=cattelan@c-24-118-241-119.hsd1.mn.comcast.net] has quit ["This computer has gone to sleep"]
20:34|-|John [n=John@d149-67-249-16.nap.wideopenwest.com] has joined #mythtv
20:34|-|cattelan_ [n=cattelan@c-24-118-241-119.hsd1.mn.comcast.net] has joined #mythtv
20:36|-|John [n=John@d149-67-249-16.nap.wideopenwest.com] has left #mythtv []
20:38|-|r3z` [n=r3z@unaffiliated/r3z] has joined #mythtv
20:42|-|russellb [n=russell@asterisk/developer-and-stable-maintainer/drumkilla] has quit []
20:50|-|russellb [n=russell@12-214-191-64.client.mchsi.com] has joined #mythtv
20:50|-|russellb [n=russell@asterisk/developer-and-stable-maintainer/drumkilla] has quit [Remote closed the connection]
20:56|-|r3z [n=r3z@unaffiliated/r3z] has quit [Read error: 110 (Connection timed out)]
21:38|-|xris [n=xris@xris.forevermore.net] has joined #mythtv
21:47<xris>Chutt: given any thought to SoC for this year?
21:52|-|e7c|home [n=e@S0106001346a3fd15.wp.shawcable.net] has joined #mythtv
21:52|-|e7c|home [n=e@S0106001346a3fd15.wp.shawcable.net] has left #mythtv []
22:07|-|JoeyBorn [n=rootmeis@adsl-75-2-244-255.dsl.chcgil.sbcglobal.net] has joined #mythtv
22:12|-|NightMonkey [n=NightMon@pdpc/supporter/sustaining/NightMonkey] has joined #mythtv
22:16|-|JoeBorn [n=rootmeis@adsl-75-2-244-255.dsl.chcgil.sbcglobal.net] has quit [Read error: 60 (Operation timed out)]
22:21|-|xris [n=xris@xris.forevermore.net] has quit ["Leaving."]
22:28|-|NightMonkey [n=NightMon@pdpc/supporter/sustaining/NightMonkey] has quit [Client Quit]
22:33|-|xris [n=xris@xris.forevermore.net] has joined #mythtv
22:38|-|Nem^1 [n=Nem@dslb-084-056-252-218.pools.arcor-ip.net] has joined #mythtv
22:39<xris>janneg: (if still awake), you ever get an answer about the recorded* table edits we talked about earlier?
22:45<xris>anyone around who knows about recordedseek/recordedmarkup to give a third opinion on these changes?
22:54|-|nn [n=joseph@cpe-72-229-104-43.nyc.res.rr.com] has joined #mythtv
22:54<nn>are there any usb2.0 (or if unavoidable, PCI) video in devices that work with myth that have component in? no need for an actual tuner, just component (and maybe composite) in
22:55<briand>nn: topic.
22:55<xris>nn: please read the topic before speaking
22:55|-|Nem^ [n=Nem@dslb-084-056-236-116.pools.arcor-ip.net] has quit [Read error: 110 (Connection timed out)]
22:55|-|Nem^1 changed nick to Nem^
22:56<nn>briand: ahh, shit sorry
22:56[~]xris apologizes for that coming out harsh
23:01|-|nn [n=joseph@cpe-72-229-104-43.nyc.res.rr.com] has left #mythtv []
23:04[~]xris wonders where all of the devs have been this last week.
23:04<briand>I saw Chutt check in here earlier today
23:05<briand>maybe they were at MythDevCon ;)
23:06[~]xris cries because he wasn't invited.
23:06<xris>:)
23:06<xris>yeah, he was here briefly.
23:07<xris>though I know he's been busy since he wasn't even on irc for a few days..
23:08<xris>I had sent him a bunch of info on what it would take to incorporate a "mythtv, inc." 501c3 org, since there had been some ramblings about it here and there.
23:08<briand>incorporate in delaware. :)
23:08<briand>(cheaper there, apparently)
23:09<xris>nonprofits get special treatment everywhere, I think.
23:09<xris>but that's Isaac's decision, and I'm pretty sure he'd want/need to talk to a lawyer first to learn about what kinds of protections (or loss of protections) it would give.
23:09<briand>true... now, my question would be: what specific benefit(s) of being a 501c3 are being sought?
23:09<xris>the fear is that if we incorporated, we'd be a bigger target for lawsuit
23:10<xris>the benefits are... time spent developing might be tax deductible, donations would be tax deductible, and we could keep some money around for things like helping pay for tradeshow exhibits, etc.
23:11<briand>our local amateur radio group is 501c3 -- but we have all sorts of property in inventory, and accept donated equipment from state and local government surplus..
23:12<briand>"myth, inc" would have.. well, an intellectual property, but one that is freely given away -- is that still an asset to protect? :shrug:
23:12<briand>i dunno... i'm not a lawyer.
23:12<xris>yeah. spi-inc.org can manage all of the money stuff for us, but it really comes down to how isaac feels about things. He's against donations, etc., but it'd be nice to be able to sell tshirts, etc to raise a little money for hardware purchases, trade shows, etc.
23:13<xris>and I personally feel kind of bad that he's now personally responsible for taxes on things like the server that was given to mythtv last year, etc.
23:14<briand>ah.. then there *is* some physical inventory involved...
23:14<briand>i had forgotten about the server donation
23:14<briand>plus annual expenses for the domain name, etc
23:15<xris>yup
23:15<xris>stuff he pays out of pocket
23:15<xris>heck, he paid hosting fees out of pocket until we got the new server, too
23:15<briand>not to change the subject -- but you just reminded me....
23:16<briand>I got a 24.68% raise this past Thursday.
23:16<briand>:)
23:16<xris>woot
23:16<xris>I might get a raise this year. not sure I want/deserve one. Would rather get more benefits.
23:16<briand>apparently, I'm "much, much better" than they expected when they hired me 1.10 years ago
23:16<briand>..and they felt 'guilty'
23:17<xris>one of my best friends just got promoted to "senior program manager" for the realplayer project. with a $7k raise.
23:17<briand>this is -really- something, when you consider I'm not working in the private sector. state gov't.
23:17<xris>wow
23:17<briand>exactly. could have knocked me over with a feather.
23:19<briand>7K is a pretty decent raise, too.. at my last private-sector job (> 4 years ago), I got a $12K raise... my boss submitted paperwork for 12K, figuring they always cut it back, and he was targeting 8K. Told me about it, and said not to expect anything for a few months.
23:20<briand>a week later, he took me out to lunch to say the higher-ups had signed the paperwork without altering anything.
23:22<xris>nice
23:22<briand>btw, did u see my trac # 3104?
23:23<xris>I've had raises that big before... won't get them again, though, now that I make a decent amount.
23:23<briand>that -should- install all the framework for the artist sort changes
23:23<xris>if the ticket got assigned to me, I've probably glanced at the email, but haven't done anything in depth in trac lately.
23:23<briand>hasn't been assigned to anyone, yet... still in isaac's inbox.
23:24<briand>I imagine gbee will probably take it
23:25<xris>ah, then I didn't see it. I ignore most tickets if they're not assigned to me... will occasionally read through the list if I'm feeling adventurous, but it's usually to find specific things (like channel icon stuff, which I'm currently working on)
23:26<briand>i've updated the master_iconlist SVN here a couple of times, but haven't started playing with it yet
23:26<xris>it's going to go away completely at some point
23:26<briand>then how will I specify/correct/get my icons?
23:27<xris>services.mythtv.org
23:27<xris>:)
23:28<briand>well, yes... i had read that much... i meant, how will it work? do I manually or automatically submit my list of xmlids and it ships the appropriate icons, or what?
23:30<xris>I'll soon have a cli app to compare your db with the website, but I'm hoping the search stuff will eventually be built into mythtv-setup or the frontend
23:30<xris>I'll add it to mythweb, too
23:32<xris>http://newmyth.forevermore.net/channel-icon/lookup/?callsign=kcpq
23:32<xris>http://newmyth.forevermore.net/channel-icon/search?s=north
23:33<briand>ah.. so we'll have an "Update Channel Icons" button in setup or something, then...
23:34<xris>yeah
23:35<xris>it'll pull down any perfect matches, and then let the user pick/choose for others, and have the option to submit those findings back to the server for later inclusion.
23:37<briand>hmm... or, you could cache the channel lineups and simply offer the "Comcast Analog - Tallahassee" to the second and subsequent users from any given area. could create the necessary tarball on-the-fly and ship it
23:40<briand>...of course, with the way cable companies (comcast, especially) like to change around the channel lineups, it might quickly become a nightmare trying to keep up -- strike that idea. :)
23:41<xris>not exactly a lot of bandwidth in the csv file the web app spits out
23:42<xris>easier to track xmitvid -> lyngsat logo, too
23:44<xris>nowhere bothers to track that info yet, either. I kind of wish lyngsat did things that way. their organizational model sucks.
23:46<briand>ah.. so you'd send the user the csv file, not the icons, and they'd grab the actual icons from lyngsat on their local myth box
23:48<xris>yeah
23:48<xris>what you see at http://newmyth.forevermore.net/channel-icon/lookup/?callsign=kcpq is exactly what the user would see
23:48<xris>the full-channel-lineup search would just be a bigger file (follow the search link above to get an idea of what it would look like)
23:50<briand>yep...
23:51<briand>+-----------+-------------+----------------+
23:51<briand>| artist_id | artist_name | artist_sortkey |
23:51<briand>+-----------+-------------+----------------+
23:51<briand>| 369 | Ringo Starr | Starr, Ringo |
23:51<briand>+-----------+-------------+----------------+
23:51<briand>:)
23:51<xris>?
23:53<briand>mythconverg.music_artists where music_artists.artist_sortkey like 'Starr%'
23:53<briand>eventually, he'll be alphabetized under 'S', not 'R' :)
23:53<briand>...but still display as 'Ringo Starr'
23:54<xris>nice
23:54<xris>user picks that info, or is it automated?
23:54<briand>that's what i put in 3104 ...
23:54<briand>it'll automatically copy the contents of artist_name
23:54<briand>thus, giving them the same exact sort they currently have
23:55<briand>i put an edit box in the editmetadata screen to allow the user to alter it
23:55<briand>i haven't gone into actually changing the sort field, yet...
23:56<briand>there's actually quite a bit of stuff that can get yanked out of there after this goes in
23:57<xris>ah, cool
23:57<briand>i thought about writing some scripts to semi-automate changing my database...
23:57<briand>but then I'd still have to fix up 'Floyd, Pink' and 'Tull, Jethro' ...
23:58<briand>so i thought better of it. :)
23:59<xris>yup
23:59<xris>that was going to be my concern, too
---Logclosed Mon Feb 19 00:00:34 2007