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 Mon 20 Oct 2014, 07:31
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 9 of 9 [134 Posts]   Goto page: Previous 1, 2, 3, ..., 7, 8, 9
Author Message
NeroVance


Joined: 10 Oct 2012
Posts: 149
Location: Canada

PostPosted: Wed 06 Feb 2013, 06:50    Post subject:  

In terms of how I'd do a DB, I'd use Tcl, Sqlite originated as a Tcl extension Cool (it's even got the feather in it's logo)

Hell, Tcl 8.6 has included a package for database access, hence it could fairly easily built using plain ol' Tcl now (ish). Good thing I've compiled Tcl and Tk 8.6 for my fellow puppians.

But in terms of DB, I would be interested in seeing what people have developed for databases in puppy.
Back to top
View user's profile Send private message Visit poster's website 
Pelo


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

PostPosted: Tue 05 Mar 2013, 14:18    Post subject: Is there anybody here (2010)
Subject description: No more interest in databases
 

No more interest in databases ? I would like to know how to include images in sqliteman. And to show it on a file

Anybody can explain ?
Back to top
View user's profile Send private message Yahoo Messenger 
Pelo


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

PostPosted: Tue 09 Apr 2013, 04:24    Post subject: nothing new about database . Sqliteman
Subject description: How to insert a photography
 

Dear users of SQLITEMAN , how do you do to insert a picture in SQLITEMAN. ?
Back to top
View user's profile Send private message Yahoo Messenger 
tallboy


Joined: 21 Sep 2010
Posts: 444
Location: Oslo, Norway

PostPosted: Tue 09 Apr 2013, 13:33    Post subject:  

I used FileMaker in my olds Macs, and miss it very much. No matter what you say, I have never used - or seen - another tool making it so easy to create a database in seconds. But I think all the Puppys I have used, have some basic tools that cover much of what a very simple database is used for:

Notecase is a very nice and compact tool, with hierachical layout and internal links. Examples: I use it a lot for making overviews and lists of source links for people in families 'in work', that are later entered into my genealogy database program Gramps. I also use it to manage my work todo-list and my spare parts, for my old Dodge, and one main use is to list all puppy-related links and notes, my memory is not what it used to be! It can be exported as a .txt, .html or even as a standalone. Bugfree.

It also has a 'poor sibling' in the form of hnb (hierachical note book) for use in a terminal window. Tiny, quick and simple to use, also bugfree.

Osmo Apart from being a calendar program that can manage your tasks and todo-lists, it is also quick and easy for managing contacts, and can easily be used for taking notes.

Homebank is a tool I don't use myself, but from what I have seen, it covers most situations where a database can be used to serve your privat economy.

There are many specialized programs in the puppy repositories for managing your collection of movies, recipes, music or pictures, I cannot mention them all, but as an example, a program like Pmusic is installed in recent puppys. They are probably more efficient than a self-made database would be.
And I hate to say it, but Gnumeric has also taken over some of the tasks that I left to FileMaker earlier. I still have some heavy duty tasks that I leave to my over-large Debian, among them a database, but the frequency of Debian use is fast moving towards zero.

So the big question is: how many puppy users really need a universal database?

Do you think the picture has changed since this thread was started in 2007, and if so: How and why?

tallboy

_________________
True freedom is a live Puppy on a multisession CD/DVD.
Back to top
View user's profile Send private message 
smokey01


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

PostPosted: Tue 09 Apr 2013, 16:05    Post subject:  

StuffKeeper is quite good.

http://www.stuffkeeper.org/index.php?title=Main_Page

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

Joined: 31 May 2008
Posts: 3220

PostPosted: Tue 16 Apr 2013, 04:32    Post subject:  

I don't know what was happening back in 2007, but sqlite3 works very well. It's also multi-platform, and you can ship the db around like a text file. I wonder how many people use it....it's a real gem.

Command line documentation:

http://www.sqlite.org/sqlite.html
Back to top
View user's profile Send private message 
tallboy


Joined: 21 Sep 2010
Posts: 444
Location: Oslo, Norway

PostPosted: Tue 16 Apr 2013, 18:11    Post subject:  

Sqlite3 is included default in my Lupu_5.2.8, but I forgot to list it, sorry!

tallboy

_________________
True freedom is a live Puppy on a multisession CD/DVD.
Back to top
View user's profile Send private message 
technosaurus


Joined: 18 May 2008
Posts: 4353

PostPosted: Wed 17 Apr 2013, 18:32    Post subject:  

I wrote a video rental webapp that uses sqlite3 shell for the backend (currently set up for in-browser javascript) ... if anyone wants to see a simple example of how you can use sqlite ... I am only capable of simple Smile

