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 Sat 18 Nov 2017, 12:12
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 15 of 18 [267 Posts]   Goto page: Previous 1, 2, 3, ..., 13, 14, 15, 16, 17, 18 Next
Author Message
Pete


Joined: 02 Mar 2014
Posts: 675

PostPosted: Sat 18 Jun 2016, 16:33    Post subject:  

@greengeek

Edited my post after you posted yours.
Back to top
View user's profile Send private message 
greengeek


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

PostPosted: 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
View user's profile Send private message 
Pete


Joined: 02 Mar 2014
Posts: 675

PostPosted: Sat 18 Jun 2016, 16:46    Post subject:  

Glad you got it sorted.
Back to top
View user's profile Send private message 
musher0


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

PostPosted: Sat 18 Jun 2016, 16:54    Post subject:  

greengeek wrote:
musher0 wrote:
Hello all.

I found an interesting "fields.awk" script through ask.com:
http://www.ask.com/youtube?q=fields.awk&qsrc=1&o=0&l=dir&qo=serpSearchTopBox
Hi Musher - I think the link you posted should be replaced with this:
https://www.youtube.com/embed/HC8Az9W8FV4?rel=0&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!) Smile TIA.

BFN.

_________________
musher0
~~~~~~~~~~
"Logical entities must not be multiplied beyond necessity." | |
« Il ne faut pas multiplier les entités logiques sans nécessité. » (Ockham)
Back to top
View user's profile Send private message 
greengeek


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

PostPosted: 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
View user's profile Send private message 
musher0


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

PostPosted: 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
~~~~~~~~~~
"Logical entities must not be multiplied beyond necessity." | |
« Il ne faut pas multiplier les entités logiques sans nécessité. » (Ockham)
Back to top
View user's profile Send private message 
smokey01


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

PostPosted: 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.
symphytum.png
 Description   Looks and works quite nicely.
 Filesize   104.66 KB
 Viewed   276 Time(s)

symphytum.png


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


Joined: 18 May 2008
Posts: 4756
Location: Kingwood, TX

PostPosted: 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
View user's profile Send private message Visit poster's website 
smokey01


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

PostPosted: 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
View user's profile Send private message Visit poster's website 
smokey01


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

PostPosted: 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
View user's profile Send private message Visit poster's website 
jrb


Joined: 11 Dec 2007
Posts: 1080
Location: Smithers, BC, Canada

PostPosted: 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
View user's profile Send private message 
Pelo

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

PostPosted: 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
View user's profile Send private message Yahoo Messenger 
gcmartin

Joined: 14 Oct 2005
Posts: 6730
Location: Earth

PostPosted: 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
View user's profile Send private message 
Pelo

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

PostPosted: 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
View user's profile Send private message Yahoo Messenger 
smokey01


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

PostPosted: 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
View user's profile Send private message Visit poster's website 
Display posts from previous:   Sort by:   
Page 15 of 18 [267 Posts]   Goto page: Previous 1, 2, 3, ..., 13, 14, 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.0585s ][ Queries: 14 (0.0057s) ][ GZIP on ]