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

Groups > linux.debian.user > #225254 > unrolled thread

FOSS equivalents of *OLD* database and spreadsheet tools?

Back to article view | Back to linux.debian.user

Contents

  FOSS equivalents of *OLD* database and spreadsheet tools? Richard Owlett <rowlett@cloud85.net> - 2020-07-25 19:40 +0200
    Re: FOSS equivalents of *OLD* database and spreadsheet tools? Paul M Foster <paulf@quillandmouse.com> - 2020-07-25 21:00 +0200
      Re: FOSS equivalents of *OLD* database and spreadsheet tools? David Wright <deblis@lionunicorn.co.uk> - 2020-07-25 21:50 +0200
      Re: FOSS equivalents of *OLD* database and spreadsheet tools? Greg Wooledge <wooledg@eeg.ccf.org> - 2020-07-27 14:10 +0200
        Re: FOSS equivalents of *OLD* database and spreadsheet tools? Michael Stone <mstone@debian.org> - 2020-07-27 17:20 +0200
          Re: FOSS equivalents of *OLD* database and spreadsheet tools? Greg Wooledge <wooledg@eeg.ccf.org> - 2020-07-27 17:40 +0200
            Re: FOSS equivalents of *OLD* database and spreadsheet tools? Michael Stone <mstone@debian.org> - 2020-07-27 21:50 +0200
              Re: FOSS equivalents of *OLD* database and spreadsheet tools? <tomas@tuxteam.de> - 2020-07-27 22:00 +0200
                Re: FOSS equivalents of *OLD* database and spreadsheet tools? Greg Wooledge <wooledg@eeg.ccf.org> - 2020-07-27 22:10 +0200
                Re: FOSS equivalents of *OLD* database and spreadsheet tools? Michael Stone <mstone@debian.org> - 2020-07-27 22:10 +0200
                  Re: FOSS equivalents of *OLD* database and spreadsheet tools? <tomas@tuxteam.de> - 2020-07-27 22:30 +0200
                    Re: FOSS equivalents of *OLD* database and spreadsheet tools? Joe <joe@jretrading.com> - 2020-07-27 23:50 +0200
                  Re: FOSS equivalents of *OLD* database and spreadsheet tools? Joe <joe@jretrading.com> - 2020-07-27 23:40 +0200
                    Re: FOSS equivalents of *OLD* database and spreadsheet tools? Michael Stone <mstone@debian.org> - 2020-07-27 23:50 +0200
                      Re: FOSS equivalents of *OLD* database and spreadsheet tools? Joe <joe@jretrading.com> - 2020-07-27 23:50 +0200
                      Re: FOSS equivalents of *OLD* database and spreadsheet tools? mick crane <mick.crane@gmail.com> - 2020-07-28 09:00 +0200
              Re: FOSS equivalents of *OLD* database and spreadsheet tools? David Wright <deblis@lionunicorn.co.uk> - 2020-07-28 00:30 +0200
                Re: FOSS equivalents of *OLD* database and spreadsheet tools? rhkramer@gmail.com - 2020-07-28 04:00 +0200
                  Re: FOSS equivalents of *OLD* database and spreadsheet tools? Nicholas Geovanis <nickgeovanis@gmail.com> - 2020-07-28 05:00 +0200
                    Re: FOSS equivalents of *OLD* database and spreadsheet tools? Nicholas Geovanis <nickgeovanis@gmail.com> - 2020-07-28 05:10 +0200
                  Re: FOSS equivalents of *OLD* database and spreadsheet tools? Miles Fidelman <mfidelman@meetinghouse.net> - 2020-07-28 09:20 +0200
          Re: FOSS equivalents of *OLD* database and spreadsheet tools? David Wright <deblis@lionunicorn.co.uk> - 2020-07-27 17:50 +0200
          Re: FOSS equivalents of *OLD* database and spreadsheet tools? <tomas@tuxteam.de> - 2020-07-27 18:10 +0200
          Re: FOSS equivalents of *OLD* database and spreadsheet tools? Miles Fidelman <mfidelman@meetinghouse.net> - 2020-07-27 18:40 +0200
    Re: FOSS equivalents of *OLD* database and spreadsheet tools? <tomas@tuxteam.de> - 2020-07-25 21:10 +0200
      Re: FOSS equivalents of *OLD* database and spreadsheet tools? Miles Fidelman <mfidelman@meetinghouse.net> - 2020-07-25 21:30 +0200
    Re: FOSS equivalents of *OLD* database and spreadsheet tools? Joe <joe@jretrading.com> - 2020-07-25 22:30 +0200
      Re: FOSS equivalents of *OLD* database and spreadsheet tools? David Christensen <dpchrist@holgerdanske.com> - 2020-07-26 00:00 +0200
        Re: FOSS equivalents of *OLD* database and spreadsheet tools? Joe <joe@jretrading.com> - 2020-07-26 10:00 +0200
          Re: FOSS equivalents of *OLD* database and spreadsheet tools? mick crane <mick.crane@gmail.com> - 2020-07-26 12:10 +0200
            Re: FOSS equivalents of *OLD* database and spreadsheet tools? Joe <joe@jretrading.com> - 2020-07-26 15:30 +0200
            Re: FOSS equivalents of *OLD* database and spreadsheet tools? David Christensen <dpchrist@holgerdanske.com> - 2020-07-27 09:10 +0200
    Re: FOSS equivalents of *OLD* database and spreadsheet tools? David Christensen <dpchrist@holgerdanske.com> - 2020-07-25 22:30 +0200
    Re: FOSS equivalents of *OLD* database and spreadsheet tools? rhkramer@gmail.com - 2020-07-25 23:00 +0200
    Re: FOSS equivalents of *OLD* database and spreadsheet tools? Michael Stone <mstone@debian.org> - 2020-07-26 16:30 +0200
      Re: FOSS equivalents of *OLD* database and spreadsheet tools? <tomas@tuxteam.de> - 2020-07-26 16:50 +0200
      Re: FOSS equivalents of *OLD* database and spreadsheet tools? Joe <joe@jretrading.com> - 2020-07-26 20:00 +0200
        Re: FOSS equivalents of *OLD* database and spreadsheet tools? Michael Stone <mstone@debian.org> - 2020-07-26 20:20 +0200
    Re: FOSS equivalents of *OLD* database and spreadsheet tools? Ajith R <ajithramayyan@yahoo.co.in> - 2020-07-27 16:20 +0200
    Re: FOSS equivalents of *OLD* database and spreadsheet tools? Eric S Fraga <e.fraga@ucl.ac.uk> - 2020-07-27 17:20 +0200
      [Interim Solution] Re: FOSS equivalents of *OLD* database and  spreadsheet tools? Richard Owlett <rowlett@cloud85.net> - 2020-07-29 11:50 +0200
        Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and  spreadsheet tools? mick crane <mick.crane@gmail.com> - 2020-07-29 12:20 +0200
        Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and  spreadsheet tools? Joe <joe@jretrading.com> - 2020-07-29 13:20 +0200
          Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and  spreadsheet tools? Richard Owlett <rowlett@cloud85.net> - 2020-07-29 14:10 +0200
            Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and  spreadsheet tools? David Christensen <dpchrist@holgerdanske.com> - 2020-07-29 22:10 +0200
              Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and  spreadsheet tools? <tomas@tuxteam.de> - 2020-07-30 11:40 +0200
            Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and  spreadsheet tools? Tom Dial <tddial@comcast.net> - 2020-07-30 22:20 +0200
        Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and spreadsheet tools? Eric S Fraga <e.fraga@ucl.ac.uk> - 2020-07-30 11:30 +0200
          Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and  spreadsheet tools? Richard Owlett <rowlett@cloud85.net> - 2020-07-30 13:20 +0200
            Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and spreadsheet tools? Eric S Fraga <e.fraga@ucl.ac.uk> - 2020-07-30 16:20 +0200
          Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and  spreadsheet tools? Miles Fidelman <mfidelman@meetinghouse.net> - 2020-07-30 17:00 +0200
            Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and  spreadsheet tools? Richard Owlett <rowlett@cloud85.net> - 2020-07-30 17:10 +0200
            Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and  spreadsheet tools? Joe <joe@jretrading.com> - 2020-07-30 19:40 +0200
      Re: FOSS equivalents of *OLD* database and spreadsheet tools? Richard Owlett <rowlett@cloud85.net> - 2020-07-30 14:50 +0200
        Re: FOSS equivalents of *OLD* database and spreadsheet          tools? Linux-Fan <Ma_Sys.ma@web.de> - 2020-07-30 15:10 +0200
          Re: FOSS equivalents of *OLD* database and spreadsheet tools? Richard Owlett <rowlett@cloud85.net> - 2020-07-30 16:10 +0200
      Example(s) of recutils project flow? - was [FOSS equivalents of *OLD*  database and spreadsheet tools?] Richard Owlett <rowlett@cloud85.net> - 2020-08-07 13:40 +0200
        Re: Example(s) of recutils project flow? - was [FOSS equivalents of  *OLD* database and spreadsheet tools?] David <bouncingcats@gmail.com> - 2020-08-07 13:50 +0200
          Re: Example(s) of recutils project flow? - was [FOSS equivalents of  *OLD* database and spreadsheet tools?] Richard Owlett <rowlett@cloud85.net> - 2020-08-07 14:40 +0200
            Re: Example(s) of recutils project flow? - was [FOSS equivalents of  *OLD* database and spreadsheet tools?] Andrei POPESCU <andreimpopescu@gmail.com> - 2020-08-11 12:30 +0200

