Re: Fwd: Stalled post to pgsql-general

help
Hi,
It would work fine to have a web interface in case the
application could be developed with that...  In fact,
we had started working on the project with PG and Java
Servlets et al...  However, we ran into problems after
a month of designing and actual implementaiton work
was over only because the browser / HTML is too
static...
a.  Extensive coding is reqd. for datatypes
validations on all forms and reports for filtering,
etc.
b.  Added functionality would result in havoc for
adding features like Grids as in MS-Access like
forms-subforms and browsing thru such records in order

c.  Non-use of client-side processing capacity i.e.,
under-utilisation and over-burdening the server which
would in case of client-server be just handling data
which would make it much more reliable
d.  The client would not shell out a single penny when
I tell him that two servers would be ideal for him...
One for handling data the other for handling http
requests
e.  Moving away from Windows is impossible fof him...
He has not heard that there is any other OS other than
Windows
f.  The client is not a jackass...  I cant conn him...
 He knows what all he wants in his software
g.  I am keen on PG/Interbase
h.  I KNOW YOU CAN HELP... SO, KINDLY DO
i.  This MS-Office interface you are talking about...
That would involve a lot of wizardry/programming...

Thanx
Kapil

--- Mark Cowlishaw <markc@ot.com.au> wrote: >
> I was asked to develop a reasonably large database
> application for my
> company intranet. My boss comes from a heavily
> windows background and wanted
> it all developed in MS Access etc but we're
> basically a UNIX house and I
> knew that would cause havoc with the software
> developers around here (and
> myself) who much prefer the UNIX way of doing things
> (and oftentimes run
> Linux as their Desktop OS).
>
> What did I do? I developed the application using a
> PostgreSQL backend with a
> web interface (I used Perl for rapid development,
> but would have preferred
> Java Servlets), and then used the ODBC drivers to
> connect Access to allow
> MSOffice automation and custom queries within Access
> so the boss can create
> his custom reports if he likes. Now I have the best
> of all worlds: Reliable
> backend (PostgreSQL), a platform neutral frontend
> (Web Interface) and Office
> automation through ODBC.
>
> Works for me!
>
>
> ----- Original Message -----
> From: "The Hermit Hacker" <scrappy@hub.org>
> To: "Kapil Tilwani" <tilwani@yahoo.co.uk>
> Cc: <pgsql-general@postgresql.org>
> Sent: Friday, February 16, 2001 4:54 AM
> Subject: Re: Fwd: Stalled post to pgsql-general
>
>
> >
> > Have you looked at the available ODBC drivers?
> >
> > On Thu, 15 Feb 2001, [iso-8859-1] Kapil Tilwani
> wrote:
> >
> > > help
> > > Hi,
> > >
> > > I am a fresh graduate from India in commerce and
> do
> > > know a little about programming using VB, Java
> and
> > > Oracle...  I, along with 5 more friends, have
> received
> > > a small-time project (small for u guys, major
> for us)
> > > for developing a small application
> > >
> > > We are considering one of the foll.options
> > > A. Totally Linux
> > >    a. Only option is using Swings and
> Postgres/MySQL
> > >    Though this would technically be the best
> option...
> > >  But, in India, it is like only Windows is the
> > > well-known client-side operating system
> > >
> > > B. Norma for Indian
> > >    a. Linux Server and Windows client
> > >    b. Windows Server and Windows client
> > >
> > > Here, my problem is a very simple one...  I need
> to
> > > put my Postgres on a Windows server (this is
> > > optional... I can convince my project-giver to
> go in
> > > for a Linux server) ...
> > > However, I have a problem in that at least my
> clients
> > > would all be Windows-based... So, how do I
> install the
> > > clients... Can I get some kind of wizarded- .exe
> file
> > > for that... and where?
> > > Also, how do I make the connection between the
> Windows
> > > Server and the client... How do I specify...
> please
> > > could u send details rather than a quick
> overview ...
> > > It would be highly appreciative
> > > Lastly, is it possible to have a Linux as a
> server and
> > > the Windows clients interacting with this
> server...
> > > and pleaaaaaaseeeee plz tell me how to do
> that...  If
> > > possible, please be descriptive and help me to
> do
> > > that...
> > >
> > > All I can say is that I will pay back to the
> community
> > > all the favours and more...  PLEASE HELP... YOU
> CAN
> > > NOT REALLY MAKE OUT HOW FRUSTRATING THIS IS
> BECOMING
> > >
> > > Also, could u just give me yr unofficial
> comments on
> > > Interbase... Is it good enough?  ...or MySQL for
> that
> > > matter?
> > >
> > > Are there any free downloadable development
> packages
> > > for Postgres and Java...  Something better than
> Forte
> > > for Java
> > >
> > > Thanx
> > > Kapil
> > >
> > > P.S. : Where am I reqd. to post my queries
> related to
> > > Postgres, Java , Interbase...
> > >
> > >
> > > --- The Hermit Hacker <scrappy@hub.org> wrote: >
> > > > could you resend the original?  I tried to
> read
> > > > through what you tried to
> > > > post, and couldn't get past line one before it
> got
> > > > all jumbled :(
> > > >
> > > >
> > > > On Wed, 14 Feb 2001, [iso-8859-1] Kapil
> Tilwani
> > > > wrote:
> > > >
> > > > > help
> > > > >
> > > > > As per the advice of Mr. Bruce M. , I sent
> my mail
> > > > to
> > > > > pgsql-general@postgresql.org and
> > > > > majordomo@postgresql.org, but every mail is
> > > > bouncing
> > > > > back... Please help
> > > > >
> > > > >
> > > > > Note: forwarded message attached.
> > > > >
> > > > >
> > > > > =====
> > > > > Better Late than Never - Drive Safely...!!
> > > > > One Life One Partner - One Result =
> Happiness +
> > > > Security !!
> > > > >
> > > > > From Kapil C. Tilwani
> > > > >
> > > > >
> > > >
> > >
>
____________________________________________________________
> > > > > Do You Yahoo!?
> > > > > Get your free @yahoo.co.uk address at
> > > > http://mail.yahoo.co.uk
> > > > > or your free @yahoo.ie address at
> > > > http://mail.yahoo.ie
> > > >
> > > > Marc G. Fournier                   ICQ#7615664
> > > >         IRC Nick: Scrappy
> > > > Systems Administrator @ hub.org
> > > > primary: scrappy@hub.org           secondary:
> > > > scrappy@{freebsd|postgresql}.org
> > > >
> > >
> > >
> > > =====
> > > Better Late than Never - Drive Safely...!!
> > > One Life One Partner - One Result = Happiness +
> Security !!
> > >
> > > From Kapil C. Tilwani
> > >
> > >
>
____________________________________________________________
> > > Do You Yahoo!?
> > > Get your free @yahoo.co.uk address at
> http://mail.yahoo.co.uk
> > > or your free @yahoo.ie address at
> http://mail.yahoo.ie
> > >
> >
> > Marc G. Fournier                   ICQ#7615664
>           IRC Nick:
> Scrappy
> > Systems Administrator @ hub.org
> > primary: scrappy@hub.org           secondary:
> scrappy@{freebsd|postgresql}.org
> >
>


=====
Better Late than Never - Drive Safely...!!
One Life One Partner - One Result = Happiness + Security !!

From Kapil C. Tilwani

____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie