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

2020-07-30 Thread Tom Dial
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

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

2020-07-30 Thread Joe
On Thu, 30 Jul 2020 10:51:06 -0400 Miles Fidelman 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

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

2020-07-30 Thread Richard Owlett
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

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

2020-07-30 Thread Miles Fidelman
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

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

2020-07-30 Thread Eric S Fraga
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

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

2020-07-30 Thread Richard Owlett
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

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

2020-07-30 Thread Linux-Fan
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

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

2020-07-30 Thread Richard Owlett
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

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

2020-07-30 Thread Richard Owlett
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

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

2020-07-30 Thread tomas
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) =

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

2020-07-30 Thread Eric S Fraga
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

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

2020-07-29 Thread David Christensen
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:

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

2020-07-29 Thread Richard Owlett
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.

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

2020-07-29 Thread Joe
On Wed, 29 Jul 2020 04:40:24 -0500 Richard Owlett 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

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

2020-07-29 Thread mick crane
On 2020-07-29 10:40, Richard Owlett wrote: A database is over-kill for some personal preferences. apropos of nothing I found this great, clear introduction to Perl/Tk for inputting how many cups of coffee and bacon sandwiches you had.

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

2020-07-29 Thread Richard Owlett
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

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

2020-07-28 Thread Miles Fidelman
On 7/27/20 9:59 PM, rhkra...@gmail.com wrote: Somebody wrote: 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.)

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

2020-07-28 Thread mick crane
On 2020-07-27 22:46, Michael Stone wrote: On Mon, Jul 27, 2020 at 10:34:39PM +0100, Joe wrote: The OP is in a learning experience, it's what retirement is for. Huh. I thought it was for doing what you want instead of what other people tell you that you "have to" do. That's funny considering

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

2020-07-27 Thread Nicholas Geovanis
Yes, the Harbour project. https://harbour.github.io/ On Mon, Jul 27, 2020, 9:57 PM Nicholas Geovanis wrote: > There used to be an open-sourced version of Clipper, wasn't there? That > was the dBase 3 compiler from a 3rd party. Did that go extinct? > > On Mon, Jul 27, 2020, 8:59 PM wrote: > >>

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

2020-07-27 Thread Nicholas Geovanis
There used to be an open-sourced version of Clipper, wasn't there? That was the dBase 3 compiler from a 3rd party. Did that go extinct? On Mon, Jul 27, 2020, 8:59 PM wrote: > Somebody wrote: > > But... isn't the tool the least of your problems? The big one being, > > where are you going to get

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

2020-07-27 Thread rhkramer
Somebody wrote: > 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

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

2020-07-27 Thread David Wright
On Mon 27 Jul 2020 at 15:46:08 (-0400), Michael Stone wrote: > On Mon, Jul 27, 2020 at 11:39:11AM -0400, Greg Wooledge wrote: > > 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

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

2020-07-27 Thread Joe
On Mon, 27 Jul 2020 17:46:35 -0400 Michael Stone wrote: > On Mon, Jul 27, 2020 at 10:34:39PM +0100, Joe wrote: > >The OP is in a learning experience, it's what retirement is for. > > Huh. I thought it was for doing what you want instead of what other > people tell you that you "have to" do.

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

2020-07-27 Thread Joe
On Mon, 27 Jul 2020 22:22:12 +0200 wrote: > On Mon, Jul 27, 2020 at 04:04:16PM -0400, Michael Stone wrote: > > On Mon, Jul 27, 2020 at 09:52:28PM +0200, to...@tuxteam.de wrote: > > >And, in Greg's defense, he provided some code, something no > > >one of us did -- I'd say this round goes to him

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

2020-07-27 Thread Michael Stone
On Mon, Jul 27, 2020 at 10:34:39PM +0100, Joe wrote: The OP is in a learning experience, it's what retirement is for. Huh. I thought it was for doing what you want instead of what other people tell you that you "have to" do.

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

2020-07-27 Thread Joe
On Mon, 27 Jul 2020 16:04:16 -0400 Michael Stone wrote: > On Mon, Jul 27, 2020 at 09:52:28PM +0200, to...@tuxteam.de wrote: > >And, in Greg's defense, he provided some code, something no > >one of us did -- I'd say this round goes to him ;-) > > How? The OP request was for something simpler

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

