Puppy Database

Under development: PCMCIA, wireless, etc.
Message
Author
musher0
Posts: 14629
Joined: Mon 05 Jan 2009, 00:54
Location: Gatineau (Qc), Canada

#256 Post by musher0 »

Hi CatDude and smokey01.

"was inspired by Ian Forsyth?" "but heavily modified"?
Please rub it in. How the man must feel.
I am this close from calling you "ingrates"...

Anyway I disagree with this kind of initiative -- passing a CLI program
for a GUI one through cosmetic changes.

If you want to run Fields.awk in a separate window, you can do it with a
wrapper like this:

Code: Select all

#!/bin/sh
# fields_awk.sh
# Launcher for Ian R. Forsyth's fields.awk script
# Can be called from a *.desktop file in /usr/share/applications.
# (c) musher0, Nov. 28, 2015; rév. : 19 juillet 2017.
####
FNT="fn xft:LiberationMono:pixelsize=14:antialias=true:autohint=true"
UrXvT="rxvt -sr -$FNT -b 15 -bd grey50 -tint SaddleBrown -sh 90"
[ -e /usr/bin/fields_ext.awk ] && $UrXvT -e fields_ext.awk
# This way, the script can be run from anywhere, provided
# the launcher and the script are in the same folder.
The advantage is that Ian's code is not changed. It's his work, he changes it
as he sees fit. He is not dead yet, AFAIK.

If you are that allergic to CLI programs. please go see a doctor? It is a
curable condition, I think.

BFN.
musher0
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)

