Which database software do you use?

Discussion topics, Linux related - not requests for help

Moderators: ChrisThornett, LXF moderators

Which database software do you use?

Postby wiz » Sun Oct 23, 2005 7:48 pm

I have been trying to shift my office database (Customers, Stock, Orders & Invoices etc) to a Linux based system for ages but it is not an easy thing to do.

I tried Postgres & MySql but it is a huge amount of effort to rewrite the whole system using apps like these.

I have just tried OpenOffice Base, found two bugs (sent in the reports) and came crashing out of the app six times in 30 mins. The last time, all the tables in the database disappeared into the blue yonder.

Is there a lightweight reasonably simple database app that I haven't found yet ?.
For the moment it's back to CBuilder :cry:
wiz
LXF regular
 
Posts: 119
Joined: Thu Apr 07, 2005 6:20 pm
Location: In front of a computer

RE: Which database software do you use?

Postby Lejon » Sun Oct 23, 2005 7:58 pm

Is ther not a lightweight version of MySQL?
I am the one you thought I was! Just not the way, you expected...
User avatar
Lejon
LXF regular
 
Posts: 150
Joined: Wed Oct 19, 2005 7:24 pm
Location: Sweden

RE: Which database software do you use?

Postby linuxgirlie » Sun Oct 23, 2005 9:19 pm

I use MySQL but only because most of my database work is web-based, mainly PHP...
My knowledge comes with no warranty...........

Server operating system designed for schools:http://www.linuxschools.com
linuxgirlie
LXF regular
 
Posts: 787
Joined: Sat Apr 09, 2005 6:34 pm
Location: Kent...UK


Re: Which database software do you use?

Postby CJLL » Mon Oct 24, 2005 4:46 pm

wiz wrote:I have been trying to shift my office database (Customers, Stock, Orders & Invoices etc) to a Linux based system for ages but it is not an easy thing to do.

I tried Postgres & MySql but it is a huge amount of effort to rewrite the whole system using apps like these.


Well, you could always try DB2, Oracle or SyBase but given your previous experience maybe not.

wiz wrote:Is there a lightweight reasonably simple database app that I haven't found yet ?.
For the moment it's back to CBuilder :cry:


Not a problem C++Builder runs on Linux too ;-)
CJLL
LXF regular
 
Posts: 193
Joined: Sat Jul 09, 2005 9:22 pm

Postby wiz » Mon Oct 24, 2005 8:57 pm

I suppose, the database itself is not really the problem, I have tried several of them & they all obviously work ok.
It is all the supporting items around them that are a bit lacking.

I was hoping that someone would say, "Try app 'xyz'. It has the database, form designer & report writer all designed to work perfectly together and is exactly what you need" but I knew it was a bit unlikely because I have not seen anything like it in several years of using Linux.
Maybe when Open Office settles down a bit I'll try again.
wiz
LXF regular
 
Posts: 119
Joined: Thu Apr 07, 2005 6:20 pm
Location: In front of a computer

Postby nordle » Mon Oct 24, 2005 9:06 pm

knoda is ok for that:

http://www.knoda.org/

or Rekall

http://www.thekompany.com/projects/rekall/

Or using QT yourself, or wxPython...
I think, therefore I compile
User avatar
nordle
LXF regular
 
Posts: 1500
Joined: Fri Apr 08, 2005 9:56 pm

Postby ggreaves » Wed Oct 26, 2005 10:59 am

Would mysql or postgres and gambas be of any use? There is a tutorial in LinuxFormat at the mo.
User avatar
ggreaves
LXF regular
 
Posts: 124
Joined: Tue Apr 12, 2005 12:58 pm


Return to Discussion

Who is online

Users browsing this forum: Exabot [Bot] and 0 guests