Official Luthiers Forum!

Owned and operated by Lance Kragenbrink
It is currently Wed Aug 13, 2025 3:50 pm


All times are UTC - 5 hours


Forum rules


Be nice, no cussin and enjoy!




Post new topic Reply to topic  [ 17 posts ] 
Author Message
 Post subject: Database program
PostPosted: Mon Sep 20, 2010 9:17 am 
Offline
Contributing Member
Contributing Member
User avatar

Joined: Sat Jul 19, 2008 11:07 am
Posts: 802
Location: Cobourg ON
First name: Steve
Last Name: Denvir
City: Baltimore
State: ON
Zip/Postal Code: K0K 1C0
Country: Canada
Focus: Build
Status: Amateur
Does anyone know of a freeware/shareware database program for Mac that I could use to log info as I build? I'd like to keep an easily accessible record of things like weight at various stages, stiffness, etc. It'd also be nice if it could accommodate photos.

Thanks in advance

Steve


Top
 Profile  
 
 Post subject: Re: Database program
PostPosted: Mon Sep 20, 2010 10:06 am 
Offline
Contributing Member
Contributing Member
User avatar

Joined: Mon Mar 19, 2007 7:05 am
Posts: 9191
Location: United States
First name: Waddy
Last Name: Thomson
City: Charlotte
State: NC
Focus: Build
Status: Semi-pro
Steve, check out http://porting.openoffice.org/mac/ I have only had experience with the Windows version, but it is an open source office suite much like Windows Office Suite, that includes a Word processing program, Database, Spreadsheet, etc, etc, etc. All of which act much like Windows Office in look feel and compatibility.

_________________
Waddy

Photobucket Build Album Library

Sound Clips of most of my guitars


Top
 Profile  
 
 Post subject: Re: Database program
PostPosted: Mon Sep 20, 2010 10:19 am 
Offline
Contributing Member
Contributing Member

Joined: Sat Aug 25, 2007 2:05 am
Posts: 685
Location: Saint Petersburg, Florida
First name: Glenn
Last Name: LaSalle
City: Saint Petersburg
State: Florida
Status: Amateur
I was actually thinking about this the other day. I have Bento, an easy to use - and cheap ($49) - database software for the MAC that has some nice templates already that can be modified easily for guitar building use. It is real easy to use as well.

Glenn


Top
 Profile  
 
 Post subject: Re: Database program
PostPosted: Mon Sep 20, 2010 10:33 am 
Offline
Koa
Koa
User avatar

Joined: Wed Dec 07, 2005 9:08 am
Posts: 535
First name: Pete
Last Name: Liccardello
City: Eden Prairie
State: Minnesota
Go to Google Docs and search for database templates to see what formats others have developed for their personal use. You are bound to find something close and then customize it to your needs. It's free and the software and your files are stored on their (Google's) servers making them accessible from any computer you are using at the time; also great to ensure that your files are backed-up and intact rather than run the risk of losing data to a local crash. This is true 'cloud' computing and probably the wave of the future.

_________________
Peter


Top
 Profile  
 
 Post subject: Re: Database program
PostPosted: Mon Sep 20, 2010 11:02 am 
Offline
Brazilian Rosewood
Brazilian Rosewood
User avatar

Joined: Tue May 02, 2006 9:02 am
Posts: 2351
Location: Canada
First name: Bob
Last Name: Garrish
City: Toronto
State: Ontario
Country: Canada
Status: Professional
I quit OSX quite soon into my Macbook Pro owning career, but I have Bento on my iPad so I've got a feel for it. Note, of course, that I might be completely off on how the desktop version works so everything I say is in reference to the version I have.

Bento is either the perfect tool, or completely useless, depending on how you use your spreadsheets. It's sort of a virtual stack of forms so it doesn't really have any ability to process data like a more traditional spreadsheet, but the interface is very nice for recording the data. If your plan is essentially to replace having a stack of one or two page records of the basic stats of your builds then it's perfect for that. Looking at a screen shot will pretty much give you the whole idea.

