Linux Format forums Forum Index Linux Format forums
Help, discussion, magazine feedback and more
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Which database software do you use?

 
Post new topic   Reply to topic    Linux Format forums Forum Index -> Discussion
View previous topic :: View next topic  
Author Message
wiz
LXF regular


Joined: Thu Apr 07, 2005 7:20 pm
Posts: 119
Location: In front of a computer

PostPosted: Sun Oct 23, 2005 8:48 pm    Post subject: Which database software do you use? Reply with quote

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 Crying or Very sad
Back to top
View user's profile Send private message
Lejon
LXF regular


Joined: Wed Oct 19, 2005 8:24 pm
Posts: 150
Location: Sweden

PostPosted: Sun Oct 23, 2005 8:58 pm    Post subject: RE: Which database software do you use? Reply with quote

Is ther not a lightweight version of MySQL?
_________________
I am the one you thought I was! Just not the way, you expected...
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
linuxgirlie
LXF regular


Joined: Sat Apr 09, 2005 7:34 pm
Posts: 787
Location: Kent...UK

PostPosted: Sun Oct 23, 2005 10:19 pm    Post subject: RE: Which database software do you use? Reply with quote

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:www.linuxschools.com
Back to top
View user's profile Send private message Send e-mail
nordle
LXF regular


Joined: Fri Apr 08, 2005 10:56 pm
Posts: 1500

PostPosted: Sun Oct 23, 2005 10:36 pm    Post subject: RE: Which database software do you use? Reply with quote

Which rdbms are you currently using? And what volumes of processing will it be doing?

I would swear by postgresql for nearly all situations, except perhaps where you need something really small for embedding into an app, in which case I'd use sqlite or hsqldb

http://www.postgresql.org/
http://www.pgadmin.org/pgadmin3/index.php
http://phppgadmin.sourceforge.net/
http://pgpool.projects.postgresql.org/
http://gborg.postgresql.org/project/slony1/projdisplay.php
http://www.unixodbc.org/
http://gborg.postgresql.org/project/psqlodbc/genpage.php?downloads
http://jdbc.postgresql.org/
http://www.pygresql.org/
http://initd.org/projects/psycopg1
http://druid.sourceforge.net/
http://www.aquafold.com/index.html
http://mdbtools.sourceforge.net/

http://www.sqlite.org/index.html
http://phpsqliteadmin.sourceforge.net/index.php

http://www.hsqldb.org

http://firebird.sourceforge.net/
Back to top
View user's profile Send private message
CJLL
LXF regular


Joined: Sat Jul 09, 2005 10:22 pm
Posts: 193

PostPosted: Mon Oct 24, 2005 5:46 pm    Post subject: Re: Which database software do you use? Reply with quote

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 Crying or Very sad


Not a problem C++Builder runs on Linux too Wink
Back to top
View user's profile Send private message
wiz
LXF regular


Joined: Thu Apr 07, 2005 7:20 pm
Posts: 119
Location: In front of a computer

PostPosted: Mon Oct 24, 2005 9:57 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
nordle
LXF regular


Joined: Fri Apr 08, 2005 10:56 pm
Posts: 1500

PostPosted: Mon Oct 24, 2005 10:06 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
ggreaves
LXF regular


Joined: Tue Apr 12, 2005 1:58 pm
Posts: 124

PostPosted: Wed Oct 26, 2005 11:59 am    Post subject: Reply with quote

Would mysql or postgres and gambas be of any use? There is a tutorial in LinuxFormat at the mo.
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
View previous topic :: View next topic  
Display posts from previous:   
Post new topic   Reply to topic    Linux Format forums Forum Index -> Discussion All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Linux Format forums topic RSS feed 


Powered by phpBB © 2001, 2005 phpBB Group


Copyright 2011 Future Publishing, all rights reserved.


Web hosting by UKFast