Page 3 of 3 — ← Prev page 1 2 [3]

#225473 — [Interim Solution] Re: FOSS equivalents of *OLD* database and spreadsheet tools?

On 07/27/2020 10:13 AM, Eric S Fraga wrote:
> You may wish to have a look at recutils:
> 
> https://www.gnu.org/software/recutils/
> 
> but it may not have some of the functionality you wish (although you
> could build on it with shell scripts & awk, say).
> 

A database is over-kill for some personal preferences.

I had mentioned spreadsheets in original post as I had visualized a 
multiple page spreadsheet. One page for the nutrient components of a 
food. One page that would be used to input date, food, and amount. A 
page that would have date and total of nutrient for that date. But I 
couldn't figure out the details.

IIUC can import data from a CSV file.
I could have one file for nutrient content of foods and one file with 
date, food, quantity, and unique record id.

Process would be edit to the appropriate CSV file to add information.
There would be a "report generator" which would read CSV files, convert 
them to recfile, then create a "Total Consumed" recfile to be displayed. 
[ A data join IIUC]. That recfile may initially be display only.

[toc] | [prev] | [next] | [standalone]

#225476 — Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and spreadsheet tools?

On 2020-07-29 10:40, Richard Owlett wrote:
<snipped>
> A database is over-kill for some personal preferences.
<snipped>
apropos of nothing I found this great, clear introduction to Perl/Tk for 
inputting how many cups of coffee and bacon sandwiches you had.
https://www.ibm.com/developerworks/aix/library/au-perltkmodule/index.html
mick
-- 
Key ID    4BFEBB31

