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 26 Nov 2014, 04:55
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 8 of 9 Posts_count   Goto page: Previous 1, 2, 3, ..., 6, 7, 8, 9 Next
Author Message
Thee_oddball

Joined: 19 Oct 2008
Posts: 9

PostPosted: Sun 22 Feb 2009, 21:55    Post_subject:
Sub_title: Sqlitemanager -> Firefox-Extension
 

aragon wrote:
for those of you who are running firefox

http://code.google.com/p/sqlite-manager/

might be interesting.

I think it is not for a beginner, but maybe someone ist interested.

The xpi is 86 kb!

cheers
aragon


I have pup4.1 and that prog requires seamonkey 2.0 ( i have 1.1) and the firfox version required is 3.0- and pup-get only has a 2.? version Sad , i have been reading for the past couple nights about setting up a MYSQL DB and PHP and have read this post
http://www.murga-linux.com/puppy/viewtopic.php?t=37109

and have tested hiawatha Smile but now i am trying se if there is a native solution to MySql , i SQLite3 mentioned but cannot find it under PETget, but i see puppybasic2 is installed Smile......im just getting more and more confued SmileSmile...ill get it sorted Smile

S!
Back to top
View user's profile Send_private_message 
DMcCunney

Joined: 02 Feb 2009
Posts: 897

PostPosted: Sun 22 Feb 2009, 22:54    Post_subject:
Sub_title: Sqlitemanager -> Firefox-Extension
 

aragon wrote:
for those of you who are running firefox

http://code.google.com/p/sqlite-manager/

might be interesting.

I think it is not for a beginner, but maybe someone ist interested.

The xpi is 86 kb!

I have the XPI installed in FF3 on Windoze. Note that it can't diddle the place.sqlite file FF3 uses to store boomarks, as that file is locked while in use by FF, but it can investigate and diddle other SQLite DB files.
______
Dennis
Back to top
View user's profile Send_private_message 
DMcCunney

Joined: 02 Feb 2009
Posts: 897

PostPosted: Sun 22 Feb 2009, 23:49    Post_subject:
Sub_title: Sqlitemanager -> Firefox-Extension
 

Thee_oddball wrote:
aragon wrote:
for those of you who are running firefox

http://code.google.com/p/sqlite-manager/

might be interesting.

I think it is not for a beginner, but maybe someone ist interested.

The xpi is 86 kb!

I have pup4.1 and that prog requires seamonkey 2.0 ( i have 1.1) and the firfox version required is 3.0- and pup-get only has a 2.? version Sad

That's because Firefox 3 and Seamonkey 2 use an SQLite database to store bookmarks instead of bookmarks.html, and use SQLite databases for a few other things. The XPI would be pointless in FF 2 or SM 1.

There's a pet for Firefox 3.03 here at puppylinux.ca, , and you can get SM 2.0 alpha 2 for Linux from Mozilla here.
(It runs on Puppy 4.12 here.)
Quote:
but now i am trying se if there is a native solution to MySql , i SQLite3 mentioned but cannot find it under PETget, but i see puppybasic2 is installed Smile......

There's a pet for SQLite 3.4.2 here at ibiblio.org.
______
Dennis
Back to top
View user's profile Send_private_message 
WhoDo


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

PostPosted: Mon 23 Feb 2009, 02:47    Post_subject:
Sub_title: Sqlitemanager -> Firefox-Extension
 

DMcCunney wrote:
There's a pet for SQLite 3.4.2 here at ibiblio.org.
______
Dennis

Actually, Puppy 4.xx Dingo series has SQLite included - DeepThought 4.2 has SQLite-3.4.2 inbuilt.

Hope that helps

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


Joined: 30 Jun 2008
Posts: 1022
Location: South of Belgium

PostPosted: Tue 31 Mar 2009, 01:07    Post_subject:
Sub_title: on toutou4.1.2 k2.6.25.16 frugal / tksqlite 0.4.5 won't work ..?
 

