Stuffkeeper database app
Stuffkeeper database app
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/stuffk ... master.zip
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/stuffk ... master.zip
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!
BFN
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!
BFN
musher0
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)
@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.
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.
@pete: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.
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
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)
@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?
Thoughts?
Puppy Linux Blog - contact me for access
@greengeekgreengeek wrote:Cool - post link to that thread when poss.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.
cheers!
Here it is:
http://www.murga-linux.com/puppy/viewtopic.php?t=107222
Puppy Linux Blog - contact me for access
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
Looking forward to seeing this in upcoming Slacko based PUPs.
The idea for Help and PDF, ... EXCELLENT! +1
@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.
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.
Last edited by smokey01 on Tue 21 Jun 2016, 21:28, edited 1 time in total.
Yes, found this the same way01micko wrote:@smokey01
Thanks to the internet archive..
https://web.archive.org/web/20140118125 ... =Main_Page
I made a few short videos showing how the basics work.
http://smokey01.com/stuffkeeper
http://smokey01.com/stuffkeeper
Pdf create seen... creating tables is not difficult.
Pdf seen... creating tables is not difficult.