Alpha Video Training
Results 1 to 7 of 7

Thread: Should I use the native database?

  1. #1
    Member Rayr's Avatar
    Real Name
    Ray Roosa
    Join Date
    Oct 2005
    Location
    New Jersey
    Posts
    427

    Default Should I use the native database?

    Hi All,

    My mind is racing trying to figure out what to do for my project, I would like to know if I should use the built in native DBF database or use MySQL, SQL Exspress or some other database if I am planing on either porting my application to the web or plan on doing a multi-model application at some point after the desktop app is done.

    I may as well ask now if you all come back and say NOT to use the built database and to start right off using SQL so its easy to setup the web application later on can I still use the field rules for the desktop part of my application? I understand field rules DONT work on the WAS side of the application but I think its a big help in getting my local/desktop app completed faster.
    Kind Regards,
    Ray Roosa
    Raylin Micro, LLC.

  2. #2
    "Certified" Alphaholic DaveM's Avatar
    Real Name
    Dave Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    6,026

    Default Re: Should I use the native database?

    Ray,

    I believe you need to let us all know what kind of data/application it will be. Size ot the table and some details as to complexity. Would you be hosting the supposed web side yourself or use an ISP like godaddy?


    .
    Dave Mason
    dave@aldausa.com
    Skype is dave.mason46

  3. #3
    Member APFCClyde's Avatar
    Real Name
    Clyde Tilley
    Join Date
    Dec 2005
    Location
    Phoenix AZ
    Posts
    125

    Default Re: Should I use the native database?

    Ray,

    My web app has a report that uses a 10 table set with the main table having over 536,000 records & the sub tables range from 57 to over 4,000,000 records. I can pull this report on selected records in a couple of seconds regardless how many records it returns.

    So if it's properly indexed & filtered, dbfs can be very fast.

  4. #4
    Member Rayr's Avatar
    Real Name
    Ray Roosa
    Join Date
    Oct 2005
    Location
    New Jersey
    Posts
    427

    Default Re: Should I use the native database?

    Quote Originally Posted by DaveM View Post
    Ray,

    I believe you need to let us all know what kind of data/application it will be. Size ot the table and some details as to complexity. Would you be hosting the supposed web side yourself or use an ISP like godaddy?


    .
    Hi Dave,

    I would most likely start out hosting myself but that could all change, I dont know hoe big my application is going to get at this point all I can tell you is the first application will be small to start with but will grow over time as will the user base. Sorry I cant be more clear, I think all I am trying to do is start this many year project off right and I did not know if the native DBF (FOX PRO) database was worth considering for application that will end up as web applications at some point.
    Kind Regards,
    Ray Roosa
    Raylin Micro, LLC.

  5. #5
    Member Rayr's Avatar
    Real Name
    Ray Roosa
    Join Date
    Oct 2005
    Location
    New Jersey
    Posts
    427

    Default Re: Should I use the native database?

    Quote Originally Posted by APFCClyde View Post
    Ray,

    My web app has a report that uses a 10 table set with the main table having over 536,000 records & the sub tables range from 57 to over 4,000,000 records. I can pull this report on selected records in a couple of seconds regardless how many records it returns.

    So if it's properly indexed & filtered, dbfs can be very fast.
    Hi Clyde,

    Thank you for your input, I guess I will start this project off using the DBF database since your having good luck with it, this would keep my project at a simple level rather then getting involved with SQL y I am still learning Alpha Five innless someone else brings a neg to light.
    Kind Regards,
    Ray Roosa
    Raylin Micro, LLC.

  6. #6
    Member
    Real Name
    Sean Kennedy
    Join Date
    Apr 2006
    Location
    Shokan, NY
    Posts
    275

    Default Re: Should I use the native database?

    From reading here, it seems that porting the tables over to SQL works pretty good. So, you can always start with the DBF's and then, at some point in the future you could decide to switch to using SQL.

    Sean

  7. #7
    Member Rayr's Avatar
    Real Name
    Ray Roosa
    Join Date
    Oct 2005
    Location
    New Jersey
    Posts
    427

    Default Re: Should I use the native database?

    Quote Originally Posted by seaken64 View Post
    From reading here, it seems that porting the tables over to SQL works pretty good. So, you can always start with the DBF's and then, at some point in the future you could decide to switch to using SQL.

    Sean
    Thanks Sean, I am just trying to build the application right from the start :confused:
    Kind Regards,
    Ray Roosa
    Raylin Micro, LLC.

Similar Threads

  1. Creating Install on Network with dbase (Native File Format)
    By timveach in forum Alpha Five Version 9 - Desktop Applications
    Replies: 3
    Last Post: 04-21-2008, 08:25 PM
  2. Build Native Executable
    By smartmedia in forum Archived Wishlist
    Replies: 1
    Last Post: 10-31-2007, 11:42 AM
  3. Native Indexes
    By Paul Main in forum Alpha Five Version 8
    Replies: 19
    Last Post: 07-24-2007, 03:05 PM
  4. Process for incorporating sample database into my test database?
    By ken doucet in forum Alpha Five Version 7
    Replies: 2
    Last Post: 07-08-2006, 12:20 PM
  5. Native Shadow
    By Alan Lucas in forum Alpha Five Version 5
    Replies: 2
    Last Post: 12-11-2003, 04:58 PM

Bookmarks

Posting Permissions

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