If you were wanting to do a bit more complex stuff, like having auto-calculations, or there was lots of data kept on each build, then I'd use a 'full' spreadsheet program like OpenOffice or such. Not as sleek to work with, but it won't slow you down if you have a lot of data entry to do.

I use Office2HD on the iPad now, and sync it with Google docs, but my database use very quickly fell into that second category no matter how much I liked the Bento interface. Short story is that Bento is nicer to work with, if it can do everything you need it to.

_________________
Bob Garrish
Former Canonized Purveyor of Fine CNC Luthier Services


Top
 Profile  
 
 Post subject: Re: Database program
PostPosted: Mon Sep 20, 2010 11:07 am 
Offline
Cocobolo
Cocobolo
User avatar

Joined: Tue Mar 17, 2009 10:22 am
Posts: 393
First name: Martin
Last Name: Lane
City: Grand Rapids
State: Michigan
Focus: Build
With blogger, you can have a private blog, that won't be indexed by search engines. The text is searchable, and you can have photos in there too.

I have one with a bunch of junk on it. You'd never find it, even if you looked for it. But if I sent you the URL, you could see it. This feature might be of benefit to a builder, especially one with clients.

_________________
"...you have to get over your strict adherence to your largely imagined notion of absolute perfection..."


Top
 Profile  
 
 Post subject: Database program
PostPosted: Mon Sep 20, 2010 9:18 pm 
Offline
Brazilian Rosewood
Brazilian Rosewood
User avatar

Joined: Wed Feb 20, 2008 9:12 pm
Posts: 6994
First name: Mike
Last Name: O'Melia
City: Huntsville
State: Alabama
Focus: Build
Status: Semi-pro
Where IS that serenity prayer when I need it?


Top
 Profile  
 
 Post subject: Re: Database program
PostPosted: Mon Sep 20, 2010 10:28 pm 
Offline
Cocobolo
Cocobolo

Joined: Sat May 02, 2009 10:53 pm
Posts: 250
First name: Mitch
Last Name: Johnson
City: Little Falls
State: Minnesota
Zip/Postal Code: 56345
Country: USA
Focus: Build
Status: Amateur
I don't think they have a mac verion, but I was looking at this the other day..........http://www.whistlingfishsoftware.com.au ... kbench.htm Looks to have some good stuff.


Top
 Profile  
 
 Post subject: Re: Database program
PostPosted: Mon Sep 20, 2010 10:46 pm 
Offline
Koa
Koa
User avatar

Joined: Thu Feb 24, 2005 4:53 am
Posts: 1584
Location: PA, United States
rats, I had a link on ebay for a software driven deal that is a luthier's journal. Could be helpful for setting up your own fields. I 'll try to locate it. SOMEONE must have also seen it a few months ago...


Top
 Profile  
 
 Post subject: Re: Database program
PostPosted: Mon Sep 20, 2010 11:06 pm 
Offline
Contributing Member
Contributing Member
User avatar

Joined: Wed Jan 13, 2010 12:46 am
Posts: 1247
First name: Beth
Last Name: Mayer
City: Tucson
State: AZ
Country: United States
Focus: Build
Status: Amateur
I use Openoffice and create my own spreadsheet. Only have to do the main fields once, then save each document as you create a new instrument. I'm currently building 2 instruments at once, so I have both on one spreadsheet. I'm no tech geek, and even I can do it!


Top
 Profile  
 
 Post subject: Re: Database program
PostPosted: Mon Sep 20, 2010 11:31 pm 
Offline
Mahogany
Mahogany

Joined: Wed May 23, 2007 4:19 am
Posts: 70
Location: United States
Wouldn't a 3-ring binder do the same thing?

Pretty much drop resistant and sawdust-proof.

Just a thought.


Top
 Profile  
 
 Post subject: Re: Database program
PostPosted: Tue Sep 21, 2010 6:12 am 
Offline
Mahogany
Mahogany
User avatar

