Database of some sort.

[Random United]

Hello there,

I'm trying to create a database of some sort about movies and tv shows I watched, also trying to have data for each movie/tv show like a description of the movie, year release, genre, rating, etc. Is there anyway of doing that? For example if i want to search for a movie, i would search it by the year instead of just the name. Is that possible? Is it even possible to create a database in general?

Also is it possible to have something like this work:
+Season 1 (Not expanded)
-Season 1 (expanded)
Ep 1
Ep 2

+Seaon 2
-Season 2
Ep 1
Ep 2

You click the text to expand. If it's possible, what would be the code?

Any help would be appreciated.
[New to tiddlywiki and don't know much about coding]

[Mark S.]

You can structure your set-up however you want. However, there is no optimized indexing in TW5 as in DBF or SQL systems. This means that things will slow down as you scale up. But unless you have many thousands of entries you probably won't notice.

c pa has an overview of one approach to structuring data here:

https://groups.google.com/d/msg/tiddlywiki/QUXd3kG1pTQ/RnYdTqLmAwAJ

Good luck,
Mark

On Tuesday, April 11, 2017 at 3:34:34 PM UTC-7, Random United wrote:

Hello there,

I'm trying to create a database of some sort about movies and tv shows I watched, also trying to have data for each movie/tv show like a description of the movie, year release, genre, rating, etc. Is there anyway of doing that? For example if i want to search for a movie, i would search it by the year instead of just the name. Is that possible? Is it even possible to create a database in general?

[Random United]

Yeah I figured I would have to do it like that.

[Edit:  I also added a second part to the post I need help with.]

Much appreciated,
Random

[Mark S.]

For your second part, consider the TOC macro (http://tiddlywiki.com/#Table-of-Contents%20Macros). It has many options.

Then have the tiddlers form a tag tree. You might structure your data like this:

Tiddler 1:
title: Season 1
tag: Root

Tiddler 2:
title: Season 1 - Episode 1
tag: Season 1

Tiddler 3:
title: Season 1 - Episode 2
tag: Season 1

Tiddler 4:
title: Season 2
tag: Root

Tiddler 5:
title: Season 2 - Episode 1
tag: Season 2

Tiddler 6:
title: Season 2 - Episode 2
tag: Season 2

... etc. ...

When creating episodes based on a particular season, the "New Here" button can be used to create an episode tiddler already tagged with that season.

HTH

Mark


On Tuesday, April 11, 2017 at 3:34:34 PM UTC-7, Random United wrote:

[Random United]

Yes I know how to do this in a tab, but I want to write it in one page(tiddler) as some sort of drop down list. Instead of having the list visible I want to be able to click for example Season 1 then a list opens down listing the episodes, if that makes any sense.

[Mat]

On Wednesday, April 12, 2017 at 6:36:24 AM UTC+2, Random United wrote:

Yes I know how to do this in a tab, but I want to write it in one page(tiddler) as some sort of drop down list. Instead of having the list visible I want to be able to click for example Season 1 then a list opens down listing the episodes, if that makes any sense.

http://tiddlywiki.com/#SelectWidget

<:-)

[Mark S.]

Isn't that what the toc-expandable version of the TOC macro does?

Good luck,
Mark

[Random United]

Thank you Mat I will look into it.

Much appreciated,
Random

[Random United]

I will look into it. Thank you Mark.

Much appreciated,
Random

[Pit.W.]

Hello Random United,

I wanted to exactly the same,  I am still working on it, but I am confident to say, what wou want is absolutely possible.

I used https://cdn.miramax.com/media/assets/f250bestmoviesmap_HQ.jpg as a starting point. The data I found in this map, I entered (partially) into http://tiddlymap.org/ (hattip to @felixhayashi)

For the rating http://tobibeer.github.io/tw5-plugins/#rate offers a lot of customisation possibilities, well documented (hattip @tobibeer) and http://favorites.tiddlyspot.com/ (hattip @Andrew Harrison) is also powerful with zero-effort :)

Kind regards

Pit.W

Am 2017-04-12 um 00:34 schrieb Random United:

Hello there,

New to tiddlywiki and I'm trying to create a database of some sort about movies and tv shows I watched, also trying to have data for each movie/tv show like a description of the movie, year release, genre, rating, etc. Is there anyway of doing that? For example if i want to search for a movie, i would search it by the year instead of just the name. Is that possible? Is it even possible to create a database in general?

Any help would be appreciated.

[Random United]

Thank you very much Pit.W. This looks exactly what I wanted.

Much appreciated,
Random

[Douglas Counts]

Hello Random,

On Tuesday, April 11, 2017 at 5:34:34 PM UTC-5, Random United wrote:

I'm trying to create a database of some sort about movies and tv shows I watched, also trying to have data for each movie/tv show like a description of the movie, year release, genre, rating, etc. Is there anyway of doing that? 

... 

[New to tiddlywiki and don't know much about coding]

I noticed that most of your responses to this post are about reinventing the wheel. Don't. Both the IMDB and the Open Movie Database have interfaces into their vast movie databases. You can query either one using an ajax request and parse the JSON that is returned.  You can even fetch images and more for each movie you wish to save to your wiki.

That way, once you have figured out how to fetch the movie poster and data for one movie, you can then leverage that knowledge to build a template for all the others you wish to save data on. There are several projects on GitHub that contain code on how to do this like this one here. You will notice that you can fetch image links and the data for things like the movie poster, description, rating, year published, genre, director, metascore, writer, runtime, and more.

Once you have the data, you can use the movie poster link inside an image tag to display the poster and use the data like the description inside your content.  If you have fifty or more DVD's that you wish to catalog, you will save enormous amounts of time if you spend the time up front figuring out how to query for the data and leveraging that.  Also, filling up your wiki with images, instead of links to online images, will make your file size grow quickly and soon become slow and unwieldy. 

Good luck,

-Doug