r/web_design•
avcue

First website, a bit in over my head. How should I structure this?

I've got programming experience with java but have not dabbled in web design in a long time. I need to know how I should be looking to accomplish a particular goal for my web page.

I have a very large set of data with lots of redundancy. Users will be searching by zip code to retrieve data, no modifications to the data though. In java I would typically use pointers to retrieve the data so that I can modify single elements and have it reflect across all zip codes that use that element.

Basically, every zip code will have 7 related objects consisting of 3 strings. Each set of 3 strings is being displayed on the same page in separate divs. The strings will be modified by me at times but not the users.

What would be the best way to organize retrieving this data before I dive head first into learning something I might not be able to accomplish this with.

Posted Jul 21, 2013, 7:49 PM UTC

88
[deleted]•

If you're a Java dev, use Java. The Spring framework is pretty quick and easy to get a project going and JDBC should help you get it connected up to a SQL db in no time.

2
DiabloVixen•

so essentially a user would put in "11103" and get back a single set of data related to only 11103?

is there a possibility that 11103 and 11102 could have the same information?

There's a really KISS way you can do this with javascript and JSON, you can always graduate to using a NOSQL solution later if the data isn't too intricate. I'm always very big on getting a working prototype before you jump into the more complicated stuff such as PHP or the play framework. Buts that's just me.

2
avcueOP•

Its going to be rare that any two zips have the same seven sets of strings, but every zip would have at least 6 in common with another. For instance one zip might have abcdefg, and another abcdhij, while another has abcdeik, where each letter is a set of three strings.

Edit: I can see doing it with just JavaScript easily, but I don't want to make every user download all of the zips data. It would literally be every zip in the US.

1
Numy•

got a scheme of your db? (it doesn't really seem clear what the issue is to me)

2
Quinesee•

Are you familiar with any PHP? I am assuming that you are using a database for the data. I would just creating a template page that PHP fills in when a search is made.

1
avcueOP•

I'm making this site as a learning experience so picking up PHP is fine if its going to be the right tool. My concern with the route I've been picturing trying to do is using 2 tables in mySQL. One of zip codes and seven indexes, where the indexes are in another table that has the 3 strings associated with each index. Does this make sense / is it reasonably feasible? Would there be a better way?

1
Quinesee•

That makes sense to me. But depending on if you have repeating data, you would do better to normalize the tables. Which is to get rid of redundancies in the tables. I'm not sure how much you are wanting to learn on this site, but since you know java, the basic PHP should be easy for you

1
Rinkana•

He said he knows java. So it would be better to look onto the play framework. So he does not need to learn PHP.

As for the website: 1 Create a desing 2 what can be dupelicated (desing wise) 3 what classes do you need for what data. 4 build template's and make it use the data. 5 add other things like animations and validations 6 ??? 7 profit

1