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 25 Oct 2014, 13:53
All times are UTC - 4
 Forum index » Advanced Topics » Additional Software (PETs, n' stuff) » Unsorted
Simple Database Program Available?
Moderators: deshlab, Flash, GuestToo, Ian, JohnMurga, Lobster
Post_new_topic   Reply_to_topic View_previous_topic :: View_next_topic
Page 1 of 1 Posts_count  
Author Message
jakfish

Joined: 18 Jul 2008
Posts: 756

PostPosted: Wed 30 Sep 2009, 09:15    Post_subject:  Simple Database Program Available?  

I'm looking for a basic database program that would allow me to import and view csv files that only have two fields: Subject and Note. So it's text only.

The OpenOffice database program is overkill. I'd like something speedier and leaner.

Is there something out there that I've missed in my searching?

Thanks,
Jake
Back to top
View user's profile Send_private_message 
Lobster
Official Crustacean


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

PostPosted: Wed 30 Sep 2009, 09:50    Post_subject:  

Database info from this thread now on Wiki
http://puppylinux.org/wikka/Database

_________________
Puppy WIKI

Edited_times_total
Back to top
View user's profile Send_private_message Visit_website 
MU


Joined: 24 Aug 2005
Posts: 13642
Location: Karlsruhe, Germany

PostPosted: Wed 30 Sep 2009, 09:57    Post_subject:  

To watch csv, you will need a spreadsheet.
The one in Puppy in Gnumeric.

Sorry if I missunderstood you Smile

Mark

_________________
my recommended links
Back to top
View user's profile Send_private_message Visit_website 
jakfish

Joined: 18 Jul 2008
Posts: 756

PostPosted: Wed 30 Sep 2009, 10:36    Post_subject:  

Thanks for the quick responses, folks. I've played with sqlite and its layout is not great for a large amount of text display. Ditto for any kind of spreadsheet program. I don't know if anybody remembers the Psion Data app, but something like that would be splendid:

http://www.mirrormere.com/frevo/images/screen/data.gif

This is what I use on my Nokia E90. Not as good, but simple and functional:

http://handheld.softpedia.com/progScreenshots/DzBase-Screenshot-70797.html

Jake
Back to top
View user's profile Send_private_message 
MU


Joined: 24 Aug 2005
Posts: 13642
Location: Karlsruhe, Germany

PostPosted: Wed 30 Sep 2009, 11:48    Post_subject:  

this is a very intersting DB:
http://www.murga-linux.com/puppy/viewtopic.php?t=42480
not certain if csv is already included,, I think it was discussed in the end of that thread.

Mark

_________________
my recommended links
Back to top
View user's profile Send_private_message Visit_website 
jakfish

Joined: 18 Jul 2008
Posts: 756

PostPosted: Wed 30 Sep 2009, 13:45    Post_subject:  

Thanks, MU, for that tip. I downloaded and installed it. The program looks good, except no csv import as of yet.

So I can't tell whether it'll render a two-field, text-heavy csv file.

Jake
Back to top
View user's profile Send_private_message 
MU


Joined: 24 Aug 2005
Posts: 13642
Location: Karlsruhe, Germany

PostPosted: Wed 30 Sep 2009, 14:20    Post_subject:  

I'd suggest to post a request in that thread.
Gposil is very active for Puppy, and if you are lucky, he soon will release an updated version that can do what you need Smile

Mark

_________________
my recommended links
Back to top
View user's profile Send_private_message Visit_website 
tlchost

Joined: 05 Aug 2007
Posts: 1727
Location: Baltimore, Maryland USA

PostPosted: Wed 30 Sep 2009, 14:43    Post_subject:  

MU wrote:
I'd suggest to post a request in that thread.
Gposil is very active for Puppy, and if you are lucky, he soon will release an updated version that can do what you need Smile


Before Barry had critical things to say about Gposil's database project, it was constantly improved and updated. Once Barry pronounced he would not include it in Puppy, it seemed to die a miserable death.

I hope you can convince Gposil to reactivate the project....it was one of the few I've seen that had real practical application and used data that was NOT OS dependent.

If you use Windows and are not afraid to admit it...you could find utilities to convert your datafile to a DBF for DbaseIII or IV or even Foxpro...all of which Gposil's application can use.

If you don't mind using windows apps in wine you can try this:
http://www.alexnolan.net/software/mdb_viewer_plus.htm

Thom
Back to top
View user's profile Send_private_message Visit_website 
jakfish

Joined: 18 Jul 2008
Posts: 756

PostPosted: Wed 30 Sep 2009, 16:45    Post_subject:  

What a great forum; everybody has been so helpful. @ tlchost: thanks for the reminder. I used to run mdb viewer on windows 95 even. I had forgotten all about it.

Here's what I ended up doing, and hope it helps somebody. I went with portabase, a sharp zaurus database whose author ported it to Debian.

Download the portabase deb file from here:

http://portabase.sourceforge.net/download.html

Use a deb2pet pet from here:

http://www.murga-linux.com/puppy/viewtopic.php?t=39756

In puppy 4.3 final, upon installation of the portabase pet, I was missing this one library:

libqt-mt.so.3

This pet, qt-3.3.8.pet, has this dependency. Get it here:

http://www.murga-linux.com/puppy/viewtopic.php?t=27406

This will put you in business with a basic database program that can import heavy-duty text csv's. Lean gui, adjustable fonts, not as visually friendly as the legendary Psion Data app, but portabase does the job nicely.

Any other suggestions would be welcome, and thank you all again. You really helped,

Jake
Back to top
View user's profile Send_private_message 
Lobster
Official Crustacean


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

PostPosted: Wed 30 Sep 2009, 20:30    Post_subject:  

Quote:
What a great forum; everybody has been so helpful


Useful question and thread
added info from thread here
http://puppylinux.org/wikka/Database
Smile

_________________
Puppy WIKI
Back to top
View user's profile Send_private_message Visit_website 
jakfish

Joined: 18 Jul 2008
Posts: 756

PostPosted: Wed 30 Sep 2009, 20:49    Post_subject:  

Nicely done, Lobster. The wikka is clean and efficient.

Jake
Back to top
View user's profile Send_private_message 
Display_posts:   Sort by:   
Page 1 of 1 Posts_count  
Post_new_topic   Reply_to_topic View_previous_topic :: View_next_topic
 Forum index » Advanced Topics » Additional Software (PETs, n' stuff) » Unsorted
Jump to:  

Rules_post_cannot
Rules_reply_cannot
Rules_edit_cannot
Rules_delete_cannot
Rules_vote_cannot
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 0.0600s ][ Queries: 11 (0.0032s) ][ GZIP on ]