Therefore, this post is me seeing someone who obviously knows what they're talking about and asking you to take a quick look at what I'm doing. I could go with straight Access, OOo Base, FileMaker Pro, or I could probably get into some more serious stuff like a PostgreSQL backend with maybe OOo Base as a frontend? I'm getting overwhelmed at all the things I need to research before I can even pick a correct direction. Villeroy, as I reseach software solutions to the obstacle that I see forming on the horizon for my business, I am learning that there are many many directions that I can take. SQL is something that can be learned easily and helps to operate any database, including Base and Access. When it comes to developing a new database or input forms for existing databases, Base is best used by some SQL-literable developer able to avoid all of it's graphical tools: Structured Query Language in Base. The Sun Report Builder extension does not help you developing new databases nor input forms.Īccess has a strong focus on ease-of-use for the database developer. Again, these reports dump grouped and sorted content plus charts and pictures out of existing databases into Writer's layout capabilities.
Currently, the main focus of development seems to be the integration of a third-party, open source report engine to allow professional reports, close to what you can do in Access. All input forms are attached to office documents. Reporting is based on the Writer component. Thus Base is hardly more than a bridge to import data sources regardless of file formats into office documents. This office suite is strictly focussed (and limited) to document creation (text, spreadsheet, presentations, vector graphics with charts and mathematical formulas).
Newbie Ask: 1-Deployable Online? 2-Can I dump Access? Access can create single-file databases from scratch by using the MS JET engine, Base pretends to do the same thing when it wraps into a zip-archive. It amounts to 15 years of development and a multi-million dollar budget.īoth are database frontends, which can be used to read, display and possibly write several types of tabular data sources from CSV to highe end database servers.
0 kommentar(er)
