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 31 Aug 2016, 00:26
All times are UTC - 4
 Forum index » Advanced Topics » Cutting edge
Stuffkeeper database app
Moderators: Flash, Ian, JohnMurga
Post new topic   Reply to topic View previous topic :: View next topic
Page 1 of 1 [14 Posts]  
Author Message
smokey01


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

PostPosted: Sat 18 Jun 2016, 08:02    Post subject:  Stuffkeeper database app
Subject description: SQLite front end. Very slick but a little different.
 

Over many years I have tried many Database applications that vary in size, complexity, ease of use and functionality.

In my opinion one of the best is Stuffkeeper. It fits very nicely with the Puppy vision as it's quite small and uses SQLite which is included in most pups. The package is around 150k when compiled. It has a simple interface and allows you to run concurrent databases.

As there is not a lot of help available I have created a basic document here: http://smokey01.com/help/StuffKeeper.pdf It's worth reading the document to help get you started.

If anyone is interested in helping me develop this a little further I would love to hear from you. I need good coders, not testers. The author, Qball Cow, has moved onto other priorities in his life and does not have time to maintain it. It really doesn't need much improving.

Source: https://github.com/DaveDavenport/stuffkeeper/archive/master.zip
Back to top
View user's profile Send private message Visit poster's website 
Pete

Joined: 02 Mar 2014
Posts: 543

PostPosted: Sat 18 Jun 2016, 08:37    Post subject:  

Looks good smokey01, will download and test.
BTW like your choice of actress in the example. Very Happy
Back to top
View user's profile Send private message 
musher0


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

PostPosted: Sat 18 Jun 2016, 15:06    Post subject:  

Great find, smokey01, and you've produced a very clear doc. Thanks.

I'll decline your kind invitation for three reasons:
- I don't know SQL
- I'm a complete cluts with XML
- I'm already involved with Ian R. Stewart's small database utility, fields.awk.
I presented it here to Puppy users.

I wish you "Good Continuation" on the StuffKeeper project! Smile

BFN

_________________
musher0
~~~~~~~~~~
"The greatest of minds are the ones that never close." | "Les plus grands esprits sont ceux qui ne se ferment jamais."
(starhawk, Resident Philosopher | philosophe en résidence) Wink
Back to top
View user's profile Send private message Visit poster's website 
Pete

Joined: 02 Mar 2014
Posts: 543

PostPosted: Sat 18 Jun 2016, 15:50    Post subject:  

@smokey01

Had a look at Stuffkeeper and rather like it, however looking at my work schedule, I doubt I'll do justice to the project but I wish you the very best with the project.

I will be keeping an eye on this thread.

@musher0

Since you introduced fields.awk, I have been using it on a daily basis.
Although a flat file DB and has no where the features of Stuffkeeper, it suits a variety of my needs and is very light weight.

So as not to hijack smokey01's thread, I will start a new one regarding fields.awk and musher0 please feel free to post any ideas, comments, suggestions and possible improvements you have in mind.
Back to top
View user's profile Send private message 
musher0


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

PostPosted: Sat 18 Jun 2016, 17:23    Post subject:  

Pete wrote:
(...)
@musher0

Since you introduced fields.awk, I have been using it on a daily basis.
Although a flat file DB and has no where the features of Stuffkeeper, it suits a variety of my needs and is very light weight.

So as not to hijack smokey01's thread, I will start a new one regarding fields.awk and musher0 please feel free to post any ideas, comments, suggestions and possible improvements you have in mind.
@pete:
To be clear: when I say "involved with fields.awk", I mean that I'm (slowly) working on
a French translation. I don't see myself editing any of Ian's awk code itself.

BFN.

_________________
musher0
~~~~~~~~~~
"The greatest of minds are the ones that never close." | "Les plus grands esprits sont ceux qui ne se ferment jamais."
(starhawk, Resident Philosopher | philosophe en résidence) Wink
Back to top
View user's profile Send private message Visit poster's website 
greengeek

Joined: 20 Jul 2010
Posts: 4061
Location: New Zealand

PostPosted: Sun 19 Jun 2016, 02:49    Post subject:  

Pete wrote:
So as not to hijack smokey01's thread, I will start a new one regarding fields.awk and musher0 please feel free to post any ideas, comments, suggestions and possible improvements you have in mind.
Cool - post link to that thread when poss.
cheers!
Back to top
View user's profile Send private message 
01micko


