Re: FOSS equivalents of *OLD* database and spreadsheet tools?
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 "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?
> >
> I used dBase (FoxPro) and Paradox decades ago. My advice: learn SQL and
> select the DBMS of your choice. SQLite3, PostgreSQL, MySQL. For
> portability and low traffic, I'd select SQLite3.
I think I indirectly made that suggestion in this thread
https://lists.debian.org/debian-user/2018/07/msg00057.html
which referred back to the OP's own thread
https://lists.debian.org/debian-user/2018/06/msg00757.html
> Gone are the days of xBase and the like. SQL is the lingua franca for
> all modern database systems. And SQLite3 has bindings for most modern
> languages.
>
> Since you probably would like an application with a nice interface
One can never be sure: the OP seems pretty fearless when it comes to CLIs.
> (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. Otherwise, you're looking at fiddly code with GTK or QT
> (or ncurses).
Cheers,
David.
Reply to: