D&C GLug - Home Page

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

Re: [LUG] Flat-file database

 

On 07/06/13 10:06, Adrian Midgley wrote:

Blackwell Idealist was the best for libraries.  My old copy runs under Wine.

A full text database with indexing and and hoc fields seems the dort of thing someone could write for Linux.

Not me, alas.

On 6 Jun 2013 21:39, "Philip Hudson" <phil.hudson@xxxxxxxxx> wrote:
On 6 Jun, 2013, at 9:17 pm, Gordon Henderson wrote:

Although you've not actually said what you want it for...

Yes, that was a mistake. But c'mon Gordon, you know you don't need to point out those basic facts to me. I stretch sed to its limits on a regular basis.

So: it's for a non-technical, naive user, who has been maintaining a c500-row library catalogue in a spreadsheet, and screwing it up in mind-boggling ways, over and over. User education has repeatedly failed. I need a no-brainer RAD GUI one-record-at-a-time CRUD app with a single table and export to CSV, or preferably, something that JFW with a single CSV file. We need to keep the data as either CSV or a common spreadsheet format for interchange with other users with absolutely unknown systems, who will usually need read-only access. One form, one report, one table, one file, no indexes. Oh, and no budget.

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


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


OK, these are probably not what you're after, but both both are for libraries and will export to XHTML and other formats. Alexandria for sure saves everything in a very unfancy flat format, so maybe the database file can just be opened as a space delimited csv spreadsheet or if individual records per book a macro inserted into ?office. And I can do you a "cuecat" ISBN barcode scanner for postage... I've mostly stopped buying paper type books...

http://alexandria.rubyforge.org/features.html

Tellico is KDE but does collections other than books.

http://tellico-project.org/

Simon


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