Database Applications
Joe Pollock
josephj at adelphia.net
Tue Jun 5 09:21:36 EDT 2001
This is a multi-part message in MIME format.
------=_NextPart_000_0043_01C0EDA0.EB652AC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thanks. I value your opinion.
I'm looking for overall guidance and direction as to what
tools to use and what approach to take. To that end, I am providing you
with quite a bit of background information to start with.
Long ago and far away, I studied rdbms' in school when they were very =
new -
mid '70's. I was a professional programmer/analyst for 17 years and now =
I
am desperately trying to become an end user <g>. Ideally, I want to =
work in
an environment that does everything for me, but that lets me get in and
change things when it (invariably) doesn't do it the way I want it.
What I want to do:
Most of what I want to do now are very simple single user (me) =
applications.
Stuff like cataloging CD's, books, and audio tapes. Later, I will want =
to
run a small business with a mail order / web catalog and client =
database.
Off the shelf for most of it would be great. I don't like reinventing
wheels.
Right now, I'm studying Holistic Health and I have a list (printed only) =
of
about 1000 remedies that I need to get into machine readable / =
searchable
form. I've designed the basic tables I'll need on paper and set it up =
so I
can expand it easily to include recommendations to (future) clients and
tracking of what they actually take or buy. Eventually, I may want to =
build
a database of herbs as well. Herbs, etc. are difficult to deal with =
because
there are so many of them and it's just a ton of memorization - a =
perfect
application for a database - especially since, if I roll my own, I can =
add
my own comments and notes, etc. to it.
If I can get this nice enough, I might want to sell it as a limited =
market
product to other practitioners, so that part would probably have to run =
in
Windoz and be as stand-alone and inexpensive as possible. But right =
now, I
just want to get it to work for me. Later, I can export the data to =
another
product etc. if I have to.
What I have now:
I am running Windoz 98se and have just installed Access 2000. I also =
have
Sybase SQL Anywhere 6.0 still in shrink wrap.
I am also running (dual boot) Red Hat 7.0 which I am about to replace =
with
Mandrake 8.0.
Under Red Hat, I was able to install mysql, but couldn't figure out
Postgresql.
When I got mysql installed, I was kind of disappointed because it was =
"just
a database". It had no application components to it - like forms, =
reports,
and programming logic, etc.
What I know:
I bought and read Mastering SQL (Linux edition), so I have some
understanding of what SQL is and does. I have programmed in many =
languages
including a bit of C, but not C++. I understand the basic concepts of
object oriented programming, but have never done any (and don't really =
want
to learn it if I don't have to.) Ditto for HTML and web programming. =
In
the distant past, I had some battles with dBase II and III as well as =
with
Paradox 3.0 (I didn't win too many of them <g>.)
Thanks for your time. Any suggestions you may have will be appreciated.
Joe
----- Original Message -----=20
From: frank pirrone=20
To: nflug at nflug.org=20
Sent: Monday, June 04, 2001 10:36 PM
Subject: Re: Database Applications
Joe Pollock wrote:=20
Anyone familiar with database *applications* (under linux or =
Windoz)? I'd like to discuss some issues by email etc. that are not =
relevant to this list. Thanks. Joe
Go ahead, Joe=20
Frank=20
------=_NextPart_000_0043_01C0EDA0.EB652AC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4613.1700" name=3DGENERATOR></HEAD>
<BODY bgColor=3D#ffffff>
<DIV>Thanks. I value your opinion.</DIV>
<DIV> </DIV>
<DIV>I'm looking for overall guidance and direction as to what<BR>tools =
to use=20
and what approach to take. To that end, I am providing you<BR>with =
quite a=20
bit of background information to start with.<BR><BR>Long ago and far =
away, I=20
studied rdbms' in school when they were very new -<BR>mid '70's. I =
was a=20
professional programmer/analyst for 17 years and now I<BR>am desperately =
trying=20
to become an end user <g>. Ideally, I want to work in<BR>an=20
environment that does everything for me, but that lets me get in =
and<BR>change=20
things when it (invariably) doesn't do it the way I want it.<BR><BR>What =
I want=20
to do:<BR><BR>Most of what I want to do now are very simple single user =
(me)=20
applications.<BR>Stuff like cataloging CD's, books, and audio =
tapes. =20
Later, I will want to<BR>run a small business with a mail order / web =
catalog=20
and client database.<BR>Off the shelf for most of it would be =
great. I=20
don't like reinventing<BR>wheels.<BR><BR>Right now, I'm studying =
Holistic Health=20
and I have a list (printed only) of<BR>about 1000 remedies that I need =
to get=20
into machine readable / searchable<BR>form. I've designed the =
basic tables=20
I'll need on paper and set it up so I<BR>can expand it easily to include =
recommendations to (future) clients and<BR>tracking of what they =
actually take=20
or buy. Eventually, I may want to build<BR>a database of herbs as=20
well. Herbs, etc. are difficult to deal with because<BR>there are =
so many=20
of them and it's just a ton of memorization - a perfect<BR>application =
for a=20
database - especially since, if I roll my own, I can add<BR>my own =
comments and=20
notes, etc. to it.<BR><BR>If I can get this nice enough, I might want to =
sell it=20
as a limited market<BR>product to other practitioners, so that part =
would=20
probably have to run in<BR>Windoz and be as stand-alone and inexpensive =
as=20
possible. But right now, I<BR>just want to get it to work for =
me. =20
Later, I can export the data to another<BR>product etc. if I have=20
to.<BR><BR>What I have now:<BR><BR>I am running Windoz 98se and have =
just=20
installed Access 2000. I also have<BR>Sybase SQL Anywhere 6.0 =
still in=20
shrink wrap.<BR><BR>I am also running (dual boot) Red Hat 7.0 which I am =
about=20
to replace with<BR>Mandrake 8.0.<BR><BR>Under Red Hat, I was able to =
install=20
mysql, but couldn't figure out<BR>Postgresql.<BR><BR>When I got mysql =
installed,=20
I was kind of disappointed because it was "just<BR>a database". It =
had no=20
application components to it - like forms, reports,<BR>and programming =
logic,=20
etc.<BR><BR>What I know:<BR><BR>I bought and read Mastering SQL (Linux =
edition),=20
so I have some<BR>understanding of what SQL is and does. I have =
programmed=20
in many languages<BR>including a bit of C, but not C++. I =
understand the=20
basic concepts of<BR>object oriented programming, but have never done =
any (and=20
don't really want<BR>to learn it if I don't have to.) Ditto for =
HTML and=20
web programming. In<BR>the distant past, I had some battles with =
dBase II=20
and III as well as with<BR>Paradox 3.0 (I didn't win too many of them=20
<g>.)<BR><BR>Thanks for your time. Any suggestions you may =
have will=20
be appreciated.<BR><BR>Joe<BR></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A title=3Dfpirrone at localnet.com =
href=3D"mailto:fpirrone at localnet.com">frank=20
pirrone</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A title=3Dnflug at nflug.org=20
href=3D"mailto:nflug at nflug.org">nflug at nflug.org</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Monday, June 04, 2001 =
10:36=20
PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Re: Database =
Applications</DIV>
<DIV><BR></DIV>Joe Pollock wrote:=20
<BLOCKQUOTE TYPE=3D"CITE">
<STYLE></STYLE>
Anyone familiar with database *applications* (under linux or =
Windoz)? =20
I'd like to discuss some issues by email etc. that are not relevant =
to this=20
list. Thanks. Joe</BLOCKQUOTE>Go ahead, Joe=20
<P>Frank </P></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0043_01C0EDA0.EB652AC0--
More information about the nflug
mailing list