From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from pigeon.gentoo.org ([208.92.234.80] helo=lists.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1PCMLn-00035N-EM for garchives@archives.gentoo.org; Sun, 31 Oct 2010 01:04:47 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 06080E0713 for ; Sun, 31 Oct 2010 01:04:47 +0000 (UTC) Received: from mail.gmx.net (mailout-de.gmx.net [213.165.64.23]) by pigeon.gentoo.org (Postfix) with SMTP id BFAB5E06CF for ; Sun, 31 Oct 2010 00:36:32 +0000 (UTC) Received: (qmail invoked by alias); 31 Oct 2010 00:36:31 -0000 Received: from p5485028B.dip0.t-ipconnect.de (EHLO gmx.net) [84.133.2.139] by mail.gmx.net (mp019) with SMTP; 31 Oct 2010 02:36:31 +0200 X-Authenticated: #20088476 X-Provags-ID: V01U2FsdGVkX1+5/Vwneri5pRKtr2bDh0wpf8Tul2RS8//b40DzlU lu41PvIPmXAT0N Received: by gmx.net (nbSMTP-1.00) for uid 1001 Meino.Cramer@gmx.de; Sun, 31 Oct 2010 02:36:29 +0200 (CEST) Date: Sun, 31 Oct 2010 02:36:29 +0200 From: meino.cramer@gmx.de To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] xmltv to MySQL ??? Message-ID: <20101031003629.GD5979@solfire> References: <20101030172553.GC5979@solfire> <7FDD27B2-FAC1-4EC0-A31F-15573912721C@stellar.eclipse.co.uk> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <7FDD27B2-FAC1-4EC0-A31F-15573912721C@stellar.eclipse.co.uk> User-Agent: mutt-ng/devel-r804 (Linux) X-Y-GMX-Trusted: 0 X-Archives-Salt: 75295f71-e023-4121-ab6b-17e02278946f X-Archives-Hash: f3ca358134e62129d3e2f6f373f270f2 Stroller [10-10-31 02:26]: > > On 30 Oct 10, at 6:25pm, meino.cramer@gmx.de wrote: > > ... > > I am looking for a tool to simply put the contents of xmltv-files into > > a MySQL database. > > I googled a lot this day and found some tools but some does not use > > MySQL (for example one uses Postgresql) other have started a project > > but do not release any code. And lot tools are part of very very big > > packages and cannot be cut out of them in a simple way. > > > > I only want a xmltv-reader which feeds the data into MySQL. Everything > > else is done elsewhere... > > I think the best answer to this is "MythTV". > > A week ago you asked about waking your computer up at certain times to record TV. > > Earlier today you were asking for something to schedule recordings. I would have replied then and suggested MythTV or atd, but you'd already had a reply you were happy with by the time I saw it. > > Now you're trying to fix another problem which has already been solved by MythTV. > > What are you going to do when you find that shows are running late and the bash script you've bodged together cuts off the last 5 minutes of Inspector Morse? You will never know whodunnit!! MythTV automatically pads the program by a few minutes, except when this would clash with another program. > > MythTV has thousands of lines of code already written to solve the problems associated with recording and watching TV on a computer. All the stuff you've asked for already, MythTV started addressing years ago. > > Will your script be able to record two shows at once, using a single tuner? MythTV can. > > I understand where you're coming from, wanting to do this yourself, but I think you're going to be continually wanting to add features to your solution. > > Having said that, I think you could probably use Perl. I think there is an xmltv module in CPAN, and you'll find about a zillion articles on the web about using Perl to shove stuff into databases. > http://kobesearch.cpan.org/htdocs/xmltv/ > Is there any reason your database has to be MySQL, rather than, say, SQLite? > > Stroller. > > Hi Stroller, thank you for your help and answer. May be your right: Why doing anything myself ?! I want to use MySQL since it is already installed and used and dont want to have n different databases programs for n different applications which basically do all the same: gathering data... Best regards and thank you again! mcc