BASE: before I go too far in the design, does base support multiple users? Assumption is the database resides on our company server. Currently, there would be 10 people accesing the DB. Three to four would be inputing AND updating data. The remainder would be pulling various “standard” reports and others pulling adhoc reports. All of these operations/tasks could be occurring at the same time. The data itself is mission critical to the company and our day-to-day operations. Thanks in advance.
Base as a ‘front-end’ can be configured to connect to various ‘back-end’ RDBMS databases (HSQLDB, MySQL, Postgre SQL and soon Firebird). See the answers by DACM in this post by DACM for some important considerations. Each system has it’s own ‘drivers/connectors’ (some native, some JDBC or ODBC) and server software. See here for an example with a Java-based MySQL driver and there is also an ‘experimental’ native driver for MySQL here. Note: Available ‘drivers’ are not always free of bugs or foibles.
Sorry for the delay in responding. Thanks for the information. I will definitely research the two approaches.
Please use comments to reply to answers or questions. If an answer works for you, please mark it as correct so people see the question has been answered. Thanks!