[toc] | [prev] | [next] | [standalone]

#225479 — Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and spreadsheet tools?

On Wed, 29 Jul 2020 04:40:24 -0500
Richard Owlett <rowlett@cloud85.net> wrote:

> On 07/27/2020 10:13 AM, Eric S Fraga wrote:
> > You may wish to have a look at recutils:
> > 
> > https://www.gnu.org/software/recutils/
> > 
> > but it may not have some of the functionality you wish (although you
> > could build on it with shell scripts & awk, say).
> >   
> 
> A database is over-kill for some personal preferences.

Which isn't what you're talking about.
> 
> I had mentioned spreadsheets in original post as I had visualized a 
> multiple page spreadsheet. One page for the nutrient components of a 
> food. One page that would be used to input date, food, and amount.

Presumably you don't want to also enter the nutrients for each food in
each meal, you want your system to look up values for that food from a
list somewhere.

>  A 
> page that would have date and total of nutrient for that date. But I 
> couldn't figure out the details.
> 
> IIUC can import data from a CSV file.
> I could have one file for nutrient content of foods and one file with 
> date, food, quantity, and unique record id.

And this is the kind of thing that spreadsheets can do on a small
scale, but they don't scale up well. As I said, I'm on over 300 foods
and adding one or two a week. I'm also looking at about a dozen
nutrients, and have over 17,000 journal entries over about 2 1/2 years.

This is exactly the kind of thing that databases are very good at.
> 
> Process would be edit to the appropriate CSV file to add information.
> There would be a "report generator" which would read CSV files,
> convert them to recfile, then create a "Total Consumed" recfile to be
> displayed. [ A data join IIUC]. That recfile may initially be display
> only.

