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 2 of 3 — ← Prev page 1 [2] 3  Next page →

#225407

On 7/27/20 9:59 PM, rhkramer@gmail.com wrote:

> Somebody wrote:
<that would have been me>
>> But... isn't the tool the least of your problems?  The big one being,
>> where are you going to get your nutritional database. (Seems to me that
>> most of what Weight Watchers and Noom do is collect data on millions of
>> products.)
>  From my records in my free format database (which would not be suitable for
> your program (at least not in its present condition), some notes on available
> databases.
>
>  From "USDA databases" Thu Sep 08 06:57:41 2016
> Date: 09/08/16 06:57 am
> Subject: USDA databases

<snip>

What a great list of databases!  Thanks for posting this.  Who knew?

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]

#225357

On Mon 27 Jul 2020 at 11:16:45 (-0400), Michael Stone wrote:
> On Mon, Jul 27, 2020 at 08:09:36AM -0400, Greg Wooledge wrote:
> > For a project of this size and scope, a Tcl application with an sqlite3
> > database in a local file seems well suited.
> 
> Only on the internet can someone ask a simple question and get tcl as
> the answer. :-/

It should suit the OP. For example,

https://lists.debian.org/debian-user/2018/07/msg00756.html

Cheers,
David.

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

#225360

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

On Mon, Jul 27, 2020 at 11:16:45AM -0400, Michael Stone wrote:
> On Mon, Jul 27, 2020 at 08:09:36AM -0400, Greg Wooledge wrote:
> >For a project of this size and scope, a Tcl application with an sqlite3
> >database in a local file seems well suited.
> 
> Only on the internet can someone ask a simple question and get tcl
> as the answer. :-/

For quick one-off GUI scripts it's still hard to beat, though.

Cheers
-- t

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

#225361

On 7/27/20 11:16 AM, Michael Stone wrote:

> On Mon, Jul 27, 2020 at 08:09:36AM -0400, Greg Wooledge wrote:
>> For a project of this size and scope, a Tcl application with an sqlite3
>> database in a local file seems well suited.
>
> Only on the internet can someone ask a simple question and get tcl as 
> the answer. :-/

Well...

1. Where else would you ask the question, if not "the internet?"

2. tcl is still pretty cool - some great things are written in it, like 
fossil-scm (the DCVS used for sqlite, built on sqlite, in tcl, by the 
author of sqlite)

Seems like a great idea.




-- 
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]

#225258

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

On Sat, Jul 25, 2020 at 12:38:10PM -0500, Richard Owlett wrote:
> Back in 70's/80's I wrote programs as part of routine job duties.
>   {8080/8085 assembler, dBase and Paradox}
> Neither I, nor my employers, classed me as a "programmer".
> I was "Senior Engineering Tech" or "Junior Engineer".
> IOW, I was not in abject *AWE* of computers. *ROFL*
> 
> Right now I'm working on a personal project.
> INPUT:	How much of what did I eat?
> OUTPUT:	How much [cal/protein/fiber] did I eat?
> 
> SQL {and variants} seen to dominate all else.
> IIRC, dBase was simpler.
> 
> What current FOSS system might I be comfortable with?

There are a couple of packages which might fit your
loose description (Disclaimer: I never tried any of
those). Perhaps kexi. Browse through the output of

  aptitude search '~sdatabase'

... there might be some nuggets in there.

Good luck
-- t

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

#225259

> On Sat, Jul 25, 2020 at 12:38:10PM -0500, Richard Owlett wrote:
>> Back in 70's/80's I wrote programs as part of routine job duties.
>>    {8080/8085 assembler, dBase and Paradox}
>> Neither I, nor my employers, classed me as a "programmer".
>> I was "Senior Engineering Tech" or "Junior Engineer".
>> IOW, I was not in abject *AWE* of computers. *ROFL*
>>
>> Right now I'm working on a personal project.
>> INPUT:	How much of what did I eat?
>> OUTPUT:	How much [cal/protein/fiber] did I eat?
>>
>> SQL {and variants} seen to dominate all else.
>> IIRC, dBase was simpler.
>>
>> What current FOSS system might I be comfortable with?

You might try googling "open source alternatives to dbase" - there seems 
to be quite a list.  Or you could go with a NoSQL database like CouchDB.

But... isn't the tool the least of your problems?  The big one being, 
where are you going to get your nutritional database. (Seems to me that 
most of what Weight Watchers and Noom do is collect data on millions of 
products.)

Good Eating,

Miles Fidelman

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

#225265

On Sat, 25 Jul 2020 12:38:10 -0500
Richard Owlett <rowlett@cloud85.net> wrote:

