Page 1 of 4 123 ... LastLast
Results 1 to 10 of 37

Thread: Is Kexi supposed to be able to use an existing mysql database?

  1. #1
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Is Kexi supposed to be able to use an existing mysql database?


    I have koffice2-kexi-2.2.2-4.2.x86_64

    I open kexi, I get a dialog: blank database, create from template, import
    existing database. I use import.

    I select "projects stored on a database server". I see the list of
    databases, I choose the proper one (an existing book list database).

    Database project stored on a server, Mysql.

    It appears that it want to replicate the existing database into another one!


    Ok, how do I tell kexi to just use the existing database, do not try to import?

    Or is kexi a tool to create databases, not to use databases?

    --
    Cheers / Saludos,

    Carlos E. R.
    (from 11.2 x86_64 "Emerald" at Telcontar)

  2. #2
    Join Date
    Jun 2008
    Location
    Inzago, Italy
    Posts
    108

    Default Re: Is Kexi supposed to be able to use an existing mysql database?

    It seems like Kexi is needing it's own workspace in your /home folder.
    In my deem at the moment Kexi is only an experiment. When I try something involving form design, it crashes.
    OpenSuse 13.1 with KDE 4.11 on Intel I7 930 motherboard Asus P6T SE - RAM 6 Gb
    - video card NVIDIA GT220 1GB - TV card Hauppauge WinTV Nova T stick

  3. #3
    Join Date
    Jun 2008
    Location
    UTC+10
    Posts
    9,686
    Blog Entries
    4

    Default Re: Is Kexi supposed to be able to use an existing mysql database?

    According to the FAQ, it cannot use an existing database because it needs to store metadata in the database also. Maybe you can create a database with the same schema as your existing database in Kexi, then use the import tool to load the data you have.

  4. #4
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Re: Is Kexi supposed to be able to use an existing mysql database?

    On 2010-11-25 16:06, ken yap wrote:
    >
    > According to the FAQ, it cannot use an existing database because it
    > needs to store metadata in the database also. Maybe you can create a
    > database with the same schema as your existing database in Kexi, then
    > use the import tool to load the data you have.


    As far as I can see, kexi is a tool to create databases, and it stores the
    new tables on a new database or on a file (or set of files), dunno. It is
    not a tool to _use_ databases, which is what I need.

    When importing, it can import the structure of an existing database and
    duplicate it, and copy the data too. It can not simply _use_ a database.

    As far as I can see, there is no such tool in kde4. Knoda has not been
    ported, nor rekall. And neither gnome has it: supposedly Glom, which is
    broken and doesn't even start. It has missing dependencies (not listed in
    requires) that make it crash (yes, there is a Bugzilla).


    There are no good database clients in Linux, it appears. The field belongs
    to MS Access. :-/

    --
    Cheers / Saludos,

    Carlos E. R.
    (from 11.2 x86_64 "Emerald" at Telcontar)

  5. #5
    Join Date
    Jun 2008
    Location
    UTC+10
    Posts
    9,686
    Blog Entries
    4

    Default Re: Is Kexi supposed to be able to use an existing mysql database?

    Yes, what I said.

  6. #6
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Re: Is Kexi supposed to be able to use an existing mysql database?

    On 2010-11-25 23:36, ken yap wrote:
    >
    > Yes, what I said.


    I hoped that things would be different 5 years after the last time I had a
    look :-(


    You know, sometimes it is true that linux is made by geeks for geeks. Or by
    hackers for hackers. Not for users.

    A hacker would program the database. Php, whatever, like some have told me
    here. But if you are a simple user and want a simple database as one would
    do with access in thousands of small offices, it is not possible, there are
    no tools.

    I'm a bit of a hacker myself. I coded for a living years ago. But I don't
    want to fight my way all the time, I want to do simple things now and then!

    --
    Cheers / Saludos,

    Carlos E. R.
    (from 11.2 x86_64 "Emerald" at Telcontar)

  7. #7
    Join Date
    Jun 2008
    Location
    Inzago, Italy
    Posts
    108

    Default Re: Is Kexi supposed to be able to use an existing mysql database?

    Quote Originally Posted by robin_listas View Post
    On 2010-11-25 23:36, ken yap wrote:
    >
    > Yes, what I said.


    I hoped that things would be different 5 years after the last time I had a
    look :-(


    You know, sometimes it is true that linux is made by geeks for geeks. Or by
    hackers for hackers. Not for users.

    A hacker would program the database. Php, whatever, like some have told me
    here. But if you are a simple user and want a simple database as one would
    do with access in thousands of small offices, it is not possible, there are
    no tools.

    I'm a bit of a hacker myself. I coded for a living years ago. But I don't
    want to fight my way all the time, I want to do simple things now and then!

    --
    Cheers / Saludos,

    Carlos E. R.
    (from 11.2 x86_64 "Emerald" at Telcontar)
    Welvome in the clan! I searched ten years experimenting almost all, but nothing comes near to MSAccess. I've always been told "it's so simple, use C or C++, or hire a technician"! To be said that I wrote a business accounting application in MSAccess ten years ago, it's still working, and I was never able to port it in Linux. The only way to make database applications in Linux is using some very complex interface like QT, KDevelop or WXWindows.
    OpenSuse 13.1 with KDE 4.11 on Intel I7 930 motherboard Asus P6T SE - RAM 6 Gb
    - video card NVIDIA GT220 1GB - TV card Hauppauge WinTV Nova T stick

  8. #8
    Join Date
    Jan 2009
    Location
    Switzerland
    Posts
    1,529

    Default Re: Is Kexi supposed to be able to use an existing mysql database?

    The only way to make database applications in Linux is using some very complex interface like QT, KDevelop or WXWindows.
    Or, simply, bash with the command line mysql client and any flavor of dialog.
    Technology is 'stuff that doesn't work yet.' -- Bran Ferren

  9. #9
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Re: Is Kexi supposed to be able to use an existing mysql database?

    On 2010-11-26 14:06, vodoo wrote:
    >
    >> The only way to make database applications in Linux is using some very
    >> complex interface like QT, KDevelop or WXWindows.

    >
    > Or, simply, bash with the command line mysql client and any flavor of
    > dialog.


    Simply? Simply?

    Why on earth do I have to write any code at all, just to use a database? It
    is absurd. MS access solved the problem many years ago. Rekall in linux did
    a fair job of it, but then abandoned.

    This is plain normal office job, not a programming job. If there is
    programming to do, then welcome Access! PUAGH! :-(

    --
    Cheers / Saludos,

    Carlos E. R.
    (from 11.2 x86_64 "Emerald" at Telcontar)

  10. #10
    Join Date
    Sep 2008
    Location
    Wenatchee WA USA
    Posts
    80

    Default Re: Is Kexi supposed to be able to use an existing mysql database?

    Having done a little bit with M$ Access 2007 in the last year or two... while you can do a considerable amount with just the point-n-click interface, I keep running up against things where either its a whole lot simpler to bypass the Query Wizard and use the SQL window directly, or where I need something more than just macros to 'glue' things together or to give a certain functionality. So Access isn't entirely 'programming-free', IMO. For all its warts, it does have quite a few years head start over any thing on the Linux desktop. I had(have) hopes for OOo Base... eventually, maybe. Dabo seems to be able to put together simple CRUD apps without too much coding, but for anything beyond bare-bones some understanding of Python and object-oriented programming is needed.

Page 1 of 4 123 ... LastLast

Posting Permissions

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