• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 425
  • Last Modified:

Create a searchable online database out of a single, huge html page

Hello, so I was tasked with creating a searchable database out of this single, humongous web page:

http://www.formatoql.it/wp-content/uploads/2011/06/rule-cards.html

This page contains a list of thousands of cards related to a card-game. The site's owner would like to convert it to a dynamic searchable database where you search for a card's name and you get a page with the card's data.

Before starting, I thought I'd ask some of you guys since online databases and search engines are fairly new to me.

So what do you think would be the best course of action to convert the page, and which kind of database would you choose? My first thought was MySQL, but maybe it would be overkill?

Thanks guys.
0
Daniele Brunengo
Asked:
Daniele Brunengo
  • 3
  • 2
1 Solution
 
Brad GrouxSenior Manager (Wintel Engineering)Commented:
Sounds like the perfect usage for JSON - http://msdn.microsoft.com/en-us/library/bb299886.aspx

Since it is static data, no database is required and simple HTML5 and JavaScript can be used to call it dynamically.

Here is a great JSON video tutorial - https://www.youtube.com/watch?v=wbB3lVyUvAM

Just think of JSON as XML-type data written in JavaScript, here's a code example:
{"employees":[
    {"firstName":"John", "lastName":"Doe"}, 
    {"firstName":"Anna", "lastName":"Smith"},
    {"firstName":"Peter", "lastName":"Jones"}
 ]}

Open in new window

vs. XML
<employees>
    <employee>
        <firstName>John</firstName> <lastName>Doe</lastName>
    </employee>
    <employee>
        <firstName>Anna</firstName> <lastName>Smith</lastName>
    </employee>
    <employee>
        <firstName>Peter</firstName> <lastName>Jones</lastName>
    </employee>
</employees>

Open in new window

Source: http://www.w3schools.com/json/default.asp
0
 
Daniele BrunengoIT Consultant, Web DesignerAuthor Commented:
I had read something about json, mostly forgot about it, but I think you may have hit the jackpot.

The problem I think I may have is with those Notes at the end of each card: some have one or more, some have none.
0
 
Brad GrouxSenior Manager (Wintel Engineering)Commented:
There is no reason you can't have an entry for multiple notes and only call those on the cards that need it, and/or make a single note section and just delaminate each multiple note as they are now, with a carriage return, paragraph or bullet.
0
 
Daniele BrunengoIT Consultant, Web DesignerAuthor Commented:
Ok, thanks, I'll try that. I'll report back in a few days.
0
 
Daniele BrunengoIT Consultant, Web DesignerAuthor Commented:
There are a few bumps, but your route is actually the best, so thanks and here's your points.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now