Hi Tony,
It is a while since I have worked with Delphi so as soon as I get the
time I will re-evaluate, which I have been meaning to do given that I
have seen some really great DB tools for Delphi that I would like to try.
I agree that when access gets used to create lots of small Databases
each with their own Jet back end the result is a horrendous mess. I also
find using Access as a front end to MS SQL Server using the the
recommended path of setting a Access Data project to be surprisingly
clumsy - surprising because the marketing from Microsoft so often
stresses the interaction between these two products as selling points
for both.
That said I have over the last few months completed 3 projects that used
Postgresql as the Data layer and Access 2000 as the Application layer.
First of all SQL Manager's (formerly EMS) Data pump tool and data import
Tool made the upsizing of the access databases to Postgresql far easier
than doing the same to SQL Server.
Secondly the work done on both the ODBC driver and the Windows port
resulted in close to completely trouble free development - the only
gotcha was ensuring that the ODBC timeout registry key needs to be
changed. Kudos to the ODBC team on a really great overhaul, and Kudos to
everyone who have made the Windows native port so much better than
anyone had a right to expect in the first version.
The installed base for Access is huge, the awareness of it's limitations
as a storage engine as opposed to client is widespread, the migration to
a two tier solution using SQL Server remains clumsy and fraught with
pitfalls, not to mention expensive. In addition even though almost none
of these Businesses are actually on selling the solution that they have
developed in house, all of them would like to retain the option to do
so, and migrating to SQL Server creates significant problems in that
regard. The BSD license, once explained becomes a big selling point for
a Postgresql solution.
So whilst I would be the last to in any way doubt the fitness of Delphi
for many of these tasks, I would disagree that Access is evil - in
circumstances like those outlined above the easy marriage of Postgresql
and Access could lead to much greater Ubiquity in the SME space. The
simple fact is that these are often business on a tight budget - and
every development minute that is saved does make a difference.
Cheers
Johan Wehtje
Tony Caduto wrote:
<With some add on tools Delphi comes close, but it is still nowhere near
as quick as Access to build a bunch of forms , pump data into
spreadsheets, charts, word processing applications. It is often little
things that make the difference - the speed with which drop down lists
can be created is a huge boon to an access developer when the business
needs an app that really does speed the workflow of their transactional
staff. >
Hi John,
Delphi is actually excellent, and while it has a slightly higher
learning curve than Access, it provides a flexibility that is
unmatched. When it comes to database development there is nothing
better IMHO :-)
Access is for business analysts and such who can't/don't want to
program, at least that is how it is used at the company I work for, and
they(the business analysts) have dug themselves into a deep hole, they
now have over 1000 little access applications floating around and they
don't know what half of them do anymore. If they would have done it the
right way they could have had a central data warehouse in PG and thin
clients built with Delphi and/or combined with Intraweb.
Another option that is starting to look really good is Lazarus
(http://www.lazarus.freepascal.org/) Zeos lib is available for it
http://www.zeoslib.net and it provides a very very very similar
experience to Delphi.
From my experience it is best to stay away from Access for application
development if can.It does have it's place but I consider it a "evil"
way of getting the job done.
Later,
Tony Caduto
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