> Back in 70's/80's I wrote programs as part of routine job duties.
>    {8080/8085 assembler, dBase and Paradox}
> Neither I, nor my employers, classed me as a "programmer".
> I was "Senior Engineering Tech" or "Junior Engineer".
> IOW, I was not in abject *AWE* of computers. *ROFL*
> 
> Right now I'm working on a personal project.
> INPUT:	How much of what did I eat?
> OUTPUT:	How much [cal/protein/fiber] did I eat?
> 
> SQL {and variants} seen to dominate all else.
> IIRC, dBase was simpler.

I think you will want SQL for this job. You will need a query with a
join of two tables. Spreadsheets really can't do that on a large scale.
I have no doubt that there are other ways (e.g. the hard way, by
programming the join code from scratch) but SQL makes that part fairly
easy. Flat-file databases are OK for trivial card-file applications,
but as soon as you want joins, you need to go relational and that
pretty much means SQL. I must admit, that after many years of dabbling,
I can still barely speak basic SQL, but that's all most simple jobs
need.
> 
> What current FOSS system might I be comfortable with?

Shame about that. If you didn't need FOSS I'd recommend Microsoft
Access, by far the best piece of software they ever produced (not that
it's a high bar). It combines a simple database server, OK for one user,
with a visual RAD system to make the user interface. Beyond doubt, it's
the quickest way to do what you want, and you can probably do most of
what you need with no code at all, just editing properties of objects.
But you have to walk the Dark Path, and pay money.

There will never be a FOSS Access, because the FOSS database people
sneer at it. A damn cheek, given the appalling state of LibreOffice
Base. I've tried to use that, but it's impossibly buggy. OK for editing
tables, now that it is finally able to talk to remote database servers
reliably and without ODBC, but disastrous for making user interfaces.
The last time I used the Report Writer (literally the last time ever) it
simply wasn't working at all, and I needed to produce an invoice
urgently. I ended up writing a PDF generator in PHP, single-purpose
certainly, just for my invoices, but it's guaranteed to work. No
software rot until PHP8...

The hard part of any database job is the user interface, an SQL database
server like MariaDb Just Works, as does SQLite. I've tried a variety of
methodologies, including CakePHP and Laravel (also a PHP framework). I
was hoping that a framework would reduce the amount of work, which they
do in some ways, but they introduce a huge amount of extra baggage. OK
if you're building something with dozens of forms and tables, or if
you're doing this every day professionally, but it doesn't help much
with simple hobby jobs. PhpMyEdit is good for really simple jobs, but it
doesn't scale well. 

I have a server, so I naturally build web applications, which are
automatically cross-platform. But I think even with a single modestly
powered computer, it's as easy to do it that way as to build interfaces
with graphics toolkits. HTML is adequate for most jobs, though *still*
missing a couple of obvious user interface features. I consider the use
of JavaScript to be an admission of defeat, but sometimes there's no
way around it. But my little netbook runs Apache2 with PHP7 and
MariaDb quite happily, for when I need to do some work away from home,
and it's trivial to copy SQL databases between servers. My first server
had 256MB of RAM, and Apache2/PHP5 and MySQL worked OK on that.

Here's how I did what you want to do: I have two main tables, the
journal and the food data. I have a third table of food categories,
which is only used as an input aid, as I currently have over 300 types
of food, which would not work well in a single drop-down list. I have a
fourth table of users, in case the application ever gets used by more
than one person.

I have three main web pages: the primary one is to make journal entries,
and show cumulative figures for single days or date ranges. it can also
edit existing entries. The next most important is for adding new foods,
which again allows editing of existing foods. There are various
databases on the Net giving nutritional values for thousands of food
types, and of course there's the side of the packet for packaged foods.
These two pages I made by hand, with a mix of PHP and HTML. The third
is a week-based statistics page, which I made with Laravel, but which
again had some hand-written PHP and HTML.

It has a few rough edges, as the programs you write for yourself never
get properly finished. I've done the 20%, I'm not willing to do the
other 80% to polish it. But it works.

Another pathway to user interfaces is either Visual Basic or Delphi, in
the FOSS form of Gambas and Lazarus. Good for making forms, but the
integration of databases is nowhere near as complete as with Access.
But it may suit you.

-- 
Joe

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

#225274

On 2020-07-25 13:22, Joe wrote:
> Shame about that. If you didn't need FOSS I'd recommend Microsoft
> Access, by far the best piece of software they ever produced (not that
> it's a high bar). It combines a simple database server, OK for one user,
> with a visual RAD system to make the user interface. Beyond doubt, it's
> the quickest way to do what you want, and you can probably do most of
> what you need with no code at all, just editing properties of objects.
> But you have to walk the Dark Path, and pay money.

+1


Using VBA to pull data from Access and feed it into other Office 
applications is very compelling-- Excel graphs, Word form letters, etc..


> There will never be a FOSS Access, because the FOSS database people
> sneer at it. A damn cheek, given the appalling state of LibreOffice
> Base. I've tried to use that, but it's impossibly buggy. OK for editing
> tables, now that it is finally able to talk to remote database servers
> reliably and without ODBC, but disastrous for making user interfaces.
> The last time I used the Report Writer (literally the last time ever) it
> simply wasn't working at all

Ouch.  was wondering about that when I posted the link to LibreOffice 
Base (which I have not tried for a very long time)...


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

https://en.wikipedia.org/wiki/Lamp_stack


David

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

#225289

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.

-- 
Joe

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

#225291

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.

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.

mick
-- 
Key ID    4BFEBB31

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

#225294

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

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

#225308

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

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

#225266

On 2020-07-25 10:38, Richard Owlett wrote:
> Back in 70's/80's I wrote programs as part of routine job duties.
>    {8080/8085 assembler, dBase and Paradox}
> Neither I, nor my employers, classed me as a "programmer".
> I was "Senior Engineering Tech" or "Junior Engineer".
> IOW, I was not in abject *AWE* of computers. *ROFL*
> 
> Right now I'm working on a personal project.
> INPUT:    How much of what did I eat?
> OUTPUT:    How much [cal/protein/fiber] did I eat?
> 
> SQL {and variants} seen to dominate all else.
> IIRC, dBase was simpler.
> 
> What current FOSS system might I be comfortable with?

https://en.wikipedia.org/wiki/LibreOffice_Base


David

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

#225271

On Saturday, July 25, 2020 01:38:10 PM Richard Owlett wrote:
> Back in 70's/80's I wrote programs as part of routine job duties.
>    {8080/8085 assembler, dBase and Paradox}
> Neither I, nor my employers, classed me as a "programmer".
> I was "Senior Engineering Tech" or "Junior Engineer".
> IOW, I was not in abject *AWE* of computers. *ROFL*
> 
> Right now I'm working on a personal project.
> INPUT:	How much of what did I eat?
> OUTPUT:	How much [cal/protein/fiber] did I eat?

There is a FOSS (I believe -- I'm pretty sure the source is available) program 
that does that -- can't recall the name -- will check my notes this evening.

It is a little less slick than some of the commercial programs, but it does 
import a database with the nutritional values of quite a few foods (it's from 
a federal agency, like the FDA or something).  It would be nice if more people 
worked on it and brought it up to date.  (For one thing, it uses an older 
version of that database -- it should be set up so that it can easily link to 
any new database that comes along._
 
> SQL {and variants} seen to dominate all else.
> IIRC, dBase was simpler.
> 
> What current FOSS system might I be comfortable with?

Well Libre / Open Office has a database that might be somewhat similar to 
Microsoft Access (and thus Paradox and dBase).

I have been working towards my own free format database (ala askSam) for a 
number of years (I don't want to say how many), but it does work for me.  

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

#225295

On Sat, Jul 25, 2020 at 12:38:10PM -0500, Richard Owlett wrote:
>Back in 70's/80's I wrote programs as part of routine job duties.
>  {8080/8085 assembler, dBase and Paradox}
>Neither I, nor my employers, classed me as a "programmer".
>I was "Senior Engineering Tech" or "Junior Engineer".
>IOW, I was not in abject *AWE* of computers. *ROFL*
>
>Right now I'm working on a personal project.
>INPUT:	How much of what did I eat?
>OUTPUT:	How much [cal/protein/fiber] did I eat?
>
>SQL {and variants} seen to dominate all else.
>IIRC, dBase was simpler.
>
>What current FOSS system might I be comfortable with?

Take a look at kexi

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

#225296

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

On Sun, Jul 26, 2020 at 10:24:25AM -0400, Michael Stone wrote:
> On Sat, Jul 25, 2020 at 12:38:10PM -0500, Richard Owlett wrote:
> >Back in 70's/80's I wrote programs as part of routine job duties.
> > {8080/8085 assembler, dBase and Paradox}
> >Neither I, nor my employers, classed me as a "programmer".
> >I was "Senior Engineering Tech" or "Junior Engineer".
> >IOW, I was not in abject *AWE* of computers. *ROFL*
> >
> >Right now I'm working on a personal project.
> >INPUT:	How much of what did I eat?
> >OUTPUT:	How much [cal/protein/fiber] did I eat?
> >
> >SQL {and variants} seen to dominate all else.
> >IIRC, dBase was simpler.
> >
> >What current FOSS system might I be comfortable with?
> 
> Take a look at kexi

Yes, I mentioned that already, although I can't vouch for it because
it's not the class of application I delve in.

I'm sure there are a few apps covering that.

Cheers
-- t

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

#225297

On Sun, 26 Jul 2020 10:24:25 -0400
Michael Stone <mstone@debian.org> wrote:

> On Sat, Jul 25, 2020 at 12:38:10PM -0500, Richard Owlett wrote:
> >Back in 70's/80's I wrote programs as part of routine job duties.
> >  {8080/8085 assembler, dBase and Paradox}
> >Neither I, nor my employers, classed me as a "programmer".
> >I was "Senior Engineering Tech" or "Junior Engineer".
> >IOW, I was not in abject *AWE* of computers. *ROFL*
> >
> >Right now I'm working on a personal project.
> >INPUT:	How much of what did I eat?
> >OUTPUT:	How much [cal/protein/fiber] did I eat?
> >
> >SQL {and variants} seen to dominate all else.
> >IIRC, dBase was simpler.
> >
> >What current FOSS system might I be comfortable with?  
> 
> Take a look at kexi
> 

Yes, that might be the way for the OP. I looked at it some years ago,
I've just installed it and looked again, and it *still* cannot connect
to an existing SQL database. It can use an SQL server, but only to make
its own databases. It can import data. But it can't share an existing
database with other types of client.

It bills itself as an equal to Access, and for all I know it might be
such when working with its own private databases. But Access could
operate as a front end to various external databases when it was
Access2 under Windows 3.1, when I first encountered it.

-- 
Joe

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

#225298

On Sun, Jul 26, 2020 at 06:58:06PM +0100, Joe wrote:
>On Sun, 26 Jul 2020 10:24:25 -0400
>Michael Stone <mstone@debian.org> wrote:
>
>> On Sat, Jul 25, 2020 at 12:38:10PM -0500, Richard Owlett wrote:
>> >Back in 70's/80's I wrote programs as part of routine job duties.
>> >  {8080/8085 assembler, dBase and Paradox}
>> >Neither I, nor my employers, classed me as a "programmer".
>> >I was "Senior Engineering Tech" or "Junior Engineer".
>> >IOW, I was not in abject *AWE* of computers. *ROFL*
>> >
>> >Right now I'm working on a personal project.
>> >INPUT:	How much of what did I eat?
>> >OUTPUT:	How much [cal/protein/fiber] did I eat?
>> >
>> >SQL {and variants} seen to dominate all else.
>> >IIRC, dBase was simpler.
>> >
>> >What current FOSS system might I be comfortable with?
>>
>> Take a look at kexi
>>
>
>Yes, that might be the way for the OP. I looked at it some years ago,
>I've just installed it and looked again, and it *still* cannot connect
>to an existing SQL database. It can use an SQL server, but only to make
>its own databases. It can import data. But it can't share an existing
>database with other types of client.

As I understood the OPs requirements, that's irrelevant. They're 
probably best off with sqlite hiding in the backend of a forms-based DB 
frontend.

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

#225341

Hi,

If you decide against a command line system and  decide to go SQL / Klexi way, I want to suggest to you a relatively lesser known integrated database system - http://www.suneido.com. It has been around for nearly 20 years. It is pretty easy to design and stable. It is FOSS. The only problem is that it is available only for the Windows platform.
If you still want to go the command line way, have a look at https://www.gnu.org/software/recutils/. From the description at the site, 
" GNU Recutils is a set of tools and libraries to access human-editable, plain text databases called recfiles. The data is stored as a sequence of records, each record containing an arbitrary number of named fields. The picture below shows a sample database containing information about GNU packages, along with the main features provided by recutils.",it looks like it is the program you have been looking for. (Disclaimer: I know nothing about the program.)

All the best,
ajith





On Saturday, 25 July, 2020, 11:08:42 pm IST, Richard Owlett <rowlett@cloud85.net> wrote: 





Back in 70's/80's I wrote programs as part of routine job duties.
  {8080/8085 assembler, dBase and Paradox}
Neither I, nor my employers, classed me as a "programmer".
I was "Senior Engineering Tech" or "Junior Engineer".
IOW, I was not in abject *AWE* of computers. *ROFL*

Right now I'm working on a personal project.
INPUT:    How much of what did I eat?
OUTPUT:    How much [cal/protein/fiber] did I eat?

SQL {and variants} seen to dominate all else.
IIRC, dBase was simpler.

What current FOSS system might I be comfortable with?

TIA

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

#225349

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).
-- 
Eric S Fraga via Emacs 28.0.50 & org 9.3.7 on Debian bullseye/sid

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

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

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

csiph-web