Results 1 to 11 of 11
  1. #1
    Join Date
    May 2007
    Posts
    139

    Access is for desktop or web Apps BUT MySQL is ONLY for web Apps ?

    Access is for desktop or web Apps BUT MySQL is ONLY for web Apps ?
    May Java desktop Apps use MySQL...If yes, how much space take the database structure in the App, if for example data in database reach 1MB exactly...?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    MySQL is a database server, and is appropriate for any type of database application.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    May 2007
    Posts
    139
    mysql is appropriate even for offline, windows desktop apps [eg. JAVA]?

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    mysql is a database server its suitable for virtually any application (web, desktop, corporate or whatever) usage

    however it does have some limitations, especially in the secuirty model.
    like all db products it depends on what version you use V5 is a better than V4 and there can be significant differences between builds of the same version.

    its not as sophisticated or rounded as other server db's.

    ultimately it depends on what you want to do, how you want to interact with the db. what your budget is what your knowledge is.

    the number of people working as MySQL DBA's is a far smaller pool than other db's, so that could be a problem
    its support for stored procedures / triggers is not as sophisticated as others.
    it can be blisteringly fast at retrieving data.
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Quote Originally Posted by lse123
    Access is for desktop or web Apps BUT MySQL is ONLY for web Apps ?
    Wouldn't you do better using a RDBMs that's actually designed to run within applications ie something like SQLITE.

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Maybe he wants a bona-fide SERVER....
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  7. #7
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    It's difficult to tell what he really wants - the question marks seem to appear as random punctuation but perhaps if he tells us what he's trying to do then we can offer better suggestions :
    • Is it a stand alone application or a web based application?
    • Do you want a database that multiple users can talk to?
    • Do you want a database that just one instance of an application can talk to?
    • Are you using Java for the application?
    • Why is space so important?
    • Are you looking for any special database features?

  8. #8
    Join Date
    May 2007
    Posts
    139
    stand alone application
    one user or network app multiple users
    one instance of app or many^
    yes JAVA or VB
    this is my first app , so I ask about space
    no just do simple db jobs

  9. #9
    Join Date
    Sep 2008
    Posts
    33
    Quote Originally Posted by lse123
    stand alone application
    one user or network app multiple users
    one instance of app or many^
    yes JAVA or VB
    this is my first app , so I ask about space
    no just do simple db jobs
    I think you're looking for an embedded db (e.g. derby or hsqld for java)

  10. #10
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    I thin it depends entirely on the eventual use of the app
    an embedded db may be the smart choice, a server db may be a smart choice. the smarted choice may be to build support fo ras many db's as required and implement them through composition classes
    I'd rather be riding on the Tiger 800 or the Norton

  11. #11
    Join Date
    May 2007
    Posts
    139
    Access is embedded db ?

Posting Permissions

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