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: Tomas Lanczos on 25 Dec 2009 22:50 On Thu, 2009-12-24 at 03:10 -0500, Drew Jensen wrote: > 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 Hello Drew and Stephen, I strongly recommend using PostgreSQL or MySQL with the Base as frontend, but I also recommend to consider the purpose, used data types, way of use and amount of stored data before creating it. PostgreSQL is an excellent database engine comparable with database as e.g. Oracle but using it in some cases is like pick children to the school by a bulldoser. Another problem is when the hosting space is designed only for data storage, no software installation is possible. For this case I recommend to consider SQLite, as the all SQLite database is stored in a single file in spite of PostgreSQL/MySQL, accessible from anywhere (at least I suppose, honestly I did not try yet :)). Regards and good luck Tomas p.s.: one note - in all above mentioned cases it is proposed and/or required not to use Ooo Base to create and design the database (in the case of SQLite also create and change tables), but any other database backend designed for the given database engine (e.g. PGAdmin III, PHPPGAdmin, PHPMySQLAdmin, Sqliteman, etc.) insted. --------------------------------------------------------------------- To unsubscribe, e-mail: discuss-unsubscribe(a)openoffice.org For additional commands, e-mail: discuss-help(a)openoffice.org |