It could be adapted for general use with the browser or I could patch the sqlite shell for use with gtkdialog (though I think the -list option should be sufficient for gtkdialog treeviews)

As a test I can write an awk script to convert the puppy package databases into sqlite3 tables as a practice project if anyone is interested in pursuing it.

Edit: alternatively we can uses the puppy standard flat file database ...
here is a way to convert them directly to javascript arrays:
Code:
#!/usr/bin/awk '
BEGIN{FS="|";OFS="\",\"";ORS="\"],\n";printf "[\n"}
{print "\t[\""$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14}
END{printf "]\n"}

... may want to wrap it in a callback via BEGIN and END for cross site capability like
Code:
#!/usr/bin/awk '
BEGIN{FS="|";OFS="\",\"";ORS="\"],\n";printf "petCallback([\n"}
{print "\t[\""$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14}
END{printf "])\n"}

_________________
Web Programming - Pet Packaging 100 & 101
Back to top
View user's profile Send private message 
jpeps

Joined: 31 May 2008
Posts: 3220

PostPosted: Thu 18 Apr 2013, 21:33    Post subject:  

technosaurus wrote:
I wrote a video rental webapp that uses sqlite3 shell for the backend (currently set up for in-browser javascript) ... if anyone wants to see a simple example of how you can use sqlite ... I am only capable of simple Smile]


It's more a language, so will be simple for developers to figure out. It's worth learning, since you'll be using it for all your android devices. I've got the MyLibrary" app (listed in Java programming) running on my Nexus with it. You can export the db anywhere exactly like a doc. The db itself is foolproof.
Back to top
View user's profile Send private message 
jpeps

Joined: 31 May 2008
Posts: 3220

PostPosted: Mon 29 Apr 2013, 03:27    Post subject:  

It's easy to transfer an sqlite database from puppy to all your devices using dropbox. ( apps like SQLed connect to it directly).
Back to top
View user's profile Send private message 
Pelo


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

PostPosted: Sat 18 May 2013, 05:48    Post subject: attn tallboy : a lot of databases
Subject description: None integrates a picture
 

attn tallboy : a lot of databases
None integrates a picture. I am looking for a database which manages item by item, Like GCstar, datacrow, ppdb, Tellico but for a larger range of material, not only leasures, but machines, meals, softwares, furniture, ... anything !
But with the image. Not so easy to find, unhappily.
You seem to know the subject, i you find anything fitting our request, pls tell us.

and have a nice week'end.
Back to top
View user's profile Send private message Yahoo Messenger 
smokey01


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

PostPosted: Sat 18 May 2013, 07:07    Post subject: Re: attn tallboy : a lot of databases
Subject description: None integrates a picture
 

Pelo wrote:
attn tallboy : a lot of databases
None integrates a picture. I am looking for a database which manages item by item, Like GCstar, datacrow, ppdb, Tellico but for a larger range of material, not only leasures, but machines, meals, softwares, furniture, ... anything !
But with the image. Not so easy to find, unhappily.
You seem to know the subject, i you find anything fitting our request, pls tell us.

and have a nice week'end.


Have you had a look at stuffkeeper? It's quite configurable.

http://www.stuffkeeper.org/index.php?title=Main_Page
stuffkeeper.jpg
 Description   
 Filesize   34.53 KB
 Viewed   409 Time(s)

stuffkeeper.jpg


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

Joined: 31 May 2008
Posts: 3220

PostPosted: Sat 18 May 2013, 14:40    Post subject: Re: attn tallboy : a lot of databases
Subject description: None integrates a picture
 

Pelo wrote:

None integrates a picture. I am looking for a database which manages item by ...


You can store images into sqlite3 with hexdump, but a more flexible method might be to just use the db to store the names along with a folder of pix.


slideshow:
Code:

echo "select * from images;" | sqlite3 images.db > /tmp/list
while read line; do  viewnior  $line;  sleep 3; done < /tmp/list
Back to top
View user's profile Send private message 
Pelo


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

PostPosted: Sat 30 Nov 2013, 23:02    Post subject: 2013 Lib QT-3.3.8
Subject description: Pet still available
 

Pet still available
here
I don't want to build my database, i need something already built. I am not a Geek ! Something pretty, if possible, not SQLite !
I Shall look at stuffkeeper.
and notecase. Stuffkeeper looks like what i wish.
Back to top
View user's profile Send private message Yahoo Messenger 
Display posts from previous:   Sort by:   
Page 9 of 9 [134 Posts]   Goto page: Previous 1, 2, 3, ..., 7, 8, 9
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.0859s ][ Queries: 13 (0.0064s) ][ GZIP on ]