(OLD) (ARCHIVED) Puppy Linux Discussion Forum

[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.

[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.

[WhoDo]

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

Hope that helps

[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.

[Lobster]

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

[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/

[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.

[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/virtualization-vmware/news-features-of-the-new-esx-40.html

[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.

[muggins]

A new release of sqlitestudio is available.

[ttuuxxx]

[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.

[ttuuxxx]

[hillside]

[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