Puppy Database pre-Alpha

Under development: PCMCIA, wireless, etc.
Post Reply
Message
Author
User avatar
Lobster
Official Crustacean
Posts: 15522
Joined: Wed 04 May 2005, 06:06
Location: Paradox Realm
Contact:

Puppy Database pre-Alpha

#1 Post by Lobster »

Image
Hi guys
HELP! :shock:

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: Select all

sqlite3 PuppDB "insert into info values ('"$INPUTNAME"','"$INPUTINFO"','"$INPUTURL"');"

How do we do this? :oops:

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: Select all

#! /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 Raspup 8.2Final 8)
Puppy Links Page http://www.smokey01.com/bruceb/puppy.html :D

User avatar
Lobster
Official Crustacean
Posts: 15522
Joined: Wed 04 May 2005, 06:06
Location: Paradox Realm
Contact:

#2 Post by Lobster »

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/viewto ... 751#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 :)

However for Puppy something smaller and simpler is required
Something like so:
Image
Puppy Raspup 8.2Final 8)
Puppy Links Page http://www.smokey01.com/bruceb/puppy.html :D

Pelo

sqlitestudio-3.0.7.tar.xz: 18 M could be used with tahrpup

#3 Post by Pelo »

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.

Post Reply