List Info

Thread: Tieing databases together?




Tieing databases together?
country flaguser name
United States
2007-11-12 16:43:42
   How does one define relationships between databases?
_______________________________________________
Kexi mailing list
Kexikde.org
https://ma
il.kde.org/mailman/listinfo/kexi

Re: Tieing databases together?
country flaguser name
Poland
2007-11-12 16:52:09
scott said the following, On 2007-11-12 23:43:
>    How does one define relationships between
databases?

Hello Scott,
If you mean tables, currently you can only define weak
relationhips within 
queries. Physical relationhips within the database is not
yet available and 
won't be until Kexi 2.x (x>0). You can always define them
using external tools 
(if your engine is PotgreSQL or MySQL), but you need to know
what are you doing.

Relationhips between databases is also not supported, and
won't be unless 
attaching a database is implemented (SQLite allows for
this).

Your other questions will be hopefully answered tomorrow.

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice
.com.pl/en) to work on
  Kexi & KOffice: http://www.kexi.pl/en, http://www.koffice.org
  KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org
_______________________________________________
Kexi mailing list
Kexikde.org
https://ma
il.kde.org/mailman/listinfo/kexi

Re: Tieing databases together?
country flaguser name
Poland
2007-11-12 17:30:49
scott said the following, On 2007-11-13 00:17:
> Jarosław Staniek wrote:
>> scott said the following, On 2007-11-12 23:43:
>>  
>>>    How does one define relationships between
databases?
>>>     
>>
>> Hello Scott,
>> If you mean tables, currently you can only define
weak relationhips 
>> within queries. Physical relationhips within the
database is not yet 
>> available and won't be until Kexi 2.x (x>0). You
can always define 
>> them using external tools (if your engine is
PotgreSQL or MySQL), but 
>> you need to know what are you doing.
>>
>> Relationhips between databases is also not
supported, and won't be 
>> unless attaching a database is implemented (SQLite
allows for this).
>>
>> Your other questions will be hopefully answered
tomorrow.
>>
>>   
>   Thanks for the reply.  When might 2.0 or 2.x be out? 
I am using 
> MySQL. Hopefully when altering a database when it has
data in it won't 
> cause data loss in the next release. 

You need to wait about 8 months for production stability.
But in the meantime 
it is good idea to put as much as possible (sane) wishes or
notes to 
bugs.kde.org about features that could be improved after
transition to 2.x. 
Namely, you can be part of the Team.

> Are you saying that with this 
> release one can't attach a database?

By attaching I mean semantics like this: http://www.sql
ite.org/lang_attach.html

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice
.com.pl/en) to work on
  Kexi & KOffice: http://www.kexi.pl/en, http://www.koffice.org
  KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org
_______________________________________________
Kexi mailing list
Kexikde.org
https://ma
il.kde.org/mailman/listinfo/kexi
[1-3]

about | contact  Other archives ( Real Estate discussion Medical topics )