On Jul 30, 2006, at 5:37 PM, Ashutosh wrote:
Currently I have a windows application that deals with reading and
writing patient information. At this moment each patient has its
individual ascii file and I use the fread and fwrite to read and write
files respectively. After being in existence for 6 years now, I feel
strongly to moving towards a database option where patient information
will reside in a database and reading and writing would be handled by
Insert, Edit & Select statement. Our primary users are pharmacist and
doctors who are not very computer savy.
I am interested in using PostGreSql database. Thus, my question
arises,
if I used PostGreSql Database and provide it with my application will
the user need to install any drivers at their end or do I provide
library files along with the application to serve as postgresql
engine.
This is my first question on this newsgroup so if I am not explained
the issue properly please let me know.
Generally, your application would be linked to the libpq library
(http://www.postgresql.org/docs/8.1/interactive/libpq.html) which
would enable it to access PostgreSQL anywhere on the network without
installing anything except your application.
But PostgreSQL is a client/server database and the difference between
managing some ASCII files and a database server is large in terms of
setup and management. If you just need an embedded database for
single user access, something like SQLite would be a better choice
(http://sqlite.org/).
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
