Puppy Linux Discussion Forum

Pete · Joined: 02 Mar 2014 Posts: 675

@greengeek

Edited my post after you posted yours.

greengeek · Posted: Sat 18 Jun 2016, 16:45 Post subject:

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 · Joined: 02 Mar 2014 Posts: 675

Glad you got it sorted.

musher0 · Posted: Sat 18 Jun 2016, 16:54 Post subject:

greengeek · Posted: Sun 19 Jun 2016, 02:47 Post subject:

musher0 · Posted: Sun 19 Jun 2016, 09:08 Post subject:

smokey01 · Joined: 30 Dec 2006 Posts: 2731 Location: South Australia

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 · Joined: 18 May 2008 Posts: 4819 Location: Kingwood, TX

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 · Joined: 30 Dec 2006 Posts: 2731 Location: South Australia

smokey01 · Joined: 30 Dec 2006 Posts: 2731 Location: South Australia

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?

jrb · Posted: Tue 28 Jun 2016, 11:45 Post subject:

Pelo · Last edited by Pelo on Thu 30 Jun 2016, 13:16; edited 2 times in total

Ah symphytum will be recognized soon as one of the best databases available for Puppy Linux.People used to database know that the most boring is creating forms, id est GUIs. Symphytum one can be changed easily by dragging windows where you like.
Sure, to test database, you need to enter some data... The most difficult !

gcmartin · Joined: 14 Oct 2005 Posts: 6730 Location: Earth

I think form processing data into a database is normal and I clearly understand the advantage to using form processing and maintaining related data in a database.

SQLite is a good selection as it is, now, in so many places across the Linux variants. Thus any knowledge gained and understood in Puppyland in its use, extends that into other areas/devices we have in our hands or around us in PC systems. Thus, it allows any user who has some knowledge of it on one system to use that knowledge in data management when on another system. Knowledge, allows it use everywhere since SQLite has become ubiquitous in small Linux, unix, and open-source systems.

Hope the developers see some value in such a step. Opens the doors for PUPPY to appeal to a larger community for use in data management for all sorts of things we users now have.

If Forms Processing does get addressed, here in this thread, it might be time to create a new thread around that facility-database where its opening thread announces the thread mission. This might lead the thread viewers having ideas of use cases they can relate to and share with others.

Pelo · Last edited by Pelo on Sun 21 May 2017, 21:08; edited 2 times in total

There are a lot of databases available. Our dear colleagues only escape when arriving to fulfill them. It's not so fun.
I never succeed to get them entering the first record ! (excepted Jopervasco)
A nice data base is our PPM, simply... But everyone should enter new stuff there. In fact, lot of databases are existing, but structures are different. An huge project would be collect all existing ones.
Folder .packages is a database. PPM is the GUI.

smokey01 · Joined: 30 Dec 2006 Posts: 2731 Location: South Australia