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

Posted on 2014-08-22
Last Modified: 2014-08-27
Hello, so I was tasked with creating a searchable database out of this single, humongous web page:

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.
Question by:Daniele Brunengo
    LVL 14

    Accepted Solution

    Sounds like the perfect usage for JSON -

    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 -

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

    Open in new window

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

    Open in new window


    Author Comment

    by:Daniele Brunengo
    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.
    LVL 14

    Expert Comment

    by:Brad Groux
    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.

    Author Comment

    by:Daniele Brunengo
    Ok, thanks, I'll try that. I'll report back in a few days.

    Author Comment

    by:Daniele Brunengo
    There are a few bumps, but your route is actually the best, so thanks and here's your points.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.
    The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now