Open Source Database required for storing huge data from Web crawler

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • KushShukla
    New Member
    • Jan 2014
    • 11

    Open Source Database required for storing huge data from Web crawler

    I have an idea to implement a web application.
    I will be having a web crawler that will fetch pages and information from the sites and store it to database. The registered end user can access the information by querying from the database.

    I will be using the Web-Crawler written in Python.
    Initially, I can design my website using some free online tools like weebly.com and later on can publish by buying some domain.

    I have no idea which open source database to use for this purpose and link it to web site.
    I am unaware of the limits which the open source databases provide ?

    Please help me with my queries?
  • Luuk
    Recognized Expert Top Contributor
    • Mar 2012
    • 1043

    #2
    Possible choices (this list is not complete):
    1) MySQL
    2) PostgeSQL
    3) SLite

    1) This is easy to setup, can do what you describe.
    2) Somewhat harder to setup, can do what you describe.
    3) no setup. Not good in concurrent updates (which you do not seem to need )

    Comment

    • KushShukla
      New Member
      • Jan 2014
      • 11

      #3
      Thanks Luuk!
      What amount of data can I store in these databases.
      What is the difference between these open source databases and the paid ones?

      Thanks in advance!

      Comment

      • mHealth
        New Member
        • Jun 2014
        • 13

        #4
        PostGreSQL is outdated, SQLLite is for Android, better go for MySQL.

        Comment

        • KushShukla
          New Member
          • Jan 2014
          • 11

          #5
          Thanks mHealth, I will check for MySQL.

          Comment

          • Luuk
            Recognized Expert Top Contributor
            • Mar 2012
            • 1043

            #6
            "PostgreSQL is outdated?"
            Why is the latest release done in 2014

            How is this 'outdated'

            "SQLite is for Android"

            This page shows some applications which use SQLite, and those are not only for Android.....

            @KushShukla
            "What amount of data can I store in these databases."
            until your hard drive is full ;)

            Comment

            Working...