Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > linux.debian.user > #178217

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

Show all headers | View raw

On 02/27/2017 09:44 AM, Joe wrote:
> On Mon, 27 Feb 2017 08:53:30 -0600
> Richard Owlett <rowlett@cloud85.net> wrote:
>
>> On 02/27/2017 07:43 AM, tomas@tuxteam.de wrote:
>>
>>>
>>> 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.
>>
>
> It's sort of functionally nearly equivalent to MS Access on Windows 3
> i.e. 1992-ish.

I had forgotten about MS Access, probably 'cause the less I think about 
that employer the better. It was later than dBaseII but aimed pretty 
much at the same market. Having used dBaseII was considered "qualifying 
experience" for the job.

> It's slow and as buggy as hell. It can't handle update
> queries. I think it still needs Java for reporting. Apart from that,
> it's about the quickest way to assemble an ad-hoc database
> application.
> Free, that is, there are probably better commercial products. I use it
> for this reason, but also that it is cross-platform, you can literally
> take a Base file from a Linux machine and run it on a Windows machine,
> and vice versa (for close-numbered versions of LO).
>
> But a lot depends on what you want to do. Only you know your actual
> database needs. LO Base can use an internal database file or pretty
> much any client-server database or other ODBC server. For making user
> applications, it's worth considering.

Not if it throws barriers between me ant its documentation.

>
> For actual storage of data in related tables, as others have said,
> there is sqlite (single file) and a few client-server SQL databases.
> Note that if you are aware of MS SQL Server, and that it is a
> humungous
> beast that needs its own powerful server hardware, MySQL and
> Postgresql
> can use orders of magnitude fewer resources, and don't cause much of a
> problem when running on a workstation. I resisted running an SQL server
> on my home server for some years, but when it became unavoidable, I
> found that it didn't really need much care and feeding.
>
> But you then do the work of getting the data in and out and presenting
> it usefully. Perl, PHP, lazarus, python and all the other languages have
> database libraries, but you may have some heavy programming to do.
> Lazarus contains visual data components like the Delphi ones, and can
> make database handling a bit easier, as well as visual application
> development. There are database admin programs which allow useful data
> manipulation, but you wouldn't give them to a user. Every now and then
> I look around, and I still haven't found a free database application
> developer better than LO Base. For all its faults.
>

I installed sqlitebrowser and looked at one set of sqlite files that was 
on of the triggers causing my current questions. It doesn't appear to 
match me. But it's looking hopeful that sqlite may be useful.

A little research indicates that Tcl/Tk plays well with sqlite. A couple 
of years ago I started learning it for a now abandoned project. I'll 
follow up on that combo. [I looked at some code fragments on 
http://wiki.tcl.tk . They were reminiscent of what I did in dBaseII so 
may be a productive path.]

Back to linux.debian.user | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