User avatar
smokey01
Posts: 2813
Joined: Sat 30 Dec 2006, 23:15
Location: South Australia :-(
Contact:

Re: Installing

#257 Post by smokey01 »

Minnesota wrote:For the novice of the world and group.
I am using fatdog64-710, put both the pet and the Txz on a stick.

Inserted stick into the computer with Fatdog clicked on, asked to extract txz file. OK, created files on the stick. Guess wrong location.
Next extracted to running fatdog location sda. What next?

Ran pet, same situation- no obvious actions. Some of us do not know how to run things without a menu entry or at least instructions.
Why would you use a pet file in Fatdog64-710? Fatdog uses .txz packages. All you have to do is right click on the package and install it.

There is a menu entry under Utilities.
Minnesota wrote: Please a few instructions.

Thanks.

Is the comment regarding dependencies relevant to Fatdog64-100 or are they included in the base or pet?
Most, if not all pups have those dependencies so they shouldn't cause an issue. Once the application is running you will see some help under the menu bar help or tool-tips.

User avatar
smokey01
Posts: 2813
Joined: Sat 30 Dec 2006, 23:15
Location: South Australia :-(
Contact:

#258 Post by smokey01 »

musher0 wrote:Have you broken the news to Ian?
I hope he does not have a heart condition.
Did you get his permission first?

BFN.
I'm not sure, have I?

User avatar
smokey01
Posts: 2813
Joined: Sat 30 Dec 2006, 23:15
Location: South Australia :-(
Contact:

#259 Post by smokey01 »

musher0 wrote:Hi CatDude and smokey01.

"was inspired by Ian Forsyth?" "but heavily modified"?
Please rub it in. How the man must feel.
I am this close from calling you "ingrates"...
He should feel honoured as I give him credit where it's due.
musher0 wrote: Anyway I disagree with this kind of initiative -- passing a CLI program
for a GUI one through cosmetic changes.
Are you serious. Out of 460 lines of code less than 20 lines resemble fields.awk. I think that's just a little more than cosmetic changes.
musher0 wrote: If you want to run Fields.awk in a separate window, you can do it with a
wrapper like this:

Code: Select all

#!/bin/sh
# fields_awk.sh
# Launcher for Ian R. Forsyth's fields.awk script
# Can be called from a *.desktop file in /usr/share/applications.
# (c) musher0, Nov. 28, 2015; rév. : 19 juillet 2017.
####
FNT="fn xft:LiberationMono:pixelsize=14:antialias=true:autohint=true"
UrXvT="rxvt -sr -$FNT -b 15 -bd grey50 -tint SaddleBrown -sh 90"
[ -e /usr/bin/fields_ext.awk ] && $UrXvT -e fields_ext.awk
# This way, the script can be run from anywhere, provided
# the launcher and the script are in the same folder.
The advantage is that Ian's code is not changed. It's his work, he changes it
as he sees fit. He is not dead yet, AFAIK.
musher0 wrote: If you are that allergic to CLI programs. please go see a doctor? It is a
curable condition, I think.
Now come on musher0 you know that's not true as we've had this discussion in the past. Many people prefer a GUI to a terminal, this just provides choice.

I just watched his video again at:
https://www.youtube.com/embed/HC8Az9W8F ... autoplay=0 where he says if anyone wants to convert it into a GUI he said "that's Ok."

Cheers

Minnesota
Posts: 326
Joined: Thu 11 Sep 2008, 11:25

more help

#260 Post by Minnesota »

Why would you use a pet file in Fatdog64-710? Fatdog uses .txz packages. All you have to do is right click on the package and install it

There is a menu entry under Utilities.


See attached photo and locations MENU is fatdog utility. No entry
Pfind locations.

As to WHY... I do not know any better!
Attachments
Utility Menu and locations.jpg
(88.14 KiB) Downloaded 254 times

User avatar
smokey01
Posts: 2813
Joined: Sat 30 Dec 2006, 23:15
Location: South Australia :-(
Contact:

#261 Post by smokey01 »

@Minnesota I take it you're new to Fatdog.

First go back and read my post where you downloaded the files.
http://www.murga-linux.com/puppy/viewto ... 277#966277 You only need this one: http://www.murga-linux.com/puppy/viewto ... &id=110935 You do not need the PET one. All older and most newer Puppy distributions use pet files. To install them, simply left mouse click on them and follow the prompts. Not so in Fatdog.

After you download the file you need to remove the .gz extansion on the package. You can do this with Rox by right clicking on spd-1.0-noarch-1.txz.gz and select Rename, then just delete the .gz on the end and click rename. The forum doesn't allow uploads with txz extensions.

With Fatdog you right mouse click on the spd-1.0-noarch-1.txz file then select install package.

You can't see an icon because you had not installed the application, instead you extracted it.

Minnesota
Posts: 326
Joined: Thu 11 Sep 2008, 11:25

installing

#262 Post by Minnesota »

"With Fatdog you right mouse click on the spd-1.0-noarch-1.txz file then select install package."

Sorry this was not obvious to Me. I left clicked and received the extract dialog.

Just was informed a program I wrote in 2001 is still being used. Linux is a foreign language to me.

Thank your for your assistance. Menu item now shows. I will play with the program.

User avatar
smokey01
Posts: 2813
Joined: Sat 30 Dec 2006, 23:15
Location: South Australia :-(
Contact:

#263 Post by smokey01 »

Updated spd to 1.1

Made a few changes:
Now it will work with much larger files. Tested it with a 100,000 record database. It should work with a much larger database file.
I think the output looks a little better.
Added an advanced search so up to three terms can be entered for each record. Look under File menu Item.
Added some more help at /usr/share/doc/spd/spd.md
http://www.murga-linux.com/puppy/viewto ... 277#966277

Pelo

Sorting 100.000 records.. It's huge.

#264 Post by Pelo »

database and database management are not the same..
CSV files are data. Dmcsv or CSVfix are usefull and very tiny. But sorting 100.000 records.. It's huge. How long will that take with your system ?

User avatar
smokey01
Posts: 2813
Joined: Sat 30 Dec 2006, 23:15
Location: South Australia :-(
Contact:

Re: Sorting 100.000 records.. It's huge.

#265 Post by smokey01 »

Pelo wrote:database and database management are not the same..
CSV files are data. Dmcsv or CSVfix are usefull and very tiny. But sorting 100.000 records.. It's huge. How long will that take with your system ?
@Pelo, The datafile is 12451926bytes (12M) in size. There are 100,003 records consisting of five fields each.

If I enter an advanced search of a record that I know is unique and at the end of the datafile, it takes less than a second to display it. If I click on search without any filtering, in other words, load the entire datafile, it takes about three seconds to start displaying records. I takes about 25 seconds to load the entire datafile.

I'm happy with the performance.

The advanced search uses grep and the default single search uses awk. Grep is a little quicker than awk.

User avatar
greengeek
Posts: 5789
Joined: Tue 20 Jul 2010, 09:34
Location: Republic of Novo Zelande

#266 Post by greengeek »

Hi Smokey, on a slacko 5.6 derivative I get "failed to install" when attempting to install the puppy database. Is a Slacko 5.6 version possible do you think? cheers!

User avatar
smokey01
Posts: 2813
Joined: Sat 30 Dec 2006, 23:15
Location: South Australia :-(
Contact:

#267 Post by smokey01 »

greengeek wrote:Hi Smokey, on a slacko 5.6 derivative I get "failed to install" when attempting to install the puppy database. Is a Slacko 5.6 version possible do you think? cheers!
The PET package is compressed with xz. If you can convert it to gz it should work or install xz to slacko-5.6 might also work.

User avatar
greengeek
Posts: 5789
Joined: Tue 20 Jul 2010, 09:34
Location: Republic of Novo Zelande

#268 Post by greengeek »

smokey01 wrote:The PET package is compressed with xz. If you can convert it to gz it should work or install xz to slacko-5.6 might also work.
Hi Smokey, I do appear to have xz in my Slacko but i just can't get the pet to install nor can I get it to extract the pet either (normally I rename a pet as .pet.tgz to extract it but it sees no contents)

Code: Select all

# which xz
/bin/xz
#
Does anyone have any suggestions or has anyone succeeded in installing this on Slacko 5.6?

EDIT :Never mind - got it sorted. All I needed to do to extract the pet was to rename it with a txz suffix (not tgz as i normally do). Then I realised I should just use the other txz package you offered anyway. Installed no worries. Only took me 6 months. Got there in the end :oops:

cheers!

User avatar
greengeek
Posts: 5789
Joined: Tue 20 Jul 2010, 09:34
Location: Republic of Novo Zelande

#269 Post by greengeek »

First question - if I am adding field names and make a mistake (eg I added "contact1", then "contact2", then tried to delete "contact2" so that I could add "address1" instead) I can't seem to delete the erroneous field I just added. Do I need to start all over?
cheers

User avatar
smokey01
Posts: 2813
Joined: Sat 30 Dec 2006, 23:15
Location: South Australia :-(
Contact:

#270 Post by smokey01 »

greengeek wrote:First question - if I am adding field names and make a mistake (eg I added "contact1", then "contact2", then tried to delete "contact2" so that I could add "address1" instead) I can't seem to delete the erroneous field I just added. Do I need to start all over?
cheers
@greengeek, the first line of the database file defines the fields. Simply open it in a text editor and make the required changes.

User avatar
greengeek
Posts: 5789
Joined: Tue 20 Jul 2010, 09:34
Location: Republic of Novo Zelande

#271 Post by greengeek »

smokey01 wrote:the first line of the database file defines the fields. Simply open it in a text editor and make the required changes.
Thanks Smokey - that fact will help me understand better how to set up what I need. But - I still have a question about useability of your simple puppy database - when I tried to use it I realised I had to be a bit better organised when defining fields (especially after a glass of vino) and I thought "is it possible for Smokey to build an "undo" button into the gui? I didn't express that very well in my post but I think that one level of "undo" is all that is needed to make the gui much improved.

It is too easy to set a field in stone then think "dammit, I named that field wrong".

One step of "undo" would be fantastic. Multiple steps of undo would be perfection.

What do you think? Is that difficult to achieve?
cheers!

hamoudoudou

The difficulty is management, mainly creating reports.

#272 Post by hamoudoudou »

a database is very easy to build, remember data in your basic programs..
The difficulty is management, mainly creating reports.

Post Reply