DBDB.io The Encyclopedia of Database Systems · Est. 2017
Database of Databases

Database Entry

4D


4D is a relational DBMS that is integrated with an IDE and a proprietary programming language. It allows users to create custom graphical interfaces to work with their database, which can then be run on Windows or Mac OS systems to edit a locally stored database file. 4D can also run as a server so that multiple clients can manage a single database. The latest version of 4D includes "4D for iOS Preview" which creates a customizable iOS app for viewing database contents.[04][05][03]

Country of Origin
FR
Start Year
1984 [11]
Former Names
4th Dimension, Silver Surfer
Project Type
Commercial
Operating Systems
iOS, macOS, Windows
License
Proprietary

Database Entry

4D


4D is a relational DBMS that is integrated with an IDE and a proprietary programming language. It allows users to create custom graphical interfaces to work with their database, which can then be run on Windows or Mac OS systems to edit a locally stored database file. 4D can also run as a server so that multiple clients can manage a single database. The latest version of 4D includes "4D for iOS Preview" which creates a customizable iOS app for viewing database contents.[04][05][03]

History


4D was originally developed under the name "Silver Surfer" in the 1980s as a DBMS for the Macintosh platform.

Checkpoints[06][07][08]


By default, 4D creates a log file with the ".journal" extension when a data file is created. Every modification to the data file since the last backup is recorded in the log file. If the database file is corrupted, 4D will restore the most recent backup and replay the changes in the log. When a new backup is created, the log file is cleared. Backups can be triggered manually or on a schedule. By default, the database will backup every Sunday at 00:00:00, and only the three most recent backups are kept. The database cannot be edited while a backup is running.

Compression[09][10]


4D Web Server supports using gzip compression when communicating with clients. Gzip compression can also be used to shrink BLOB objects stored in the database. The 4D documentation does not mention support for any other types of compression.

Data Model


Query Interface


Citations

11 sources
  1. Fast development platform for business apps | 4D 4d.com
  2. https://doc.4d.com/4Dv21R2/index.en.html 4d.com
  3. 4th Dimension (software) - Wikipedia wikipedia.org
  4. Why 4D | 4D 4d.com
  5. FAQ · 4D for iOS 4d.com
  6. https://doc.4d.com/4Dv16/4D/16.6/Managing-the-log-file.300-4460832.en.html 4d.com
  7. https://doc.4d.com/4Dv16/4D/16.6/Backing-up-the-database.300-4460834.en.html 4d.com
  8. https://doc.4d.com/4Dv16/4D/16.6/Automatic-backup-strategy.300-4460828.en.html 4d.com
  9. https://doc.4d.com/4Dv15/4D/15.6/Web-Server-Overview.300-3817736.en.html 4d.com
  10. https://doc.4d.com/4Dv15/4D/15.6/COMPRESS-BLOB.301-3818262.en.html 4d.com
  11. About us | 4D 4d.com
Revision #4