Results 1 to 15 of 15
  1. #1
    What's the word? Rhia7's Avatar
    Join Date
    January 13th, 2006
    Posts
    9,578
    Question Help allocating/using resources in programming
    I almost wrote this post in the SAS column because I am thinking of SAS merchants, but in this post I am asking for advice on the best way to use the technical resources (in terms of using them for datafeeds available) available to me in the hosting plan I have right now.

    I am not asking anyone to set-up a database but I am trying to educate myself about databases and about using either a MySQL/PHP combination or the included database program that is included in my hosting.

    My host (by the way) is 1&1.

    If there are any online scripts/tutorials that people know about and could recommend, that would be great.

    What is the best way to allocate and use my MySQL and PHP resources and the included WebDatabase?

    How should I use the resources for merchant datafeeds and possibly a forum (or something else to enhance my site(s) ):

    My host supports: Perl, Python, PHP3,PHP4, PHP5.

    I have 50 MySQL databases (100 MB).

    In addition to the above MySQL and the scripting languages supported by my package, I have an included WebDatabase with the following features:

    * Password protection
    * Picture upload feature
    * .CSV import/export – Use ‘comma-separated values’ files to back up data or read from other programs
    * Database copy feature

    In the included WebDatabase I can create upto 25 WebDatabases each with a maximum of 20 fields.
    I cannot have more than 5000 entries/WebDatabase.

    Please give me advice on how I could plan to use these resources.

    Thank you.
    Last edited by Rhia7; June 15th, 2006 at 03:15 PM.
    ~Rhia7 -- Remember the 7
    Twitter me

  2. #2
    ABW Ambassador Snib's Avatar
    Join Date
    January 18th, 2005
    Location
    Virginia
    Posts
    5,303
    If you don't have the programming know-how to build something on your own I suggest starting with any of the numerous scripts available:

    http://www.creloaded.com/
    http://www.pricetapestry.com/
    http://www.kaonsoftwares.com/price-c...on-script.html

    I've heard good things about Price Tapestry and for less than $100 it's a great deal. The software looks very nice based on the demos available.

    - Scott
    Hatred stirs up strife, But love covers all transgressions.

  3. #3
    What's the word? Rhia7's Avatar
    Join Date
    January 13th, 2006
    Posts
    9,578
    What about the 1&1 Webdatabase? Could I start with that?

    No technical knowledge is needed because 1&1 has done the programming work for you and provides you with a complete database building kit. Select one of the templates for a quick, simple setup. You can easily edit the fields to fit your specifications.
    The following is an actual link to my plan but it is not an affiliate link, so quoting the link should be alright:
    http://order.1and1.com/xml/order/Hos...op&__lf=Static
    ~Rhia7 -- Remember the 7
    Twitter me

  4. #4
    ABW Ambassador Snib's Avatar
    Join Date
    January 18th, 2005
    Location
    Virginia
    Posts
    5,303
    Quote Originally Posted by Rhia7
    What about the 1&1 Webdatabase? Could I start with that?
    It doesn't look like it's made for affiliate datafeeds or shopping. I wouldn't use it.

    - Scott
    Hatred stirs up strife, But love covers all transgressions.

  5. #5
    What's the word? Rhia7's Avatar
    Join Date
    January 13th, 2006
    Posts
    9,578
    No other comments or suggestions?

    Okay, let me ask you this:

    Let's say you were just given a new hosting package.
    The host supports Perl, Python, PHP3,PHP4, PHP5 and you get 50 MySQL databases (100 MB).

    What would you do with the above? Just type off a couple of ideas, you don't have to explain how to do it.

    Here's a hypothetical response:
    I'd build a database of names, addresses, and e-mails so that I could e-mail people who live in Anytown, USA to let them know that the Carnival would be in their town soon.
    I just gave a familiar address database as an example (I have no intention of e-mailing anyone HaHaHa )

    Is 50 MySQL adequate to run a forum? I've seen hosting requests for "unlimited MySQL" why do webmasters request "unlimited MySQL"?

    Is 50 MySQL databases (100 MB) considered to be a fair amount or a puny amount? What would you do with them? Have a guestbook? Run a forum? Any ideas at all?
    Last edited by Rhia7; June 15th, 2006 at 09:46 PM.
    ~Rhia7 -- Remember the 7
    Twitter me

  6. #6
    What's the word? Rhia7's Avatar
    Join Date
    January 13th, 2006
    Posts
    9,578
    Microsoft Access
    Has anyone combined Microsoft Access data with the web?
    ~Rhia7 -- Remember the 7
    Twitter me

  7. #7
    ABW Ambassador MoneyBusiness's Avatar
    Join Date
    March 14th, 2006
    Posts
    2,051
    Quote Originally Posted by Rhia7
    Has anyone combined Microsoft Access data with the web?
    Yes, I've written web apps in my past positions that was based in part on Microsoft Access. However, if you're planning on building anything of value, or anything of large scale, it's probably advisable to use something better. Once you start reaching a high number of records, etc, MS Access pretty much goes downhill.
    Follow my dog, Maya, and I, as we fumble around the affiliate marketing world: www.MarketingMaya.com
    Recent Project: Cheap Personal Checks (using DigitalQuill)

  8. #8

    Join Date
    June 7th, 2006
    Posts
    1,596
    Rhia, you only need 1 mySQL database to run a forum such as ABW.

    Most scripts only use 1 database for what they want to do.

    Though, to me, 1&1 seems very limited. 100MB can quickly be eaten up by just a single database. I have one forum whose SQL database is now 230MB alone.

  9. #9
    What's the word? Rhia7's Avatar
    Join Date
    January 13th, 2006
    Posts
    9,578
    Quote Originally Posted by nakedgamer
    Rhia, you only need 1 mySQL database to run a forum such as ABW.

    Most scripts only use 1 database for what they want to do.

    Though, to me, 1&1 seems very limited. 100MB can quickly be eaten up by just a single database. I have one forum whose SQL database is now 230MB alone.
    Thank you for that information.
    ~Rhia7 -- Remember the 7
    Twitter me

  10. #10
    ABW Founder Haiko de Poel, Jr.'s Avatar
    Join Date
    January 18th, 2005
    Location
    New York
    Posts
    21,609
    However queries, page loads and simultaneous users are crucial for real operability
    Continued Success,

    Haiko
    The secret of success is constancy of purpose ~ Disraeli

  11. #11
    What's the word? Rhia7's Avatar
    Join Date
    January 13th, 2006
    Posts
    9,578
    Smile DataFeed Script Site to check out
    I found out that Oscar (an ABW member) has a very helpful datafeed script site with tutorials, information, some free datafeed scripts plus ready-to-use templates (and some for sale) and I'd just like to list the site here so I can find it again, what a helpful resource!

    http://mydatafeedscripts.com/
    ~Rhia7 -- Remember the 7
    Twitter me

  12. #12
    What's the word? Rhia7's Avatar
    Join Date
    January 13th, 2006
    Posts
    9,578
    Quote Originally Posted by Haiko de Poel, Jr.
    However queries, page loads and simultaneous users are crucial for real operability
    I know what a query is and I know what page loading means, what do you mean by
    simultaneous users?
    ~Rhia7 -- Remember the 7
    Twitter me

  13. #13
    ABW Founder Haiko de Poel, Jr.'s Avatar
    Join Date
    January 18th, 2005
    Location
    New York
    Posts
    21,609
    how many users online at the same time doing the Qs
    Continued Success,

    Haiko
    The secret of success is constancy of purpose ~ Disraeli

  14. #14
    What's the word? Rhia7's Avatar
    Join Date
    January 13th, 2006
    Posts
    9,578
    Quote Originally Posted by Snib
    If you don't have the programming know-how to build something on your own I suggest starting with any of the numerous scripts available:

    http://www.creloaded.com/
    http://www.pricetapestry.com/
    http://www.kaonsoftwares.com/price-c...on-script.html

    I've heard good things about Price Tapestry and for less than $100 it's a great deal. The software looks very nice based on the demos available.

    - Scott
    Scott, thanks for the tips

    I noticed that the free version of CRE Loaded has lots of features:
    http://www.creloaded.com/pages.php?cID=1&pID=1

    Has anyone heard of Actinic Catalog 7 LE? The Lite version on CD-Rom is included in a magazine published in England entitled Web Builder
    Actinic offers a free trial download from its site:

    http://actinic.co.uk/

    The article says:
    This version of Actinic offers full functionality with the exception of the number of products you can display - up to 25.
    Does that mean 25 per web page or a total limit of 25 products?

    Maybe I could use it for a small store?

    My plan is to try out the Actinic Catalog program on the CD that accompanies the magazine and then CRE Loaded Standard definitely looks worth a download
    ~Rhia7 -- Remember the 7
    Twitter me

  15. #15
    What's the word? Rhia7's Avatar
    Join Date
    January 13th, 2006
    Posts
    9,578
    Quote Originally Posted by nakedgamer
    Rhia, you only need 1 mySQL database to run a forum such as ABW.
    Naked, I like your new monkey avatar
    ~Rhia7 -- Remember the 7
    Twitter me

  16. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. programming services
    By spiderninja in forum Midnight Cafe'
    Replies: 13
    Last Post: February 9th, 2007, 11:30 PM
  2. Programming skills
    By Tess in forum Newbie Affiliate FAQs & Helpful Articles
    Replies: 4
    Last Post: May 30th, 2006, 07:55 AM
  3. Programming help - Will pay!
    By eusophix in forum Programming / Datafeeds / Tools
    Replies: 0
    Last Post: March 25th, 2006, 05:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •