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 Thu 28 Aug 2014, 21:32
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 5 of 9 [134 Posts]   Goto page: Previous 1, 2, 3, 4, 5, 6, 7, 8, 9 Next
Author Message
scheck.r

Joined: 30 Apr 2008
Posts: 12

PostPosted: Wed 30 Apr 2008, 13:28    Post subject:  

I don't know much about databases but I recall people using portabase or treeline as very simple database software on the Zaurus pda.
Both require Qt. No Sqlite. They are available also on the desktop. Very user friendly apps.

See http://portabase.sourceforge.net/index.html
and http://treeline.bellz.org/index.html
Back to top
View user's profile Send private message 
WhoDo


Joined: 11 Jul 2006
Posts: 4441
Location: Lake Macquarie NSW Australia

PostPosted: Wed 30 Apr 2008, 20:01    Post subject:  

scheck.r wrote:
I don't know much about databases but I recall people using portabase or treeline as very simple database software on the Zaurus pda.
Both require Qt. No Sqlite. They are available also on the desktop. Very user friendly apps.

See http://portabase.sourceforge.net/index.html
and http://treeline.bellz.org/index.html

Thanks, scheck.r - treeline needs Python which kinda defeats the Puppy ethic, but portabase looks interesting. I have downloaded the tarball and will attempt a compile in Puppy. If successful I'll post the dotpet result here. At 256kb the download looks distinctly promising if QT is the only dependency.

The thread was really aimed at getting a fully-relational database for Puppy, but something this small might be enough for most people IF it is easier to use than TkSQlite for example.

Update: Compile from source failed due to missing directory but I downloaded the debian binary and that works. I have repacked as a dotpet here. Small, quick and relatively easy to use IMHO. Surprising how much it can do for such a little app. Good find, scheck.r Cool

Portabase.pet
Description  Portabase mini-database for Puppy - needs Qt3 or later
pet

 Download 
Filename  Portabase.pet 
Filesize  595.09 KB 
Downloaded  715 Time(s) 

_________________
Actions speak louder than words ... and they usually work when words don't!
SIP:whodo@proxy01.sipphone.com; whodo@realsip.com

Last edited by WhoDo on Sun 04 May 2008, 07:23; edited 1 time in total
Back to top
View user's profile Send private message 
Jactek

Joined: 10 Dec 2006
Posts: 37
Location: Hport NY

PostPosted: Thu 01 May 2008, 11:06    Post subject: Database  

At work I use an old DOS database QA4 by Symantec we have been using it since the early 90's and it works well, it works in Puppy using DosBox, also there is a program EZbase that work with DosBox. I bought a copy of Lotus Approch for Win3.1 but havnt been able to get to work with Wine or Dosbox

Jim
Back to top
View user's profile Send private message 
WhoDo


Joined: 11 Jul 2006
Posts: 4441
Location: Lake Macquarie NSW Australia

PostPosted: Sun 04 May 2008, 07:40    Post subject:  

Just finished playing with Portabase. For less than 600kb it is certainly very versatile (see screenshot in post above). As a simple, everyday flat file database, I think it would be a great asset to Puppy and make the base version software complete.

Any comments?

Here are some more shots of relevant input/view screens.




_________________
Actions speak louder than words ... and they usually work when words don't!
SIP:whodo@proxy01.sipphone.com; whodo@realsip.com

Last edited by WhoDo on Sun 04 May 2008, 07:57; edited 1 time in total
Back to top
View user's profile Send private message 
Colonel Panic


Joined: 16 Sep 2006
Posts: 1511

PostPosted: Sun 04 May 2008, 07:43    Post subject:  

Yeah, there's some good DOS database software out there. I sometimes use PC-File, a freeware database program, in DOSBox.

Portabase sounds good though.
Back to top
View user's profile Send private message 
scheck.r

Joined: 30 Apr 2008
Posts: 12

PostPosted: Mon 05 May 2008, 17:58    Post subject:  

@ WhoDo

I'm glad you find it useful. Thanks for the pet package.
Back to top
View user's profile Send private message 
Lobster
Official Crustacean


Joined: 04 May 2005
Posts: 15117
Location: Paradox Realm

PostPosted: Tue 06 May 2008, 08:25    Post subject:  

tried it in Dingo without success but I am notoriously inept, anyone get it working? Cool
_________________
Puppy WIKI
Back to top
View user's profile Send private message Visit poster's website 
scheck.r

Joined: 30 Apr 2008
Posts: 12

PostPosted: Tue 06 May 2008, 10:22    Post subject:  

Portabase works in Dingo.
Install qt-3 form official puppy3 repository using puppy package manager.
Back to top
View user's profile Send private message 
oblivious

Joined: 14 Apr 2007
Posts: 304
Location: Western Australia

PostPosted: Sat 24 May 2008, 07:12    Post subject:  

I tried this in Dingo, without success Crying or Very sad
Back to top
View user's profile Send private message 
Swarup

Joined: 20 May 2008
Posts: 219

PostPosted: Wed 28 May 2008, 01:23    Post subject:  

I need a database for use in Puppy 3.01-- I've read through this thread, and so many different DB applications have been discussed that it is a bit hard for a newbie like me to understand what the upshot of it all is.

I had several DB's in MSA (MS Access) a year ago, which when I shifted from Window$ to Ubuntu I imported with great difficulty into OOo Base. Only to find out as I started using Base, that compared with MSA's ease of use, Base is like something out of the middle ages. And very buggy. So, around 3 months ago I compiled the latest version of Kexi in Ubuntu, and exported all my Base DBs into Kexi. Kexi is like a good fairy c/w OOo Base. I do like Kexi-- very user friendly.

But now I've decided that for my old laptop (433 mhz celeron; 256 Ram), Ubuntu is really too much. So after some serious investigations, two days ago I've shifted all my things over to Puppy. One of the last things I haven't ported over yet is my DB which is in Kexi now.

I only have one active DB which I need to bring over now. My DB is a simple table with around 20 columns and 60 rows. I don't need to be able to do anything further than maintain my data in the table. No need for queries even with this DB.

Would the best thing be for me to compile Kexi in Puppy and just bring the Kexi DB file over? (There is a HowTo for compiling Kexi, and it includes special instructions for those compiling into a Debian-based distro. Would Puppy fall in that category? If so, then the compile would be pretty straightforward.)

Or would I be better off switching to something smaller and lighter, more suited for use in Puppy 3.01? In that case I could export from Kexi/Ubuntu as .csv, then import the .csv into the new DB application in Puppy. And if so, then of all the DB applications which have been discussed, which is recommended?
Back to top
View user's profile Send private message 
WhoDo


Joined: 11 Jul 2006
Posts: 4441
Location: Lake Macquarie NSW Australia

PostPosted: Wed 28 May 2008, 04:30    Post subject:  

Swarup wrote:
Would the best thing be for me to compile Kexi in Puppy and just bring the Kexi DB file over? (There is a HowTo for compiling Kexi, and it includes special instructions for those compiling into a Debian-based distro. Would Puppy fall in that category? If so, then the compile would be pretty straightforward.)

Or would I be better off switching to something smaller and lighter, more suited for use in Puppy 3.01? In that case I could export from Kexi/Ubuntu as .csv, then import the .csv into the new DB application in Puppy. And if so, then of all the DB applications which have been discussed, which is recommended?

Here's a suggestion; what about just using the Gnome sfs with Puppy and then you can keep Kexi in its present form? That way you get the best that Puppy can offer with the familiarity of your Ubuntu wm. Just a thought.

If you want to go smaller and lighter, Portabase is probably your best bet now, although it only imports XML and MobileDB formats. It shouldn't be too hard to get your CSV over to XML format.

If you do end up successfully compiling Kexi in Puppy format, I'll be one of the first to give it a try. I've been looking for a user-friendly database for so long now I've all but given up! Base is too buggy and nothing else is as user-friendly IMHO.

Go for it, mate!

_________________
Actions speak louder than words ... and they usually work when words don't!
SIP:whodo@proxy01.sipphone.com; whodo@realsip.com
Back to top
View user's profile Send private message 
hillside


Joined: 02 Sep 2007
Posts: 642
Location: Minnesota, USA. The frozen north.

PostPosted: Wed 28 May 2008, 09:01    Post subject:  

Puppy has been serving as my small (read micro) business operating system and I'll have to admit that lack of a good database program has been the most difficult part.

I've been keeping my customer list on a spreadsheet. It's easy to update, allows me to sort, search, etc, and the appropriate data can be copied to the OO database for printing purposes when I need to do envelopes or mail labels. When I'm done with the print job, I just delete the table from the database and go back to my spreadsheet.

Even though this is a little awkward, it has been working quite well. I could make use of subforms, but a flat database does the job well enough.

I'm not familiar with Kexi, but what I would find useful is a database system that managed child tables, had a good data entry system using forms, and did a good job with mail merge and label printing. OO base is getting close, but it's not there yet.
Back to top
View user's profile Send private message 
Swarup

Joined: 20 May 2008
Posts: 219

PostPosted: Wed 28 May 2008, 09:10    Post subject:  

WhoDo wrote:
Here's a suggestion; what about just using the Gnome sfs with Puppy and then you can keep Kexi in its present form? That way you get the best that Puppy can offer with the familiarity of your Ubuntu wm. Just a thought.


1. I've been searching a bit on Gnome sfs just now-- found a HowTo for an install into Puppy 4.0, but in the only 3.01 threads I saw people were struggling trying to get the sfs to work, but I hadn't found a thread where folks had gotten clear success.

2. If there is a good install for Gnome sfs in Puppy 3.01, then would that setup require more system resources (I mean cpu and ram) than the default 3.01 install with JWM? I am trying to keep system demand to a minimum.

3. If both the above items are a go, then when you say "you can keep Kexi in its present form", are you suggesting that the install of Kexi which I have now in Ubuntu, that very installation would be used somehow in puppy? Or do you mean that once I have established Puppy with a Gnome DE, then I'd be able to install Kexi the same way I had done in Ubuntu? (As a note: my Ubuntu install is on a different HD from my Puppy install. That could be changed later if needed, but for right now this is how things are arranged. And only one HD goes on my laptop at a time.)

WhoDo wrote:
If you want to go smaller and lighter, Portabase is probably your best bet now, although it only imports XML and MobileDB formats. It shouldn't be too hard to get your CSV over to XML format.


"Lighter" means less demand on cpu and/or ram, right? Sounds good. From the way you are discussing the Kexi installation (below), it sounds like Portabase is easy to install in comparison. Is the Portabase.pet which you've given above on this very web page, all that is needed? (It says there, "needs Qt3 or later"-- something I need to install as well?)

If the Portabase install is easy, I might just have a quick look at it today, to see what it's like. And I'll have to have another look at Kexi later when I put the other HD in. Perhaps Kexi can export directly as XML. And actually, I still have OOo Base running with that DB in Ubuntu as well. If OOo Base can export as XML, then that would also be fine for me.

WhoDo wrote:
If you do end up successfully compiling Kexi in Puppy format, I'll be one of the first to give it a try. I've been looking for a user-friendly database for so long now I've all but given up! Base is too buggy and nothing else is as user-friendly IMHO.


Is Puppy regarded as being a debian-based distribution? If so, then the compiling should be pretty straight forward. If Puppy is not correctly characterized as being in the "debian family", then is there a particular distro family of which puppy could be accurately described as being a member? That will help me a great deal in finding out what is needed to compile Kexi in it.
Back to top
View user's profile Send private message 
Swarup

Joined: 20 May 2008
Posts: 219

PostPosted: Wed 28 May 2008, 21:25    Post subject:  

I just installed Portabase in Puppy 3.01, wanting to see how it is. But I can't seem to find qt3 anywhere. I looked in the Puppy package manager, but I am not finding it there. Neither under "qt3", and nor under the official depedency name "libqt-mt.so.3". Upon googling it, I got a an RPM resource page called:

RPM resource libqt-mt.so.3
Found 263 RPM for libqt-mt.so.3
webpage address:
http://rpmfind.net/linux/rpm2html/search.php?query=libqt-mt.so.3&submit=Search+...&system=&arch=

But I have no idea which of these 263 if any, is the one I need.
Back to top
View user's profile Send private message 
oblivious

Joined: 14 Apr 2007
Posts: 304
Location: Western Australia

PostPosted: Thu 29 May 2008, 01:12    Post subject:  

Quote:
But I have no idea which of these 263 if any, is the one I need.

There's qt-3.3.8 in the puppy package manager if you select (I think, from memory) Official Puppy 3 at the top. That's what I used.
(The database DOES work - I was trying to start it from files in the directories, but it actually created a menu entry and it starts from that - not sure where it's starting from, but it's definitely starting Laughing )

As far as I know (and I don't know much Laughing):
- Puppy is not debian-based, it is created from scratch.
- Puppy 3.01 is compatible with Slackware packages
Back to top
View user's profile Send private message 
Display posts from previous:   Sort by:   
Page 5 of 9 [134 Posts]   Goto page: Previous 1, 2, 3, 4, 5, 6, 7, 8, 9 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.1053s ][ Queries: 13 (0.0099s) ][ GZIP on ]