D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] Flat-file database

 

On 06/06/13 16:07, Philip Hudson wrote:
I want to create a simple single-flat-file database and I'm having a
surprisingly difficult time finding any FLOSS software to do it.

The aim is to move away from L/OOffice Calc (the spreadsheet) as this
has proved far too error-prone, and user education has repeatedly failed
to improve matters. I need to ensure that each record is isolated and
encapsulated in the UI.

Unfortunately, it turns out that L/OOffice Base (the "database" module)
only supports flat files (both spreadsheet and CSV) as read-only
datasources -- for mail merges etc. (It also has the most unintuitive,
ill-designed forms builder I've ever seen. The whole module reeks of
developer-designed-UI).

Any ideas?

--
Phil Hudson                  http://hudson-it.no-ip.biz
@UWascalWabbit                 PGP/GnuPG ID: 0x887DCA63


My last job before retirement was self employed, setting up databases for small local companies in my home town of Bristol. At that time, about 20 years ago, I used Borland Paradox as the program. Similar idea to Access but, IMHO, far superior.

When I moved over to Linux 13 years ago I expected to be able to find something similar, and as good. I am still looking!

I will be very interested to see what kind of response you get to this. I personally have given up looking. As far as I can see there is nothing on Linux even close to what I was using on Windows back then. I am talking here about an all-in-one, monolithic, type of database. I have looked at OO Base and Kexi. Waste of time. All the databases I set up with Paradox needed calculated fields, for example. When I tried to see how to do that in Base and Kexi .... well I am still laughing.

So I wish you the best of luck,

Neil





--
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/listfaq