Joined: 11 Oct 2008
Posts: 8534
Location: qld

PostPosted: Sun 19 Jun 2016, 07:49    Post subject:  

@smokey01 - I managed to build stuffkeeper in slacko. I see what is needed. The 'Help' is useless. It would be good if we could incorporate your PDF (or even change it to html format) to get people started. Probably removing the bugtracker entry is a good idea too.

Thoughts?

_________________
Puppy Linux Blog - contact me for access
Back to top
View user's profile Send private message Visit poster's website 
Pete

Joined: 02 Mar 2014
Posts: 543

PostPosted: Sun 19 Jun 2016, 19:20    Post subject:  

greengeek wrote:
Pete wrote:
So as not to hijack smokey01's thread, I will start a new one regarding fields.awk and musher0 please feel free to post any ideas, comments, suggestions and possible improvements you have in mind.
Cool - post link to that thread when poss.
cheers!


@greengeek

Here it is:

http://www.murga-linux.com/puppy/viewtopic.php?t=107222
Back to top
View user's profile Send private message 
01micko


Joined: 11 Oct 2008
Posts: 8534
Location: qld

PostPosted: Mon 20 Jun 2016, 17:54    Post subject:  

@smokey01

Thanks to the internet archive..

https://web.archive.org/web/20140118125339/http://www.stuffkeeper.org/index.php?title=Main_Page

_________________
Puppy Linux Blog - contact me for access
Back to top
View user's profile Send private message Visit poster's website 
gcmartin


Joined: 14 Oct 2005
Posts: 6617
Location: Earth

PostPosted: Mon 20 Jun 2016, 20:38    Post subject:  

With SQLite in PUPs and more and more users with Amazon/Apple/Google phones, tablets, and laptops this small DB could come in handy as PUPPY progresses into the future. Apps designed around it could have companions/duplicates in those environments.

Looking forward to seeing this in upcoming Slacko based PUPs.

The idea for Help and PDF, ... EXCELLENT! +1

_________________
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 
smokey01


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

PostPosted: Tue 21 Jun 2016, 07:52    Post subject:  

@01micko
I haven't had any issues compiling stuffkeeper, in fact it builds quite easy as long as you have Vala.

At the moment I have three little issues that need attention.

1. I'm not able to import records with the Generic Import command.

If I export a record it should be able to import that same record but it doesn't recognise the file format. I have tried all three file format options when exporting and importing. The export part seems to work ok though.

It seems to use : instead of , for delimiters.

If I create a new csv file to import with two fields it should look like:
firstname,lastname or firstname:lastname in this case.
This file is not recognised. If I change the file to:
::firstname:lastname it allows importation but it duplicates data.

My coding isn't good enough to fix the problem. I was hoping someone in the forums may be able to fix this.

2. It could probably do with a print option to print records. Not a biggie though.

3. A number field might be nice so $$$ and totals could be added.

I agree the debug could be removed and a Help file included. Converting the PDF to HTML is easy enough.

_________________
Puppy Software <-> Distros <-> Puppy Linux Tips

Last edited by smokey01 on Tue 21 Jun 2016, 17:28; edited 1 time in total
Back to top
View user's profile Send private message Visit poster's website 
smokey01


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

PostPosted: Tue 21 Jun 2016, 07:55    Post subject:  

01micko wrote:
@smokey01

Thanks to the internet archive..

https://web.archive.org/web/20140118125339/http://www.stuffkeeper.org/index.php?title=Main_Page


Yes, found this the same way Laughing

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


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

PostPosted: Wed 22 Jun 2016, 02:46    Post subject:  

I made a few short videos showing how the basics work.
http://smokey01.com/stuffkeeper

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


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

PostPosted: Thu 30 Jun 2016, 13:30    Post subject: Pdf create seen... creating tables is not difficult.  

Pdf seen... creating tables is not difficult.

Database management becomes awful when you mix columns from different tables...
Simply how to clone MS Access, for MS Access lovers.
I was employed with DBASE II around 1986. DBASE is more fun than MS access but less than... Symphytum. Smile

_________________
Sprinters choose Puppy Linux as mascot, always happy, always speedy.
Back to top
View user's profile Send private message Yahoo Messenger 
Display posts from previous:   Sort by:   
Page 1 of 1 [14 Posts]  
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.0530s ][ Queries: 11 (0.0034s) ][ GZIP on ]