Subject FYI - dBASE LLC niches From Edward Racht <eracht@yahoo.com> Date Sun, 2 Apr 2023 13:23:18 -0400 Newsgroups dbase.getting-started Greetings, FYI dBASE Niches: Although the language has fallen out of favor as a primary business language, some find dBase an excellent interactive ad hoc data manipulation tool. Whereas SQL retrieves data sets from a relational database (RDBMS), with dBase one can more easily manipulate, format, analyze and perform calculations on individual records, strings, numbers, and so on in a step-by-step imperative (procedural) way instead of trying to figure out how to use SQL's declarative operations. Its granularity of operations is generally smaller than SQL, making it easier to split querying and table processing into easy-to-understand and easy-to-test parts. For example, one could insert a BROWSE operation between the filtering and the aggregation step to study the intermediate table or view (applied filter) before the aggregation step is applied. As an application development platform, dBase fills a gap between lower-level languages such as C, C++, and Java, and high-level proprietary 4GLs (fourth generation languages) and purely visual tools, providing relative ease-of-use for business people with less formal programming skill and high productivity for professional developers willing to trade off the low-level control. dBase remained a popular teaching tool even after sales slowed because the text-oriented commands were easier to present in printed training material than the mouse-oriented competitors. Mouse-oriented commands were added to the product over time, but the command language remained a popular de facto standard, while mousing commands tended to be vendor-specific. File formats: A major legacy of dBase is its .dbf file format, which has been adopted in a number of other applications.