Web lists-archives.com

A cumulative reply [Re: A minimal relational database in Debian?]

On 02/27/2017 07:43 AM, tomas@xxxxxxxxxx wrote:
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.


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

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?


[1] Yeah: absolute purists will say most SQL databases out there
   are not relational, and they'd be right

- -- tomás
Version: GnuPG v1.4.12 (GNU/Linux)