Path: csiph.com!x330-a1.tempe.blueboxinc.net!feeder1.hal-mli.net!nx02.iad01.newshosting.com!newshosting.com!novia!transit4.readnews.com!textspool2.readnews.com!news-out.readnews.com!transit3.readnews.com!news-out.news.tds.net!newsreading01.news.tds.net!86597e80!not-for-mail From: "Larry Barowski" Subject: Re: Writing a Movie Datab Message-ID: X-Comment-To: comp.lang.java.gui Newsgroups: comp.lang.java.gui In-Reply-To: References: Content-Type: text/plain; charset=IBM437 Content-Transfer-Encoding: 8bit X-Gateway: time.synchro.net [Synchronet 3.15a-Win32 NewsLink 1.92] Lines: 26 Date: Wed, 27 Apr 2011 15:27:26 GMT NNTP-Posting-Host: 96.60.20.240 X-Complaints-To: news@tds.net X-Trace: newsreading01.news.tds.net 1303918046 96.60.20.240 (Wed, 27 Apr 2011 10:27:26 CDT) NNTP-Posting-Date: Wed, 27 Apr 2011 10:27:26 CDT Organization: TDS.net Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.gui:421 To: comp.lang.java.gui "Johs" wrote in message news:em49gq$cdd$1@news.net.uni-c.dk... >I would like to write a simple movie Database in java. When run it should >open a gui where all the movies are listed with the following info: > > title, DVD-Number, Genre > > It should be possible to add more columns later on. It should also be > possible to sort by genre and, title etc and print all the info to a pdf > file. > > I hope its not necessary to use MySQL since its rather simple to just keep > all the movie info in a plain text file. If you had every movie in IMDB, that would be less than 70,000. Even with that number you could easily keep the data in a flat file, and while running keep all data in memory sorted and/or hashed by title, number, and genre. I do a similar thing with a few hundred thousand download records, and the performance is quite good. --- * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet! --- Synchronet 3.15a-Win32 NewsLink 1.92 Time Warp of the Future BBS - telnet://time.synchro.net:24