A minimal relational database in Debian? Richard Owlett <rowlett@cloud85.net> - 2017-02-27 14:20 +0100
  Re: A minimal relational database in Debian? Christian Seiler <christian@iwakd.de> - 2017-02-27 14:30 +0100
    Re: A minimal relational database in Debian? Jonathan Dowland <jmtd@debian.org> - 2017-02-27 15:20 +0100
    Re: A minimal relational database in Debian? Dan Ritter <dsr@randomstring.org> - 2017-02-27 15:50 +0100
    Re: A minimal relational database in Debian? Lisi Reisz <lisi.reisz@gmail.com> - 2017-02-28 03:40 +0100
  Re: A minimal relational database in Debian? James Allsopp <jamesaallsopp@googlemail.com> - 2017-02-27 14:50 +0100
  Re: A minimal relational database in Debian? <tomas@tuxteam.de> - 2017-02-27 14:50 +0100
    A cumulative reply [Re: A minimal relational database in Debian?] Richard Owlett <rowlett@cloud85.net> - 2017-02-27 16:00 +0100
      Re: A cumulative reply [Re: A minimal relational database in  Debian?] Joe <joe@jretrading.com> - 2017-02-27 16:50 +0100
        Re: A cumulative reply [Re: A minimal relational database in Debian?] Richard Owlett <rowlett@cloud85.net> - 2017-02-27 17:50 +0100
          Re: A cumulative reply [Re: A minimal relational database in  Debian?] sunrise <sunrise@emypeople.net> - 2017-02-27 21:20 +0100
            Re: A cumulative reply [Re: A minimal relational database in Debian?] GiaThnYgeia <GiaThnYgeia@openmailbox.org> - 2017-02-27 21:50 +0100
            Re: A cumulative reply [Re: A minimal relational database in Debian?] Lisi Reisz <lisi.reisz@gmail.com> - 2017-02-28 03:40 +0100
          Re: A cumulative reply [Re: A minimal relational database in Debian?] <tomas@tuxteam.de> - 2017-02-27 21:50 +0100
            Re: A cumulative reply [Re: A minimal relational database in Debian?] Richard Owlett <rowlett@cloud85.net> - 2017-02-28 03:50 +0100
              Re: A cumulative reply [Re: A minimal relational database in Debian?] conover@rahul.net (John Conover) - 2017-02-28 04:40 +0100
  Re: A minimal relational database in Debian? Jude DaShiell <jdashiel@panix.com> - 2017-02-27 19:10 +0100
  an answer plus minimal font size (was: A minimal relational  database in Debian? songbird <songbird@anthive.com> - 2017-02-27 20:50 +0100
  Re: A minimal relational database in Debian? Ben Caradoc-Davies <ben@transient.nz> - 2017-02-28 01:10 +0100
    Re: A minimal relational database in Debian? Richard Owlett <rowlett@cloud85.net> - 2017-02-28 04:00 +0100
  Re: A minimal relational database in Debian? Lisi Reisz <lisi.reisz@gmail.com> - 2017-02-28 03:40 +0100
    Re: A minimal relational database in Debian Dominic Knight <dominicknight@gmx.com> - 2017-03-01 00:30 +0100
      Re: A minimal relational database in Debian Richard Owlett <rowlett@cloud85.net> - 2017-03-01 00:50 +0100
        Re: A minimal relational database in Debian Jörg-Volker Peetz <jvpeetz@web.de> - 2017-03-01 09:10 +0100
          Re: A minimal relational database in Debian Curt <curty@free.fr> - 2017-03-01 10:50 +0100
          font sizes in LibreOffice (was Re: A minimal relational database in  Debian) Jonathan Dowland <jmtd@debian.org> - 2017-03-01 12:20 +0100
          Re: A minimal relational database in Debian <tomas@tuxteam.de> - 2017-03-01 13:40 +0100
            Re: A minimal relational database in Debian Richard Owlett <rowlett@cloud85.net> - 2017-03-01 14:50 +0100
              Contributing [was: A minimal relational database in Debian] <tomas@tuxteam.de> - 2017-03-01 15:00 +0100
              Re: A minimal relational database in Debian John Hasler <jhasler@newsguy.com> - 2017-03-01 15:10 +0100
              Re: A minimal relational database in Debian Stefan Monnier <monnier@iro.umontreal.ca> - 2017-03-01 15:20 +0100
              Re: A minimal relational database in Debian Jude DaShiell <jdashiel@panix.com> - 2017-03-01 15:50 +0100
              Re: A minimal relational database in Debian Joe <joe@jretrading.com> - 2017-03-01 16:10 +0100
                Re: A minimal relational database in Debian Richard Owlett <rowlett@cloud85.net> - 2017-03-01 16:50 +0100
                Re: A minimal relational database in Debian Joe <joe@jretrading.com> - 2017-03-01 17:40 +0100
          Re: A minimal relational database in Debian Richard Owlett <rowlett@cloud85.net> - 2017-03-01 13:40 +0100
            Re: bad LibreOffice font sizes (was: A minimal relational data...) Felix Miata <mrmazda@earthlink.net> - 2017-03-01 14:10 +0100
            Re: A minimal relational database in Debian Bob Weber <bobrweber@gmail.com> - 2017-03-01 15:20 +0100
              Re: A minimal relational database in Debian Richard Owlett <rowlett@cloud85.net> - 2017-03-01 16:00 +0100
                Re: A minimal relational database in Debian <tomas@tuxteam.de> - 2017-03-01 21:40 +0100
                Re: A minimal relational database in Debian GiaThnYgeia <GiaThnYgeia@openmailbox.org> - 2017-03-03 09:50 +0100
                Re: A minimal relational database in Debian Curt <curty@free.fr> - 2017-03-03 10:50 +0100
                Re: A minimal relational database in Debian Joe Pfeiffer <pfeiffer@cs.nmsu.edu> - 2017-03-03 19:00 +0100
                Re: A minimal relational database in Debian Curt <curty@free.fr> - 2017-03-03 22:00 +0100
                Re: A minimal relational database in Debian <tomas@tuxteam.de> - 2017-03-03 11:20 +0100
                Re: A minimal relational database in Debian Richard Owlett <rowlett@cloud85.net> - 2017-03-03 12:50 +0100
        Re: A minimal relational database in Debian <tomas@tuxteam.de> - 2017-03-01 10:40 +0100
        Re: A minimal relational database in Debian GiaThnYgeia <GiaThnYgeia@openmailbox.org> - 2017-03-01 10:40 +0100

csiph-web