So is this.

I'd recommend using the right tool for the job.

-- 
Joe

[toc] | [prev] | [next] | [standalone]

#225483 — Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and spreadsheet tools?

On 07/29/2020 06:13 AM, Joe wrote:
> [snip]
> 
> I'd recommend using the right tool for the job.
> 

Which is why I'll investigate.
Your approach is literally orders of magnitude more than I want.

[toc] | [prev] | [next] | [standalone]

#225506 — Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and spreadsheet tools?

On 2020-07-29 05:03, Richard Owlett wrote:

> [A suggested] approach is literally orders of magnitude more than I want.


Consider these idealized cost functions for solution technologies A, B, 
and C:

     fA(t) = t*t + 1

     fB(t) = (t/3)*(t/3) + 10

     fC(t) = (t/10/*(t/10) + 100


Observe:

- fA has the lowest initial cost, but the highest cost over time.

- fB has an order of magnitude higher initial cost, but an order of 
magnitude lower cost over time.

- fC has the highest initial cost and the lowest cost over time.

- fA and fB intersect at time tAB.

- fB and fC intersect at time tBC.


The obvious strategy is to estimate t and pick the technology with the 
lowest cost:

-  For t < tAB, pick technology A.

-  For tAB < t < tBC, pick technology B.

-  For tBC < t, pick technology C.


The debate is over which cost function applies to which technology, and 
estimates of t.


I would put Excel and scripting language solutions into A.  I would put 
Access into B (unfortunately, there does not appear to be a FOSS B),  I 
would put .NET, Java, CORBA, LAMP, etc., into C.  Using Perl, I estimate 
your app should be t < tAB.


David

[toc] | [prev] | [next] | [standalone]

#225526 — Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and spreadsheet tools?

[Multipart message — attachments visible in raw view] — view raw

On Wed, Jul 29, 2020 at 01:09:15PM -0700, David Christensen wrote:
> On 2020-07-29 05:03, Richard Owlett wrote:
> 
> >[A suggested] approach is literally orders of magnitude more than I want.
> 
> 
> Consider these idealized cost functions for solution technologies A,
> B, and C:
> 
>     fA(t) = t*t + 1
> 
>     fB(t) = (t/3)*(t/3) + 10
> 
>     fC(t) = (t/10/*(t/10) + 100
[...]

I really fear that's the way economists operate. This would explain
a lot of things ;-P

Cheers
-- t

[toc] | [prev] | [next] | [standalone]

#225573 — Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and spreadsheet tools?

On 7/29/20 06:03, Richard Owlett wrote:
> On 07/29/2020 06:13 AM, Joe wrote:
>> [snip]
>>
>> I'd recommend using the right tool for the job.
>>
> 
> Which is why I'll investigate.
> Your approach is literally orders of magnitude more than I want.

With respect, Joe is right, in my opinion based on some about 20 as a
DBA and later head of the database branch in a DOD agency.

I quite understand what you are proposing, and over the years the branch
spent a good deal of time and taxpayer resources sorting such
applications developed by accountants to help them in their work. Over
time they grew big and complex beyond their original simple design,
scaled and performed poorly, became infected with data (and formula)
errors that the developers could not fix. All too often the developers
had retired or otherwise moved on and their successors, who had little
understanding of the application beyond its use, were completely at a
loss. It was a mess, and around the time I retired, we did an agency
wide search and found around 500 of them, quite a few critical to
accounting operations yet largely undocumented and often seriously at
variance with accepted accounting rules and standards. The projected
cost of cleaning up was mind-boggling.

Many of those concerns, of course, do not apply to a relatively small
dietary application like you are considering (but consider Joe's size
metrics). A number of them do.

1. Lack of documentation. It takes a lot of discipline to document any
application even to the point where the developer, after a few weeks,
can easily identify its organization and fix or extend it. That is more
difficult with a set of spreadsheets than with a proper relational
database where the defining statements go a considerable way to
documenting themselves.

2. Errors. A decently designed relational database will present fewer
opportunities to insert data errors and make them easier to find and fix
when they do creep in.

3. Work involved. It is entirely possible to design a relational system
based only on CSV or other flat files; Unix, and I suppose Linux even
provides commands for most or all of the fundamental processes, and
desktop machines no more than a decade or so old can perform reasonably
well for small and moderate size databases and straightforward queries,
although performance will fall fairly rapidly with size and complexity,
and designing queries is harder and more labor intensive and error prone
than using a tool - SQL - designed for the job.

I have not looked at recutils, and my opinion is not necessarily worth
much as far as they are concerned. That said, I think it is unlikely
that the learning curve would be lower or less steep than with a proper
DBMS. My preference in a Linux environment is Postgres, but MariaDB and
SQLite are quite up to the task. Any of them can be installed with a
single command, and at least one probably already is installed. Their
configuration for basic use is not difficult, and there are ample web
based and probably public library based sources of "howto" information.

You are the best judge of your situation, but the notion that setting up
and using a proper database is "literally orders of magnitude more than"
a utility based alternative almost certainly is rubbish; it is, at
worst, only slightly more, and the benefits are substantially more.

Regards,
Tom Dial

[toc] | [prev] | [next] | [standalone]

#225525 — Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and spreadsheet tools?

On Wednesday, 29 Jul 2020 at 04:40, Richard Owlett wrote:
> On 07/27/2020 10:13 AM, Eric S Fraga wrote:
>> You may wish to have a look at recutils:
>
> A database is over-kill for some personal preferences.
>
> I had mentioned spreadsheets in original post as I had visualized a

I am confused. You also mentioned databases and specifically SQL for
querying databases.

No worries.
-- 
Eric S Fraga via Emacs 28.0.50 & org 9.3.7 on Debian bullseye/sid

[toc] | [prev] | [next] | [standalone]

#225532 — Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and spreadsheet tools?

On 07/30/2020 04:21 AM, Eric S Fraga wrote:
> On Wednesday, 29 Jul 2020 at 04:40, Richard Owlett wrote:
>> On 07/27/2020 10:13 AM, Eric S Fraga wrote:
>>> You may wish to have a look at recutils:
>>
>> A database is over-kill for some personal preferences.
>>
>> I had mentioned spreadsheets in original post as I had visualized a
> 
> I am confused. You also mentioned databases and specifically SQL for
> querying databases.
> 
> No worries.
> 

Quoting yours truly:
>> SQL {and variants} seen to dominate all else.
>> IIRC, dBase was simpler. 

Does that sound at all like I saw anything in favor of SQL ?????  !

[toc] | [prev] | [next] | [standalone]

#225552 — Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and spreadsheet tools?

On Thursday, 30 Jul 2020 at 06:15, Richard Owlett wrote:
> Does that sound at all like I saw anything in favor of SQL ?????  !

No but you said:

> IIRC, dBase was simpler.

so I suggested a simple FOSS database system.  Like I said, no
worries.  I obviously misunderstood what you were looking for.

-- 
Eric S Fraga via Emacs 28.0.50 & org 9.3.7 on Debian bullseye/sid

[toc] | [prev] | [next] | [standalone]

#225559 — Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and spreadsheet tools?

On 7/30/20 5:21 AM, Eric S Fraga wrote:

> On Wednesday, 29 Jul 2020 at 04:40, Richard Owlett wrote:
>> On 07/27/2020 10:13 AM, Eric S Fraga wrote:
>>> You may wish to have a look at recutils:
>> A database is over-kill for some personal preferences.
>>
>> I had mentioned spreadsheets in original post as I had visualized a
> I am confused. You also mentioned databases and specifically SQL for
> querying databases.
>
Yes, indeed - it sure seems like SQL will be necessary for either querying,
or importing from, databases of nutritional content.  Building the app around
and SQL engine - say SQL Lite - would seem to make a lot of sense.

Anything else, and some kind of converter will be needed.

Miles Fidelman


-- 
In theory, there is no difference between theory and practice.
In practice, there is.  .... Yogi Berra

Theory is when you know everything but nothing works.
Practice is when everything works but no one knows why.
In our lab, theory and practice are combined:
nothing works and no one knows why.  ... unknown

[toc] | [prev] | [next] | [standalone]

#225561 — Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and spreadsheet tools?

On 07/30/2020 09:51 AM, Miles Fidelman wrote:
> In theory, there is no difference between theory and practice.
> In practice, there is.  .... Yogi Berra

[toc] | [prev] | [next] | [standalone]

#225567 — Re: [Interim Solution] Re: FOSS equivalents of *OLD* database and spreadsheet tools?

On Thu, 30 Jul 2020 10:51:06 -0400
Miles Fidelman <mfidelman@meetinghouse.net> wrote:

> On 7/30/20 5:21 AM, Eric S Fraga wrote:
> 
> > On Wednesday, 29 Jul 2020 at 04:40, Richard Owlett wrote:  
> >> On 07/27/2020 10:13 AM, Eric S Fraga wrote:  
> >>> You may wish to have a look at recutils:  
> >> A database is over-kill for some personal preferences.
> >>
> >> I had mentioned spreadsheets in original post as I had visualized
> >> a  
> > I am confused. You also mentioned databases and specifically SQL for
> > querying databases.
> >  
> Yes, indeed - it sure seems like SQL will be necessary for either
> querying, or importing from, databases of nutritional content.
> Building the app around and SQL engine - say SQL Lite - would seem to
> make a lot of sense.
> 
> Anything else, and some kind of converter will be needed.
>

There's at least one US database in spreadsheet form, I found it a
couple of years ago. The problem for me was that the numbers aren't the
same for the UK, even with basic foodstuffs, and the proprietary foods
are formulated for local market preferences. I'm mostly using a UK
database with about 3000 entries.

I wasn't keen on the idea of tapping an Internet database directly.
Firstly, the Net is a lot more ephemeral than we like to think, and
things do just disappear, but also these databases are of variable
quality, often containing alphabetic characters where numbers are
expected. I preferred to make my own databases, cleaning up information
where necessary and dropping most of the nutrients. I also often need
to create entries, both from the sides of packets for packaged foods
and ingredients lists for home-cooked dishes.

-- 
Joe

[toc] | [prev] | [next] | [standalone]

#225542

On 07/27/2020 10:13 AM, Eric S Fraga wrote:
> You may wish to have a look at recutils:
> 
> https://www.gnu.org/software/recutils/
> 
> but it may not have some of the functionality you wish (although you
> could build on it with shell scripts & awk, say).
> 

I've just begun going through the manual
   [https://www.gnu.org/software/recutils/manual/]
It appears to be a good match for what I want to do.

I prefer reading manuals offline. Is it available as a single HTML document?

TIA

[toc] | [prev] | [next] | [standalone]

#225545 — Re: FOSS equivalents of *OLD* database and spreadsheet tools?

[Multipart message — attachments visible in raw view] — view raw

Richard Owlett writes:

> On 07/27/2020 10:13 AM, Eric S Fraga wrote:
>> You may wish to have a look at recutils:
>>
>> https://www.gnu.org/software/recutils/
>>
>> but it may not have some of the functionality you wish (although you
>> could build on it with shell scripts & awk, say).
>>
>
> I've just begun going through the manual
>   [https://www.gnu.org/software/recutils/manual/]
> It appears to be a good match for what I want to do.
>
> I prefer reading manuals offline. Is it available as a single HTML document?

I have not found it as a single HTML document, but it should be possible to
generate it given that the online variant is also generated -- the HTML source
tells it was generated by `makeinfo` which you can find it in package texinfo.

On a Debian system with deb-src lines and texinfo installed, I could do:

	$ aptitude source recutils
	$ mkdir sub
	$ tar -C sub -xf recutils_1.7.orig.tar.gz
	$ cd sub
	$ makeinfo --html ./recutils-1.7/doc/recutils.texi

Afterwards, the generated HTML files (not a single document, but the same
view you find online) were available in directory `sub/recutils`.

If it is just about offline reading and less about the HTML: Seems the
complete documentation is shipped as part of Debian package recutils
(access it via `info recutils`).

HTH
Linux-Fan

[toc] | [prev] | [next] | [standalone]

#225548

On 07/30/2020 08:03 AM, Linux-Fan wrote:
> Richard Owlett writes:
> 
>> On 07/27/2020 10:13 AM, Eric S Fraga wrote:
>>> You may wish to have a look at recutils:
>>>
>>> https://www.gnu.org/software/recutils/
>>>
>>> but it may not have some of the functionality you wish (although you
>>> could build on it with shell scripts & awk, say).
>>>
>>
>> I've just begun going through the manual
>>   [https://www.gnu.org/software/recutils/manual/]
>> It appears to be a good match for what I want to do.
>>
>> I prefer reading manuals offline. Is it available as a single HTML 
>> document?
> 
> I have not found it as a single HTML document, but it should be possible to
> generate it given that the online variant is also generated -- the HTML 
> source
> tells it was generated by `makeinfo` which you can find it in package 
> texinfo.
> 
> On a Debian system with deb-src lines and texinfo installed, I could do:
> 
>      $ aptitude source recutils
>      $ mkdir sub
>      $ tar -C sub -xf recutils_1.7.orig.tar.gz
>      $ cd sub
>      $ makeinfo --html ./recutils-1.7/doc/recutils.texi
> 
> Afterwards, the generated HTML files (not a single document, but the same
> view you find online) were available in directory `sub/recutils`.
> 
> If it is just about offline reading and less about the HTML: Seems the
> complete documentation is shipped as part of Debian package recutils
> (access it via `info recutils`).
> 

As I'm already familiar with it, I'll use WebHTTrack to get a local copy 
of the manual. Being able to jump to references [my reason to prefer 
HTML] is more important than ease of stepping linearly thru a document 
[i.e. using space key in 'info'].

Thanks.

[toc] | [prev] | [next] | [standalone]

#225970 — Example(s) of recutils project flow? - was [FOSS equivalents of *OLD* database and spreadsheet tools?]

On 07/27/2020 10:13 AM, Eric S Fraga wrote:
> You may wish to have a look at recutils:
> 
> https://www.gnu.org/software/recutils/
> 
> but it may not have some of the functionality you wish (although you
> could build on it with shell scripts & awk, say).
> 

I've done a first read of the well written manual which has many 
examples of individual commands. Are there any examples of project 
workflow using shell scripts or Tcl?

TIA

[toc] | [prev] | [next] | [standalone]

#225972 — Re: Example(s) of recutils project flow? - was [FOSS equivalents of *OLD* database and spreadsheet tools?]

On Fri, 7 Aug 2020 at 21:31, Richard Owlett <rowlett@cloud85.net> wrote:
> On 07/27/2020 10:13 AM, Eric S Fraga wrote:
> > You may wish to have a look at recutils:

> > https://www.gnu.org/software/recutils/

> I've done a first read of the well written manual which has many
> examples of individual commands. Are there any examples of project
> workflow using shell scripts or Tcl?

https://www.google.com/search?q=recutils+script+example

[toc] | [prev] | [next] | [standalone]

#225975 — Re: Example(s) of recutils project flow? - was [FOSS equivalents of *OLD* database and spreadsheet tools?]

On 08/07/2020 06:46 AM, David wrote:
> On Fri, 7 Aug 2020 at 21:31, Richard Owlett <rowlett@cloud85.net> wrote:
>> On 07/27/2020 10:13 AM, Eric S Fraga wrote:
>>> You may wish to have a look at recutils:
> 
>>> https://www.gnu.org/software/recutils/
> 
>> I've done a first read of the well written manual which has many
>> examples of individual commands. Are there any examples of project
>> workflow using shell scripts or Tcl?
> 
> https://www.google.com/search?q=recutils+script+example
> 

I had done similar search with DuckDuckGo receiving similarly useless hits.
I tried more restrictive forms of your search i.e.
https://www.google.com/search?gbv=1&q=%2Brecutils+%2Bscript+%2Bexample
and
https://www.google.com/search?gbv=1&q=%2B%22recutils%22+%2B%22tcl%22+%2B%22example%22

The second is especially irrelevant - it *ACTIVELY* ignores request that 
"recutils" *MUST* be present.

That's why I'm looking for a human's answer.
Thank you.

[toc] | [prev] | [next] | [standalone]

#226105 — Re: Example(s) of recutils project flow? - was [FOSS equivalents of *OLD* database and spreadsheet tools?]

[Multipart message — attachments visible in raw view] — view raw

On Vi, 07 aug 20, 07:33:05, Richard Owlett wrote:
> 
> I had done similar search with DuckDuckGo receiving similarly useless hits.

[...]
 
> That's why I'm looking for a human's answer.

It helps to specify in advance what you tried already and didn't work.

Kind regards,
Andrei
-- 
http://wiki.debian.org/FAQsFromDebianUser

[toc] | [prev] | [standalone]

Page 3 of 3 — ← Prev page 1 2 [3]

Back to top | Article view | linux.debian.user

csiph-web