Good database program

English Open Chat
#1

hi all
I have some problem. I`m have the huge collection of documentation, files, archives, examples, manuals for my work, and i really need turn this chaos to some structured look…

i need some not hard database engine, with GUI (if possible) for home using, ( and not home, may be…) I`m not skilled in database engines, and want to ask:

Can someone recommend me some database ? I need to collect something, search by some criteria and sort by custom options.

Which packages (or repositories) provide some like that for OpenSUSE 11.1 ?

Thanks for answers.

#2

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

What are you wanting to do? Store just the metadata somehow or do you
actually want to store all of your files in their myriad of types in the
database? At some point an RDBMS (database like you are probably
referring to… MySQL, PostgreSQL, Oracle, etc.) is probably not what
you want. A great “database” for handing “large objects” (LOB) is also
known as your filesystem. The downside of filesystems is they know
about data by directory and filename, but if you add in something like
Beagle you get an application that will index all of your
files/directories so you can search through them. You could also create
your own database that stored your own metadata and then a location to
the file referred-to by those data. Anyway, creating a database is
great and all but if it’s just to hold your data again it’s often just
another point of failure and bottleneck.

Good luck.

live fx wrote:
> hi all
> I have some problem. I`m have the huge collection of documentation,

files, archives, examples, manuals for my work, and i really need turn
this chaos to some structured look…

i need some not hard database engine, with GUI (if possible) for home
using, ( and not home, may be…) I`m not skilled in database engines,
> and want to ask:
>
> Can someone recommend me some database ? I need to collect something,
> search by some criteria and sort by custom options.
>
> Which packages (or repositories) provide some like that for OpenSUSE
> 11.1 ?
>
> Thanks for answers.
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iQIcBAEBAgAGBQJJrDVIAAoJEFl00+q2r0YpmtgQALMeXRqbS6Ha+9P953hfyC8C
NNauSld7jTt542CwUl+W8DSi4B79a0h/6fnqqLRosY5VWfgR/8kxhRrw+iFDxPj8
mNv7VPVPDmCa8BOD/j0c17DEyCG7CJPqnRYdVRyU7AOiPtwbViASsm2hlMChxSuR
igtQM07S5CntWomZtHR4MiwcgMVapfAbbaCRc1VMJei6WzhW2cA7AbA6tuS/zLsA
iDTJ8IQxYQ7q2N6IHPXSOlAiIBpW4EGs1/ccMnTnaPeHmK+5lRpyTxygwF7UUv+r
/GZ7eK23Vor7caD1bt/hzs1pufpfsO0kxQi70avt5h6+4tQ0ZP5WN0vHG9hBpozf
a64egQGfFYmM5AlMnuADUQlT8Eg+QwQQLq+rLa/3nLZ46oh6qVEYV7qViZe2GZPb
dr/wfucGARi97qp9L/Ae4A/Nf1C3U94CuTSvPdmUzJG6aAqTDvhKk5SUe0qyUDGl
M7WNK/zWbfJNtFFDG63fbBKCJUn59hsElyWxtbAch+cOIzzXqFlJ8pD3f6WuPymP
9g1C/JeFMRAhPyJEVXD1+2AkW+UgGWzzqFLEcc3MvaWI15jiALb6lUyNhvTvsXQc
iz2j37/0Sl5L97uR/K0842yoxlGvJFcp3rlcNZu/7byqdEU/6B2SRDYEtw1HnLTf
tnqxQ8O2NiAqLM+89wq+
=lic8
-----END PGP SIGNATURE-----

#3

What are you wanting to do? Store just the metadata somehow or do you
actually want to store all of your files in their myriad of types in the
database?

Yes, im want to store all of my files. This a not random files, this 3D software scenes, images, technical documents, scripts, source codes, movies, examples, learning materials. I want to try collect all of them, because this more and more look like hell. And want to search, or sort this information. Make this more structured and ready to searching and of course... may be..im hope - multiplatform …

MySQL, PostgreSQL, Oracle

  • i never touch this before, and i`m afraid this sounds.

The downside of filesystems is they know
about data by directory and filename, but if you add in something like
Beagle you get an application that will index all of your
files/directories so you can search through them.

…But beagle… Sorry, but Beagle provide some interactive lists? (im dont know what is “Beagle” - i think, this is a some process in memory, killed by me few days ago… when i try to free some memory… called “beagled” or something…oops)

For example i open some mmm…Page, and click on some field, and this sort my catalog, and then i just click and open some location with my nice stuff. Something like this. Standard filesystem searches don`t help me in this local little hell.

No ready-to-use forms or engines ? Only MySQL ?

Anyway, creating a database is
great

im fully agree this.. But im not skilled in database writing. May be you have a link where i can find some ready-to-use forms? Of course with changing possibilities… Or only MySQL or Oracle? (may be is time for me?)

Big thanks for really fast answer…

#4

(read about beagle now - Main Page - Beagle)

…and what do you think about OpenOffice + database ? I`m hear about some databases support in OpenOffice…

#5

As ab says, your filesystem is a database. It sounds as if the first thing is to create a structure for storing the material within the filesystem.

If you use meaningful names for files and folders, you can use a simple CLI program like locate to identify what you have got and where it is.

Programs like Gwenview allow you to add tags to images which can be used by other programs for searching.

If you are using KDE4, filesystem search facilities are being built into it; so by the time you have sorted everything out, you may well find that KDE4.3 has arrived and you have what you need.

It sounds to me as if you would simply duplicate the information that is already in the files if you used a database program.

#6

You may want to check out Tellico, a “collection manager”. It’s very versatile, but also simple to setup and use. Also, it’s in the openSUSE 11.1 OSS repo, and probably elsewhere if you check, so very easy to install.

Since you killed beagled previously, you may want to avoid software like that, which runs constantly (using memory) in the background, watching parts of your file system. However, I think it offers the ability to ‘tag’/categorize your files and folders as you want, and automatically tracks specified folders for new documents and other changes. So, if you’d like that automatic ability, you may want to turn it back on and fine-tune it for your needs. There are other “desktop search/index tools” available if you’d prefer, such as Strigi.

Another software category that may do what you want is “project management”. These tend to focus on multiple user features, but allow linking and categorizing all kinds of documents.

#7

john_hudson - thanks for this, i try CLI. I want some more centralized instead of many utilities… Just look for example… hmm… Im have some 3D program file, with some dynamics animation, this also have a result movie, and some "work in progress" images, and also have the custom plugin C++ code, and my custom notes (or of course without any notes) - what i want? I need some database with fields - when im type “rigid body dynamics” - and i see some list of stuff. I`m click on some “rigid test two objects - water collision” - and i see image, or movie link, or all files linked with this, and of course some notes.

silentstone - thanks! i will try all of this programs. May be Tellico is enough for my needs.

Yes, you right, i`m search some “Project Manager”, because i have huge data count, and this manager is really safe my time and working productivity. I have many ready-to-use stuff, and need to collect this chaos by categories…

Very big thanks for answers! :slight_smile:

#8

You could use a combo of MySQL and OpenOffice Base. I have been using Base to retrieve data from a website’s MySQL database, had quite some trouble to get it talking through some nasty firewalls, but once the connection is OK, all data are available.