This, and other free tools, can ease migration to/from virtually any SQL-compliant database engine.should it ever become necessary.īut there may be good reasons to skip HSQLDB and H2 altogether. And lastly, these engines feature "compatibility modes/ settings" to mimic other popular RDBMS's (PostgreSQL, MySQL, Oracle, SQL Server, etc.) in their role as SQL prototyping tools for database professionals. They also provide superior LOB support, which allows media-file storage inside the database while maintaining performance through mapped/indirect storage up to 64 Terabytes. As a bonus, these two Java-based engines are considerably faster than most other RDBMS's relatively easy to install (a single 1MB file) they're FLOSS cross-platform USB flash-drive portable and HSQLDB is particularly well-known and supported by the Base user-community. Their modern architectures promote ease-of-use on many levels, whereas legacy RDBMS's can overwhelm Base users with undue complexity and out-dated conventions requiring additional tools. You'll be hard-pressed to utilize either of these RDBMS's to their full potential, much less find them lacking in features or function. ![]() If you're starting a new project in Base, I suspect that combining it with the latest HSQLDB 2.x or H2 database engine will take you as far as you'll want to go. This is probably a better location for the Pro/Con list.(please PM me with any comments, updates or suggestions)Ĭhoose your own Back-End Database for Base: ![]() I have connected Base to a corporate Oracle DB and my own MySQL and HSQL databases and it all worked fine.īe sure to read the thread on data loss in base. My advice is to choose the database engine based on your needs first, then worry about connecting Base to the DB. There is an extension for Base that provides an easy connection to MySQL, which is another advantage, though not all that significant. ![]() It is a long thread, so you might want to search for the phrase "Pro's and Con's". The pro's and con's of various databases are discussed in this thread. You can separate the HSQLDB engine from the base file, or you can use any other DB engine, such as MySQL. If OOo crashes while our are working on an embedded database, you can lose your data. ![]() I would say that the important thing is to not use the embedded database because of the risk of data loss. Base is most useful as a bridge between a database and other OOo documents.
0 Comments
Leave a Reply. |