Puppy Linux Discussion Forum Forum Index Puppy Linux Discussion Forum
Puppy HOME page : puppylinux.com
"THE" alternative forum : puppylinux.info
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

The time now is Wed 20 Sep 2017, 00:15
All times are UTC - 4
 Forum index » Advanced Topics » Cutting edge
Puppy Database
Moderators: Flash, Ian, JohnMurga
Post new topic   Reply to topic View previous topic :: View next topic
Page 17 of 18 [265 Posts]   Goto page: Previous 1, 2, 3, ..., 15, 16, 17, 18 Next
Author Message
smokey01


Joined: 30 Dec 2006
Posts: 2642
Location: South Australia

PostPosted: Mon 14 Aug 2017, 17:30    Post subject:  

Yeah the original version menu wasn't in a very logical order and the terms used didn't make much sense, not to me anyway, so I changed it.
old.png
 Description   The original version
 Filesize   16.61 KB
 Viewed   584 Time(s)

old.png

new.png
 Description   My modified version
 Filesize   17.86 KB
 Viewed   582 Time(s)

new.png


_________________
Software <-> Distros <-> Tips <-> Newsletters
Back to top
View user's profile Send private message Visit poster's website 
6502coder


Joined: 23 Mar 2009
Posts: 382
Location: Western United States

PostPosted: Mon 14 Aug 2017, 17:51    Post subject:  

smokey01 wrote:
@musher0, found the problem.

I had a directory called tmp in /root that was created by another app. This prevented touch from creating a file called tmp in /root.

I noticed this too when I played with fields.awk. It's one of the first things I changed. Applications writing temporary files in the user's home directory is a BIG NO-NO in my book. That's what /tmp is for!
Back to top
View user's profile Send private message 
greengeek


Joined: 20 Jul 2010
Posts: 4636
Location: Republic of Novo Zelande

PostPosted: Tue 15 Aug 2017, 03:46    Post subject:  

6502coder wrote:
smokey01 wrote:
@musher0, found the problem.

I had a directory called tmp in /root that was created by another app. This prevented touch from creating a file called tmp in /root.

I noticed this too when I played with fields.awk. It's one of the first things I changed. Applications writing temporary files in the user's home directory is a BIG NO-NO in my book. That's what /tmp is for!
But wouldn't the same problem have occurred if the file already existed in /tmp? The way I read it the problem is the failure to detect if the file already exists (and choose a different file name or location if so...). Doesn't matter where the file already exists - the question is what to do about that.
Back to top
View user's profile Send private message 
6502coder


Joined: 23 Mar 2009
Posts: 382
Location: Western United States

PostPosted: Tue 15 Aug 2017, 16:04    Post subject:  

Well, first off, touch simply changes the timestamp on a file -- it doesn't matter whether the file already exists or not -- so there shouldn't have been a permissions problem, unless maybe some of that shady spot/fido business was involved.

Secondly, the shell provides mechanisms for making unique temporary file names, and that's what I always do. The mktemp command is probably the best way, but being old-school I usually use the classic method of including $$ (the process ID) as part of the file name.
Back to top
View user's profile Send private message 
musher0


Joined: 04 Jan 2009
Posts: 10793
Location: Gatineau (Qc), Canada

PostPosted: Thu 17 Aug 2017, 16:59    Post subject:  

Hello everyone.

Have we forgotten that all Puppies have on board THE very powerful
sqlite3 database processor? Wink

Now that we're reminded, the next thing we lazy bones must do is learn
the sqlite language! Laughing

This one-liner will call it as a stand-alone window, like in the attached pic.
Code:
urxvt -bg snow -fg "#432D1E" -g 90x28 +tr -cr orange -bd orange3 -b 20 -e sqlite3

You may fiddle with it as you like.

Please remember that If you use the above line in a script or make it into
a string, the foreground color ( -fg ) will have to be written '\#432D1E'. As
a general rule, in such situations, the # character of any hex color needs
to be escaped.

BFN
sqlite3-on-Puppies.jpg
 Description   
 Filesize   54.11 KB
 Viewed   443 Time(s)

sqlite3-on-Puppies.jpg


_________________
musher0
~~~~~~~~~~
« Un insensé sur le trône n'est qu'un singe sur le haut d'un toit. » / "A madman
on the throne is just a monkey on top of a roof." (Bernard de Clervaux)
Back to top
View user's profile Send private message 
smokey01


Joined: 30 Dec 2006
Posts: 2642
Location: South Australia

PostPosted: Thu 17 Aug 2017, 17:26    Post subject:  

Thanks musher. I hadn't forgotten about sqlite but last time I looked it nearly did my head in. I'm currently writing a small database similar to awk. Maybe I should re-visit sqlite.
_________________
Software <-> Distros <-> Tips <-> Newsletters
Back to top
View user's profile Send private message Visit poster's website 
musher0


Joined: 04 Jan 2009
Posts: 10793
Location: Gatineau (Qc), Canada

PostPosted: Thu 17 Aug 2017, 23:15    Post subject:  

Hi Smokey01.

You're brave! I wouldn't even think of trying to emulate awk!

Best of luck!

_________________
musher0
~~~~~~~~~~
« Un insensé sur le trône n'est qu'un singe sur le haut d'un toit. » / "A madman
on the throne is just a monkey on top of a roof." (Bernard de Clervaux)
Back to top
View user's profile Send private message 
Pelo


Joined: 10 Sep 2011
Posts: 12468
Location: Mer méditerrannée (1 kms°)

PostPosted: Fri 18 Aug 2017, 06:02    Post subject: When you must create your reports, then only the best go on.  

