I was under the impression that OpenOffice now provides a database application. Am I incorrect? Or is this app just not provided with Fedora? Or can I just not find it.
Please advise. Thank you.
Arthur Pemberton wrote:
I was under the impression that OpenOffice now provides a database application. Am I incorrect? Or is this app just not provided with Fedora? Or can I just not find it.
Please advise. Thank you.
Have you checked www.openoffice.org?
In any case, I'd like to use your thread (to avoid opening another) since you talk about OOorg and I wanted to ask something about OO.org too... OO.org 1.1.4 is out... Are there any FC2/3 RPMs ready somewhere? If so where? Thanks...
Sorry for highjacking your thread...
Gain Paolo Mureddu wrote:
Arthur Pemberton wrote:
I was under the impression that OpenOffice now provides a database application. Am I incorrect? Or is this app just not provided with Fedora? Or can I just not find it.
Please advise. Thank you.
Have you checked www.openoffice.org?
Yes, this is what I'm refering to: http://www.openoffice.org/product/dbase.html
In any case, I'd like to use your thread (to avoid opening another) since you talk about OOorg and I wanted to ask something about OO.org too... OO.org 1.1.4 is out... Are there any FC2/3 RPMs ready somewhere? If so where? Thanks...
Sorry for highjacking your thread...
I don't mind. I just want to know how to get this database app on FC3
On Thu, 2005-01-27 at 21:00 -0400, Arthur Pemberton wrote:
Have you checked www.openoffice.org?
Yes, this is what I'm refering to: http://www.openoffice.org/product/dbase.html
OpenOffice doesn't really provide a native database program.
From the web site:
For simple database applications, OpenOffice.org 1.1 supports dBASE (.dbf) databases without any additional software.
OpenOffice also supports MySQL databases natively, so if you have MySQL connected and running, you can use OpenOffice to create databases.
You can set up Unix ODBC and then connect to a MySQL database or use the MySQL JDBC drivers.
That said, you can create a file-based database right now.
1. Under Tools-->Data Sources right click under the list of data sources, and create a new data source. 2. Select DBase, and then fill in the URL with a file path. Hint: use the Bibliography database URL as an example. 3. Now go to the Tables tab and select new table 4. Edit away
It's not very elegant, but it appears to work. You can lace OpenOffice into any database that has a JDBC or UNIX ODBC driver. I'm not quite sure where you place the drivers so that OpenOffice can load them, but I'm sure it's buried in the documentation somewhere.
That said, I've been playing with DBDesigner (http://www.fabforce.net/). There appears to be a problem with DBDesigner and MySQL 4 in that it doesn't seem to want to take a password when connecting to a specific database. I haven't tried it via ODBC. Also, the graphics aren't very good since this is written in Delphi (I think).
I also use SQuirrel (http://squirrel-sql.sourceforge.net/). I personally think this a great tool for doing SQL queries, although it's not much for developing databases.
I don't mind. I just want to know how to get this database app on FC3
Hope this helps.
----- /mde/ just my two cents . . . .
On Thursday 27 January 2005 4:17 pm, Arthur Pemberton flailed at a keyboard and produced this:
I was under the impression that OpenOffice now provides a database application. Am I incorrect? Or is this app just not provided with Fedora? Or can I just not find it.
The 2.0 beta version of OOo -- 1.9.x, actually -- includes a database component, but the current stable version, 1.1.4, does not. As far as I know, the most current FC build of OOo is 1.1.3.
You can download the 2.0 beta from OOo and play with it. I installed it with no problems (it comes as several .rpm files zipped up into one big archive), and I really like it. I'm looking forward to the final build.
Richard S. Crawford wrote:
On Thursday 27 January 2005 4:17 pm, Arthur Pemberton flailed at a keyboard and produced this:
I was under the impression that OpenOffice now provides a database application. Am I incorrect? Or is this app just not provided with Fedora? Or can I just not find it.
The 2.0 beta version of OOo -- 1.9.x, actually -- includes a database component, but the current stable version, 1.1.4, does not. As far as I know, the most current FC build of OOo is 1.1.3.
You can download the 2.0 beta from OOo and play with it. I installed it with no problems (it comes as several .rpm files zipped up into one big archive), and I really like it. I'm looking forward to the final build.
Oh...so that's the problem, I have to wait. I couldn't really figure out when they plan to release a stable with the database component, any idea? A database compontent is an essential part of some high school comsci sylabuses.
On Thursday 27 January 2005 5:08 pm, Arthur Pemberton flailed at a keyboard and produced this:
Oh...so that's the problem, I have to wait. I couldn't really figure out when they plan to release a stable with the database component, any idea? A database compontent is an essential part of some high school comsci sylabuses.
I'm not sure when the 2.0 stable is expected to be release, but something tells me March is the target. You can find out more at http://download.openoffice.org/680/index.html.
On Thu, 2005-01-27 at 17:16 -0800, Richard S. Crawford wrote:
On Thursday 27 January 2005 5:08 pm, Arthur Pemberton flailed at a keyboard and produced this:
Oh...so that's the problem, I have to wait. I couldn't really figure out when they plan to release a stable with the database component, any idea? A database compontent is an essential part of some high school comsci sylabuses.
I'm not sure when the 2.0 stable is expected to be release, but something tells me March is the target. You can find out more at http://download.openoffice.org/680/index.html.
FWIW, there was just an article at NewsForge on the OO.org DB:
http://software.newsforge.com/article.pl?sid=05/01/25/1758245
HTH,
Marc Schwartz
On Thu, 2005-01-27 at 20:08, Arthur Pemberton wrote:
Oh...so that's the problem, I have to wait. I couldn't really figure out when they plan to release a stable with the database component, any idea? A database compontent is an essential part of some high school comsci sylabuses.
Why not use postgresql and pgadmin3?
You can combine that with PHP or several other languages to do all kinds of database work.
Scot L. Harris wrote:
On Thu, 2005-01-27 at 20:08, Arthur Pemberton wrote:
Oh...so that's the problem, I have to wait. I couldn't really figure out when they plan to release a stable with the database component, any idea? A database compontent is an essential part of some high school comsci sylabuses.
Why not use postgresql and pgadmin3?
You can combine that with PHP or several other languages to do all kinds of database work.
I'm interested in this for the high schools in my country who belive that M$ Office is the end all be all computing. The comsci syllabus here uses an Wordprocessor+spreadshet+database combination. So it would be terribly difficult for me to suggest OO if there's no such database component. I myself have very little need for such.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Arthur Pemberton wrote:
| Scot L. Harris wrote: | |> On Thu, 2005-01-27 at 20:08, Arthur Pemberton wrote: |> |> |> |>> Oh...so that's the problem, I have to wait. I couldn't really |>> figure out when they plan to release a stable with the database |>> component, any idea? |>> A database compontent is an essential part of some high school |>> comsci sylabuses. |>> |> |> |> Why not use postgresql and pgadmin3? |> |> You can combine that with PHP or several other languages to do all |> kinds |> of database work. |> |> |> | I'm interested in this for the high schools in my country who belive | that M$ Office is the end all be all computing. The comsci syllabus | here uses an Wordprocessor+spreadshet+database combination. So it | would be terribly difficult for me to suggest OO if there's no such | database component. I myself have very little need for such. | So what you are looking for is something like Rekall?
If memory serves me correctly, didn't The Kompany put out a lower featured GPL'd version of Rekall? For some reason, I want to say it was added to the KDE project. Does this ring any bells with anyone?
If not, at $70.00 per seat (less for volume licenses), the price beats the pants off M$ Access at approx $100 - $130 per seat. And if you use a full database back end like Postgre or MySQL, OO.o has an awesome mail merge feature on the F4 key.
HTH Kevin Fries
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Kevin Fries wrote:
| Arthur Pemberton wrote: | | | I'm interested in this for the high schools in my country who | belive | that M$ Office is the end all be all computing. The comsci | syllabus | here uses an Wordprocessor+spreadshet+database | combination. So it | would be terribly difficult for me to suggest | OO if there's no such | database component. I myself have very | little need for such. | So what you are looking for is something | like Rekall? | | If memory serves me correctly, didn't The Kompany put out a lower | featured GPL'd version of Rekall? For some reason, I want to say | it was added to the KDE project. Does this ring any bells with | anyone? | | If not, at $70.00 per seat (less for volume licenses), the price | beats the pants off M$ Access at approx $100 - $130 per seat. And | if you use a full database back end like Postgre or MySQL, OO.o has | an awesome mail merge feature on the F4 key.
OK, sorry for answering my own post, should have done more checking before spouting off.
See: http://www.rekallrevealed.org/
It sounds like what you are looking for.
Kevin Fries
-
Arthur Pemberton -
Gain Paolo Mureddu -
Kevin Fries -
Marc Schwartz -
Mark Eggers -
Richard S. Crawford -
Scot L. Harris