Database design
in [Open Office]
|
Prev: I'd like to join your mailing list. Also would like know if www.office-suite.org is a true OpenOffice.org web si
Next: [discuss] open office - language issue
From: Drew Jensen on 24 Dec 2009 03:10 Stephen Wolfe wrote: > I was wondering if there is a way to store the database file on my hosting > space so I can allow access to it from any computer? Of course, it would > need to accept some kind of login password or some other way for me to > control access from others who use the database. I'm also guessing this > would also get more people to use OpenOffice. That would be perfect :) > Hello Stephen, I suppose you are referring to a Base embedded database. Short answer is - no, you can not open and connect to the database, embedded in a Base file from a shared hosting environment. Least not that I know of. Of course Base is really a Database Front-end Document package, not a database manager. So you might consider PostgreSQl or MySQL or ???? Drew --------------------------------------------------------------------- To unsubscribe, e-mail: discuss-unsubscribe(a)openoffice.org For additional commands, e-mail: discuss-help(a)openoffice.org
From: Alexandro Colorado on 24 Dec 2009 03:18 On Wed, Dec 23, 2009 at 11:46 AM, Stephen Wolfe <stephen.a.wolfe(a)gmail.com>wrote: > I was wondering if there is a way to store the database file on my hosting > space so I can allow access to it from any computer? Of course, it would > need to accept some kind of login password or some other way for me to > control access from others who use the database. I'm also guessing this > would also get more people to use OpenOffice. That would be perfect :) > > -Stephen Wolfe (software designer) > wolfe1.com > What you can do is connect Base to your mysql database althought connecting directly to a remote database is not a good security practice. Is better if you implement replication on a local environment over an encripted tunnel and then connect locally using Base. Your local mysql database will be able to sync all the information with the one on the hosting area. -- Alexandro Colorado OpenOffice.org Español IM: jza(a)jabber.org
From: Andreas Saeger on 24 Dec 2009 03:18 Stephen Wolfe wrote: > I was wondering if there is a way to store the database file on my hosting > space so I can allow access to it from any computer? Of course, it would > need to accept some kind of login password or some other way for me to > control access from others who use the database. I'm also guessing this > would also get more people to use OpenOffice. That would be perfect :) > > -Stephen Wolfe (software designer) > wolfe1.com > Hi Stephen, Base is a mere database front-end. It's main purpose is to "serve" row sets to office documents. It can connect to databases of various types, including some file based pseudo-datbases (csv, spreadsheets). It provides some basic tools to let you filter, sort, rearrange and aggregate database data by means of SELECT queries. The resulting row sets can be viewed in tables, queries and the data-source window (also called "beamer"). They can be used in office documents as address list, bibliography, structured source for your calculation models and such. Base uses the layout capabilities of Calc and Writer to present formatted output of database data. Input forms provide the bare minimum to let you edit relations (which is why quite a lot new users give up with them). The resulting input forms are _well enough_ for me. To meet higher expectations (a database GUI that is worth some money) you need to be a fairly good programmer with a lot of time. The Sun Report Builder add-on links Base and Writer through a professional, 3rd party reporting engine. http://extensions.services.openoffice.org/project/reportdesign As an additional "gimmick" (or prove of concept), Base lets you create new relational databases from scratch wrapping HSQLDB tables into the configuration file (the "database document"), so you can distribute copies of self-contained database documents to desktop users. Refer to http://hsqldb.org for all the details and documentation of this database. OOo provides no sufficient documentation. The required security measures granted, you may use OOo Base to connect a set of forms, reports, spreadsheets and other office documents to some remote database. Normally, you would build up a web-front-end for this. Hope that helps, Andreas --------------------------------------------------------------------- To unsubscribe, e-mail: discuss-unsubscribe(a)openoffice.org For additional commands, e-mail: discuss-help(a)openoffice.org
From: "Bruce Martin" on 24 Dec 2009 03:40 Dear Steve: Any Oo file can be saved with a password. As for hosting it, you would likely want to host it as a file and download it before attempting to use it. Then, if there are changes, upload it to overwrite. You could try bluehost or adrive for FTP hosting, and filezilla for SFTP. Cheers, Bruce M. -----Original Message----- From: Stephen Wolfe [mailto:stephen.a.wolfe(a)gmail.com] Sent: December 23, 2009 12:46 PM To: discuss(a)openoffice.org Subject: [discuss] Database design I was wondering if there is a way to store the database file on my hosting space so I can allow access to it from any computer? Of course, it would need to accept some kind of login password or some other way for me to control access from others who use the database. I'm also guessing this would also get more people to use OpenOffice. That would be perfect :) -Stephen Wolfe (software designer) wolfe1.com No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.722 / Virus Database: 270.14.118/2584 - Release Date: 12/23/09 14:02:00 --------------------------------------------------------------------- To unsubscribe, e-mail: discuss-unsubscribe(a)openoffice.org For additional commands, e-mail: discuss-help(a)openoffice.org
From: Andreas Saeger on 24 Dec 2009 07:03
Bruce Martin wrote: > Dear Steve: > > Any Oo file can be saved with a password. Except for databases. As for hosting it, you would > likely want to host it as a file and download it before attempting to use > it. Then, if there are changes, upload it to overwrite. > This may apply to the special type of Base document with an embedded HSQLDB. But using some kind of version control for web-hosted files turns this into a caricature of a web-database. A database server serves database rows like a http server serves web pages, a mail server serves mail and a ftp server serves files. Firefox is one app to view web-pages and ftp-directories, Thunderbird communicates with mail servers and OOo's Base component is one tool to access databases (guess where MS Access got its name from). There are plenty of well working database servers, including free ones. If you are really, really sure that you want to access such a database behind a server by means of OpenOffice.org, then you need the well formed, valid database and the carefully set up database server first before you *finally* distribute a set of configuration, queries, forms and reports wrapped into a "Base document" together with the respecive user's log-in data. Many users can use the very same database at the same time, using Base or any other suitable front-end tool (HTML forms, MS Access, what else). The user opens the Base document and some object therein, Base prompts for the log-in at the remote database server before it can fill the grids, forms and reports with data. --------------------------------------------------------------------- To unsubscribe, e-mail: discuss-unsubscribe(a)openoffice.org For additional commands, e-mail: discuss-help(a)openoffice.org |