The time now is Mon 16 Dec 2019, 02:20
All times are UTC - 4 |
Page 15 of 19 [272 Posts] |
Goto page: Previous 1, 2, 3, ..., 13, 14, 15, 16, 17, 18, 19 Next |
Author |
Message |
Pete

Joined: 02 Mar 2014 Posts: 675
|
Posted: Sat 18 Jun 2016, 16:33 Post subject:
|
|
@greengeek
Edited my post after you posted yours.
|
Back to top
|
|
 |
greengeek

Joined: 20 Jul 2010 Posts: 5624 Location: Republic of Novo Zelande
|
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!
|
Back to top
|
|
 |
Pete

Joined: 02 Mar 2014 Posts: 675
|
Posted: Sat 18 Jun 2016, 16:46 Post subject:
|
|
Glad you got it sorted.
|
Back to top
|
|
 |
musher0
Joined: 04 Jan 2009 Posts: 14554 Location: Gatineau (Qc), Canada
|
Posted: Sat 18 Jun 2016, 16:54 Post subject:
|
|
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.
_________________ musher0
~~~~~~~~~~
Je suis né pour aimer et non pas pour haïr. (Sophocle) /
I was born to love and not to hate. (Sophocles)
|
Back to top
|
|
 |
greengeek

Joined: 20 Jul 2010 Posts: 5624 Location: Republic of Novo Zelande
|
Posted: Sun 19 Jun 2016, 02:47 Post subject:
|
|
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!
|
Back to top
|
|
 |
musher0
Joined: 04 Jan 2009 Posts: 14554 Location: Gatineau (Qc), Canada
|
Posted: Sun 19 Jun 2016, 09:08 Post subject:
|
|
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.
_________________ musher0
~~~~~~~~~~
Je suis né pour aimer et non pas pour haïr. (Sophocle) /
I was born to love and not to hate. (Sophocles)
|
Back to top
|
|
 |
smokey01

Joined: 30 Dec 2006 Posts: 2811 Location: South Australia :-(
|
Posted: Mon 27 Jun 2016, 22:12 Post subject:
|
|
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.
 |
Description |
Looks and works quite nicely. |
Filesize |
104.66 KB |
Viewed |
371 Time(s) |

|
_________________ Software <-> Distros <-> Tips <-> Newsletters
|
Back to top
|
|
 |
technosaurus

Joined: 18 May 2008 Posts: 4872 Location: Blue Springs, MO
|
Posted: Tue 28 Jun 2016, 00:00 Post subject:
|
|
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.
_________________ Check out my github repositories. I may eventually get around to updating my blogspot.
|
Back to top
|
|
 |
smokey01

Joined: 30 Dec 2006 Posts: 2811 Location: South Australia :-(
|
Posted: Tue 28 Jun 2016, 01:19 Post subject:
|
|
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
_________________ Software <-> Distros <-> Tips <-> Newsletters
|
Back to top
|
|
 |
smokey01

Joined: 30 Dec 2006 Posts: 2811 Location: South Australia :-(
|
Posted: Tue 28 Jun 2016, 06:17 Post subject:
|
|
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?
_________________ Software <-> Distros <-> Tips <-> Newsletters
|
Back to top
|
|
 |
jrb

Joined: 11 Dec 2007 Posts: 1330 Location: Smithers, BC, Canada
|
Posted: Tue 28 Jun 2016, 11:45 Post subject:
|
|
smokey01 wrote: | 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. |
Hardly elegant, but you can maintain a corresponding .csv to your database, copy and paste new import data into this in your spreadsheet program and then reimport the .csv file.
Cheers, J
|
Back to top
|
|
 |
Pelo
Joined: 10 Sep 2011 Posts: 12591 Location: Mer méditerrannée (1 kms°)
|
Posted: Tue 28 Jun 2016, 12:11 Post subject:
you need to enter some data... |
|
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 !
_________________ Passenger Pelo ! don't ask him to repair the aircraft. Don't use him as a demining dog .... pleeease.
Last edited by Pelo on Thu 30 Jun 2016, 13:16; edited 2 times in total
|
Back to top
|
|
 |
gcmartin
Joined: 14 Oct 2005 Posts: 6730 Location: Earth
|
Posted: Tue 28 Jun 2016, 12:13 Post subject:
|
|
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.
_________________ Get ACTIVE Create Circles; Do those good things which benefit people's needs!
We are all related ... Its time to show that we know this!
3 Different Puppy Search Engines or use DogPile
|
Back to top
|
|
 |
Pelo
Joined: 10 Sep 2011 Posts: 12591 Location: Mer méditerrannée (1 kms°)
|
Posted: Tue 28 Jun 2016, 12:20 Post subject:
There are a lot of databases available. |
|
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.
_________________ Passenger Pelo ! don't ask him to repair the aircraft. Don't use him as a demining dog .... pleeease.
Last edited by Pelo on Sun 21 May 2017, 21:08; edited 2 times in total
|
Back to top
|
|
 |
smokey01

Joined: 30 Dec 2006 Posts: 2811 Location: South Australia :-(
|
Posted: Tue 28 Jun 2016, 19:32 Post subject:
|
|
jrb wrote: | smokey01 wrote: | 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. |
Hardly elegant, but you can maintain a corresponding .csv to your database, copy and paste new import data into this in your spreadsheet program and then reimport the .csv file.
Cheers, J |
I do exactly that but you still have to re-do the form each time:-(
I guess it will have to do for now.
I'm using Ver 1.2. Has anyone managed to compile Ver 2.0?
_________________ Software <-> Distros <-> Tips <-> Newsletters
|
Back to top
|
|
 |
|
Page 15 of 19 [272 Posts] |
Goto page: Previous 1, 2, 3, ..., 13, 14, 15, 16, 17, 18, 19 Next |
|
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
|