The vital object of this first decision is to plan our project in a manner (with tools and database engines) which will support your needs all the way down a road through a future, in which, because you made the right initial decisions, you will build effectively upon your initial foundation, efficiently and without eventual obstruction. This means that ideally for instance, the database engine you choose isn’t just the easy, or seemingly simple one to deploy today; from the beginning it must be an engine which will support your downstream processing demands. Sometimes commercial considerations further affect such choices. What engines are attendance intensive (and costly)? What engines are virtually attendance free in implementations sustaining the processing goals your eventual project must sustain? Generally, the pattern to follow is to select your engine based on one of two possible dispositions. To do so, you must first chart out your basic table needs. A professional won’t even need to build this map (regardless even if hundreds or thousands of tables are involved), because they will usually immediately see whether the architecture and future needs you will need to support are either read or write intensive. You will then choose an appropriate database, based on this overall disposition, and perhaps further based on personal taste and experience, as working with respective software development tools may predicate. MySQL is the usual choice for read intensive implementations. Many developers look to databases such as PostgreSQL for reliable write intensive implementations. We develop our dispositions toward such vital tools by careful research, and by drawing on the pool of experience of the general software development industry. Expense can generally be avoided, because free deployments of very good tools are available. What we’re looking for is performance in either read or write intensive environments, reliability, ease and minimization of administration, and ready integration with prospective software development tools.
