Page 1 of 3
What database software can we use in Puppy?
Posted: Tue 02 Dec 2008, 02:50
by charleshdw
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.
Posted: Tue 02 Dec 2008, 06:23
by DaveS
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.
Posted: Tue 02 Dec 2008, 06:38
by WhoDo
...OR ... you can use
Portabase or install the Koffice sfs and use Kexi.
Hope that helps
Posted: Tue 02 Dec 2008, 13:08
by loganz
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.
Posted: Tue 02 Dec 2008, 14:29
by Lobster
Posted: Tue 02 Dec 2008, 22:43
by hillside
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/
Posted: Fri 05 Dec 2008, 05:21
by muggins
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.
What database software we can use.
Posted: Wed 10 Dec 2008, 15:28
by jamesanderson
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/virtu ... sx-40.html
Posted: Thu 11 Dec 2008, 03:40
by Flash
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.
Posted: Fri 26 Dec 2008, 02:07
by muggins
A new release of
sqlitestudio is available.
Posted: Fri 26 Dec 2008, 11:21
by ttuuxxx
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/s ... -1.1.0.bin
ttuuxxx
Posted: Sun 28 Dec 2008, 15:49
by hillside
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.
Posted: Sun 28 Dec 2008, 16:36
by ttuuxxx
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
Posted: Sun 28 Dec 2008, 22:17
by hillside
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: Select all
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)
Posted: Wed 31 Dec 2008, 00:23
by muggins
@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
Posted: Thu 01 Jan 2009, 00:55
by hillside
Thanks for the tips, Muggins.
Both of those options look like they will require some serious
upgrading to my old and feeble system, so I may pass on them for
now.
I've been using OObase and don't really need a new database
system, but I feel that database management for the desktop is a
weak area in Linux and was excited to see a new potential solution.
I actually can make it work by doing some cutting and pasting
instead of using the export function, but full functionality is what I'm
hoping for. I can also just use sqlite from the command line, but I
think a more graphical tool is what is really needed.
I think sqlitestudio has a lot of potential and am looking forward to
the next version that comes out. It's close to being a tool for the
masses.
Posted: Thu 01 Jan 2009, 01:27
by muggins
AFAIK neither should require any upgrade. Tksqlite, while being tcl/tk based, comes in a completely self-contained, ready to run, executable. If it doesn't have the functionality you require, just delete the one file.
Whereas sqlitemanager you can just download the .xpi file, open it with firefox, or seamonkey, and install it as a plugin. Maybe one problem with doing this with seamonkey is that if you don't like the app, it's not as easy to uninstall as with firefox.
Posted: Tue 06 Jan 2009, 11:14
by aragon
@hillside
next version (1.1.1) of sqlitestudio is out.
http://sqlitestudio.one.pl/index.rvt?act=download
cheers
aragon
Posted: Wed 14 Jan 2009, 10:10
by googie
Hi, I'm SQLiteStudio developer.
Please report bugs to to sqlitestudio bug track system (
http://sqlitestudio.one.pl/index.rvt?act=bug ). You don't have to report this bug above, since I've read it here
I didn't met this error before, so I didn't fix it in 1.1.1. I'll fix it in version 1.1.2.
Please tell me a detail:
Did you execute SQL query, then disconnect from database file, then tried to export data? I need to know if you closed database before exporting. It might be reason (which I should fix).
Posted: Wed 14 Jan 2009, 22:10
by googie
Ok, I think I found source of problem and I solved it.
If anybody is interested, please monitor SQLiteStudio homepage for version 1.1.2 (I hope to release it in 2-3 weeks, or something about it) and try out if error described few posts above is really solved or not.