[ubuntu-za] Database Problems

[Ewald Horn]

2010/1/22 Ian Whitfield <whitfield at federalsaints.net>

>  Hi all
>
> Another cry for help!
>
> I've been using OOBase for my Group records since moving to Kubuntu but am
> VERY un-happy with it! It hangs a lot and crashes and does not save on
> record exit either. It is VERY slow and the save routine is a nightmare.
> Also the recovery mode after a crash does NOT work!
>
> As a result I have lost much data and/or spend lots of time re-entering
> stuff. So I decided I should move to a 'better' option.
>
> 1) - I was told I could change the DB Engine in OOBase for MySQL which
> would sort out my problems but after working at this for some time I gave up
> as I could not get it to work at all.
>
> 2) - I then decided to try MySQL on it's own, but again was unable to get
> any success. While investigating this I also became worried about the future
> of MySQL with the Orical buy-out!
>
> 3) - Having noticed that a recent upgrade included PostgreSQL which is
> supported by Canonical I decided to try this. I found a good tutorial for
> setting this up but have come un-stuck editing the config file as it will
> not accept my submask address!!!
>
> Is there anyone out there who could "hold my hand" and help me out here?
>
> My OpSys is Kubuntu 9.10
>
> Thanks a lot
>
> Ian
>
> --
> ubuntu-za mailing list
> ubuntu-za at lists.ubuntu.com
> https://lists.ubuntu.com/mailman/listinfo/ubuntu-za
>
> Hi Ian.

As a matter of interest, what did you use before? More importantly, what do
you want to do?

OOBase is only as good as the database you are using, and there is nothing
wrong with PostgreSQL or MySQL. The default database, HSQLDB or something
like that, has never given me anything but a constant headache! Having said
that, I do find it a bit stubborn at times.

You could check out http://www.kexi-project.org/ - it's an alternative to
Microsoft Access, but I have not messed around with it at all and it seems
to depend on KDE.

Please tell us what background you have, it sounds like you might be better
off using PHP coupled with MySQL or PostreSQL, but that's just a wild guess.

Best regards
Ewald
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.ubuntu.com/archives/ubuntu-za/attachments/20100122/b029861f/attachment-0001.htm