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

Groups > linux.debian.user > #225294

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

Show key headers only | View raw

On Sun, 26 Jul 2020 11:06:51 +0100
mick crane <mick.crane@gmail.com> wrote:

> On 2020-07-26 08:54, Joe wrote:
> > On Sat, 25 Jul 2020 14:55:35 -0700
> > David Christensen <dpchrist@holgerdanske.com> wrote:
> >   
> >> 
> >> 
> >> It's been a while, but Linux-Apache-MySQL-Perl worked for me back
> >> in the day:
> >> 
> >> https://en.wikipedia.org/wiki/Lamp_stack  
> > 
> > I have a couple of early web applications written in Perl, but then
> > I found PHP. There's still no SQL user interface RAD tool like
> > Access, which uses SQL internally and externally, and has a lot of
> > database design knowledge built into it.  
> 
> 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.

I have something over 300 foods in my database, and I'm storing a dozen
parameters for each. I also don't want to calculate these parameters
for each entry in the journal, just enter the name and weight, that's
what joining two tables is for.
> 
> 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.
> 

Yes, though I had the impression the OP was looking for a suitable
database to do the job, rather than writing from scratch. I have run
web and SQL servers at home for twenty years, doing it the way I did
was the obvious route.

-- 
Joe

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