Fsdb

Fsdb, the flatfile streaming database is package of commands for manipulating flat-ASCII databases from shell scripts. Fsdb is useful to process medium amounts of data (with very little data you'd do it by hand, with megabytes you might want a real database). Fsdb was known as as Jdb from 1991 to Oct. 2008.

Fsdb is very good at doing things like:

  • extracting measurements from experimental output
  • re-examining data to address different hypotheses
  • joining data from different experiments
  • eliminating/detecting outliers
  • computing statistics on data (mean, confidence intervals, histograms, correlations)
  • reformatting data for graphing programs

Rather than hand-code scripts to do each special case, Fsdb provides higher-level functions.

Fsdb is built on flat-ASCII databases. By storing data in simple text files and processing it with pipelines it is easy to experiment (in the shell) and look at the output. The original implementation of this idea was /rdb, a commercial product described in the book ``UNIX relational database management: application development in the UNIX environment'' by Rod Manis, Evan Schaffer, and Robert Jorgensen (and also at their web page). Fsdb is an incompatible re-implementation of their idea without any accelerated indexing or forms support. (But it's free!).

For more information, see the README file or download Fsdb 2.51 (released 2014-05-27): Fsdb-2.51.tar.gz, and in RPM format perl-Fsdb-2.51-1.fc20.noarch.rpm, perl-Fsdb-2.51-1.fc20.src.rpm (built against Fedora 20, signed by my PGP key).

Alternatively: download Fsdb-current.tar.gz, perl-Fsdb-current.noarch.rpm, perl-Fsdb-current.src.rpm to get the same thing with an unchanging link.

Alternatively still, some versions are available in CPAN. See also the Fsdb CPAN testers report.

For announcements and discussion about Fsdb, please watch this web page.

(Download older releases in tar.gz format: 2.51 (2014-09-05), 2.50 (2014-05-27), 2.49 (2014-01-04), 2.48 (2014-01-03), 2.47 (2013-10-12), 2.46 (2013-10-08), 2.45 (2013-10-07), 2.44 (2013-10-02), 2.43 (2013-08-27), 2.42 (2013-07-31), 2.41 (2013-07-29), 2.40 (2013-07-13), 2.39 (2013-05-31), 2.38 (2013-04-29), 2.37 (2013-02-26), 2.36 (2013-02-25), 2.35 (2013-02-23), 2.34 (2013-02-10), 2.33 (2012-12-23), 2.32 (2012-12-21), 2.31 (2012-11-28), 2.30 (2012-11-25), 2.29 (2012-11-20), 2.28 (2012-11-15), 2.27 (2012-11-15), 2.26 (2011-12-12), 2.25 (2011-08-07), 2.24 (2011-04-15), 2.23 (2011-03-10), 2.22 (31-Oct-10), 2.21 (16-Apr-10), 2.20 (30-Nov-09), 2.19 (10-Jul-09), 2.18 (1-Jul-09), 2.17 (25-Jun-09), 2.16 (14-Apr-09), 2.15 (13-Apr-09), 2.14 (26-Nov-08), 2.13 (30-Oct-08), 2.12 (16-Oct-08). Releases before 2.12 were called Jdb: 2.11 (14-Oct-08), 2.10 (23-Sep-08), 2.9 (6-Aug-08), 2.8 (5-Aug-08), 2.7 (30-Jul-08), 2.6 (11-Jul-08), 2.5 (24-Jun-08), 2.4 (18-Jun-08), 2.3 (27-May-08), 2.2 (23-May-08), 2.1 (6-Apr-08), 2.0 (25-Jan-08), 1.15 (12-Nov-07), 1.14 (24-Aug-06), 1.13 (4-Feb-04), 1.12 (30-Oct-02), 1.11 (2-Nov-01), 1.10 (10-Apr-01), 1.9 (6-Nov-00), 1.8 (28-Jun-00), 1.7 (5-Jan-00), 1.6 (24-May-99), 1.5 (25-Jun-98), 1.4 (27-Mar-98), 1.3 (17-Mar-98), 1.2 (11-Feb-98), 1.1 (20-Jan-98), 1.0 (22-Jul-97), 0.2 (15-Mar-95), 0.1 (26-May-94), 0.0 (1991).