Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Need of design ideas

3 posts in Objects Last posting was on 2007-10-22 03:50:59.0Z
neil Posted on 2007-10-16 04:52:03.0Z
Sender: 4345.47143d65.1804289383@sybase.com
From: Neil
Newsgroups: sybase.public.powerbuilder.objects
Subject: Need of design ideas
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <47144373.4486.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 15 Oct 2007 21:52:03 -0700
X-Trace: forums-1-dub 1192510323 10.22.241.41 (15 Oct 2007 21:52:03 -0700)
X-Original-Trace: 15 Oct 2007 21:52:03 -0700, 10.22.241.41
Lines: 33
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9521
Article PK: 736678

Hi,

I have the following requirements and I felt that this is
tough to accomplish. I hope you can share ideas with me on
what is the best design to go thru.

This is a client/Server somewhat.

Requirements:

1. The user should be able to upload/download a file to/from
the server (some kind of an email) where the user uploads
(send) a file to another user, or it will just post a file
intended for all users.

2. A user may only view files intended for him or the files
posted publicly.

3. A user may send a message (instant message) to another
user or propagate the message to all other online users as
sort of an announcement.


Do I really need EAServer to accomplish this tasks or just a
database server is enough?

I am afraid of EAServer because i dont have much knowledge
about HTML and Javascript coding. This is very tough for me.

Any inputs are truly appreciated.

Thanks,
Neil


Arthur Hefti Posted on 2007-10-22 03:50:59.0Z
Reply-To: "Arthur Hefti" <arthur@catsoft.ch>
From: "Arthur Hefti" <arthur@catsoft.ch>
Newsgroups: sybase.public.powerbuilder.objects
References: <47144373.4486.1681692777@sybase.com>
Subject: Re: Need of design ideas
Lines: 52
Organization: CATsoft Development GmbH
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: cust.static.213-180-184-33.cybernet.ch
X-Original-NNTP-Posting-Host: cust.static.213-180-184-33.cybernet.ch
Message-ID: <471c1e23$1@forums-1-dub>
Date: 21 Oct 2007 20:50:59 -0700
X-Trace: forums-1-dub 1193025059 213.180.184.33 (21 Oct 2007 20:50:59 -0700)
X-Original-Trace: 21 Oct 2007 20:50:59 -0700, cust.static.213-180-184-33.cybernet.ch
X-Authenticated-User: pb110beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9526
Article PK: 736682

Neil

Why not going with a traditional Client / Server application? The database
acts as container for the files. The advantage is that you don't have to
work with something unknown.

- You can store/retrieve them from the database with UpdateBlob/SelectBlob
and set the security on each item (optional compress the files before
storing).
- You can use tables to store the access information.
- You can use message to client for notifications or create a table with the
notifications that is polled every few seconds

Regards
Arthur

<Neil> wrote in message news:47144373.4486.1681692777@sybase.com...
> Hi,
>
> I have the following requirements and I felt that this is
> tough to accomplish. I hope you can share ideas with me on
> what is the best design to go thru.
>
> This is a client/Server somewhat.
>
> Requirements:
>
> 1. The user should be able to upload/download a file to/from
> the server (some kind of an email) where the user uploads
> (send) a file to another user, or it will just post a file
> intended for all users.
>
> 2. A user may only view files intended for him or the files
> posted publicly.
>
> 3. A user may send a message (instant message) to another
> user or propagate the message to all other online users as
> sort of an announcement.
>
>
> Do I really need EAServer to accomplish this tasks or just a
> database server is enough?
>
> I am afraid of EAServer because i dont have much knowledge
> about HTML and Javascript coding. This is very tough for me.
>
> Any inputs are truly appreciated.
>
> Thanks,
> Neil


Jamal Ahmad Posted on 2007-10-22 02:19:14.0Z
Reply-To: "Jamal Ahmad" <jamal.ahmad@logicacmg.com>
From: "Jamal Ahmad" <jamal.ahmad@logicacmg.com>
Newsgroups: sybase.public.powerbuilder.objects
References: <47144373.4486.1681692777@sybase.com>
Subject: Re: Need of design ideas
Lines: 62
Organization: LogicaCMG
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896
NNTP-Posting-Host: 202.53.35.62
X-Original-NNTP-Posting-Host: 202.53.35.62
Message-ID: <471c08a2@forums-1-dub>
Date: 21 Oct 2007 19:19:14 -0700
X-Trace: forums-1-dub 1193019554 202.53.35.62 (21 Oct 2007 19:19:14 -0700)
X-Original-Trace: 21 Oct 2007 19:19:14 -0700, 202.53.35.62
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9525
Article PK: 736683


<Neil> wrote in message news:47144373.4486.1681692777@sybase.com...
> Hi,
>
> I have the following requirements and I felt that this is
> tough to accomplish. I hope you can share ideas with me on
> what is the best design to go thru.
>
> This is a client/Server somewhat.
>
> Requirements:
>
> 1. The user should be able to upload/download a file to/from
> the server (some kind of an email) where the user uploads
> (send) a file to another user, or it will just post a file
> intended for all users.
>

FTP would be a best option for this. There are many APIs that you can call
for this. If you want to Send and receive email then PB provides built in
functions for it.

> 2. A user may only view files intended for him or the files
> posted publicly.

Ideally this should be managed by OS permissions but if you want to do it
through PB then you will have to implement you DB design for roles and
rights.


>
> 3. A user may send a message (instant message) to another
> user or propagate the message to all other online users as
> sort of an announcement.

Once I done it through sockets. You need to develop a separate socket that
will manage all the these type of request and client will be implemented by
your application or you can have a separate client . It depends on you how
you prefer to manage. An example of socket implementation in win32 is in
codeexchange.


If you want to use EAServer the you can also use its Messaging Queues.



>
>
> Do I really need EAServer to accomplish this tasks or just a
> database server is enough?
>
> I am afraid of EAServer because i dont have much knowledge
> about HTML and Javascript coding. This is very tough for me.

There is nothing to do with HTML and javascript in EAServer particularly in
client server application.
>
> Any inputs are truly appreciated.
>
> Thanks,
> Neil