SQLite Manager 0.8.3.1 available as addon in Firefox and Seamonkey 290kb
Easy to create fields, and to fulfill, but so boring !
When you must create your reports, that will get everybody giving up.
Downloads : 5.000.000 (more)
vendee85.jpg
 Description   108 reecords, people providing French revolution army with food.
 Filesize   78.51 KB
 Viewed   393 Time(s)

vendee85.jpg


_________________
Passenger Pelo ! don't ask him to repair the aircraft. Don't use him as a demining dog .... pleeease.
Back to top
View user's profile Send private message Yahoo Messenger 
smokey01


Joined: 30 Dec 2006
Posts: 2642
Location: South Australia

PostPosted: Fri 18 Aug 2017, 08:38    Post subject:  

SQLiteStudio doesn't look too bad but much bigger than I want. I might try and wrap a gtkdialog around sqlite one day.

@musher0 I'm not competing with awk, using some awk, grep and gtkdialog.

Only a few more hurdles to jump.

_________________
Software <-> Distros <-> Tips <-> Newsletters
Back to top
View user's profile Send private message Visit poster's website 
musher0


Joined: 04 Jan 2009
Posts: 10793
Location: Gatineau (Qc), Canada

PostPosted: Fri 18 Aug 2017, 17:52    Post subject:  

@ Smokey01:
I still think you're brave! Smile

_________________
musher0
~~~~~~~~~~
« Un insensé sur le trône n'est qu'un singe sur le haut d'un toit. » / "A madman
on the throne is just a monkey on top of a roof." (Bernard de Clervaux)
Back to top
View user's profile Send private message 
smokey01


Joined: 30 Dec 2006
Posts: 2642
Location: South Australia

PostPosted: Fri 18 Aug 2017, 19:38    Post subject:  

musher0 wrote:
@ Smokey01:
I still think you're brave! Smile


Maybe just a little stupid as well Crying or Very sad Crying or Very sad Embarassed Embarassed

_________________
Software <-> Distros <-> Tips <-> Newsletters
Back to top
View user's profile Send private message Visit poster's website 
musher0


Joined: 04 Jan 2009
Posts: 10793
Location: Gatineau (Qc), Canada

PostPosted: Fri 18 Aug 2017, 19:40    Post subject:  

Smile
_________________
musher0
~~~~~~~~~~
« Un insensé sur le trône n'est qu'un singe sur le haut d'un toit. » / "A madman
on the throne is just a monkey on top of a roof." (Bernard de Clervaux)
Back to top
View user's profile Send private message 
smokey01


Joined: 30 Dec 2006
Posts: 2642
Location: South Australia

PostPosted: Fri 01 Sep 2017, 18:41    Post subject:  

CatDude and myself have been working on a little database application written in gtkdialog. It's small, fast and simple to use. It's based on Ian R. Forsyth's fields.awk database with some serious modifications. It should run on any Linux OS, 32 or 64bit with bash, sed, awk, gawk and gtkdialog2.

There are a lot of things going on under the hood. We even changed the colours to make it easier on the eyes, especially when using it late at night.

Thanks to some1, MochiMoppel and musher0 for a little guidance along the way.
spd-1.1-noarch-1.txz.gz
Description  For Slackware based systems like Slacko and Fatdog.
Fake gz, just remove the .gz
gz

 Download 
Filename  spd-1.1-noarch-1.txz.gz 
Filesize  7.59 KB 
Downloaded  37 Time(s) 
spd-1.1-noarch.pet
Description  For distros that use pets.
pet

 Download 
Filename  spd-1.1-noarch.pet 
Filesize  7.55 KB 
Downloaded  36 Time(s) 
spd.png
 Description   This is what it looks like.
 Filesize   99.24 KB
 Viewed   261 Time(s)

spd.png


_________________
Software <-> Distros <-> Tips <-> Newsletters

Last edited by smokey01 on Sat 09 Sep 2017, 21:32; edited 5 times in total
Back to top
View user's profile Send private message Visit poster's website 
Minnesota

Joined: 11 Sep 2008
Posts: 325

PostPosted: Sat 02 Sep 2017, 12:15    Post subject: Installing
Subject description: explination please
 

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.

Please a few instructions.

Thanks.

Is the comment regarding dependencies relevant to Fatdog64-100 or are they included in the base or pet?
Back to top
View user's profile Send private message 
musher0


Joined: 04 Jan 2009
Posts: 10793
Location: Gatineau (Qc), Canada

PostPosted: Sat 02 Sep 2017, 12:28    Post subject:  

smokey01 wrote:
CatDude and myself have been working on a little database application written in gtkdialog. It's small, fast and simple to use. It's based on Ian R. Forsyth's fields.awk database with some serious modifications. It should run on any Linux OS, 32 or 64bit with bash, sed, awk, gawk and gtkdialog2.

There are a lot of things going on under the hood. We even changed the colours to make it easier on the eyes, especially when using it late at night.

Thanks to some1, MochiMoppel and musher0 for a little guidance along the way.

Hi smokey01.

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

BFN.

_________________
musher0
~~~~~~~~~~
« Un insensé sur le trône n'est qu'un singe sur le haut d'un toit. » / "A madman
on the throne is just a monkey on top of a roof." (Bernard de Clervaux)
Back to top
View user's profile Send private message 
Display posts from previous:   Sort by:   
Page 17 of 18 [265 Posts]   Goto page: Previous 1, 2, 3, ..., 15, 16, 17, 18 Next
Post new topic   Reply to topic View previous topic :: View next topic
 Forum index » Advanced Topics » Cutting edge
Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 0.0662s ][ Queries: 15 (0.0047s) ][ GZIP on ]