Re: Fwd: Stalled post to pgsql-general

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
>