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 23 Apr 2014, 09:42
All times are UTC - 4
 Forum index » Advanced Topics » Additional Software (PETs, n' stuff) » Business
What database software can we use in Puppy?
Post new topic   Reply to topic View previous topic :: View next topic
Page 1 of 3 [45 Posts]   Goto page: 1, 2, 3 Next
Author Message
charleshdw

Joined: 25 Oct 2008
Posts: 8

PostPosted: Mon 01 Dec 2008, 22:50    Post subject:  What database software can we use in Puppy?  

Me and my friend want to make accounting software in puppy linux base, but we doesn't know what database we can use and how to combine it with C++.
thank's for your help.
Back to top
View user's profile Send private message 
DaveS


Joined: 09 Oct 2008
Posts: 3726
Location: UK

PostPosted: Tue 02 Dec 2008, 02:23    Post subject:  

You can use Open Office Base, which is a very competent app. I built my own accounts program using it, which I use to run my business, but it is big and complex to learn, and is 'end user' rather than compiled. It needs Java installed.
_________________
Spup Frugal HD and USB
Root forever!
Back to top
View user's profile Send private message 
WhoDo


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

PostPosted: Tue 02 Dec 2008, 02:38    Post subject:  

...OR ... you can use Portabase or install the Koffice sfs and use Kexi.

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 
loganz

Joined: 13 Nov 2008
Posts: 8

PostPosted: Tue 02 Dec 2008, 09:08    Post subject:  

Hi,
I noticed the other day that puppy has sqlite installed in it.

If you go to a terminal and type:

sqlite3 mydatabase.db

it creates a new database and you can type any normal sql statements in and it will happly create tables, insert values, update values, run selects.

I believe that sqlite has loads of bindings for all kinds of languages.

I hope this helps.
Back to top
View user's profile Send private message 
Lobster
Official Crustacean


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

PostPosted: Tue 02 Dec 2008, 10:29    Post subject:  

Database discussion
http://www.murga-linux.com/puppy/viewtopic.php?p=118295#118295

LAMP (Puppy Style)
http://www.murga-linux.com/puppy/viewtopic.php?p=224547#224547

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


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

PostPosted: Tue 02 Dec 2008, 18:43    Post subject:  

sqlite is actually quite powerful. It has c/c++ bindings. It can also work with php or tcl/tk, although I don't know if the version in Puppy is the complete version. It's definitely not the most up to date version, but it's current enough to be very useful.

http://www.sqlite.org/
Back to top
View user's profile Send private message 
muggins

Joined: 20 Jan 2006
Posts: 6668
Location: lisbon

PostPosted: Fri 05 Dec 2008, 01:21    Post subject:  

The newest release of the sqlite frontend, tkqlite-0.5.7, was released on 17/11/2008. The linked binary is standalone, and doesn't require any additional tcl/tk libraries.
Back to top
View user's profile Send private message 
jamesanderson

Joined: 10 Dec 2008
Posts: 1

PostPosted: Wed 10 Dec 2008, 11:28    Post subject: What database software we can use.  

he organization shown above suggests that each character instance image is storage in a separate file. In fact, the physical organization of the database is quite different. Typical database queries at CEDAR, such as a classifier training job, rapidly access a large number of characters. Were each character stored in a separate file, the retrieval overhead would be impractically high. Instead, all images for a particular JIS code are stored in a single file. Software simulates the logical organization shown above.http://www.virtualizationteam.com/virtualization-vmware/news-features-of-the-new-esx-40.html
Back to top
View user's profile Send private message 
Flash
Official Dog Handler


Joined: 04 May 2005
Posts: 10686
Location: Arizona USA

PostPosted: Wed 10 Dec 2008, 23:40    Post subject:  

OpenOffice includes a database program, called Base if I remember right. I tried tinkering with it several years ago but, never having used a database program before, couldn't figure it out so I gave up. It wasn't exactly intuitive. Laughing
Back to top
View user's profile Send private message 
muggins

Joined: 20 Jan 2006
Posts: 6668
Location: lisbon

PostPosted: Thu 25 Dec 2008, 22:07    Post subject:  

A new release of sqlitestudio is available.
Back to top
View user's profile Send private message 
ttuuxxx


Joined: 05 May 2007
Posts: 10730
Location: Ontario Canada,Sydney Australia

PostPosted: Fri 26 Dec 2008, 07:21    Post subject:  

muggins wrote:
A new release of sqlitestudio is available.

Just run the bin file, first right click it, then select permissions, and select a+x (Make executable/searchable) click, Quiet then ok and thats it, it will run. any problems with that, I'll make a package or maybe muggins for you. Smile
http://sqlitestudio.one.pl/files/free/stable/linux/sqlitestudio-1.1.0.bin
ttuuxxx

_________________
http://audio.online-convert.com/ <-- excellent site
http://samples.mplayerhq.hu/A-codecs/ <-- Codec Test Files
http://html5games.com/ <-- excellent HTML5 games Smile

Back to top
View user's profile Send private message Visit poster's website 
hillside


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

PostPosted: Sun 28 Dec 2008, 11:49    Post subject:  

Let me start off by saying I'm not any kind of database guru, but I have worked at least some with Access, Open Office Base, Sequel, and a few others, so I have a smattering of fairly shallow experience.

After only the most basic testing -- Sqlitestudio is great.
1. It helps me build tables very quickly.
2. Entering data is easy, although I wish the tab key would move me to the next field instead of entering an actual tab.
3. The only problem I have run into so far, is that the sql results won't export. I get a big list of errors that I haven't dissected yet. I'd like to get my results to a comma delimited list to merge with my documents, but so far no dice.

I'll keep working as time permits.
Back to top
View user's profile Send private message 
ttuuxxx


Joined: 05 May 2007
Posts: 10730
Location: Ontario Canada,Sydney Australia

PostPosted: Sun 28 Dec 2008, 12:36    Post subject:  

hillside wrote:
Let me start off by saying I'm not any kind of database guru, but I have worked at least some with Access, Open Office Base, Sequel, and a few others, so I have a smattering of fairly shallow experience.

After only the most basic testing -- Sqlitestudio is great.
1. It helps me build tables very quickly.
2. Entering data is easy, although I wish the tab key would move me to the next field instead of entering an actual tab.
3. The only problem I have run into so far, is that the sql results won't export. I get a big list of errors that I haven't dissected yet. I'd like to get my results to a comma delimited list to merge with my documents, but so far no dice.

I'll keep working as time permits.

maybe next time post the errors here? And we'll see if we can help you out some Smile
ttuuxxx

_________________
http://audio.online-convert.com/ <-- excellent site
http://samples.mplayerhq.hu/A-codecs/ <-- Codec Test Files
http://html5games.com/ <-- excellent HTML5 games Smile

Back to top
View user's profile Send private message Visit poster's website 
hillside


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

PostPosted: Sun 28 Dec 2008, 18:17    Post subject:  

Quote:
maybe next time post the errors here? And we'll see if we can help you out some


Well, I guess if you insist. Smile

I was going to spend some more time on this myself before posting anything detailed here, but more eyes, and brains, are usually better.

I was able to build a table, enter data, and run a simple SQL query successfully. Everything seems to work about as expected. The query returns exactly the data that I had expected it to. But, when I try to export the results of my query, I get errors. Usually the file that the exported info is to go into is created, but it's empty.

The table and SQL are extremely basic. I was only doing this as an initial test. I don't think I have any problems with how they are created. Plus, they seem to work very well until I try to export.

The export error info is as follows:

Code:
invalid command name ""
    while executing
"$db eval $query R {
               set cols $R(*)
               set row [list]
               foreach c $R(*) {
                  lappend row $R($c)
               }
               lappend data $row
            }"
    ("results" arm line 8)
    invoked from within
