Author |
Message |
charleshdw
Joined: 25 Oct 2008 Posts: 8
|
Posted: 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
|
|
 |
DaveS

Joined: 09 Oct 2008 Posts: 3726 Location: UK
|
Posted: 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
|
|
 |
WhoDo

Joined: 11 Jul 2006 Posts: 4440 Location: Lake Macquarie NSW Australia
|
Posted: 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
|
|
 |
loganz
Joined: 13 Nov 2008 Posts: 8
|
Posted: 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
|
|
 |
Lobster
Official Crustacean

Joined: 04 May 2005 Posts: 15238 Location: Paradox Realm
|
Posted: 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
_________________ YinYana AI Buddhism
|
Back to top
|
|
 |
hillside

Joined: 02 Sep 2007 Posts: 642 Location: Minnesota, USA. The frozen north.
|
Posted: 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
|
|
 |
muggins
Joined: 20 Jan 2006 Posts: 6747 Location: hobart
|
Posted: 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
|
|
 |
jamesanderson
Joined: 10 Dec 2008 Posts: 1
|
Posted: 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
|
|
 |
Flash
Official Dog Handler

Joined: 04 May 2005 Posts: 12820 Location: Arizona USA
|
Posted: 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.
|
Back to top
|
|
 |
muggins
Joined: 20 Jan 2006 Posts: 6747 Location: hobart
|
Posted: Thu 25 Dec 2008, 22:07 Post subject:
|
|
A new release of sqlitestudio is available.
|
Back to top
|
|
 |
ttuuxxx

Joined: 05 May 2007 Posts: 11193 Location: Ontario Canada,Sydney Australia
|
Posted: Fri 26 Dec 2008, 07:21 Post subject:
|
|
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.
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 
|
Back to top
|
|
 |
hillside

Joined: 02 Sep 2007 Posts: 642 Location: Minnesota, USA. The frozen north.
|
Posted: 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
|
|
 |
ttuuxxx

Joined: 05 May 2007 Posts: 11193 Location: Ontario Canada,Sydney Australia
|
Posted: 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
ttuuxxx
_________________ http://audio.online-convert.com/ <-- excellent site
http://samples.mplayerhq.hu/A-codecs/ <-- Codec Test Files
http://html5games.com/ <-- excellent HTML5 games 
|
Back to top
|
|
 |
hillside

Joined: 02 Sep 2007 Posts: 642 Location: Minnesota, USA. The frozen north.
|
Posted: 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.
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
|
|
 |
muggins
Joined: 20 Jan 2006 Posts: 6747 Location: hobart
|
Posted: 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
|
|
 |
|