Joined: Sat Feb 09, 2008 1:40 pm
Posts: 91
Location: Orangeville Ont. Canada
Hi Steve

I'll put another vote in for Bento. I've been using it for a couple of
years now & wouldn't be without it.
As Bob G points out, it is not a spreadsheet program, but the desktop
version does have the ability to do some basic calculations.
The value I see in it is it's ability to act kind of like a central command centre
for lack of a better word.
From your database you can design various form pages to collect data.
For example
A page showing every detail of the guitar - material,width @ nut etc. and including pics
from all angles.
A page dedicated to bracing details only, including a labelled pic, for ex.
A page linked to all email correspondence pertinent to the particular instrument
(Bento has a data field that links directly to Mail)
A checklist page for ensuring that either you have or have ordered all components.

You can also insert fields anywhere, linked to Address Book,iCal or an IM account.
A bit of a learning curve, but once you get your head around it, it's easy.

The program has the ability to export templates for use by other Bento users.
Mine is work in progress, but I'd be happy to share it with you ( or anyone else)
should you decide to give it a try. It is a 1.3meg file, so it there is any interest
I'd have to figure out how to send it.

Cheers
Bob Hames


Top
 Profile  
 
 Post subject: Re: Database program
PostPosted: Tue Sep 21, 2010 8:43 am 
Offline
Contributing Member
Contributing Member
User avatar

Joined: Sat Jul 19, 2008 11:07 am
Posts: 802
Location: Cobourg ON
First name: Steve
Last Name: Denvir
City: Baltimore
State: ON
Zip/Postal Code: K0K 1C0
Country: Canada
Focus: Build
Status: Amateur
Hi Bob, I'd love to have a look at your template. 1.3 megs shouldn't be a problem. Could you please send it to me at stevedenvir@gmail.com.

Thanks

Steve


Top
 Profile  
 
 Post subject: Database program
PostPosted: Tue Sep 21, 2010 9:28 pm 
Offline
Brazilian Rosewood
Brazilian Rosewood
User avatar

Joined: Wed Feb 20, 2008 9:12 pm
Posts: 6994
First name: Mike
Last Name: O'Melia
City: Huntsville
State: Alabama
Focus: Build
Status: Semi-pro
You guys are such nerds! And this is coming from a self proclaimed nerd! :)


Top
 Profile  
 
 Post subject: Re: Database program
PostPosted: Tue Sep 21, 2010 10:55 pm 
Offline
Cocobolo
Cocobolo

Joined: Sat May 02, 2009 10:53 pm
Posts: 250
First name: Mitch
Last Name: Johnson
City: Little Falls
State: Minnesota
Zip/Postal Code: 56345
Country: USA
Focus: Build
Status: Amateur
Terry,
The link I posted was a sponsored link on ebay. Sounds like the same one you had in mind. Just trying to save you the trouble of trying to figure it out.


Top
 Profile  
 
 Post subject: Re: Database program
PostPosted: Wed Sep 22, 2010 2:56 pm 
Offline
Cocobolo
Cocobolo
User avatar

Joined: Thu Aug 13, 2009 4:32 pm
Posts: 480
First name: John
Last Name: Charnock
Country: UK
Focus: Build
Status: Amateur
I would use a blog and add photographs and video - much better to see pictures and video of your progress - you can also keep a diary of your thoughts as well as those important dimensions etc etc

J


Top
 Profile  
 
 Post subject: Re: Database program
PostPosted: Wed Sep 22, 2010 5:38 pm 
Offline
Contributing Member
Contributing Member

Joined: Sun Jan 10, 2010 11:40 am
Posts: 764
First name: wes
Last Name: Lewis
City: Garland
State: Tx.
Zip/Postal Code: 75044
Focus: Build
I use open office office...do it in a newletter style..adding notes on where I goofed up and how to avoid them next time...

Lots of notes!!!!!! [headinwall]

_________________
MK5acoustics.com


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 17 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 41 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group
phpBB customization services by 2by2host.com