Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Mac Applications / December 2007



Tip: Looking for answers? Try searching our database.

Simple free database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Peter James - 05 Dec 2007 16:35 GMT
With Apple announcing that they are no longer going to supply Works with
new versions of the OS can anyone supply the name of a simple database
that's free to download and use.

I only want it for things like Xmas card lists, and records of CD's and
DVD's and addresses.  Thanks
Tim Streater - 05 Dec 2007 16:49 GMT
> With Apple announcing that they are no longer going to supply Works with
> new versions of the OS can anyone supply the name of a simple database
> that's free to download and use.
>
> I only want it for things like Xmas card lists, and records of CD's and
> DVD's and addresses.  Thanks

Xmas card lists you can do with Address Book. You choose which label
format to use, in the print dialogue. Dunno about the other.
Peter James - 05 Dec 2007 18:56 GMT
> > With Apple announcing that they are no longer going to supply Works with
> > new versions of the OS can anyone supply the name of a simple database
[quoted text clipped - 5 lines]
> Xmas card lists you can do with Address Book. You choose which label
> format to use, in the print dialogue. Dunno about the other.
Thank you.  As a Mac newbie I never knew I could use the Address Book
for that.  Many thanks.
BreadWithSpam@fractious.net - 05 Dec 2007 16:51 GMT
> With Apple announcing that they are no longer going to supply Works with
> new versions of the OS can anyone supply the name of a simple database
> that's free to download and use.

If a spreadsheet will get the job done, you can use
any of several free variations (ie. google apps,
NeoOffice/J.

Apple will apparently be releasing (it's in "trial" now)
a personal database application called Bento sometime soon.
See http://bentotrial.com and maybe google for "bento database"
and read some of the articles which come up.

Unfortunately, most of the rest of DB apps out there are
either commercial or more complex than appropriate for
average end users (ie. MySQL, etc).  

Signature

Plain Bread alone for e-mail, thanks.  The rest gets trashed.
No HTML in E-Mail! --    http://www.expita.com/nomime.html
Are you posting responses that are easy for others to follow?
  http://www.greenend.org.uk/rjk/2000/06/14/quoting

Martin Trautmann - 05 Dec 2007 17:09 GMT
>  If a spreadsheet will get the job done, you can use
>  any of several free variations (ie. google apps,
>  NeoOffice/J.

... or any simple text file. There are tons of web applications around
which use simple text files for sophisticated database applications,
just by reading and reformatting simple text.

A reasonable knowledge of the unix commands grep and sort is more
powerful than some so called databases. Taking some programming language
such as perl you will have most powerful options.

However, most databases do not support simple functions which are part
of may spreadsheet applications, especially multi-cell copy/paste.

It does take some time to use e.g. vim or other text editors for those
tasks (which, on the other hand, are more powerful than most spreadsheet
programs, as long as you do not use sophisticated calculations).

>  Apple will apparently be releasing (it's in "trial" now)
>  a personal database application called Bento sometime soon.
>  See http://bentotrial.com and maybe google for "bento database"
>  and read some of the articles which come up.

It's around for some time via filemaker.com
BreadWithSpam@fractious.net - 05 Dec 2007 18:27 GMT
> >  If a spreadsheet will get the job done, you can use
> >  any of several free variations (ie. google apps,
[quoted text clipped - 7 lines]
> powerful than some so called databases. Taking some programming language
> such as perl you will have most powerful options.

I was not assuming our OP was command-line literate.  If he
is, then, sure - grep, sort, perl etc.  I figure anyone who's
ready to use those commands already knows they are there.

One which may not be as obvious to unix-familiar folks
is SQLite, which OS X includes.  It's actually pretty
spiffy and handy - and command-line friendly and simple
file-oriented.

See http://www.sqlite.org for more info.  

There are also drivers which allow other languages to
use SQLite DBs via other standard interfaces (ie. Perl,
Ruby, etc).

Probably not what the OP wants, but a very nifty tool
to know about nonetheless.

Signature

Plain Bread alone for e-mail, thanks.  The rest gets trashed.
No HTML in E-Mail! --    http://www.expita.com/nomime.html
Are you posting responses that are easy for others to follow?
  http://www.greenend.org.uk/rjk/2000/06/14/quoting

Clark Martin - 09 Dec 2007 19:28 GMT
> > With Apple announcing that they are no longer going to supply Works with
> > new versions of the OS can anyone supply the name of a simple database
[quoted text clipped - 3 lines]
> any of several free variations (ie. google apps,
> NeoOffice/J.

Or you can use the Database function in NeoOffice.  I don't know
anything about it but I'm guessing it will probably import an AppleWorks
Db.

Signature

Clark Martin
Redwood City, CA, USA               Macintosh / Internet Consulting

"I'm a designated driver on the Information Super Highway"

Steve Hix - 09 Dec 2007 21:05 GMT
> > > With Apple announcing that they are no longer going to supply Works with
> > > new versions of the OS can anyone supply the name of a simple database
[quoted text clipped - 7 lines]
> anything about it but I'm guessing it will probably import an AppleWorks
> Db.

It's not one of the listed formats in the Open menu list.
Bill - 09 Dec 2007 22:36 GMT
> > > > With Apple announcing that they are no longer going to supply Works with
> > > > new versions of the OS can anyone supply the name of a simple database
[quoted text clipped - 9 lines]
>
> It's not one of the listed formats in the Open menu list.

IIRC, you can export from an Appleworks database to tab-separated text
or other format that other databases can import. You can all do a copy
and paste of an entire Appleworks database in a single operation.

Signature

Bill Collins
For email, change "fake" to "earthlink"

Steve Hix - 10 Dec 2007 05:06 GMT
In article
<bbcollins-86053F.17360109122007@70-3-168-216.area5.spcsdns.net>,

> > > > > With Apple announcing that they are no longer going to supply Works
> > > > > with
[quoted text clipped - 15 lines]
> or other format that other databases can import. You can all do a copy
> and paste of an entire Appleworks database in a single operation.

Well, that's not "an AppleWorks Db", strictly speaking, is it?

Now, assuming the OP has a working installation of AppleWorks, he's in
good shape.

If all he has are the old files, maybe not so much.
wightstraker - 05 Dec 2007 17:56 GMT
> With Apple announcing that they are no longer going to supply Works with
> new versions of the OS can anyone supply the name of a simple database
> that's free to download and use.
>
> I only want it for things like Xmas card lists, and records of CD's and
> DVD's and addresses.  Thanks

This maybe overkill, but it's worth a look:

http://cocoamysql.sourceforge.net/

It's GUI shell for mySQL, so you don't actually have to know how
program it. It's free.
Peter James - 05 Dec 2007 18:56 GMT
> With Apple announcing that they are no longer going to supply Works with
> new versions of the OS can anyone supply the name of a simple database
> that's free to download and use.
>
> I only want it for things like Xmas card lists, and records of CD's and
> DVD's and addresses.  Thanks
Thanks for the replies.  It looks like Address Book will be the way for
my future Xmas  card labels.  Command line applications are not for me.
But thanks for the suggestions.
Mike Rosenberg - 05 Dec 2007 19:44 GMT
> With Apple announcing that they are no longer going to supply Works with
> new versions of the OS...

Apple has never provided AppleWorks, which I'm assuming is what you
mean, with any version of the OS.  The did used to include it with new
computers, though, and they've stopped selling it.

Signature

<http://designsbymike.info/shop/mac.cgi> Mac and geek T-shirts & gifts
<http://designsbymike.info/shop/musings.cgi> Muckraking T-shirts
<http://designsbymike.info/shop/prius.cgi> Prius shirts/bumper stickers
<http://bogart-tribute.net> Tribute to Humphrey Bogart

David Empson - 05 Dec 2007 23:02 GMT
> > With Apple announcing that they are no longer going to supply Works with
> > new versions of the OS...
>
> Apple has never provided AppleWorks, which I'm assuming is what you
> mean, with any version of the OS.  The did used to include it with new
> computers, though, and they've stopped selling it.

And then, it was only with "consumer" models, e.g. Performa, iMac, eMac
and iBook, but not PowerBook or PowerMac.

I bought ClarisWorks 4 and 5 for use on my PowerMac 7600 and 8600, and
AppleWorks 6 for my PowerBook G4. It came free with my iMac G3 and iBook
G3.

AppleWorks 6 still works fine on my MacBook Pro under Leopard, but is
archaic and I'm phasing it out in favour of iWork and Bento.

I never used the database module in ClarisWorks/AppleWorks as I also had
FileMaker Pro, which is much more powerful. I'm now intending to use
Bento for the simple "personal information" stuff and FileMaker Pro for
the complex and business stuff.

Signature

David Empson
dempson@actrix.gen.nz

Adrian - 05 Dec 2007 21:06 GMT
> With Apple announcing that they are no longer going to supply Works with
> new versions of the OS can anyone supply the name of a simple database
> that's free to download and use.
>
> I only want it for things like Xmas card lists, and records of CD's and
> DVD's and addresses.  Thanks

You could get a copy of Appleworks on Ebay.

Signature

Adrian

dorayme - 05 Dec 2007 21:26 GMT
> > With Apple announcing that they are no longer going to supply Works with
> > new versions of the OS can anyone supply the name of a simple database
> > that's free to download and use.

OfficeWorks?

Signature

dorayme

Steve Hix - 05 Dec 2007 22:28 GMT
> > With Apple announcing that they are no longer going to supply Works with
> > new versions of the OS can anyone supply the name of a simple database
> > that's free to download and use.
> >
> > I only want it for things like Xmas card lists, and records of CD's and
> > DVD's and addresses.  Thanks

OpenOffice or NeoOffice have a database module, and the cost is to
download either of them.
Martin Trautmann - 06 Dec 2007 09:33 GMT
>  OpenOffice or NeoOffice have a database module, and the cost is to
>  download either of them.

I did not manage to use it yet. Is it a database with a simple GUI or is
it more or less some kind of SQL database to hold and query data, but
less to show and edit it? I don't know any samples yet how powerful it
is. Personally, I'd like to have the calc spreadsheet surface to edit
data from within the database. Possible?
Marc Heusser - 05 Dec 2007 22:00 GMT
> With Apple announcing that they are no longer going to supply Works with
> new versions of the OS can anyone supply the name of a simple database
> that's free to download and use.
>
> I only want it for things like Xmas card lists, and records of CD's and
> DVD's and addresses.  Thanks

Apart from the answer of Address Book:
There are a list of applications to catalog CD's, DVD's and Books,
search on www.versiontracker.com.
And as for a free database there is also NeoOffice Database, a port of
OpenOffice to the Mac. Not that I would want to use it though ;-)
You might find a front end for sqllite or mysql (both free) too.
And Apple plans to release Bento, currently beta testing.
iWork also has limited database capabilites.

Hope that gets you started.

Marc

Signature

remove bye and from mercial to get valid e-mail
<http://www.heusser.com>

Peter James - 06 Dec 2007 08:54 GMT
> > With Apple announcing that they are no longer going to supply Works with
> > new versions of the OS can anyone supply the name of a simple database
[quoted text clipped - 15 lines]
>
> Marc
I have got OpenOffice and tried the database, but found the label
printing facility very difficult to get my head around.  Works is a
doddle to use and i like it.
I guess I'll stick with Works until Bento comes out.  hoepfully it will
be a reasonably easy to use database and not too expensive.
Tim Lance - 06 Dec 2007 11:45 GMT
>>> With Apple announcing that they are no longer going to supply Works with
>>> new versions of the OS can anyone supply the name of a simple database
[quoted text clipped - 20 lines]
> I guess I'll stick with Works until Bento comes out.  hoepfully it will
> be a reasonably easy to use database and not too expensive.

There is a trial version available. Haven't tried it myself as I still use
AppleWorks and is fine under Leopard.

Signature

Tim
lance_1012@hotmail.com

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.