"switch -- $type {
         "database" {
            switch -- [$res get format] {
               "SQL" {
                  set ret [exportDatabaseAsSQL $db $dbonly [$res get sql:null]]
   ..."
    while executing
"error $::errorInfo"
    invoked from within
"if {$catchCode} {
         error $::errorInfo
      }"
    ("uplevel" body line 98)
    invoked from within
"uplevel 2 "
      set catchCode 0
      if {\[catch {
         $body1
      } error]} {
         set catchCode [catch {$body2}]
      }
      $body2
      if {\$catchCode} {
         error \$:..."
    (procedure "_tryfinally" line 2)
    invoked from within
"_tryfinally [lindex $args 0] [lindex $args 2]"
    (procedure "try" line 7)
    invoked from within
"try {
      switch -- $type {
         "database" {
            switch -- [$res get format] {
               "SQL" {
                  set ret [exportDatabaseAsSQL $db $dbonly [$res get sql:..."
    (procedure "::MainExport::parseExportDialogResults" body line 16)
    invoked from within
"MainExport::parseExportDialogResults $ret results"
    ("results" arm line 2)
    invoked from within
"switch -- $_type {
      "database" {
         set res [MainExport::parseExportDialogResults $ret database]
      }
      "table" {
         set res [MainExport::parseExportD..."
    (object "::.resultsExportDialog" method "::ExportDialog::okClicked" body line 76)
    invoked from within
"okClicked"
    ("default" arm line 3)
    invoked from within
"switch -- $bt {
      "cancel" {
         set retval [cancelClicked]
      }
      default {
         set okBtn 1
         set retval [okClicked]
      }
   }"
    (object "::.resultsExportDialog" method "::Modal::clicked" body line 3)
    invoked from within
"::.resultsExportDialog clicked ok"
    invoked from within
".resultsExportDialog.f.btn.export invoke "
    invoked from within
".resultsExportDialog.f.btn.export instate {pressed !disabled} { .resultsExportDialog.f.btn.export state !pressed; .resultsExportDialog.f.btn.export in..."
    (command bound to event)
Back to top
View user's profile Send private message 
muggins

Joined: 20 Jan 2006
Posts: 6668
Location: lisbon

PostPosted: Tue 30 Dec 2008, 20:23    Post subject:  

@Hillside,

unfortunately I know little about sql, so can't help you there. But I wonder whether you've tried exporting your table with either sqlite-manager, which can be used as a firefox/seamonkey plugin, or with tksqlite
Back to top
View user's profile Send private message 
Display posts from previous:   Sort by:   
Page 1 of 3 [45 Posts]   Goto page: 1, 2, 3 Next
Post new topic   Reply to topic View previous topic :: View next topic
 Forum index » Advanced Topics » Additional Software (PETs, n' stuff) » Business
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.1016s ][ Queries: 13 (0.0227s) ][ GZIP on ]