Puppy Linux Discussion Forum

charleshdw · Joined: 25 Oct 2008 Posts: 8

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

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 · 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

loganz · Joined: 13 Nov 2008 Posts: 8

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 · 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

hillside · 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/

muggins · Joined: 20 Jan 2006 Posts: 6691 Location: lisbon

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 · Joined: 10 Dec 2008 Posts: 1

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 · 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. Laughing

muggins · Joined: 20 Jan 2006 Posts: 6691 Location: lisbon

A new release of sqlitestudio is available.

ttuuxxx · Posted: Fri 26 Dec 2008, 07:21 Post subject:

hillside · 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.

ttuuxxx · Posted: Sun 28 Dec 2008, 12:36 Post subject:

hillside · Posted: Sun 28 Dec 2008, 18:17 Post subject:

muggins · Joined: 20 Jan 2006 Posts: 6691 Location: lisbon

@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