Hi,
At work I was assigned the task of migrating a
very large (and very unmanageable) MS Access
database to a solution that would be massively
scalable and support a number of simultaneous
users and features.[1]
After lengthy study I concluded that Postgresql
running on OpenBSD would be ideal[2]. So now I
am designing and implementing programs to allow a
number of clients to connect to the database over
the network.[3]
I was wondering if anybody could recommend good
books, resources, references, or otherwise
general starting points to help steer me in the
right direction? I've been through the docs and
at this point am just trying to remember
everything (it's quite overwhelming!) But any
suggestions to make the life of a postgres noob
easier would be welcomed. =)
Thanks,
Dan Anderson
Lab Rat and Helper Monkey
Great Lakes Industries, Inc.
[1] I've already figured out that I can save MS
Access files as text and COPY them to the
postgres database.
[2] The discussion of exactly why I chose
OpenBSD and Postgresql is beyond the scope of
this e-mail, but I would be more then happy to
discuss/debate/explain why to anybody who e-mails
me. (dan3487@yahoo.com)
[3] Suffice it to say each and every OpenBSD box
needs to completely automate connection to the
database (including the use of barcode scanners)
at a number of different points across the floor,
all connected via 802.11b. So my job is to
design a system and code it to make it work.
__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com
