Menu
▾
▴
mailsomething-devl
|
From: Stig T. <st...@st...> - 2003-09-13 10:50:02
|
Hey
So one define one column in a table as being a foreign key? What is the purpose exactly? Does it allow for smarter queries? Ur welcome to adjust the create statements in the dbtasklist.
I think we can just use the RessourceManager interface for files. It is placed in the core package. It allows for several implementations, which means one could also make a db implementation if necessary. The fileressoucemanger implementation uses the filenames/paths as keys, and serves up a file as object if a such exists. Ie, it has a base folder, and if u call getInputStream("filepath"), u will get an inputstream for that file. It doesnt return a file, since that would be implementation specific, but an inputstream for the object related to the key. If the object is a file, like a pdf file or similar, we would get an inputstream which we can read from and send over network or similar. We dont need an actual filereference tohandle files, though, when creating a gui where one can add attachments (as files) u will ofcourse get a file. To add this file to the ressourcemanager u then add it like
ressourcemanager.add(file.getpath(), file.getInputStream());
Untill now most of the saving of more 'advanced' objects happens through serializing in the app. I can easely serialize the taskmodel like I do with the mailmodel. There is several reason that I wanted to test and have a db implementation of the taskmodel -
1. To have quik access to some testdate while building the model (changing a class tends to break serializing and u loose all data if ur not carefulll.
2. Loading a lot of data through serializing is slow. I like to create a db implementation of the mailmodel too, since I try to create all those models as independent of rest of the app. Which means that someone will be able to use them in a webapp or similar, and then use a database for saving.
3. In general I just want some more experience with databases.
So if a standard user downloads and uses the program, we can use either serializing, or some xml scheme to save objects to disk. And otherwise a database. I think its save to assume, that if the program is used by someone seriously for a project (when we reach that point) they wont mind installing a database seperately to get a better backup of the data.
There are some schemes for saving data to xml based on some definition files... (castor etc). But currently I think its too much trouble to start use those.
Preferable I would like a small java db integreated in the app, but I havent yet found a good (opensource) java db. Theres on on sf, but it only supports a subset of sql. And I had trouble making it work.
But if we find one it will be very easy to integreate that.
Another issue about db and saving objects is when I try to implement some p2p structure. Then we need to send objects between peers, when synchronizing. This probably can be done through serializing. But I think I prefer doing it through some xml-scheme.
The goals should not, as I see it, be displayed in the TaskView. The entranceview should display a list of modules/projects/clients or whatever to call it, and when u choose one of theese u should be able to see a list of goals, and also a list of tasks. But u can define a dependency between a goal and a task, and in that case... I guess it will be shown in the dependency list of the task (not as a prerequiesite, but the reverse thing). In general though, if a task is part of a module it (ofcourse) also has some dependency relationship with the goals of that module.
But the model arent finished. Maybe the goal thing is not a good idea. I think we need to test it first and see how it works. I mean one can have some nice model, but if the user doesnt find it intuitive and uses it the way its expected, then it is wrong designed. But if I imagine the mailsomething project, I could have a mailapi module with goals like
- implement pop3
- implement smtp
- implement smtp authentification
- do a mailbox/mailaccount structure
- define interfaces for model
There dont necessarely needs to be many goals. My point with this is basicly, that a task in one module should NOT be able to be directly dependent on a task in another module. If thats the case, the goals are not probably created.
One thing to remember when creating a gui for this is, that goals is not something which changes a lot, like tasks. Primarely the user will work with tasks, while goals has a more static nature. The above example of some goals could have been the same goals for the mailsomething mailapi for the last 2 years, while the tasks have changed a lot.
Maybe I just want to force the user to consider what is goals and what is tasks. In current implementations there seem to be some mixing up between those. Actually, if u see the testdata (I know have posted to cvs) several of those tasks can be considered as goals, since they are a definition of where to go, but not how to get there.
I have uploaded the data from my tables. I think we should create some methods for loading and dumbing data, and while testing we can place some buttons for that in the entrance view, so one can export the data easily and then synchronize with cvs. Actually, when the p2p get running the entrancepoint should have some other actions for synchronizing between peers.
Maybe u will create those load and export actions? We could also place them in a db-settings view. That would seem natural.
Stig
>----- Original Message -----
>From: "Darren Woollatt" <dwo...@ho...>
>To: mai...@li...
>Sent: Sat, 13 Sep 2003 10:50:18 +0930
>Subject: Re: Re: Re: [Mailsomething-devl] Compilation Problems
>Hello again,
>
>I now see what you mean goals and that sort of thing. How will this need to>
>be shown on the UI. For example would there jyst be a list of goals that ar>e
>displayed under this task.
>
>To your questions about the database. I think it is possible to store files>
>in a db, but I'm not sure what support MySQL has. I know PostgreSQL has som>e
>support for this, but getting Postgres to work in Windows is an extreme
>hassle. What I meant by foriegn key relationship was that a field in a
>certain table would rterference a field in another table. For example, in a>
>goal table (or something like that) you may have an id to the task which it>
>belongs, this means that this table would reference the Task table with a
>
>foriegn key. This reduces redundancy as you can only enter a task in the
>goal table that exists in the Task table.
>
>I will do some thinking and looking around for ideas for the entrance point>.
>I think that the configuring of the database would be a good idea.
>
>I see your point of not wanting to include a database with the project, and>
>this should be an option for the user. If there is no db how do you see thi>s
>task module working?? Would it also have some sort of XML implementation
>sitting on some sort of server. I was at a seminar the other day (at uni)
>
>conducted by the W3C (WWW consortium) and they were talking bout this stuff>
>about the power of XML for this sort of thing. A db is probably better
>though.
>
>Could you post that test-data to the cvs as a txt file??
>
>Thanks
>
>Darren Woollatt
>
>
>_________________________
>Mailsomething-devl mailing list
>Mai...@li...
>https://lists.sourceforge.net/lists/listinfo/mailsomething-devl
|
|
From: Darren W. <dwo...@ho...> - 2003-09-15 12:05:46
|
Hello
You can define one column in a table as being a foreign key. Its purpose is
to reduce redundancy of data, coz the the id of a task must exist in the
task table before it can be used in the dependency table. Maybe I'll change
the creates in the DBTasklist and this may become more clearer of what I am
actually trying to say. I spose its one thing for me to understand it and
another to explain it.
Your right in saying that if its actually being used by a user then they
wouldn't mind installing a databse. It may be an idea to include or suggest
a certain databse, because the SQL in different databases is completely
different as you may have already found out.
With all of the goal and task stuff. I can see why you want to have tasks
and then goals. I believe that we probably should have goals as well as
tasks. This will help the user to understand what they eventually want to
have (a goal) and the tasks that they will need to do to achieve this task.
I think its a good idea to have the import and export functionality for
data. I will do this and will also have a look at creating some sort of gui
for this functionality of database settings.
I also will have a look in the next few days at those gui issues you raised
for the next release.
Darren
>From: "Stig Tanggaard" <st...@st...>
>To: "Mailsomething-devl" <Mai...@li...>
>Subject: Re: Re: Re: Re: [Mailsomething-devl] Compilation Problems
>Date: l?, 13 sep 2003 11:02:42 Central European Summer Time
>
>Hey
>
>So one define one column in a table as being a foreign key? What is the
>purpose exactly? Does it allow for smarter queries? Ur welcome to adjust
>the create statements in the dbtasklist.
>
>I think we can just use the RessourceManager interface for files. It is
>placed in the core package. It allows for several implementations, which
>means one could also make a db implementation if necessary. The
>fileressoucemanger implementation uses the filenames/paths as keys, and
>serves up a file as object if a such exists. Ie, it has a base folder, and
>if u call getInputStream("filepath"), u will get an inputstream for that
>file. It doesnt return a file, since that would be implementation specific,
>but an inputstream for the object related to the key. If the object is a
>file, like a pdf file or similar, we would get an inputstream which we can
>read from and send over network or similar. We dont need an actual
>filereference tohandle files, though, when creating a gui where one can add
>attachments (as files) u will ofcourse get a file. To add this file to the
>ressourcemanager u then add it like
>ressourcemanager.add(file.getpath(), file.getInputStream());
>
>Untill now most of the saving of more 'advanced' objects happens through
>serializing in the app. I can easely serialize the taskmodel like I do with
>the mailmodel. There is several reason that I wanted to test and have a db
>implementation of the taskmodel -
>1. To have quik access to some testdate while building the model (changing
>a class tends to break serializing and u loose all data if ur not
>carefulll.
>2. Loading a lot of data through serializing is slow. I like to create a db
>implementation of the mailmodel too, since I try to create all those models
>as independent of rest of the app. Which means that someone will be able to
>use them in a webapp or similar, and then use a database for saving.
>3. In general I just want some more experience with databases.
>
>So if a standard user downloads and uses the program, we can use either
>serializing, or some xml scheme to save objects to disk. And otherwise a
>database. I think its save to assume, that if the program is used by
>someone seriously for a project (when we reach that point) they wont mind
>installing a database seperately to get a better backup of the data.
>
>There are some schemes for saving data to xml based on some definition
>files... (castor etc). But currently I think its too much trouble to start
>use those.
>
>Preferable I would like a small java db integreated in the app, but I
>havent yet found a good (opensource) java db. Theres on on sf, but it only
>supports a subset of sql. And I had trouble making it work.
>
>But if we find one it will be very easy to integreate that.
>
>Another issue about db and saving objects is when I try to implement some
>p2p structure. Then we need to send objects between peers, when
>synchronizing. This probably can be done through serializing. But I think I
>prefer doing it through some xml-scheme.
>
>The goals should not, as I see it, be displayed in the TaskView. The
>entranceview should display a list of modules/projects/clients or whatever
>to call it, and when u choose one of theese u should be able to see a list
>of goals, and also a list of tasks. But u can define a dependency between a
>goal and a task, and in that case... I guess it will be shown in the
>dependency list of the task (not as a prerequiesite, but the reverse
>thing). In general though, if a task is part of a module it (ofcourse) also
>has some dependency relationship with the goals of that module.
>
>But the model arent finished. Maybe the goal thing is not a good idea. I
>think we need to test it first and see how it works. I mean one can have
>some nice model, but if the user doesnt find it intuitive and uses it the
>way its expected, then it is wrong designed. But if I imagine the
>mailsomething project, I could have a mailapi module with goals like
>- implement pop3
>- implement smtp
>- implement smtp authentification
>- do a mailbox/mailaccount structure
>- define interfaces for model
>
>There dont necessarely needs to be many goals. My point with this is
>basicly, that a task in one module should NOT be able to be directly
>dependent on a task in another module. If thats the case, the goals are not
>probably created.
>
>One thing to remember when creating a gui for this is, that goals is not
>something which changes a lot, like tasks. Primarely the user will work
>with tasks, while goals has a more static nature. The above example of some
>goals could have been the same goals for the mailsomething mailapi for the
>last 2 years, while the tasks have changed a lot.
>
>Maybe I just want to force the user to consider what is goals and what is
>tasks. In current implementations there seem to be some mixing up between
>those. Actually, if u see the testdata (I know have posted to cvs) several
>of those tasks can be considered as goals, since they are a definition of
>where to go, but not how to get there.
>
>I have uploaded the data from my tables. I think we should create some
>methods for loading and dumbing data, and while testing we can place some
>buttons for that in the entrance view, so one can export the data easily
>and then synchronize with cvs. Actually, when the p2p get running the
>entrancepoint should have some other actions for synchronizing between
>peers.
>
>Maybe u will create those load and export actions? We could also place them
>in a db-settings view. That would seem natural.
>
>Stig
>
>
>
>
> >----- Original Message -----
> >From: "Darren Woollatt" <dwo...@ho...>
> >To: mai...@li...
> >Sent: Sat, 13 Sep 2003 10:50:18 +0930
> >Subject: Re: Re: Re: [Mailsomething-devl] Compilation Problems
>
> >Hello again,
> >
> >I now see what you mean goals and that sort of thing. How will this need
>to>
> >be shown on the UI. For example would there jyst be a list of goals that
>ar>e
> >displayed under this task.
> >
> >To your questions about the database. I think it is possible to store
>files>
> >in a db, but I'm not sure what support MySQL has. I know PostgreSQL has
>som>e
> >support for this, but getting Postgres to work in Windows is an extreme
> >hassle. What I meant by foriegn key relationship was that a field in a
> >certain table would rterference a field in another table. For example, in
>a>
> >goal table (or something like that) you may have an id to the task which
>it>
> >belongs, this means that this table would reference the Task table with a
> >
> >foriegn key. This reduces redundancy as you can only enter a task in the
> >goal table that exists in the Task table.
> >
> >I will do some thinking and looking around for ideas for the entrance
>point>.
> >I think that the configuring of the database would be a good idea.
> >
> >I see your point of not wanting to include a database with the project,
>and>
> >this should be an option for the user. If there is no db how do you see
>thi>s
> >task module working?? Would it also have some sort of XML implementation
> >sitting on some sort of server. I was at a seminar the other day (at uni)
> >
> >conducted by the W3C (WWW consortium) and they were talking bout this
>stuff>
> >about the power of XML for this sort of thing. A db is probably better
> >though.
> >
> >Could you post that test-data to the cvs as a txt file??
> >
> >Thanks
> >
> >Darren Woollatt
> >
> >
> >_________________________
> >Mailsomething-devl mailing list
> >Mai...@li...
> >https://lists.sourceforge.net/lists/listinfo/mailsomething-devl
>
>
>
>
>
>-------------------------------------------------------
>This sf.net email is sponsored by:ThinkGeek
>Welcome to geek heaven.
>http://thinkgeek.com/sf
>_______________________________________________
>Mailsomething-devl mailing list
>Mai...@li...
>https://lists.sourceforge.net/lists/listinfo/mailsomething-devl
_________________________________________________________________
Get less junk mail with ninemsn Premium. Click here
http://ninemsn.com.au/premium/landing.asp
|
|
From: Pier L. D. <du...@ae...> - 2003-09-24 02:04:41
|
Hi,
I'll be working on it this. I browsed a lot of the current code. I'm kind
specialized in databases and if you guys want to stick to SQL, there is
embedded SQL dbs existing which do not requier the user to install a whole
db engine. The rdbms is included whitin the file (and there is some
specially for java, all shipped in one tiny jar file). Is there any task
manager. We should use foreign key as much as possible and enforece the use
of unique keys and primary keys. Is there any task management system up
yet? I'll try to catch up on you this week to get to know what is being
worked on and what is needed to be done.
Later,
Dutch
> Hello
>
> You can define one column in a table as being a foreign key. Its purpose
is
> to reduce redundancy of data, coz the the id of a task must exist in the
> task table before it can be used in the dependency table. Maybe I'll
change
> the creates in the DBTasklist and this may become more clearer of what I
am
> actually trying to say. I spose its one thing for me to understand it and
> another to explain it.
>
> Your right in saying that if its actually being used by a user then they
> wouldn't mind installing a databse. It may be an idea to include or
suggest
> a certain databse, because the SQL in different databases is completely
> different as you may have already found out.
>
> With all of the goal and task stuff. I can see why you want to have tasks
> and then goals. I believe that we probably should have goals as well as
> tasks. This will help the user to understand what they eventually want to
> have (a goal) and the tasks that they will need to do to achieve this
task.
>
> I think its a good idea to have the import and export functionality for
> data. I will do this and will also have a look at creating some sort of
gui
> for this functionality of database settings.
>
> I also will have a look in the next few days at those gui issues you
raised
> for the next release.
>
> Darren
>
>
> >From: "Stig Tanggaard" <st...@st...>
> >To: "Mailsomething-devl" <Mai...@li...>
> >Subject: Re: Re: Re: Re: [Mailsomething-devl] Compilation Problems
> >Date: l?, 13 sep 2003 11:02:42 Central European Summer Time
> >
> >Hey
> >
> >So one define one column in a table as being a foreign key? What is the
> >purpose exactly? Does it allow for smarter queries? Ur welcome to adjust
> >the create statements in the dbtasklist.
> >
> >I think we can just use the RessourceManager interface for files. It is
> >placed in the core package. It allows for several implementations, which
> >means one could also make a db implementation if necessary. The
> >fileressoucemanger implementation uses the filenames/paths as keys, and
> >serves up a file as object if a such exists. Ie, it has a base folder,
and
> >if u call getInputStream("filepath"), u will get an inputstream for that
> >file. It doesnt return a file, since that would be implementation
specific,
> >but an inputstream for the object related to the key. If the object is a
> >file, like a pdf file or similar, we would get an inputstream which we
can
> >read from and send over network or similar. We dont need an actual
> >filereference tohandle files, though, when creating a gui where one can
add
> >attachments (as files) u will ofcourse get a file. To add this file to
the
> >ressourcemanager u then add it like
> >ressourcemanager.add(file.getpath(), file.getInputStream());
> >
> >Untill now most of the saving of more 'advanced' objects happens through
> >serializing in the app. I can easely serialize the taskmodel like I do
with
> >the mailmodel. There is several reason that I wanted to test and have a
db
> >implementation of the taskmodel -
> >1. To have quik access to some testdate while building the model
(changing
> >a class tends to break serializing and u loose all data if ur not
> >carefulll.
> >2. Loading a lot of data through serializing is slow. I like to create a
db
> >implementation of the mailmodel too, since I try to create all those
models
> >as independent of rest of the app. Which means that someone will be able
to
> >use them in a webapp or similar, and then use a database for saving.
> >3. In general I just want some more experience with databases.
> >
> >So if a standard user downloads and uses the program, we can use either
> >serializing, or some xml scheme to save objects to disk. And otherwise a
> >database. I think its save to assume, that if the program is used by
> >someone seriously for a project (when we reach that point) they wont mind
> >installing a database seperately to get a better backup of the data.
> >
> >There are some schemes for saving data to xml based on some definition
> >files... (castor etc). But currently I think its too much trouble to
start
> >use those.
> >
> >Preferable I would like a small java db integreated in the app, but I
> >havent yet found a good (opensource) java db. Theres on on sf, but it
only
> >supports a subset of sql. And I had trouble making it work.
> >
> >But if we find one it will be very easy to integreate that.
> >
> >Another issue about db and saving objects is when I try to implement some
> >p2p structure. Then we need to send objects between peers, when
> >synchronizing. This probably can be done through serializing. But I think
I
> >prefer doing it through some xml-scheme.
> >
> >The goals should not, as I see it, be displayed in the TaskView. The
> >entranceview should display a list of modules/projects/clients or
whatever
> >to call it, and when u choose one of theese u should be able to see a
list
> >of goals, and also a list of tasks. But u can define a dependency between
a
> >goal and a task, and in that case... I guess it will be shown in the
> >dependency list of the task (not as a prerequiesite, but the reverse
> >thing). In general though, if a task is part of a module it (ofcourse)
also
> >has some dependency relationship with the goals of that module.
> >
> >But the model arent finished. Maybe the goal thing is not a good idea. I
> >think we need to test it first and see how it works. I mean one can have
> >some nice model, but if the user doesnt find it intuitive and uses it the
> >way its expected, then it is wrong designed. But if I imagine the
> >mailsomething project, I could have a mailapi module with goals like
> >- implement pop3
> >- implement smtp
> >- implement smtp authentification
> >- do a mailbox/mailaccount structure
> >- define interfaces for model
> >
> >There dont necessarely needs to be many goals. My point with this is
> >basicly, that a task in one module should NOT be able to be directly
> >dependent on a task in another module. If thats the case, the goals are
not
> >probably created.
> >
> >One thing to remember when creating a gui for this is, that goals is not
> >something which changes a lot, like tasks. Primarely the user will work
> >with tasks, while goals has a more static nature. The above example of
some
> >goals could have been the same goals for the mailsomething mailapi for
the
> >last 2 years, while the tasks have changed a lot.
> >
> >Maybe I just want to force the user to consider what is goals and what is
> >tasks. In current implementations there seem to be some mixing up between
> >those. Actually, if u see the testdata (I know have posted to cvs)
several
> >of those tasks can be considered as goals, since they are a definition of
> >where to go, but not how to get there.
> >
> >I have uploaded the data from my tables. I think we should create some
> >methods for loading and dumbing data, and while testing we can place some
> >buttons for that in the entrance view, so one can export the data easily
> >and then synchronize with cvs. Actually, when the p2p get running the
> >entrancepoint should have some other actions for synchronizing between
> >peers.
> >
> >Maybe u will create those load and export actions? We could also place
them
> >in a db-settings view. That would seem natural.
> >
> >Stig
> >
> >
> >
> >
> > >----- Original Message -----
> > >From: "Darren Woollatt" <dwo...@ho...>
> > >To: mai...@li...
> > >Sent: Sat, 13 Sep 2003 10:50:18 +0930
> > >Subject: Re: Re: Re: [Mailsomething-devl] Compilation Problems
> >
> > >Hello again,
> > >
> > >I now see what you mean goals and that sort of thing. How will this
need
> >to>
> > >be shown on the UI. For example would there jyst be a list of goals
that
> >ar>e
> > >displayed under this task.
> > >
> > >To your questions about the database. I think it is possible to store
> >files>
> > >in a db, but I'm not sure what support MySQL has. I know PostgreSQL has
> >som>e
> > >support for this, but getting Postgres to work in Windows is an extreme
> > >hassle. What I meant by foriegn key relationship was that a field in a
> > >certain table would rterference a field in another table. For example,
in
> >a>
> > >goal table (or something like that) you may have an id to the task
which
> >it>
> > >belongs, this means that this table would reference the Task table with
a
> > >
> > >foriegn key. This reduces redundancy as you can only enter a task in
the
> > >goal table that exists in the Task table.
> > >
> > >I will do some thinking and looking around for ideas for the entrance
> >point>.
> > >I think that the configuring of the database would be a good idea.
> > >
> > >I see your point of not wanting to include a database with the project,
> >and>
> > >this should be an option for the user. If there is no db how do you see
> >thi>s
> > >task module working?? Would it also have some sort of XML
implementation
> > >sitting on some sort of server. I was at a seminar the other day (at
uni)
> > >
> > >conducted by the W3C (WWW consortium) and they were talking bout this
> >stuff>
> > >about the power of XML for this sort of thing. A db is probably better
> > >though.
> > >
> > >Could you post that test-data to the cvs as a txt file??
> > >
> > >Thanks
> > >
> > >Darren Woollatt
> > >
> > >
> > >_________________________
> > >Mailsomething-devl mailing list
> > >Mai...@li...
> > >https://lists.sourceforge.net/lists/listinfo/mailsomething-devl
> >
> >
> >
> >
> >
> >-------------------------------------------------------
> >This sf.net email is sponsored by:ThinkGeek
> >Welcome to geek heaven.
> >http://thinkgeek.com/sf
> >_______________________________________________
> >Mailsomething-devl mailing list
> >Mai...@li...
> >https://lists.sourceforge.net/lists/listinfo/mailsomething-devl
>
> _________________________________________________________________
> Get less junk mail with ninemsn Premium. Click here
> http://ninemsn.com.au/premium/landing.asp
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Mailsomething-devl mailing list
> Mai...@li...
> https://lists.sourceforge.net/lists/listinfo/mailsomething-devl
>
|
|
From: stig <st...@eu...> - 2003-09-24 07:43:08
|
Hey :)
Currently theres a TaskView for viewing and editing tasks, and a
tasktableview for viewing a list of tasks. Theese are build on the model I
have been working with. This is working, and running, but not finished at
all. Theres still work to do there.
If ur interested in testing the current state u can use the main method in
the *.gui.task.TaskTableView. Before that u need to setup a database and
adjust the DBTasklist. U can eventually import some data (I have put the
result of some queries at a package under the taskmodel at cvs). Darren is
working on an interface for db-settings, and automatizing the import/export.
This is a temporary solution of sharing data in the db untill the p2p
implementation can take over.
Which db are u talking about? I have tried hsqldb which wasnt a big success,
I couldnt make it work properly and had to adjust the sql. But if u know of
some embedable javadb it would be very nice. If we can find a stable one I
would also like to try and use the db to save mails.
The best way of figuring out the state of the taskmodel and related gui is
probably to test the TaskTableView with some of the data I have supplied.
Perhabs I will update them later today.
The last week I have been busy with the existing mailclient functionality,
doing a new release, and havent been active with the tasks. I intend to
continue with the taskmodel and the related p2p functionality around this
weekend.
Stig
----- Original Message -----
From: "Pier Luc Ducharme" <du...@ae...>
To: <mai...@li...>
Sent: Tuesday, September 23, 2003 10:57 PM
Subject: Re: Re: Re: Re: [Mailsomething-devl] Compilation Problems
> Hi,
> I'll be working on it this. I browsed a lot of the current code. I'm
kind
> specialized in databases and if you guys want to stick to SQL, there is
> embedded SQL dbs existing which do not requier the user to install a whole
> db engine. The rdbms is included whitin the file (and there is some
> specially for java, all shipped in one tiny jar file). Is there any task
> manager. We should use foreign key as much as possible and enforece the
use
> of unique keys and primary keys. Is there any task management system up
> yet? I'll try to catch up on you this week to get to know what is being
> worked on and what is needed to be done.
>
> Later,
> Dutch
>
> > Hello
> >
> > You can define one column in a table as being a foreign key. Its purpose
> is
> > to reduce redundancy of data, coz the the id of a task must exist in the
> > task table before it can be used in the dependency table. Maybe I'll
> change
> > the creates in the DBTasklist and this may become more clearer of what I
> am
> > actually trying to say. I spose its one thing for me to understand it
and
> > another to explain it.
> >
> > Your right in saying that if its actually being used by a user then they
> > wouldn't mind installing a databse. It may be an idea to include or
> suggest
> > a certain databse, because the SQL in different databases is completely
> > different as you may have already found out.
> >
> > With all of the goal and task stuff. I can see why you want to have
tasks
> > and then goals. I believe that we probably should have goals as well as
> > tasks. This will help the user to understand what they eventually want
to
> > have (a goal) and the tasks that they will need to do to achieve this
> task.
> >
> > I think its a good idea to have the import and export functionality for
> > data. I will do this and will also have a look at creating some sort of
> gui
> > for this functionality of database settings.
> >
> > I also will have a look in the next few days at those gui issues you
> raised
> > for the next release.
> >
> > Darren
> >
> >
> > >From: "Stig Tanggaard" <st...@st...>
> > >To: "Mailsomething-devl" <Mai...@li...>
> > >Subject: Re: Re: Re: Re: [Mailsomething-devl] Compilation Problems
> > >Date: l?, 13 sep 2003 11:02:42 Central European Summer Time
> > >
> > >Hey
> > >
> > >So one define one column in a table as being a foreign key? What is the
> > >purpose exactly? Does it allow for smarter queries? Ur welcome to
adjust
> > >the create statements in the dbtasklist.
> > >
> > >I think we can just use the RessourceManager interface for files. It is
> > >placed in the core package. It allows for several implementations,
which
> > >means one could also make a db implementation if necessary. The
> > >fileressoucemanger implementation uses the filenames/paths as keys, and
> > >serves up a file as object if a such exists. Ie, it has a base folder,
> and
> > >if u call getInputStream("filepath"), u will get an inputstream for
that
> > >file. It doesnt return a file, since that would be implementation
> specific,
> > >but an inputstream for the object related to the key. If the object is
a
> > >file, like a pdf file or similar, we would get an inputstream which we
> can
> > >read from and send over network or similar. We dont need an actual
> > >filereference tohandle files, though, when creating a gui where one can
> add
> > >attachments (as files) u will ofcourse get a file. To add this file to
> the
> > >ressourcemanager u then add it like
> > >ressourcemanager.add(file.getpath(), file.getInputStream());
> > >
> > >Untill now most of the saving of more 'advanced' objects happens
through
> > >serializing in the app. I can easely serialize the taskmodel like I do
> with
> > >the mailmodel. There is several reason that I wanted to test and have a
> db
> > >implementation of the taskmodel -
> > >1. To have quik access to some testdate while building the model
> (changing
> > >a class tends to break serializing and u loose all data if ur not
> > >carefulll.
> > >2. Loading a lot of data through serializing is slow. I like to create
a
> db
> > >implementation of the mailmodel too, since I try to create all those
> models
> > >as independent of rest of the app. Which means that someone will be
able
> to
> > >use them in a webapp or similar, and then use a database for saving.
> > >3. In general I just want some more experience with databases.
> > >
> > >So if a standard user downloads and uses the program, we can use either
> > >serializing, or some xml scheme to save objects to disk. And otherwise
a
> > >database. I think its save to assume, that if the program is used by
> > >someone seriously for a project (when we reach that point) they wont
mind
> > >installing a database seperately to get a better backup of the data.
> > >
> > >There are some schemes for saving data to xml based on some definition
> > >files... (castor etc). But currently I think its too much trouble to
> start
> > >use those.
> > >
> > >Preferable I would like a small java db integreated in the app, but I
> > >havent yet found a good (opensource) java db. Theres on on sf, but it
> only
> > >supports a subset of sql. And I had trouble making it work.
> > >
> > >But if we find one it will be very easy to integreate that.
> > >
> > >Another issue about db and saving objects is when I try to implement
some
> > >p2p structure. Then we need to send objects between peers, when
> > >synchronizing. This probably can be done through serializing. But I
think
> I
> > >prefer doing it through some xml-scheme.
> > >
> > >The goals should not, as I see it, be displayed in the TaskView. The
> > >entranceview should display a list of modules/projects/clients or
> whatever
> > >to call it, and when u choose one of theese u should be able to see a
> list
> > >of goals, and also a list of tasks. But u can define a dependency
between
> a
> > >goal and a task, and in that case... I guess it will be shown in the
> > >dependency list of the task (not as a prerequiesite, but the reverse
> > >thing). In general though, if a task is part of a module it (ofcourse)
> also
> > >has some dependency relationship with the goals of that module.
> > >
> > >But the model arent finished. Maybe the goal thing is not a good idea.
I
> > >think we need to test it first and see how it works. I mean one can
have
> > >some nice model, but if the user doesnt find it intuitive and uses it
the
> > >way its expected, then it is wrong designed. But if I imagine the
> > >mailsomething project, I could have a mailapi module with goals like
> > >- implement pop3
> > >- implement smtp
> > >- implement smtp authentification
> > >- do a mailbox/mailaccount structure
> > >- define interfaces for model
> > >
> > >There dont necessarely needs to be many goals. My point with this is
> > >basicly, that a task in one module should NOT be able to be directly
> > >dependent on a task in another module. If thats the case, the goals are
> not
> > >probably created.
> > >
> > >One thing to remember when creating a gui for this is, that goals is
not
> > >something which changes a lot, like tasks. Primarely the user will work
> > >with tasks, while goals has a more static nature. The above example of
> some
> > >goals could have been the same goals for the mailsomething mailapi for
> the
> > >last 2 years, while the tasks have changed a lot.
> > >
> > >Maybe I just want to force the user to consider what is goals and what
is
> > >tasks. In current implementations there seem to be some mixing up
between
> > >those. Actually, if u see the testdata (I know have posted to cvs)
> several
> > >of those tasks can be considered as goals, since they are a definition
of
> > >where to go, but not how to get there.
> > >
> > >I have uploaded the data from my tables. I think we should create some
> > >methods for loading and dumbing data, and while testing we can place
some
> > >buttons for that in the entrance view, so one can export the data
easily
> > >and then synchronize with cvs. Actually, when the p2p get running the
> > >entrancepoint should have some other actions for synchronizing between
> > >peers.
> > >
> > >Maybe u will create those load and export actions? We could also place
> them
> > >in a db-settings view. That would seem natural.
> > >
> > >Stig
> > >
> > >
> > >
> > >
> > > >----- Original Message -----
> > > >From: "Darren Woollatt" <dwo...@ho...>
> > > >To: mai...@li...
> > > >Sent: Sat, 13 Sep 2003 10:50:18 +0930
> > > >Subject: Re: Re: Re: [Mailsomething-devl] Compilation Problems
> > >
> > > >Hello again,
> > > >
> > > >I now see what you mean goals and that sort of thing. How will this
> need
> > >to>
> > > >be shown on the UI. For example would there jyst be a list of goals
> that
> > >ar>e
> > > >displayed under this task.
> > > >
> > > >To your questions about the database. I think it is possible to store
> > >files>
> > > >in a db, but I'm not sure what support MySQL has. I know PostgreSQL
has
> > >som>e
> > > >support for this, but getting Postgres to work in Windows is an
extreme
> > > >hassle. What I meant by foriegn key relationship was that a field in
a
> > > >certain table would rterference a field in another table. For
example,
> in
> > >a>
> > > >goal table (or something like that) you may have an id to the task
> which
> > >it>
> > > >belongs, this means that this table would reference the Task table
with
> a
> > > >
> > > >foriegn key. This reduces redundancy as you can only enter a task in
> the
> > > >goal table that exists in the Task table.
> > > >
> > > >I will do some thinking and looking around for ideas for the entrance
> > >point>.
> > > >I think that the configuring of the database would be a good idea.
> > > >
> > > >I see your point of not wanting to include a database with the
project,
> > >and>
> > > >this should be an option for the user. If there is no db how do you
see
> > >thi>s
> > > >task module working?? Would it also have some sort of XML
> implementation
> > > >sitting on some sort of server. I was at a seminar the other day (at
> uni)
> > > >
> > > >conducted by the W3C (WWW consortium) and they were talking bout this
> > >stuff>
> > > >about the power of XML for this sort of thing. A db is probably
better
> > > >though.
> > > >
> > > >Could you post that test-data to the cvs as a txt file??
> > > >
> > > >Thanks
> > > >
> > > >Darren Woollatt
> > > >
> > > >
> > > >_________________________
> > > >Mailsomething-devl mailing list
> > > >Mai...@li...
> > > >https://lists.sourceforge.net/lists/listinfo/mailsomething-devl
> > >
> > >
> > >
> > >
> > >
> > >-------------------------------------------------------
> > >This sf.net email is sponsored by:ThinkGeek
> > >Welcome to geek heaven.
> > >http://thinkgeek.com/sf
> > >_______________________________________________
> > >Mailsomething-devl mailing list
> > >Mai...@li...
> > >https://lists.sourceforge.net/lists/listinfo/mailsomething-devl
> >
> > _________________________________________________________________
> > Get less junk mail with ninemsn Premium. Click here
> > http://ninemsn.com.au/premium/landing.asp
> >
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > Mailsomething-devl mailing list
> > Mai...@li...
> > https://lists.sourceforge.net/lists/listinfo/mailsomething-devl
> >
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Mailsomething-devl mailing list
> Mai...@li...
> https://lists.sourceforge.net/lists/listinfo/mailsomething-devl
>
|
Thanks for helping keep SourceForge clean.
X