Solved

Web Development - Database

Posted on 2014-03-12
12
242 Views
Last Modified: 2014-03-12
OK.  So I have a concept for a website and based on what I require, I find myself that besides developing the frontend without a problem, my real challenge is the backend which will require SQL database.

The database, as I forsee, will require an extensive amount of data/table.  I am expecting at least 250,000 entries/subscription by the end of its first year of launch.  Then obviously as years go by, it will increase exponentially.  

Having said so, what are my solution and who would be ideal firm that can assist me with such tasks.  What is the best approach?  Is this something that I can work on as well?  I do have limited budget but willing to explore.

Yes, I am somewhat familiar with Dreamweaver but I am 100% certain that most will suggest me with Wordpress or other tools.  No problem.   But my main problem is the backend that can grow exponentially given few years out.  So where to start?
0
Comment
Question by:kaushalk
  • 6
  • 3
  • 2
  • +1
12 Comments
 
LVL 58

Expert Comment

by:Gary
ID: 39925391
To condense your question...
I have an idea, how do I make it work

Which gives us nothing with which to make any suggestions.
0
 

Author Comment

by:kaushalk
ID: 39925403
I could go in great depth in explaining here and take up hours explaining.  I did condense enough to say that the site I am trying to setup requires a subscription for 100's of customers over the course of time.  What the table will contain is:

....detail information about daily/weekly/monthly/yearly activity of pets

customers will need to be able to save such activities, retrieve previous entries, print activities, export activities, etc, etc

and since this is not specific to a particular region, the site will become global, especially those who owns pets.
0
 
LVL 58

Expert Comment

by:Gary
ID: 39925411
If it's too much for one question then break it down into several questions.
The database part in itself is a myriad of questions.
I suggest you delete this question and break it down into its constituent parts e.g.

What database is good for a large growing customer base.
How do you suggest I design a customer database.
What do I need to think about when storing customer details.
etc
0
 

Author Comment

by:kaushalk
ID: 39925414
each component is related to each other.  I don't think it's too difficult to follow my key point.  looking for a large database to implement.  Any suggestions?

I will wait for responses from other experts and hope to find a solution or possible answers with my posts.  Thanks for your suggestions.
0
 
LVL 35

Expert Comment

by:Terry Woods
ID: 39925435
As far as I'm aware both MySQL and PostgreSQL would do the job, and you can't beat the price. The business I work for uses both of these as standard.
0
 

Author Comment

by:kaushalk
ID: 39925438
and based on what I had posted, is it too difficult to do or should I possibly look into a firm to set this portion of website?  I have limited experience on SQL but not completely oblivious.  

I am quite certain that Experts-Exchange uses database for it's clients too, especially subscription based for millions of customers.  My concept is similar.  Subscription based clients with logins.

Also, any suggestions on Wordpress or should I continue on Dreamweaver?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 35

Expert Comment

by:Terry Woods
ID: 39925445
If the site is going to be a hobby, then you could do it yourself. If it's going to be a serious business, then it would be a mistake, though I also wouldn't recommend forking out a large sum of money before proving the idea will be profitable.

Whatever you do, please ensure you keep user data safe by using the correct techniques to prevent the most common attacks listed here: https://www.owasp.org/index.php/Category:OWASP_Top_Ten_Project

My understanding is that Dreamweaver is great for some pretty graphics, but very poor in maintaining the dynamic content needed in a modern interactive website. Wordpress would likely suit you much better.
0
 

Author Comment

by:kaushalk
ID: 39925448
Thanks.  Honestly, it will be serious business project.

Understood about forking large sum of money but could this developed in a small scale as a hobby to start and see?  I mean, I could start out as a small scale project as a hobby and see the results.

Suggestions is very appreciated.  And yes, I have security in mind.  I was a Sys Admin myself and understand various security flaws and issues.

Dreamweaver or Wordpress?
0
 
LVL 35

Accepted Solution

by:
Terry Woods earned 500 total points
ID: 39925449
If it was me, I'd start it as a hobby, but try to keep the data structures as simple as possible while I tested the idea. I edited my previous comment with regards to Wordpress/Dreamweaver.
0
 

Author Comment

by:kaushalk
ID: 39925452
Perfect.  Thanks for all your suggestions.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39925458
Experts-Exchange uses Oracle and JSP (Java Server Pages) for the main pages such as this.  PHP and MySQL are the easiest to start with.  I don't use Dreamweaver and I don't recommend Wordpress for anything dealing with money.  It is well know open source and a favorite target of hackers.

Facebook uses compiled PHP and MySQL along with probably every other known web technology.  When you get to the point where you need it, their compiler technology is available.  And you will be able to hire the programmers needed to make it all work.

And I agree about starting it out yourself.  You can expect the code for such a site, if it is successful, to be totally re-written several times and constantly revised in between.  If you take it as far as you can, you will know what you need when it is time to hire people.
0
 

Author Comment

by:kaushalk
ID: 39925470
Thank you very much
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SASS allows you to treat your CSS code in a more OOP way. Let's have a look on how you can structure your code in order for it to be easily maintained and reused.
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
The viewer will learn the benefit of using external CSS files and the relationship between class and ID selectors. Create your external css file by saving it as style.css then set up your style tags: (CODE) Reference the nav tag and set your prop…
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

864 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

24 Experts available now in Live!

Get 1:1 Help Now