A cumulative reply [Re: A minimal relational database in Debian?]
On 02/27/2017 07:43 AM, tomas@tuxteam.de wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Mon, Feb 27, 2017 at 07:17:56AM -0600, Richard Owlett wrote:
The last time I needed a relational database my employer was using
dBaseII on a MS-DOS machine.
An IBM PC-XT IIRC
Hm. A strange "relational" database indeed...
It is dated (obsolete for decades), but why "strange". It development
was apparently contemporaneous with SQL, but unrelated.
What is a functional equivalent in the Debian repository?
I looked at at LibreOffice Base. It was unusable as its "help"
system provided no intrinsic way to increase fonts to a legible
size.
LibreOffice Base is, AFAIK *not* a relational database, but just
a -possibly graphical- user interface to one. Relational databases,
as I know them, have no "fonts", for example.
I didn't claim it was ;/
I looked at it as it was install by default when I chose MATE as my DE.
The "font problem" was that I could not force its "help system" to use a
legible font size. Not being able to read its "help", I have ABSOLUTELY
NO idea of what capability it does/doesn't supply.
Sorry for sounding somewhat snarky, but I'm trying to help you refine
your requirements.
No problem. I was using a definition I learned in the 1980's.
What is it exactly what you are looking for?
I accept as satisfactory the definition given at
https://en.wikipedia.org/wiki/Relational_database .
- some kind of dBase clone (in a very loose sense), i.e. some
GUI where you can click together small data-centric GUI apps?
"Relational", perhaps "concurrent multi-user" not so important?
I have to defer to others in this one. But perhaps you might
want to look into gambas (for which you'd need a "real" database
beneath, see below)
- a "relational" [1] database with transactions, SQL, perhaps some
concurrent multi-user capabilities?
Here, you could do significantly worse than PostgreSQL. Highly
recommended. Or, if you want to embed it into applications and
don't care about multi-user (and many other niceties), you
might want to look into sqlite. Then there is MariaDB (which
was formerly spelled MySQL, but Oracle). Others will disagree,
but my take is: don't if you don't have to.
(The first class of applications might contain one of the second
class as embedded data store -- or it might not).
What does you use case look like, approximately?
Regards
[1] Yeah: absolute purists will say most SQL databases out there
are not relational, and they'd be right
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
iEYEARECAAYFAli0LQUACgkQBcgs9XrR2kYRqQCfQoF10Q4ZvLzLEP5u2y9dVJPK
uWoAniS+XnG6uKqkKWSwjYieYTgFW9xe
=l5rv
-----END PGP SIGNATURE-----
Reply to: