Puppy Database

Message

Pete · #201 Post by **Pete** » Tue 07 Jun 2016, 23:01

Sorry to revive such an old thread but was looking for a super simple database and landed up here.

Amazing how often it's the simple, easy things in life that make the most difference and fields.awk is one of those.
It suits my needs perfectly.

Thank you musher0 for posting about it and of course thanks to Ian R. Forsyth for writing it.

musher0 · #202 Post by **musher0** » Wed 08 Jun 2016, 01:05

Pete wrote:Sorry to revive such an old thread but was looking for a super simple database and landed up here.

Amazing how often it's the simple, easy things in life that make the most difference and fields.awk is one of those.
It suits my needs perfectly.

Thank you musher0 for posting about it and of course thanks to Ian R. Forsyth for writing it.

My pleasure!

Pete · #203 Post by **Pete** » Wed 08 Jun 2016, 10:20

BTW, the files produced by fields.awk are 99% compatible with Gnumeric.
By 99% I mean that if one leaves the "::" between fields, Gnumeric inserts the data on every second column.

Easy fix, make a copy of the database file, and replace all "::" with a single ":"

Now can import the file into Gnumeric (just select all files not database files)
and generate stats or even graphs.

The "@@@" at the beginning does not seem to bother Gnumeric at all.

It also occurred to me that field.awk is a perfect lightweight DB for small computers like the Rasp PI.
However be aware of this:

https://www.raspberrypi.org/forums/view ... 7&p=178094

The post is from 2012, so don't know if it still applies and don't have a PI (thinking of getting one) so can't test.

If anyone here has a PI and is willing to test and report back, that would be great.

Example file (with "::" removed):

Code: Select all

@@@Param1:Param2:Param3:Param4:
11:22:44:33:
12:24:46:38:
14:24:44:34:
11:22:44:33:

musher0 · #204 Post by **musher0** » Wed 08 Jun 2016, 16:35

Great find, Pete!

Thanks!

Pete · #205 Post by **Pete** » Wed 08 Jun 2016, 18:30

Pleasure musher0.

It also works in OpenOffice (3.4.1) under Mac.
Here I didn't even bother to take out the "::"

Pete · #206 Post by **Pete** » Wed 08 Jun 2016, 20:01

Also OK with Google Drive (Google Sheets).
Just need to specify "custom separator" i.e. "::"

Pete · #207 Post by **Pete** » Wed 08 Jun 2016, 23:06

Found a bug which is urxvt related and not fields.awk related.

When reading/displaying from a file and the data exceeds a certain amount of lines,
one cannot scroll down anymore even if it's made fullscreen.

I installed LXTerminal (ver 0.1.11) from the official Slacko 14 repo and problem gone.

Anyway I prefer LXTerminal as it has better copy+paste functionality.

Running Slacko 6.3 (32 bit)

greengeek · #208 Post by **greengeek** » Sat 18 Jun 2016, 20:20

Hi Musher, do you have a thread for fields.awk support? I tried to install the pet but it said "failed to install" (Slacko 5.6 derivative). I tried clicking the fields.awk script and my puppy doesn't know what to do with it (nor do I !!).

Any assistance or headslaps gratefully received.

Pete · #209 Post by **Pete** » Sat 18 Jun 2016, 20:28

@greengeek

I'm using Slacko 6.3 32 bit and fields.awk is working perfectly.
Keep in mind that as musher0 wrote, it's a CLI pgm so start a terminal, rather use LXTerminal over URXVT (available in the PPM) then just type in fields.awk

When you run fields.awk for the first time, it will ask you to select/create a database directory.
Ffom there then you can carry on.

Another point to note, fields.awk uses a .txt extension for it's databases.
When opening a new one, or selecting one, never include the extension, just the name else it gets all confused as it appends the .txt automatically so MyDB.txt will become MyDB.txt.txt which of course will not exist.

greengeek · #210 Post by **greengeek** » Sat 18 Jun 2016, 20:31

musher0 wrote:Hello all.

I found an interesting "fields.awk" script through ask.com:
http://www.ask.com/youtube?q=fields.awk ... archTopBox

Hi Musher - I think the link you posted should be replaced with this:
https://www.youtube.com/embed/HC8Az9W8F ... autoplay=0

