I think your best bet is to see if people have recommendations for any tool that will make it easy to maintain a simple DB via a web browser, install it, export your data from Base, and import it into the new system. You could also just ditch OOBase all together, export your data into a CSV file, and then import it into whatever system you end up using, and do all your maintenance through a web UI.Īt this point though, I'm guessing that this is more than you'd planned to bite off. Step 1 - Creating a New Project with Android Studio. That suggests that you might have to go with the very common mySQL, or the awesome, but somewhat less common Postgres. I have divided this implementation into 4 steps as shown in the following. Unfortunately, while SQLite is pretty widely supported, it looks like Base's SQLlite support is only in alpha. SQLite would be the easiest, since it doesn't require that you install and maintain a DB server. If you are going to go that far, you'd be better off taking advantage of Base's ability to work with other database backends and choose something that is likely to be better supported by a wider range of web frontends. However, it would end up being an HSQLDB database file, rather than a Base file. File extension sdb is associated with OpenOffice Base, a fully featured desktop database management system, designed to meet the needs of a broad array of users. If there were an Java app that made it easy to edit databases via a web browser, then it should be pretty easy to have it work with data from Base. It's opensource and Java, it looks like support for accessing HSQLDB's are spotty in other common languages used on the web. At its heart, OO Base uses an embedded database engine called HSQLDB. ![]() It doesn't really look like their are easy ways to update the DB from the web. Not sure if their is an easy way to automate the regeneration of the web pages, or not. ![]() If people aren't going to be editing the DB that often, you could throw it up on a fileserver and let people edit it in OO. ![]() You could just throw those up on a web server. It looks relatively easy to have base export the contents of a DB as one or more static web pages.
0 Comments
Leave a Reply. |