Small database recommendation (free)

I need a small database for handling some stuff ... nothing too big, up to let's say 1000 entries.

Problem is the last time I used a database of some kind, was round', oh I don't know, 1995 ... dBase, version unknown, under DOS.

What is there on the market today, that is roundabout in that league: small, fast, it's really be swell if it was free, but I won't insist on that.

I just went through dBase's website (wow, they still exist) but it doesn't seem they have any kind of free version.

p.s. I'd really like to try to avoid any kind of "programming" in that area. The simpler, the better.

database

Rook

Posted 2010-02-21T23:59:54.847

Reputation: 21 622

What do you need this for? – Sasha Chedygov – 2010-02-22T05:43:05.277

@musicfreak - i explained it some more here: http://superuser.com/questions/111823/is-this-data-appropriate-for-keeping-in-a-database

– Rook – 2010-02-22T11:56:01.940

Answers

sqlite might be the answer, with a suitable front end. It is a SLIGHT abuse of it, but in a good way

Journeyman Geek

Posted 2010-02-21T23:59:54.847

Reputation: 119 122

Why/what do you mean under "slight abuse" ... I'm not into databases, so some hidden meaning probably escapes me ... – Rook – 2010-02-22T01:01:43.567

If I understood correctly, sqlite is a whole (minus the frontend - btw, I don't mind the command line interface, quite the opposite :) database. I don't need anything else to use it and save my data in a file, right ? I know these may be overly simple questions, but I'd appreciate all the help you can give on the subject. – Rook – 2010-02-22T01:10:10.350

sqlite is generally meant to be used embedded as part of a app - you're using tools meant to edit or create databased which later get incorperated into an app. However, it seems quite perfect considering what you seem to want. You'd need to know some basic sql to do stuff over cli- and that's pretty close to programming, so i was looking for GUIs. – Journeyman Geek – 2010-02-22T11:34:57.777

Perhaps try Open Office Base http://www.openoffice.org/product/base.html

Martin Hilton

Posted 2010-02-21T23:59:54.847

Reputation: 1 386

I'll try it ... hardly small, but at least they're free :-) – Rook – 2010-02-22T00:37:41.667

SQLite for small apps, MySQL for bigger ones.

mencargo

Posted 2010-02-21T23:59:54.847

Reputation: 11

Well, it is small :) And free :) Apart from the documentation available next to the download section, do you perchance know of some tutorial for this kind of databases (assume no previous knowledge <-- this doesn't look like anything like dBase ... as I remember it) – Rook – 2010-02-22T01:03:26.453

If I understood correctly, sqlite is a whole (minus the frontend) database. I don't need anything else to use it and save my data in a file, right ? I know these may be overly simple questions, but I'd appreciate all the help you can give on the subject. – Rook – 2010-02-22T01:05:30.743

Relational databases may not be the best for this situation. Yes, you can avoid programming with a good enough front-end, but I think it's just overkill. @Idigas: Yes, SQLite is all you need if you want to go into that direction. – Sasha Chedygov – 2010-02-22T05:43:55.290

if you wanted mysql, you could probably use the cli, phpmyadmin or adminer to work on it. Without knowing more though, sqlite sounds like the best bet. – Journeyman Geek – 2010-02-22T11:39:19.327

I think Kexi is what you looking for.

http://www.kexi-project.org/

MicTech

Posted 2010-02-21T23:59:54.847

Reputation: 9 888