(I also followed the link from one of your other posts but that just went to the search page too, instead of direct to the tutorial.

cheers!

Pete · #211 Post by **Pete** » Sat 18 Jun 2016, 20:33

@greengeek

Edited my post after you posted yours.

greengeek · #212 Post by **greengeek** » Sat 18 Jun 2016, 20:45

Thanks Pete. I had foolishly pre-pended the awk script with #!/bin/sh. Duh!
Got it working now - just need to view the tute a couple more times.
cheers!

Pete · #213 Post by **Pete** » Sat 18 Jun 2016, 20:46

Glad you got it sorted.

musher0 · #214 Post by **musher0** » Sat 18 Jun 2016, 20:54

greengeek wrote:
musher0 wrote:Hello all.

I found an interesting "fields.awk" script through ask.com:
http://www.ask.com/youtube?q=fields.awk ... archTopBox
Hi Musher - I think the link you posted should be replaced with this:
https://www.youtube.com/embed/HC8Az9W8F ... autoplay=0

(I also followed the link from one of your other posts but that just went to the search page too, instead of direct to the tutorial.

cheers!

Many thanks for pointing that out, greengeek. I corrected my original post about fields.awk.

If you could tell me where that "other post" is, I'll correct it too. (I've written a lot of posts
on this forum!)

TIA.

BFN.

greengeek · #215 Post by **greengeek** » Sun 19 Jun 2016, 06:47

musher0 wrote:If you could tell me where that "other post" is, I'll correct it too. (I've written a lot of posts
on this forum!)

It's this post back a couple of pages.
cheers!

musher0 · #216 Post by **musher0** » Sun 19 Jun 2016, 13:08

greengeek wrote:
musher0 wrote:If you could tell me where that "other post" is, I'll correct it too. (I've written a lot of posts
on this forum!)
It's this post back a couple of pages.
cheers!

Done! Simple as pie!

Thanks, greengeek. BFN.

smokey01 · #217 Post by **smokey01** » Tue 28 Jun 2016, 02:12

Trying to find a small intuitive database for Puppy has been a challenge. I really like stuffkeeper and portabase but they are both not quite complete. As I was searching this forum and the wider internet I came across symphytum. It has been previously mentioned by muggins, pelo, geoffrey and maybe others. The problem is it never really stood out and I don't understand why as it's very nice. It may have been because in the past it was not freeware, now it is.

It only has one drawback, it requires Qt4. For me that's not a problem because I use Fatdog64-702 or tahrpup-6.0.5 and they both have Qt4 included. Qt4 is a bit heavy but it does provide nice interfaces.

In form mode symphytum is very cool. You simply drag and drop the fields where you like within the working pane. In table mode you get the normal tabulated display. I couldn't find any user help for symphytum but then it's probably not necessary as it's so easy to use. It comes with a small database included to show you how it works.

The other thing I really like about symphytum is it's a single binary and only about 4.5M. You can run it from anyware. Simply drop it on your desktop if you like.

It's a bit like stuffkeeper, all of the tables, symphytum calls them collections, are stored in the same SQLite database. The database is stored here: /root/.local/share/data/giowisys/Symphytum
It took me a bit of time to find it. You will also notice there is a files directory in the same location. Any attached files are stored here. They could be images, pdf's etc. Unfortunately this location is hard coded. It could be changed in the source but it's probably easier to copy the Symphytum directory where you have lots of space then symlink it back.

I have made two packages available on my site here:
http://smokey01.com/symphytum/

They have only been tested on Fatdog64-702 and Tahrpup-6.0.5.

If you are looking for a database, symphytum is worth a look.

technosaurus · #218 Post by **technosaurus** » Tue 28 Jun 2016, 04:00

I liked: sqlite-manager
I find it a bit ironing that mozilla has been using sqlite the longest, but has no plan to support the Web SQL specification.

smokey01 · #219 Post by **smokey01** » Tue 28 Jun 2016, 05:19

technosaurus wrote:I liked: sqlite-manager
I find it a bit ironing that mozilla has been using sqlite the longest, but has no plan to support the Web SQL specification.

I installed sqlite-manager into seamonkey but it's a lot more complicated to use than symphytum. I guess it does cut down a bit of fat though.

Cheers

smokey01 · #220 Post by **smokey01** » Tue 28 Jun 2016, 10:17

Bugger! symphytum suffers a similar fate to stuffkeeper. Although symphytum can import data, it does it to a new collection/database. I want to be able to import data into an existing database, GGrrrr.

technosaurus is it possible to create forms and display images in SQLite-manager? If so How?

(old)Puppy Linux Discussion Forum

(old)Puppy Linux Discussion Forum

Puppy Database