2020-07-27 Thread tomas
On Mon, Jul 27, 2020 at 04:04:16PM -0400, Michael Stone wrote: > On Mon, Jul 27, 2020 at 09:52:28PM +0200, to...@tuxteam.de wrote: > >And, in Greg's defense, he provided some code, something no > >one of us did -- I'd say this round goes to him ;-) > > How? The OP request was for something

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

2020-07-27 Thread Greg Wooledge
On Mon, Jul 27, 2020 at 04:04:16PM -0400, Michael Stone wrote: > On Mon, Jul 27, 2020 at 09:52:28PM +0200, to...@tuxteam.de wrote: > > And, in Greg's defense, he provided some code, something no > > one of us did -- I'd say this round goes to him ;-) > > How? The OP request was for something

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

2020-07-27 Thread Michael Stone
On Mon, Jul 27, 2020 at 09:52:28PM +0200, to...@tuxteam.de wrote: And, in Greg's defense, he provided some code, something no one of us did -- I'd say this round goes to him ;-) How? The OP request was for something simpler than SQL (presumably because he didn't want to learn SQL?), so the

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

2020-07-27 Thread tomas
On Mon, Jul 27, 2020 at 03:46:08PM -0400, Michael Stone wrote: > On Mon, Jul 27, 2020 at 11:39:11AM -0400, Greg Wooledge wrote: [...] > >OK, here's a quick program to show how it might be done. > > The question wasn't "what's your favorite programming language", was it? To be fair, the

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

2020-07-27 Thread Michael Stone
On Mon, Jul 27, 2020 at 11:39:11AM -0400, Greg Wooledge wrote: 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

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

2020-07-27 Thread Miles Fidelman
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

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

2020-07-27 Thread tomas
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

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

2020-07-27 Thread David Wright
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

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

2020-07-27 Thread Greg Wooledge
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

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

2020-07-27 Thread Michael Stone
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. :-/

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

2020-07-27 Thread Eric S Fraga
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

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

2020-07-27 Thread Ajith R
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

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

2020-07-27 Thread Greg Wooledge
On Sat, Jul 25, 2020 at 02:45:58PM -0400, Paul M Foster wrote: > Since you probably would like an application with a nice interface > (curses, GUI, web), I'd suggest PHP. The platform for your interface is > in the server and the browser; you just have to write some HTML, which > is pretty easy.

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

2020-07-27 Thread David Christensen
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

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

2020-07-26 Thread Michael Stone
On Sun, Jul 26, 2020 at 06:58:06PM +0100, Joe wrote: On Sun, 26 Jul 2020 10:24:25 -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

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

2020-07-26 Thread Joe
On Sun, 26 Jul 2020 10:24:25 -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

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

2020-07-26 Thread tomas
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

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

2020-07-26 Thread Michael Stone
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

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

2020-07-26 Thread Joe
On Sun, 26 Jul 2020 11:06:51 +0100 mick crane wrote: > On 2020-07-26 08:54, Joe 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: > >> > >>

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

2020-07-26 Thread mick crane
On 2020-07-26 08:54, Joe 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: https://en.wikipedia.org/wiki/Lamp_stack I have a couple of early web applications written in Perl, but then I found

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

2020-07-26 Thread Joe
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: > > 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

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

2020-07-25 Thread Rh Kramer
I suspect the threading on this will be broken -- I forwarded it to another computer where I have my notes on my adventures with "nutrition" programs. On Saturday, July 25, 2020 6:40:47 PM you wrote: > -- Forwarded Message -- > > Subject: Re: FOSS equivalent

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

2020-07-25 Thread David Christensen
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.

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

2020-07-25 Thread rhkramer
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,

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

2020-07-25 Thread David Christensen
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*

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

2020-07-25 Thread Joe
On Sat, 25 Jul 2020 12:38:10 -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

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

2020-07-25 Thread David Wright
On Sat 25 Jul 2020 at 14:45:58 (-0400), Paul M Foster 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

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

2020-07-25 Thread Miles Fidelman
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

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

2020-07-25 Thread tomas
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". >

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

2020-07-25 Thread Paul M Foster
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". >