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 Tue 26 Jul 2016, 04:29
All times are UTC - 4
 Forum index » Advanced Topics » Cutting edge
Puppy Database pre-Alpha
Moderators: Flash, Ian, JohnMurga
Post new topic   Reply to topic View previous topic :: View next topic
Page 1 of 1 [3 Posts]  
Author Message
Lobster
Official Crustacean


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

PostPosted: Sat 07 Feb 2009, 13:32    Post subject:  Puppy Database pre-Alpha
Subject description: SQLite front end - help with Bash required
 


Hi guys
HELP! Shocked

We have been trying to code a simple front end to SQlite3 (in Puppy 4.xx series)
Enclosed is the gtkdialog3/Bash code we are using to call the SQLite Database file - PuppDB

This is the line we are trying to call from the InsertData button
Code:
sqlite3 PuppDB "insert into info values ('"$INPUTNAME"','"$INPUTINFO"','"$INPUTURL"');"



How do we do this? Embarassed

In order to examine the PuppyDB file and any changes you require sqlitestudio (also enclosed below)
This is a massive but complete binary for creating and examining sqlite databases

You can download the below code, the PuppDB and SQLitestudio from here
http://tmxxine.com/pupdb/puppdb.tar.gz

Code:
#! /bin/bash
#! /usr/sbin/gtkdialog3 -e

# Puppy Database ver 0.4 created by Lobster and Shadow
# for Puppy DeepThought and Linux Tmxxine
# Feb 2009 GPL v3 License
# http://tmxxine.com

export Puppybase='
<window title="PuppyDB SQLite3">
<vbox>
 <hbox>
  <text><label>Add info</label></text>
 </hbox>
 <hbox>
  <text><label>Name</label></text>
  <entry><variable>INPUTNAME</variable></entry>
 </hbox>
 <hbox>
  <text><label>Info</label></text>
  <entry><variable>INPUTINFO</variable></entry>
 </hbox>
 <hbox>
  <text><label>URL</label></text>
  <entry><variable>INPUTURL</variable></entry>
 </hbox>
 <hbox>
  <button help>
   <action>`Xdialog --wrap --screencenter --left --title "Pwget - HELP" --msgbox "Puppy Database is a simple front end to SQLite3 for 4.xx series Puppy including Dingo, 4.1.2 and Deep Thought (under development) This version is pre-Alpha quality. \n\n Lobster & Shadow, Feb 2009" 600x0`</action>
  </button>
  <button cancel></button>
  <button><action>insert</action><label>InsertData</label></button>
 </hbox>
</vbox>
</window>'

I=$IFS; IFS=""
for STATEMENTS in $(gtkdialog3 --program=Puppybase --center); do
   eval $STATEMENTS
done
IFS=$I
function insert(){
  sqlite3 PuppDB "insert into info values ('"$INPUTNAME"','"$INPUTINFO"','"$INPUTURL"');"
}

_________________
Puppy WIKI
Back to top
View user's profile Send private message Visit poster's website 
Lobster
Official Crustacean


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

PostPosted: Mon 09 Feb 2009, 05:16    Post subject:  

Before trying to program
I examined this thread
http://www.murga-linux.com/puppy/viewtopic.php?t=18420

and eventually concluded that a secure and powerful option was
sqlitestudio
http://www.murga-linux.com/puppy/viewtopic.php?p=263497&search_id=1930532751#263497

The reasons I like sqlitestudio is it contains sqlite in a single linux binary and a Windows exe
This means you can have a database on a keydrive and run it on a Windows or any Linux distro - just don't lose that USB thumbdrive
The developer is on the above thread - so give him some feedback Smile

However for Puppy something smaller and simpler is required
Something like so:

_________________
Puppy WIKI
Back to top
View user's profile Send private message Visit poster's website 
Pelo


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

PostPosted: Thu 17 Mar 2016, 11:03    Post subject: sqlitestudio-3.0.7.tar.xz: 18 M could be used with tahrpup  

sqlitestudio-3.0.7.tar.xz: 18 M
Taxrxz dowloaded, needs QT5. i shall see when i use Tahrpup.
It's really because i am curious. I used a lot database at the office in the past
(as Application system , IBM ?) for an airline to analyse activity.
I am retired now, and i thought that a database would be of some interest for Puppy, but it's a fantastic 'flop'. fiasco, lack of interest...
Nevertheless, i will try it.
Lobster was full of hope here, topic same subject
X-basic could interest me
Lobster has gone, i worry, we shall have been two, it's more fun.
Toronto ? 17% of canadians speak french, I Musher0 interested, i shall see with him.

_________________
While Puppy get tan on the deck, Linux teams in the bulks check what they could change to the boat.
Back to top
View user's profile Send private message Yahoo Messenger 
Display posts from previous:   Sort by:   
Page 1 of 1 [3 Posts]  
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.0399s ][ Queries: 11 (0.0035s) ][ GZIP on ]