[wellylug] Database application using OpenOffice?

[Hong Chyr]

Thanks for all the feedback/info.

I'm just doing some feasibility study for now. Openoffice is quite good as a general front to SQL databases, altho I've only tried connecting to MySQL via ODBC. The form autopilot feature allows you to create forms quite easily. Postgres shouldn't be too different if you can get it talk ODBC to OOo.

OOo is good as a general front for updating databases, I'm not sure if its as easy to use as Access to create application, eg. stock management console kinda thing. Or at least it needs some elbow grease to get started. Had a look at Rekall, the only problem is I don't have any experience with Python...

So the quest continues.

Cheers,
Hong

----- Original Message -----
From: Wood Brent <pcreso at pcreso.com>
Date: Fri, 16 Apr 2004 13:37:02 -0700 (PDT)
To: wellylug at lists.naos.co.nz
Subject: Re: [wellylug] Database application using OpenOffice?

> 
> IMHO that is the real hole in non-windows RDBMS software. MS Access makes it so
> easy to develop db apps/gui's, & there are 4GLs & GUI builders for most
> commercial RDBMS. Paradox, Foxbase, R:base, even DB III.IV had tools to make
> applications which are better than most OS offerings today.
> 
> > Has anyone heard of/have any experience with developing a database
> > application using mysql and openoffice (ala MS Access)?
> 
> The following links might be useful:
> 
> Free Java based app development toolkit, works via jdbc:
> http://www.minq.se/products/dbvis/index.html
> 
> Have a look here, there is lots of stuff...
> http://knowledgestorm.techtarget.com/searchstorage/search/topsearches/20
> 
> Rekall was announced as "the Access for Linux" but seems to have faded
> somewhat. Supports Posgres & MySQL natively. Files available from:
> http://www.smga3000.com/thekompany/RekallDemo/
> 
> 
> > I know OOo can talk to mysql via ODBC and in oowriter/oocalc there are basic
> > form functions. But is it possible to development an application out if these
> > components? 
> > 
> > I really don't want to go back to the MS Access route if possible.
> 
> 
> Please post your results? I'd be interested in any success you have with a
> suitable front end to Postgres.
> 
> 
> Brent Wood
> 
> 
> -- 
> Wellington Linux Users Group Mailing List: wellylug at lists.naos.co.nz
> To Leave:  http://lists.naos.co.nz/mailman/listinfo/wellylug

-- 
______________________________________________
Check out the latest SMS services @ http://www.linuxmail.org 
This allows you to send and receive SMS through your mailbox.


Powered by Outblaze