Roadmap Database

From TurboCASH Wiki

Jump to: navigation, search

We currently use the Paradox Database. There are a number of routes here:

Contents

Paradox

Strengths

  1. Dead simple install.
  2. Stable on single user.
  3. Extends to 10 users on Windows 2003 Server.
  4. Lightning fast on standalone systems.

Weaknesses

  1. Unstable on Peer to Peer Networks.
  2. Don't even think of putting Windows 98 in the Network.
  3. Locks us out of Linux.

Firebird

Strengths

  1. Strong Delphi history.
  2. Pure Open Source product.
  3. Scales upwards.
  4. Has Storage Procedures
  5. Embedded installation within TC for single user environment
  6. Server installation for multi user environment
  7. Transaction management

Weaknesses

  1. Complex system.
  2. Unknown installation procedures.

MySQL

Strengths

  1. Introduces a huge base of PHP programmers.
  2. Dominant OSS database.
  3. Open Source.
  4. Runs on virtually all platforms.
  5. 5.2 version has transaction management

Weaknesses

  1. Suspicious licence
  2. Dubious relationship with Oracle
  3. Gotchas
  4. Aggregates use floating point math so that you can only ever get approximate answers
  5. Transaction management requires local configuration, and can silently go AWOL

PostgreSQL

Strengths

  1. Highly functional OSS database
  2. Free software for all kinds of uses - BSD License
  3. Runs on virtually all platforms
  4. Mature, robust transaction management implementation
  5. Exact numeric types for financial management
  6. Mature support for stored procedures, with support for implementing SPs in Perl, Python, PHP, Tcl, Java
  7. Mature support for triggers, foreign key relationships, views

Weaknesses

  1. Not as popular as MySQL
  2. Perceived as slower due to (now ancient) versions being slow
  3. Like all databases, requires periodic table maintenance, in its case, via regular "vacuuming" or running a separate autovacuum daemon

NexusDB V2.4

Strengths

  1. Dead simple install.
  2. Embedded Database.
  3. Transactions (Commit or Rollback)
  4. True Client/Server System.
  5. Lightning fast on ALL Windows systems. (Well maybe not WIN95)
  6. Working towards Full SQL 2003 Compliance.
  7. Conversion Tools from BDE already available.
  8. TurboCASH Australia will produce a system for test case.

Weaknesses

  1. Philip doesn't like the licencing because it is Commercial.
  2. Commercial product for developers. NO LICENCE FEES for distribution.
  3. If you want to stepback to Version 1.8 the DCU are FREE to TC Community.
  4. Locks us out of Linux (for the Server).
Retrieved from "http://www.box.co.za/wiki/index.php/Roadmap_Database"
Personal tools