Solved

Web Development - Database

Posted on 2014-03-12
12
244 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 

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
 
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Insert values are dynamic 11 51
asp Google Map 2 32
Use Select Query to Return Results as a Form 9 24
MySQL Finding Duplicates in a Normalized Database 6 9
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
The viewer will learn how to dynamically set the form action using jQuery.
Learn how to set-up custom confirmation messages to users who complete your Wufoo form. Include inputs from fields in your form, webpage redirects, and more with Wufoo’s confirmation options.

831 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