[Rockhounds] Database template?

Julie Siebel julie at pandemoniumgraphics.com
Fri Oct 24 15:30:41 PDT 2008 

Ahhh, so logically, I should store the path of the image, and then build 
some .asp pages or whatever to display the picture with the data? THAT I 
know how to do - lol. Or perhaps Access just displays those...I know that 
SQL server doesn't.

Sadly, no, I don't know what normalization is. I'm a generalist and can 
write some very complex queries, but I work in databases for 2 days, web 
scripting for 10 days, creating images/etc. for 5 days, doing tech support 
for 3 days, then perhaps back to a database for a day...you get the idea.

I'll look it up, though. Always good to learn new stuff. Generally, I create 
pretty efficient tables in SQL server when I have to...but that's SQL 
server, which is *mostly* built for efficiency.

So far as how big this thing will be - lol - I haven't a clue. We have lots 
of stuff, from yard rocks to exquisite cabinet specimens, most of which 
we've collected ourselves...probably a much larger count of yard rocks than 
cabinet specimens, if you see what I mean.

My thought - and always my thought where technology is concerned - is to 
build stuff as fast as it can be while be as expandable as you will likely 
need. (I still try to keep webpage sizes, max, wherever possible, at 2-3 
rings of a telephone at dial up speed - 40k-60k.) So I'd rather err on the 
large side and as efficient as possible, instead of having to redo it later. 
One nice thing about using Access is (John, I love ya, honest) that John is 
likely to change his mind about what mineral information he wants stored, 
and Access is fairly easy to modify.

I spend quite a bit of time on MSDN for other reasons...I'll take a peek.

Thanks!

Julie



----- Original Message ----- 
From: "J Bryan Kramer" <codeburner at gmail.com>
To: "Rockhounds at drizzle.com: A mailing list for rock and gem collectors" 
<rockhounds at lists.drizzle.com>
Sent: Friday, October 24, 2008 3:11 PM
Subject: Re: [Rockhounds] Database template?


You just pick the right variable type for photos, it's actually better to
store photos out of the db and just store the address of the photos. I'd
have to dig thru the help files on MSDN but it isn't hard to do.

It is very important to thing thru the table structure before building the
db tho. I don't know if you are familiar with normalization but using at
least a couple of levels of normalized tables is a good idea. If you expect
this to be a moderately large db, for smaller db's it really doesn't make a
lot of difference.

I think I only have the current version of access on this computer and I'm
off to the NAS Jacksonville airshow tomorrow or I might be able to set
something up for you easily.


BK

On Fri, Oct 24, 2008 at 17:36, Julie Siebel
<julie at pandemoniumgraphics.com>wrote:

> Well, I'm just trying to figure out a logical sort of format for John. I
> *have* Access (free from Microsoft for a beta test for another app - lol),
> but I haven't worked in it much for the last 5 years, because my main 
> client
> (that's the person kind of client, not the web kind ;) uses SQL Server.
>
> I know that it's possible to display pictures in Access, though I'm not
> really clear of the "how" of it.
>
> John wants to store a picture, with a mineral name, secondary name/habit,
> three locations (site, county, state), date collected, date purchased (for
> purchased minerals), and if it was a trade or whatever, who he got it 
> from.
> And a "notes" field, of course.
>
> He's not looking for chemical formulas or anything - just a pretty generic
> DB. I was hoping someone out there had a template that I could just 
> modify.
>
> Thanks,
>
> Julie
>
>
>
>
> ----- Original Message ----- From: "J Bryan Kramer" <codeburner at gmail.com>
> To: "Rockhounds at drizzle.com: A mailing list for rock and gem collectors" <
> rockhounds at lists.drizzle.com>
> Sent: Friday, October 24, 2008 2:22 PM
> Subject: Re: [Rockhounds] Database template?
>
>
> I don't recall anything detailed about using MS Access there was some
> general talk about databases and someone had written one. I have done some
> Access work(tho it's been awhile), what do you need to know?
>
> BK
>
> On Fri, Oct 24, 2008 at 17:10, Julie Siebel
> <julie at pandemoniumgraphics.com>wrote:
>
>  John was asking me about putting pictures/mineral information in MS 
> Access
>> (we have Access 2003). He swears there was a long discussion about that 
>> on
>> the list in the past six months, but I can't find it. (I may be being
>> deceived by the email headers - lol - but I *am* searching.) Anyone
>> remember
>> when that happened?
>>
>> Thanks,
>>
>> Julie
>>
>>
>> --
>> _______________________________________________
>> Rockhounds at drizzle Mailing List
>> Subscription Services:
>> http://lists.drizzle.com/mailman/listinfo/rockhounds
>> List Home Page, with a link to the List Usage Policy:
>> http://www.eclecticlapidary.com/Rockhounds/index.html
>>
>>
>
>
> --
>
>
> "The thunderbolt falls on an inch of ground; but the light of it fills the
> horizon."
>
>                      Ralph Waldo Emerson
>
> J Bryan Krämer
> North Florida, USA
> photos at:
> http://pbase.com/photoburner
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>  text/plain (text body -- kept)
>  text/html
> ---
> --
> _______________________________________________
> Rockhounds at drizzle Mailing List
> Subscription Services:
> http://lists.drizzle.com/mailman/listinfo/rockhounds
> List Home Page, with a link to the List Usage Policy:
> http://www.eclecticlapidary.com/Rockhounds/index.html
>
> --
> _______________________________________________
> Rockhounds at drizzle Mailing List
> Subscription Services:
> http://lists.drizzle.com/mailman/listinfo/rockhounds
> List Home Page, with a link to the List Usage Policy:
> http://www.eclecticlapidary.com/Rockhounds/index.html
>



-- 


"The thunderbolt falls on an inch of ground; but the light of it fills the
horizon."

                       Ralph Waldo Emerson

J Bryan Krämer
North Florida, USA
photos at:
http://pbase.com/photoburner


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---
-- 
_______________________________________________
Rockhounds at drizzle Mailing List
Subscription Services:
http://lists.drizzle.com/mailman/listinfo/rockhounds
List Home Page, with a link to the List Usage Policy:
http://www.eclecticlapidary.com/Rockhounds/index.html

More information about the Rockhounds mailing list