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


Groups > linux.debian.user > #225308

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

From David Christensen <dpchrist@holgerdanske.com>
Newsgroups linux.debian.user
Subject Re: FOSS equivalents of *OLD* database and spreadsheet tools?
Date 2020-07-27 09:10 +0200
Message-ID <Ax5qN-36h-1@gated-at.bofh.it> (permalink)
References <Awwjn-6S3-1@gated-at.bofh.it> <AwyXU-8uW-1@gated-at.bofh.it> <AwAmZ-M7-9@gated-at.bofh.it> <AwJJD-6wn-1@gated-at.bofh.it> <AwLLr-7Xc-15@gated-at.bofh.it>
Organization linux.* mail to news gateway

Show all headers | View raw


On 2020-07-26 03:06, mick crane wrote:

>> On Sat, 25 Jul 2020 14:55:35 -0700 David Christensen wrote:

>>> It's been a while, but Linux-Apache-MySQL-Perl worked for me back in
>>> the day:

> I'm not very good at this and wondered how to do it and thought could 
> have things in a hash of hashes. As you tend to stick with a limited 
> variety of recipes wouldn't be that extensive for personal use. After 
> sorting out input.
> 
> my %food=(
> "ham sandwich"=>{
> cal=> .4,
> protein=>.2,
> fiber=>.3,
> },
> "cauliflower cheese"=>{
> cal=> .8,
> protein=>.3,
> fiber=>.1,
> },
> );
> my $calories= $food{$ARGV[0]}{cal}*$ARGV[1];
> 
> and add it to a weekly and daily totals file.


Perl data structures and algorithms can work when needs are few, simple, 
and fixed.  The UI is command-line options and arguments to the Perl 
script.  Data is stored in CSV or TSV files, and accessed with a 
library.  Reports are generated with a PDF library.  The key is that 
everything must fit into memory at once.


As complexity, change, and/or size increase, a database management 
system and SQL become necessary.


David

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


Thread

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

csiph-web