+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 15

Free Databases with GUI Interface

  1. Free Databases with GUI Interface

    Is there a good free database program that exists for Windows XP that
    has a capacity of between 2 and 6 gigabytes? I have a little
    experience with Access but the files I am dealing with are too big for
    access.

    I have done some research on the internet and found a few programs that
    might achieve what I want to do but I am not certain that one of these
    programs will work.

    Your suggestions are appreciated.


  2. Re: Free Databases with GUI Interface

    On 16.02.2006 16:27 Jonas wrote:
    > Is there a good free database program that exists for Windows XP that
    > has a capacity of between 2 and 6 gigabytes? I have a little
    > experience with Access but the files I am dealing with are too big for
    > access.
    >
    > I have done some research on the internet and found a few programs that
    > might achieve what I want to do but I am not certain that one of these
    > programs will work.
    >


    You could try OpenOffice Base backed by a Postgres database.

    I haven't worked with Access & Base though, so I don't know how good the
    Base component from OOo is compared to Access, but Postgres will
    absolutely be able to cope with the size

    Thomas


    --
    It's not a RootKit - it's a Sony

  3. Re: Free Databases with GUI Interface

    Thomas,

    I was looking into that program. Don't I need another program to deal
    with the data and put it in visible tables? It seems to me that I
    would have to run it on a server. Can I run it on my desktop computer?
    Do you have any suggestions for somebody who isn't accustomed to the
    PostGreSQL program?


  4. Re: Free Databases with GUI Interface

    On 16.02.2006 16:56 Jonas wrote:
    > Thomas,
    >
    > I was looking into that program. Don't I need another program to deal
    > with the data and put it in visible tables? It seems to me that I
    > would have to run it on a server. Can I run it on my desktop computer?
    > Do you have any suggestions for somebody who isn't accustomed to the
    > PostGreSQL program?
    >


    Of course you are right, Postgres will need to be run as a separate
    process (though it happily runs on a the same computer as OOo)

    You could try to use Firebird which offers a true embedded DB as well,
    but I have never tried it with OOo.

    The nice thing about OOo is, that you can prototype your application
    with the embedded HSQL database (which isn't really capable of handling
    6 GB) and later switch to another. This way you could at least find out
    whether OOo suits your needs

    Thomas

    --
    It's not a RootKit - it's a Sony

  5. Re: Free Databases with GUI Interface

    You can use MySQL (latest version 5.0.18) or PostgreSQL (latest version
    8.1.3) and use Access as backend program:

    http://www.mysql.com
    http://www.postgresql.org

    You also need the ODBC drivers to connect Access to the MySQL/PostgreSQL
    databases:

    http://dev.mysql.com/downloads/connector/odbc/3.51.html
    http://pgfoundry.org/projects/psqlodbc/

    Markus



  6. Re: Free Databases with GUI Interface

    Markus Popp wrote on 16.02.2006 18:07:
    > You can use MySQL (latest version 5.0.18) or PostgreSQL (latest version
    > 8.1.3) and use Access as backend program:
    >


    You probably meant Access as a *frontend*.
    MySQL or Postgres would be the backend

    Thomas

  7. Re: Free Databases with GUI Interface


    "Thomas Kellerer" schrieb im Newsbeitrag
    news:45jra8F73nu6U1@individual.net...
    > Markus Popp wrote on 16.02.2006 18:07:
    > > You can use MySQL (latest version 5.0.18) or PostgreSQL (latest version
    > > 8.1.3) and use Access as backend program:
    > >

    >
    > You probably meant Access as a *frontend*.
    > MySQL or Postgres would be the backend
    >
    > Thomas


    Oups - of course, you're right ;-).

    Markus



  8. Re: Free Databases with GUI Interface

    "Jonas" wrote in news:1140103670.202757.38150
    @f14g2000cwb.googlegroups.com:

    > Is there a good free database program that exists for Windows XP that
    > has a capacity of between 2 and 6 gigabytes? I have a little
    > experience with Access but the files I am dealing with are too big for
    > access.
    >
    > I have done some research on the internet and found a few programs that
    > might achieve what I want to do but I am not certain that one of these
    > programs will work.


    SQLite (http://www.sqlite.org) along with an ODBC driver, used as a back-
    end for Access, would probably suit your needs. It doesn't require setting
    up a separate server process.


  9. Re: Free Databases with GUI Interface

    "Eric Bohlman" schrieb im Newsbeitrag
    news:Xns976DBD74DE630ebohlmanomsdevcom@130.133.1.4...
    > "Jonas" wrote in news:1140103670.202757.38150
    > @f14g2000cwb.googlegroups.com:
    >
    > > Is there a good free database program that exists for Windows XP that
    > > has a capacity of between 2 and 6 gigabytes? I have a little
    > > experience with Access but the files I am dealing with are too big for
    > > access.
    > >
    > > I have done some research on the internet and found a few programs that
    > > might achieve what I want to do but I am not certain that one of these
    > > programs will work.

    >
    > SQLite (http://www.sqlite.org) along with an ODBC driver, used as a back-
    > end for Access, would probably suit your needs. It doesn't require

    setting
    > up a separate server process.
    >


    I don't know much about SQLite, but I have doubts that it's able to handle 6
    gigabytes of data (with suitable performence).

    Therefore, I would rather recommand MySQL or PostgreSQL.

    Markus



  10. Re: Free Databases with GUI Interface

    "Markus Popp" wrote:

    >You can use MySQL (latest version 5.0.18) or PostgreSQL (latest version
    >8.1.3) and use Access as backend program:
    >
    >http://www.mysql.com
    >http://www.postgresql.org
    >
    >You also need the ODBC drivers to connect Access to the MySQL/PostgreSQL
    >databases:
    >
    >http://dev.mysql.com/downloads/connector/odbc/3.51.html
    >http://pgfoundry.org/projects/psqlodbc/

    Are you sure this will work? I realise that the 2GB Access database
    size restriction can be lifted by using attached tables. Can the
    similar limit on table size be overcome the same way?

+ Reply to Thread
Page 1 of 2 1 2 LastLast