Hello all.
Here is probably one of the best names and addresses database ever:
http://www.tranglos.com/free/phonedeck.html
A bit old, lacks incorporation of pictures, but still very good.
On the download page, don't forget the import-export module and
the language pack -- if you need them.
The tool to use if you have to do regular follow-ups with your
business or community contacts, IMO.
You need wine installed, though. I never had a problem
with it running under wine.
The grey-ish screenshots on the author's site are ugly. Phonedeck
will look much better than that if you have themed your wine.
( Here is another explanation of how to theme wine. )
BFN.
musher0
Puppy Database
Hello all.
I found an interesting "fields.awk" script through ask.com:
http://www.ask.com/youtube?q=fields.awk ... archTopBox
and I thought I'd share the discovery. It is a simple universal flat file database. You
request a copy by e-mailing the author, Ian R. Forsyth. (His e-mail address appears in
the intro of the video.)
Judging from the video, you can adapt it to any collection (photographs, etc.) or follow-
up situation (car maintenance, etc.). The video explains quite nicely how to work with it.
BFN.
musher0
~~~~~~~~~~
PS. As greengeek pointed out to me here, this is the correct address for the
fields.awk video:
https://www.youtube.com/embed/HC8Az9W8F ... autoplay=0
Thanks, greengeek.
I found an interesting "fields.awk" script through ask.com:
http://www.ask.com/youtube?q=fields.awk ... archTopBox
and I thought I'd share the discovery. It is a simple universal flat file database. You
request a copy by e-mailing the author, Ian R. Forsyth. (His e-mail address appears in
the intro of the video.)
Judging from the video, you can adapt it to any collection (photographs, etc.) or follow-
up situation (car maintenance, etc.). The video explains quite nicely how to work with it.
BFN.
musher0
~~~~~~~~~~
PS. As greengeek pointed out to me here, this is the correct address for the
fields.awk video:
https://www.youtube.com/embed/HC8Az9W8F ... autoplay=0
Thanks, greengeek.
Last edited by musher0 on Sat 18 Jun 2016, 20:46, edited 1 time in total.
-
Pelo
Many have bugs, they are still free of charge
i took a glance at awk videos. The guy speaks slowly enough to make me understand what he means.
What i want to underline, is that to judge a photo editor software, you must at least got one picture to work on it.
A database as for instance open concerto, you must at least enter one employee and give him existence to know if database works, only one ! That is not done...
Same for Laurux.. or GNUcash... How can you judge if a database has no bugs.
Many have bugs, that's the reason why they are still free of charge.
One serious guy is jopervasco from french forum. Beyond words, he acts.
SQLiteStudio last version is a real database, and Puppy can go with. Waiting for some customers... Really Windows users are more reliable, some even pay euros for using databases.
What i want to underline, is that to judge a photo editor software, you must at least got one picture to work on it.
A database as for instance open concerto, you must at least enter one employee and give him existence to know if database works, only one ! That is not done...
Same for Laurux.. or GNUcash... How can you judge if a database has no bugs.
Many have bugs, that's the reason why they are still free of charge.
One serious guy is jopervasco from french forum. Beyond words, he acts.
SQLiteStudio last version is a real database, and Puppy can go with. Waiting for some customers... Really Windows users are more reliable, some even pay euros for using databases.
- Attachments
-
- meute.jpg
- A csv file is needed. Create it with Osmo, then, export it to your real database.
- (49.55 KiB) Downloaded 765 times
-
- openconcerto.jpg
- openconcerto need at least one employee. Please enter one to test.
- (37.5 KiB) Downloaded 785 times
Hi pelo.
As for me, I find OpenConcerto, Laurux, & Company, "overkill" for my
needs. I see no point in spending more time keeping the database up-to-
date than doing my actual job.
But you did work in very large concerns, and that's your frame of
reference. That's fine, but please do not think that all businesses need
BIG databases.
Thanks for your understanding.
BFN.
musher0
As for me, I find OpenConcerto, Laurux, & Company, "overkill" for my
needs. I see no point in spending more time keeping the database up-to-
date than doing my actual job.
But you did work in very large concerns, and that's your frame of
reference. That's fine, but please do not think that all businesses need
BIG databases.
Thanks for your understanding.
BFN.
musher0
musher0
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)
Hello again all.
Regarding the fields.awk post above, here's a *.pet archive containing it.
This archive contains, in addition to the script, a launcher and a *.desktop
file, plus an icon that I've derived from one of Ian's illustrations. Those
don't make a "GUI" per se, but they do make launching the script from a
menu easier. A "lazy" user won't have to open a console and then launch
the database script, (s)he'll just click on the menu item to open it.
Depending on the categories activated in your Puppy, after installation,
you'll find the menu entry for the fields.awk script available either under
the "Personal" or the "Business" sub-menu.
I am joining a screen capture of the result. As you'll see I took the liberty
of adding a grey border and of using the DejaVuSansMono font, which is
already included in all Puppy distros, I believe (this way it doesn't weigh
down the *.pet archive any more than it needs to).
The *.pet also contains the author's permission to publish his script here,
under /usr/share/doc/fields.awk-1/. There is a short help panel available
by typing 'H' in the menu. If you need more, please remember to refer
to Ian's youtube video.
Finally, the jpg's at /usr/share/doc/fields.awk-1/ contain, near the top, Db
structures for receipts and car maintenance. You can recreate them and/or
use them as templates for other Db's.
Enjoy!
musher0
~~~~~~~~~~
(Edit, 2015-12-05.)
PS. I would be remiss not to mention that Ian R. Forsyth's attached
fields.awk script is licensed under GPL.
Regarding the fields.awk post above, here's a *.pet archive containing it.
This archive contains, in addition to the script, a launcher and a *.desktop
file, plus an icon that I've derived from one of Ian's illustrations. Those
don't make a "GUI" per se, but they do make launching the script from a
menu easier. A "lazy" user won't have to open a console and then launch
the database script, (s)he'll just click on the menu item to open it.
Depending on the categories activated in your Puppy, after installation,
you'll find the menu entry for the fields.awk script available either under
the "Personal" or the "Business" sub-menu.
I am joining a screen capture of the result. As you'll see I took the liberty
of adding a grey border and of using the DejaVuSansMono font, which is
already included in all Puppy distros, I believe (this way it doesn't weigh
down the *.pet archive any more than it needs to).
The *.pet also contains the author's permission to publish his script here,
under /usr/share/doc/fields.awk-1/. There is a short help panel available
by typing 'H' in the menu. If you need more, please remember to refer
to Ian's youtube video.
Finally, the jpg's at /usr/share/doc/fields.awk-1/ contain, near the top, Db
structures for receipts and car maintenance. You can recreate them and/or
use them as templates for other Db's.
Enjoy!
musher0
~~~~~~~~~~
(Edit, 2015-12-05.)
PS. I would be remiss not to mention that Ian R. Forsyth's attached
fields.awk script is licensed under GPL.
- Attachments
-
- fields.awk.gz
- Although the exact same is in the attached pet, for reference, here is a g'zip of Ian
Forsyth's bash/awk DB script as I received it from him by e-mail Nov. 28, 2015. - (3.89 KiB) Downloaded 305 times
-
- fields.awk_15-11-28.jpg
- (29.38 KiB) Downloaded 745 times
-
- fields.awk-1.pet
- (160.01 KiB) Downloaded 299 times
Last edited by musher0 on Sat 18 Jun 2016, 03:49, edited 2 times in total.
musher0
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)
Hello all.
I just received this precision from Ian R. Forsyth, the author of the
fields.awk script:
BFN.
musher0
I just received this precision from Ian R. Forsyth, the author of the
fields.awk script:
(Underlining by me).(...)
Also there is one small thing I wanted to mention as it might trip some
users up if not mentioned. That is the default labeling of all the
database files with .txt suffix. This could cause confusion in options S
(Select) and N (Create New). In the Select option the list of already
created database files is listed from which to select, and they all are
presented with their .txt suffix endings. But you don't include that in
your typed entry, just the name of the file. If you also include the
".txt" the script will think you mean [basename].txt.txt since it
handles the suffix by default. The result will be reading of a NULL file
with no data. Similarly in the N option, when it asks for the name of
the new datafile you want to create, don't include the ".txt".
(...)
BFN.
musher0
musher0
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)
-
Pelo
I did it with OpenConcerto, and lot of questions arrive at t
That's fine, but please do not think that all businesses need
BIG databases. sure, i agree. Personally what would I do with a big Database.
I was thinking about our businessmen, not retired employees as me.
Nevertheless enter one record to check if everything runs as scheduled, wouldn't be a so big effort.
I did it with OpenConcerto, and lot of questions arrive at the top, mainly the taxes to be applied depending on items
The coach on the blackboard has easy task, People in the workshop hardly run this database.
The main thing generally is time spent doing task, spare parts to do it, and level of employees.
the cost is apart, because employees are not aware of how much the boss makes benefits on their labour. Gnu-cash is the tool for the girls at the budgeting department.
Somebody used to Microsoft Access would easily manage with Puppy databases.
SQLite is enough, included in browsers. and a majority of us use it, by importing CSV files from Gnumeric or Osmo,
AWK pet downloaded. It's a barebone database, really.
BIG databases. sure, i agree. Personally what would I do with a big Database.
I was thinking about our businessmen, not retired employees as me.
Nevertheless enter one record to check if everything runs as scheduled, wouldn't be a so big effort.
I did it with OpenConcerto, and lot of questions arrive at the top, mainly the taxes to be applied depending on items
The coach on the blackboard has easy task, People in the workshop hardly run this database.
The main thing generally is time spent doing task, spare parts to do it, and level of employees.
the cost is apart, because employees are not aware of how much the boss makes benefits on their labour. Gnu-cash is the tool for the girls at the budgeting department.
Somebody used to Microsoft Access would easily manage with Puppy databases.
SQLite is enough, included in browsers. and a majority of us use it, by importing CSV files from Gnumeric or Osmo,
AWK pet downloaded. It's a barebone database, really.
Hello gungsukma and all.gungsukma wrote:SQLite must be good as Puppy database.
It is very small, it understands SQL, it is used anywhere,
may be you are using it now but you don't notice it.
The simplest way to use SQLite:
- install Firefox
- install add ons SQLite Manager
(Warning: just don't accidentally mesh your firefox database!)
The SQL superseded the DBF as the de facto database format
+/- twenty years ago. It gathered a lot of enthusiasts.
I'm not saying SQL is no good, problem is I still can't wrap my head
around it. I have smaller and simpler needs, like most people,
probably -- needs that are met with "good old" csv-type, so-called
"flat-file databases".
I find it easier to use join or combine on plain text files if I need to
establish some form of "relationship" between them or bring them
together. (String concatenation in a bash script may work too.)
~~~~~~~~~
Edit, 2015-12-05: That's why I find Ian Forsyth's "fields.awk" script
(above) interesting: it's quick to load, it's simple and to the point during
its operation, and it has no fancy commands or logic to remember.
~~~~~~~~~
Best regards.
musher0
musher0
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)
-
Colonel Panic
- Posts: 2171
- Joined: Sat 16 Sep 2006, 11:09
Me too, this is why I use PortaBase, which both imports and exports .csv files (Warren, aka WhoDo, produced an excellent pet of it a while back).musher0 wrote:Hello gungsukma and all.gungsukma wrote:SQLite must be good as Puppy database.
It is very small, it understands SQL, it is used anywhere,
may be you are using it now but you don't notice it.
The simplest way to use SQLite:
- install Firefox
- install add ons SQLite Manager
(Warning: just don't accidentally mesh your firefox database!)
The SQL superseded the DBF as the de facto database format
+/- twenty years ago. It gathered a lot of enthusiasts.
I'm not saying SQL is no good, problem is I still can't wrap my head
around it. I have smaller and simpler needs, like most people,
probably -- needs that are met with "good old" csv-type, so-called
"flat-file databases".
I find it easier to use join or combine on plain text files if I need to
establish some form of "relationship" between them or bring them
together. (String concatenation in a bash script may work too.)
~~~~~~~~~
Edit, 2015-12-05: That's why I find Ian Forsyth's "fields.awk" script
(above) interesting: it's quick to load, it's simple and to the point during
its operation, and it has no fancy commands or logic to remember.
~~~~~~~~~
Best regards.
musher0
EDIT: DaveS's is more current;
http://puppylinuxstuff.meownplanet.net/DaveS/portabase/
Gigabyte M68MT-52P motherboard, AMD Athlon II X4 630, 5.8 GB of DDR3 RAM and a 250 GB Hitachi hard drive running Ubuntu 16.04.6, MX-19.2, Peppermint 10, PCLinuxOS 20.02, LXLE 18.04.3, Pardus 19.2, exGENT 200119, Bionic Pup 8.0 and Xenial CE 7.5 XL.
About portabase: heads up! I had to un-install it on my LibrePup becauseThanks for reminding us, Colonel Panic.
I noticed on the portabase site a "call for templates", so to speak. However I
could not find any portabase templates on the site. Would anyone know
where to find some? It'd make life easier for a few people, no doubt.
Thanks in advance. BFN.
its Qt libraries prevented vlc and qupzilla from launching.
Last edited by musher0 on Tue 08 Dec 2015, 17:11, edited 1 time in total.
musher0
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)
-
gcmartin
I know I will get some heat on this concern. And coming from the old school PUPPY user background, many will scream "size".
But, has anyone looked around at smartPhones/smartTablets. No matter which mature one you look at, there is a "common" database in it. In fact, you CANNOT program without using it ... at some point via direct/indirect knowledge.
If we started to look at DBs for a PUP,
In fact, @BarryK's development Puppy distro; namely Appril has it built in, OOTB.
If it is used, there is little to no need to re-invent skills.
Just a thought. I whole-heartedly (maybe whole-heatedly) support DB use for any/everything 10 items or more!!!
But, has anyone looked around at smartPhones/smartTablets. No matter which mature one you look at, there is a "common" database in it. In fact, you CANNOT program without using it ... at some point via direct/indirect knowledge.
If we started to look at DBs for a PUP,
- Should we consider "future proofing" our selection?
- Shouldn't it contribute to a skillset that is universal?
In fact, @BarryK's development Puppy distro; namely Appril has it built in, OOTB.
If it is used, there is little to no need to re-invent skills.
Just a thought. I whole-heartedly (maybe whole-heatedly) support DB use for any/everything 10 items or more!!!
Hello, gc.
Borrowing Brahms reply to Wagner about music, I'll answer you:
"To the database of the future, I prefer the database that has one."
I don't see the value of deliberately making obsolete to users any
previous database format they may have stored their data in.
Unless of course you have a pricey database program to sell them.
BTW, man, looking at your recent posts, I am beginning to wonder:
"Are you on a campaign to bring down anything of traditional value in
computing?"
Your comments about touch screens, now this. You're still a good
Puppyist, but geez...
Don't impose your own views on the future, man, just let it become.
BFN.
Borrowing Brahms reply to Wagner about music, I'll answer you:
"To the database of the future, I prefer the database that has one."
I don't see the value of deliberately making obsolete to users any
previous database format they may have stored their data in.
Unless of course you have a pricey database program to sell them.
BTW, man, looking at your recent posts, I am beginning to wonder:
"Are you on a campaign to bring down anything of traditional value in
computing?"
Your comments about touch screens, now this. You're still a good
Puppyist, but geez...
Don't impose your own views on the future, man, just let it become.
BFN.
musher0
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)
-
gcmartin
Sorry @Musher0. As you know it is not meant to either offend. I only bring up the DB issue as I am looking at an industry pattern where I think it may be overlooked in its value. And, I see it as consistent with what your topic is drawing attention to. All DB products, that I am aware of, provide import-export/mapping abilities so that extracts for whatever reason are useful.
None of what I refer to is closed-source, proprietary, or commercial. That mentioned DB is open-source and anyone, using @BarryK's distro can create applications, even DB applications, which run on smart devices as well as Puppy Linux.
And, I am not trying to suggest that past technologies are not good technologies. I was a big dBase user back in the day, as well as DOS, as well as ... well you know.
My comments were to bring awareness.
None of what I refer to is closed-source, proprietary, or commercial. That mentioned DB is open-source and anyone, using @BarryK's distro can create applications, even DB applications, which run on smart devices as well as Puppy Linux.
And, I am not trying to suggest that past technologies are not good technologies. I was a big dBase user back in the day, as well as DOS, as well as ... well you know.
My comments were to bring awareness.
-
gcmartin
-
Colonel Panic
- Posts: 2171
- Joined: Sat 16 Sep 2006, 11:09
Sorry to hear it. I'm sure there's a way round that, but I don't know enough about Linux's file structure to be able to come up with it (something I hope to change soon). Could you install two versions of Qt in different locations, for example?musher0 wrote:About portabase: heads up! I had to un-install it on my LibrePup because its Qt libraries prevented vlc and qupzilla from launching.Thanks for reminding us, Colonel Panic.
I noticed on the portabase site a "call for templates", so to speak. However I
could not find any portabase templates on the site. Would anyone know
where to find some? It'd make life easier for a few people, no doubt.
Thanks in advance. BFN.
Gigabyte M68MT-52P motherboard, AMD Athlon II X4 630, 5.8 GB of DDR3 RAM and a 250 GB Hitachi hard drive running Ubuntu 16.04.6, MX-19.2, Peppermint 10, PCLinuxOS 20.02, LXLE 18.04.3, Pardus 19.2, exGENT 200119, Bionic Pup 8.0 and Xenial CE 7.5 XL.