[opensuse] Small database program?
Is there something small and simple? All I want is to set up a simple home database. Items,serial numbers maybe a couple more fields. Every time I go looking all I seem to find is stuff geared at running a Fortune 500 company. Thanks Nick -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Saturday 26 May 2007, Nick Zentena wrote:
Is there something small and simple? All I want is to set up a simple home database. Items,serial numbers maybe a couple more fields.
Tellico might suit your needs. Dylan -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Use OpenOffice.org's BASE which is part of SUSE's distribution....it is a replacement for MS-Access in many ways, can interface with MySQL and others if you like but can stand alone. Nick Zentena wrote:
Is there something small and simple? All I want is to set up a simple home database. Items,serial numbers maybe a couple more fields. Every time I go looking all I seem to find is stuff geared at running a Fortune 500 company.
Thanks Nick
-- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Saturday 26 May 2007 10:46, Richard Creighton wrote:
Use OpenOffice.org's BASE which is part of SUSE's distribution....it is a replacement for MS-Access in many ways, can interface with MySQL and others if you like but can stand alone.
Thanks. I'm trying it out now. Outside of more or less locking up the computer the first time I think it might work -) Nick -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Saturday 26 May 2007 11:00 am, Nick Zentena wrote:
Thanks. I'm trying it out now. Outside of more or less locking up the computer the first time I think it might work -)
I believe the first thing that it does is initialize you Java system.... That may have taken some time to startup and do it's work. B-) -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Nick Zentena wrote:
Is there something small and simple? All I want is to set up a simple home database. Items,serial numbers maybe a couple more fields. Every time I go looking all I seem to find is stuff geared at running a Fortune 500 company.
sqlite3 (+ GUI frontend if required) Th. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Saturday 26 May 2007 11:12, Thomas Hertweck wrote:
Nick Zentena wrote:
Is there something small and simple? All I want is to set up a simple home database. Items,serial numbers maybe a couple more fields. Every time I go looking all I seem to find is stuff geared at running a Fortune 500 company.
sqlite3 (+ GUI frontend if required)
I think I'd need the GUI with that one-) Thanks Nick -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Nick Zentena wrote:
Is there something small and simple? All I want is to set up a simple home database. Items,serial numbers maybe a couple more fields. Every time I go looking all I seem to find is stuff geared at running a Fortune 500 company.
Thanks Nick
You can use a spread sheet app, such as OpenOffice Calc. Here's some info on doing that. http://documentation.openoffice.org/manuals/oooauthors2/0313CG-CalcAsASimple... -- Use OpenOffice.org <http://www.openoffice.org> -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
James Knott wrote:
Nick Zentena wrote:
Is there something small and simple? All I want is to set up a simple home database. Items,serial numbers maybe a couple more fields. Every time I go looking all I seem to find is stuff geared at running a Fortune 500 company.
Thanks Nick
You can use a spread sheet app, such as OpenOffice Calc. Here's some info on doing that. http://documentation.openoffice.org/manuals/oooauthors2/0313CG-CalcAsASimple...
Well, we got a pretty good list of database programs here. The only thing I would ask you is what do you mean by "simple". Do you mean all the fields set up and you don't have to do much work (tellico or a small niche database) or one with few bells and whistles (Calc spreadsheet)? -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Pueblo Native wrote:
James Knott wrote:
Nick Zentena wrote:
Is there something small and simple? All I want is to set up a simple home database. Items,serial numbers maybe a couple more fields. Every time I go looking all I seem to find is stuff geared at running a Fortune 500 company.
Thanks Nick
You can use a spread sheet app, such as OpenOffice Calc. Here's some info on doing that. http://documentation.openoffice.org/manuals/oooauthors2/0313CG-CalcAsASimple...
Well, we got a pretty good list of database programs here. The only thing I would ask you is what do you mean by "simple". Do you mean all the fields set up and you don't have to do much work (tellico or a small niche database) or one with few bells and whistles (Calc spreadsheet)?
I only meant that for a simple database, a spreadsheet suffices. -- Use OpenOffice.org <http://www.openoffice.org> -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
James Knott wrote:
I only meant that for a simple database, a spreadsheet suffices.
That should teach me to respond to the right e-mail. Acutally, I was trying to ask Nick what his definition of "simple" was: functionality or set up time. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Saturday 26 May 2007 19:29, Pueblo Native wrote:
Well, we got a pretty good list of database programs here. The only thing I would ask you is what do you mean by "simple". Do you mean all the fields set up and you don't have to do much work (tellico or a small niche database) or one with few bells and whistles (Calc spreadsheet)?
I think Openoffice Base is going to work for me. I've had to redo things a few times. But I'm getting closer to something that does what I need. It would have been easier if I kept my eyes open the first time but redoing it hasn't hurt. We'll so how well things go when I get serious about inputting the data. So far I've only added about five records. Nick -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Nick Zentena wrote:
On Saturday 26 May 2007 19:29, Pueblo Native wrote:
Well, we got a pretty good list of database programs here. The only thing I would ask you is what do you mean by "simple". Do you mean all the fields set up and you don't have to do much work (tellico or a small niche database) or one with few bells and whistles (Calc spreadsheet)?
I think Openoffice Base is going to work for me. I've had to redo things a few times. But I'm getting closer to something that does what I need. It would have been easier if I kept my eyes open the first time but redoing it hasn't hurt. We'll so how well things go when I get serious about inputting the data. So far I've only added about five records.
Nick
Whatever you use, don't spend too much time reinventing the wheel. I'd try to find a template that matches your needs generally if not preciesely. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Nick Zentena wrote:
Is there something small and simple? All I want is to set up a simple home database. Items,serial numbers maybe a couple more fields. Every time I go looking all I seem to find is stuff geared at running a Fortune 500 company.
Thanks Nick
gvim -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Nick Zentena wrote:
Is there something small and simple? All I want is to set up a simple home database. Items,serial numbers maybe a couple more fields. Every time I go looking all I seem to find is stuff geared at running a Fortune 500 company.
Thanks Nick
gvim I use MySQL at home for several small databases. I use phpMyAdmin to enter and
On Monday May 28 2007 17:22, Aaron Kulkis wrote: maintain the data, etc. -- Russ Linux register user 441463 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On 08/18/2007 01:41 PM somebody named russbucket wrote:
Nick Zentena wrote:
Is there something small and simple? All I want is to set up a simple home database. Items,serial numbers maybe a couple more fields. Every time I go looking all I seem to find is stuff geared at running a Fortune 500 company.
Thanks Nick gvim I use MySQL at home for several small databases. I use phpMyAdmin to enter and
On Monday May 28 2007 17:22, Aaron Kulkis wrote: maintain the data, etc.
On the other end of the tech scale, some people just use an ASCII file with delimiters. Create and maintain it with any text editor. Pull data out with utilities like grep, awk, and sed. -- Abstinence-Only sex education is a little like Just-Hold-It potty training. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Monday 2007-05-28 20:22, Aaron Kulkis wrote:
Nick Zentena wrote:
Is there something small and simple? All I want is to set up a simple home database. Items,serial numbers maybe a couple more fields. Every time I go looking all I seem to find is stuff geared at running a Fortune 500 company.
gvim
Ha! ;-) Or maybe use a spreadsheet. (My father-in-law tracks and indexes all his jazz recordings using a port of ISPF for DOS.) -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Ken Jennings wrote:
On Monday 2007-05-28 20:22, Aaron Kulkis wrote:
Nick Zentena wrote:
Is there something small and simple? All I want is to set up a simple home database. Items,serial numbers maybe a couple more fields. Every time I go looking all I seem to find is stuff geared at running a Fortune 500 company.
gvim
Ha! ;-) Or maybe use a spreadsheet.
(My father-in-law tracks and indexes all his jazz recordings using a port of ISPF for DOS.)
The OpenOffice site has info on using Calc as a small database. http://documentation.openoffice.org/manuals/oooauthors2/0313CG-CalcAsASimple... -- Use OpenOffice.org <http://www.openoffice.org> -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Mon, May 28, 2007 5:22 pm, Aaron Kulkis wrote:
Nick Zentena wrote:
Is there something small and simple? All I want is to set up a simple home database. Items,serial numbers maybe a couple more fields. Every time I go looking all I seem to find is stuff geared at running a Fortune 500 company.
Thanks Nick
gvim
MS Access? Open Office Calc? -- kai -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sat, 2007-08-18 at 10:55 -0700, Kai Ponte wrote:
On Mon, May 28, 2007 5:22 pm, Aaron Kulkis wrote:
Nick Zentena wrote:
Is there something small and simple? All I want is to set up a simple home database. Items,serial numbers maybe a couple more fields. Every time I go looking all I seem to find is stuff geared at running a Fortune 500 company.
Thanks Nick
gvim
MS Access?
Open Office Calc?
OpenOffice has a light weight DB program similar to access. Ken -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sat, August 18, 2007 11:17 am, Ken Schneider wrote:
On Sat, 2007-08-18 at 10:55 -0700, Kai Ponte wrote:
On Mon, May 28, 2007 5:22 pm, Aaron Kulkis wrote:
Nick Zentena wrote:
Is there something small and simple? All I want is to set up a simple home database. Items,serial numbers maybe a couple more fields. Every time I go looking all I seem to find is stuff geared at running a Fortune 500 company.
Thanks Nick
gvim
MS Access?
Open Office Calc?
OpenOffice has a light weight DB program similar to access.
Well, I was only half-kidding about OOo Calc. Honestly it works as a smallish database with no relational fields needed. Though I've created multi-terabyte databases with several hundred million records and scores of tables, I find that Calc - or Excel - works fine for the simple task of keeping track of items. No, it isn't normalized and you can't add related tables, but it works great, lets you sort, is portable and even allows for calculation and reporting. If you do really want a database with forms and whatnot, you can use OOo again, which includes the pretty cool HSQLDB engine. http://hsqldb.sourceforge.net/ I created and included on in this post (11kb) for you to review. Took me about two minutes.
On Sat 18 August 2007 20:19:21 Kai Ponte wrote:
On Sat, August 18, 2007 11:17 am, Ken Schneider wrote:
On Sat, 2007-08-18 at 10:55 -0700, Kai Ponte wrote:
On Mon, May 28, 2007 5:22 pm, Aaron Kulkis wrote:
Nick Zentena wrote:
Is there something small and simple? All I want is to set up a simple home database. Items,serial numbers maybe a couple more fields.
Perhaps look at something like Tellico? -- Pob hwyl / Best wishes Kevin Donnelly blog.thinkopen.co.uk - Me Myself Why? www.kyfieithu.co.uk - KDE yn Gymraeg www.klebran.org.uk - Gwirydd gramadeg rhydd i'r Gymraeg www.eurfa.org.uk - Geiriadur rhydd i'r Gymraeg -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Kevin Donnelly wrote:
On Sat 18 August 2007 20:19:21 Kai Ponte wrote:
On Sat, August 18, 2007 11:17 am, Ken Schneider wrote:
On Sat, 2007-08-18 at 10:55 -0700, Kai Ponte wrote:
On Mon, May 28, 2007 5:22 pm, Aaron Kulkis wrote:
Nick Zentena wrote:
Is there something small and simple? All I want is to set up a simple home database. Items,serial numbers maybe a couple more fields.
Perhaps look at something like Tellico?
I second the recommendation for tellico. Very nice little program. Joe -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On 26/05/07, Nick Zentena <zentena@sympatico.ca> wrote:
Is there something small and simple? All I want is to set up a simple home database. Items,serial numbers maybe a couple more fields. Every time I go looking all I seem to find is stuff geared at running a Fortune 500 company.
I'm surprised no-one has mentioned kexi yet, probably the closest to your needs, much more feature complete than OOo base. http://www.kexi-project.org/ _ Benjamin Weber -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (16)
-
Aaron Kulkis -
Benji Weber -
Brad Bourn -
Dylan -
James Knott -
joe -
Kai Ponte -
ken -
Ken Jennings -
Ken Schneider -
Kevin Donnelly -
Nick Zentena -
Pueblo Native -
Richard Creighton -
russbucket -
Thomas Hertweck