|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
09-11-2008, 01:48 PM
|
#1 |
|
Registered User
Join Date: Jul 2004
Location: Canada
Posts: 459
|
Need to set up DB with API, considering SQL, need your expert advice
basically, we need to have a database where people can drop of files through an API into our system.
so primarily we need a database/database server where people can drop of files through an API. We then need to have to be able to access this data at some point. secondly, we eventually want to have a secure public interface where people can run reports. but this is not a priority as i have some experience(years ago) with managing SQL database through MS access, i think that basically, it will take the following steps: get a Windows SQL database server hire somebody to set up the database/API on it once its working, use MS Access to pull the data that was put in through the API obviously, im new at this will the above work, what do i need to be careful with? any advice would be appreciated |
|
|
|
09-11-2008, 01:55 PM
|
#2 |
|
<&(©¿©)&>
Industry Role:
Join Date: Jul 2002
Location: Chicago
Posts: 47,882
|
It would be helpful to know what the whole setup is... why are people dropping files through an api to your server? are they backing up files? uploading content they created?
__________________
Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000 Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager  Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager |
|
|
|
|
09-11-2008, 02:12 PM
|
#3 | |
|
Registered User
Join Date: Jul 2004
Location: Canada
Posts: 459
|
Quote:
we are setting up a system to process affiliate data and do the payouts for 2 clients, so they are dropping off check name, amount, memo field, etc so we need to store that and maybe 5-6 other data points |
|
|
|
|
|
09-11-2008, 03:15 PM
|
#4 |
|
Registered User
Join Date: Jul 2004
Location: Canada
Posts: 459
|
bumparoo
|
|
|
|
|
09-11-2008, 04:00 PM
|
#5 |
|
Confirmed User
Join Date: Apr 2004
Location: Toronto, ON
Posts: 1,706
|
I cringed a bit while reading this.
From what you described, can't you just do away with a web interface for those 2 clients rather than an API?
__________________
 315-310
|
|
|
|
|
09-11-2008, 04:08 PM
|
#6 | |
|
Registered User
Join Date: Jul 2004
Location: Canada
Posts: 459
|
Quote:
they are big clients and want an API, mostly i just need a way to have them connect to a web DB and drop off their data. im assuming we can create queries through an MS access connection and get the data we need that way. obviously im trying to do this at the most cost-effective way possible, but yea, i understand im over my head here and i know there are some brilliant people on this board, so thats why im here |
|
|
|
|
