7 {{ upvoteCount | shortNum }}
7 {{ upvoteCount | shortNum }}

Creating a subscription site with a database?

by James Pierson
6 replies
I am creating a database of businesses/websites (in a certain category) along with useful information about them manually using a small team.

I would like to do the following:

1. The database would be created manually and it would be in an excel sheet format. I would like to take some of those details (like the URL) and perform certain operations.

a. Take the website's URL and see if the site is up or down or re-directed. This has to be done on an ongoing basis.
b. Go to the website and check for social media links (like their Facebook page, twitter page, etc)
c. Get their contact us page, get the details and put that in a separate database.
d. Get the tags from the main website URL or something. So that I would know what the website is about.

2. I would like to sell access to this constantly updated and growing database on a subscription basis. The price would be something like $9-19/month.

(I was looking at off the shelf solutions for doing something like this. However, not able to find the right one that matches my needs.)

How do I do this?
#creating #database #site #subscription
  • Profile picture of the author Joe Crosbie
    Conduct market research to see if this is something people would actually want to pay for.

    To build the actual product, I'd recommend hiring a back end web developer as well as a UI designer and having all the information on a clean, easy to use site.

    Unless you have a fairly strong understanding of coding languages such as PHP & MySQL, this would be pretty difficult to achieve yourself.

    That's how I would approach it anyways,

    Joe Crosbie
    Signature
    I chose entrepreneurship over further education despite being laughed at by my friends and family..

    I recently hit the "RESTART" button on my life, read my personal blog to find out how I did it :)
    {{ DiscussionBoard.errors[8419258].message }}
  • Profile picture of the author Steve Fleming
    Not sure you'll find something off the shelf that's going to do such
    specific things so you'll either have to hack an existing application
    or write your own from scratch.

    Also I'd suggest not using excel as a database but rather something
    like MySql which is designed for the task.

    Good luck

    Steve
    Signature

    {{ DiscussionBoard.errors[8419271].message }}
    • Profile picture of the author James Pierson
      Originally Posted by Joe Crosbie View Post

      Conduct market research to see if this is something people would actually want to pay for.

      To build the actual product, I'd recommend hiring a back end web developer as well as a UI designer and having all the information on a clean, easy to use site.

      Unless you have a fairly strong understanding of coding languages such as PHP & MySQL, this would be pretty difficult to achieve yourself.

      That's how I would approach it anyways,

      Joe Crosbie
      Originally Posted by Steve Fleming View Post

      Not sure you'll find something off the shelf that's going to do such
      specific things so you'll either have to hack an existing application
      or write your own from scratch.

      Also I'd suggest not using excel as a database but rather something
      like MySql which is designed for the task.

      Good luck

      Steve


      Not necessarily incorporate excel on the web platform. I am just building the database on excel temporarily. (I said the database is currently in excel). I am willing to export that to MySql or whatever it necessary.
      {{ DiscussionBoard.errors[8419337].message }}
  • Profile picture of the author CyberCoder
    Some of these tasks may seem simple, but the code to accomplish would have to be very robust.

    What you are really asking for is a spider program to crawl a site and give back details.

    The database is the easy part.

    This is the type work I do, if you would like to discuss, drop me a line.
    {{ DiscussionBoard.errors[8423105].message }}
  • Profile picture of the author BrianMcLeod
    This can be automated with the right kind of desktop database software:

    Database Software | FileMaker
    Signature
    Brian McLeod
    {{ DiscussionBoard.errors[8423127].message }}
  • Profile picture of the author thedanbrown
    Ya the functionality you require is a little more complicated than using a general platform for your site, you will probably need it custom built I would assume
    Signature

    {{ DiscussionBoard.errors[8423147].message }}

Trending Topics