Hi
on Toutou4.1.2 k2.6.25.16 frugal / (= french translation of Puppy 4.1.2)
I installed tksqlite 0.4.5 from the Pet Manager (from Puppy3 list; there isn't any in Puppy 4 pet list) ;
the dependencies were automatically installed one after the other;
I restarted jwm and X;
There is well a menu entry under 'Personal';
but it won't work ..?
I have made the dependencies check: they 'seems' all being installed.

Can somebody give me some help?

Thanks in advance
Cheers
Charlie

update Ooupss ! Now my question is solved ! Please, just disregard it.
Having a look at the previous posts from the beginning I notice that tile-0.7.8.pet was missing ...Just had to load it from the pet manager, restart jwm and X and it is done.

I 'll now try to use that database with abiword to perform Mail merge.

Not enough 'many thanks!' to all the developpers (of Puppy and also its french translation 'Toutou') for such a nice tool !
Cheers
Charlie

re-update ...again...too fast spoken!
trying to open sqlite2_test.db (or sqlite3_test.db) I get a message asking
Quote:
...install tclsqlite2...(or tclsqlite3)

I am now looking for tclsqlite2 and 3. Do .pet packages exist?


Cheers
Charlie

re-re-update
Quote:
..looking for tclsqlite2 and 3...

I did not find them.
I found here (see previous post of 2byte on 15 dec 2007)
http://reddog.s35.xrea.com/software/tksqlite-0.5.6-linux-ix86-bin.tar.gz
I " tar -xzvf " it and got tksqlite working (I could create a table and import another .csv one).
(...with tksqlite-0.4.5.pet already installed...I think i've made some jam...!?)

I 'm trying now to uninstall tksqlite-0.4.5.pet but do not succed in; using the Pet Manager to uninstall it gives no result for tksqlite and its dependencies as well.

I tried with Pet-be-Gone which seems only applicable for programs delivered with the Puppy live-cd.
How could I uninstall it?

Thanks for any idea.

Cheers
Charlie
Back to top
View user's profile Send_private_message 
Colonel Panic


Joined: 16 Sep 2006
Posts: 1529

PostPosted: Fri 10 Apr 2009, 17:41    Post_subject:  

WhoDo wrote:
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



Thanks for this one, I downloaded it today and spent three-quarters of an hour or so converting my existing databases over so that Portabase could use them. I'm very impressed, it does everything I need from a database and is easy to understand and use.
Back to top
View user's profile Send_private_message 
smokey01


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

PostPosted: Sun 24 May 2009, 03:43    Post_subject:  

I have looked at the GLOM database web site and I must admit it looks pretty good.

Has anyone managed to compile this for Puppy?

Apparently it is based on File Maker Pro which is very popular.

For any body who has compiling skills the source can be found at:
http://ftp.gnome.org/pub/GNOME/sources/glom/

GLOM home Page:
http://www.glom.org/wiki/index.php?title=Main_Page

A .PET would be nice that included all the dependencies.

I have tried to use the Database application in Open Office 2.4 and 3.0. It keeps telling me it needs JRE but it also says it is already installed.

I have tried PortaBase which is quite good but I need a little more functionality such as relationships and the ability to create forms.

For those who have the skills a GLOM PET or SFS would be very useful and appreciated I'm sure, by the Puppy community.

Regards

Smokey

_________________
Puppy Software <-> Distros <-> Puppy Linux Tips
Back to top
View user's profile Send_private_message Visit_website 
gposil


Joined: 06 Apr 2009
Posts: 1305
Location: Stanthorpe (The Granite Belt), QLD, Australia

PostPosted: Sun 24 May 2009, 04:11    Post_subject:  

?...The depends alone for glom are almost as large as puppy itself...I don't think that's the way to go... Sad

I'm working on a RDBMS for Puppy but it's not going to happen overnight... Sad

_________________
Dpup Home
Back to top
View user's profile Send_private_message Visit_website MSNM 
cklammer


Joined: 26 Apr 2008
Posts: 28
Location: Abu Dhabi, United Arab Emirates

PostPosted: Tue 14 Jul 2009, 14:49    Post_subject: /rdb, NoSQL and SHQL and other unix test file dbs
Sub_title: Beware if you need UNICODE compatibility
 

A long time ago I wrote an integration application using unix text file tools (if I remember correctly it was under SGI IRIX 6.5). Everything worked well until some of the input data became arabic (unicode) characters .... it wasn't pretty let me tell you. I was new to the whole unicode thingy then.

Anyway: Before you read my following warning please bear in mind I admit that I did not look at the latest versions of /rdb, NoSQL and SHQL and such but:

/rdb, NoSQL and other similar tools all use to some the available unix text file utilities (which may or may not have problems supporting unicode fully) and you really want make sure that Unicode is properly supported before you put them into production (either for just for yourself or for others). All the the unix text databases were created in under old unix initially living in a pure ASCII world - so if you have Unicode data then TEST, TEST, TEST EVERYTHING!!!

If people find this post offensive because they feel stepped on their toes then I am sorry - this is most certainly not my intention.

cklammer
Back to top
View user's profile Send_private_message 
Colonel Panic


Joined: 16 Sep 2006
Posts: 1529

PostPosted: Sun 07 Feb 2010, 18:11    Post_subject:  

Hi. Just revisiting this thread and I'd like to say I think Portabase could usefully be included in an official release; it's as far as I know unique to Puppy.

The other Linux distros I've looked at and used certainly don't have anything like it.

I'm still using it for addresses and 'phone numbers as well as for a local history project I've been doing about the local dialect of my home area.

Well done Warren, it's a fine app.

CP.

_________________
Stone Pentium IV (2.4 GHz), 2 GB of RAM, 160 GB hard drive running Puppy Classic 214X GTK3, Puppy 4.32 v3, Precise Puppy 573-L, Puppy Tahr 6.0 Exton, Puppy 4.20 Deeper Thought v2.
Back to top
View user's profile Send_private_message 
tlchost

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

PostPosted: Sun 07 Feb 2010, 19:07    Post_subject:  

gposil wrote:

I'm working on a RDBMS for Puppy but it's not going to happen overnight... Sad


Any progress? Your previous efforts were very promising.

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

Joined: 08 May 2010
Posts: 1

PostPosted: Sat 08 May 2010, 23:01    Post_subject:  

Hello, I thought you guys might like to know that there's now an updated version of PortaBase available, 2.0 beta 1 (I'm the author). It's finally been ported to Qt 4, so it should be easier to install alongside modern software without dragging in ancient versions of Qt. Other changes are summarized on the history page. This beta version has a few minor regressions from 1.9 that were discovered after the release, but those have already been fixed in the Git repository. Let me know if you find any other problems with it, or have suggestions for improvement.
Back to top
View user's profile Send_private_message 
Colonel Panic


Joined: 16 Sep 2006
Posts: 1529

PostPosted: Sun 09 May 2010, 05:05    Post_subject:  

Thanks for this one, I'll try it soon.

I really appreciate all the work you've done in putting together an open source personal database; there's absolutely nothing else out there for Linux which does the same job, and precious little for any other OS which does either (do you really want to have to power up Access just to be able to access your address book, for example, or your database of dialect words?).

I started a thread on the Vector Linux (which I also use) forum about Portabase, and one of the devs there has promised to have a go at building a Portabase package for that distro.

Best,

CP .

_________________
Stone Pentium IV (2.4 GHz), 2 GB of RAM, 160 GB hard drive running Puppy Classic 214X GTK3, Puppy 4.32 v3, Precise Puppy 573-L, Puppy Tahr 6.0 Exton, Puppy 4.20 Deeper Thought v2.
Back to top
View user's profile Send_private_message 
Colonel Panic


Joined: 16 Sep 2006
Posts: 1529

PostPosted: Mon 10 May 2010, 12:20    Post_subject:  

I've just looked at this and I think it's one for the devs. It needs QT4, which is a big package, and also the dev_x sfs which I don't have.

The alternative, if it's possible, is if someone's got a way of "processing" the deb file to extract the binary, as Warren said he was able to (earlier in the thread).

It's not a big deal in any case since Portabase 1.9 works fine.

_________________
Stone Pentium IV (2.4 GHz), 2 GB of RAM, 160 GB hard drive running Puppy Classic 214X GTK3, Puppy 4.32 v3, Precise Puppy 573-L, Puppy Tahr 6.0 Exton, Puppy 4.20 Deeper Thought v2.
Back to top
View user's profile Send_private_message 
Pelo


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

PostPosted: Wed 06 Feb 2013, 05:44    Post_subject: sqliteman tested ok on here below distros  

Racy, Passagio-es, lxpup : ok
Lucid 5.2.8 : negative
Back to top
View user's profile Send_private_message YIM 
Display_posts:   Sort by:   
Page 8 of 9 Posts_count   Goto page: Previous 1, 2, 3, ..., 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:  

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.1062s ][ Queries: 13 (0.0078s) ][ GZIP on ]