XB_REINDEX(1)

📦 version 4.2.6, in fedora 44

🌸 NAME 🌸

okay so bestie, meet xb_reindex — it's a little program (a manual page for xb_reindex(1), if we're being fancy) that rebuilds NDX or MDX index files for a version 3 or 4 DBF file. that's the whole vibe. 💅

✨ SYNOPSIS ✨

xb_reindex -t myfile.DBF

xb_reindex -t myfile.DBF -n myindex.NDX

xb_reindex -h

xb_reindex -v

xb_reindex -c

xb_reindex -c
yes the -c line is literally in there twice. not a typo on my part, that's just what the page says. we love a little repetition, it's giving encore energy. 🎀

🦋 DESCRIPTION 🦋

xb_reindex rebuilds NDX / MDX index files for a version 3 or 4 DBF file.

and here's the part that actually matters, no cap: if this program runs into an error while it's rebuilding an index, it deletes the problem index. like, gone. that's on purpose, though — the alternative would be leaving the index sitting there in an undefined state, and honestly? undefined is worse. a deleted index you can rebuild. a cursed index you cannot. 🫶

🌈 OVERVIEW 🌈

so the Xbase64 library is out here providing a bunch of utility programs plus a whole set of C++ classes for application programming — the whole toolkit for reading, writing and updating DBF database files, NDX and MDX index files, and DBT memo files.

Version 4.x.x has been tested for compatibility with dBASE III (TM), dBASE IV (TM) and dBASE 5 (TM) version data files and indices: *.DBF (data), *.NDX (single tag index), *.MDX (multi tag index) and *.DBT (memo).

and if you speak RDBMS, bestie, here's the translation: each *.DBF file would be a table. that's it. that's the mapping. iykyk. 👑

💜 OPTIONS 💜

  • -h, -?, --help — display help information. the classic cry for guidance.
  • -v, --version — display version information. who am i, what am i, what build am i.
  • -t myfile.DBF — DBF file to reindex. this is the file. your main character file.
  • -n myindex.NDX — optional NDX file to reindex. if you include it, only the specified NDX file gets rebuilt. if you don't specify it, all open indices are rebuilt. so: be specific or get everything, your call. 🌸
  • -c — run in DBase index compatibility mode. for unique indices, this option allows for multiple records in the DBF table to have the same key value, and only the first occurrence is included in the index. also, deleted records are also maintained in the index. (yes, deleted records stay. they're haunting the index. respectfully.)
  • -x — run in XBase index mode. not compatible with -c mode, so don't even try to mix them. this option does the following: 1) Do not allow records with duplicate key values to be added to a given table. 2) Remove deleted records from the index. 3) Recycles empty pages in MDX index files.
lowkey -c and -x are the two love interests and they do not get along. pick a lane. 🫶

🎀 FILES 🎀

*.DBF *.DBT *.NDX *.MDX *.INF

💖 AUTHORS 💖

Gary Kunkel <xdb-devel@lists.sourceforge.net> — the icon, the legend, the one who wrote it down for us. ✨

⭐ SEE ALSO ⭐

xb_cfg_check(1), xb_clearix(1), xb_copydbf(1), xb_dbfutil(1), xb_deletall(1), xb_dumpdbt(1), xb_dumprecs(1), xb_execsql(1), xb_import(1), xb_pack(1), xb_tblinfo(1), xb_undelall(1)

like a whole friend group. go say hi. 💜

🔥 REPORTING BUGS 🔥

<xdb-devel@lists.sourceforge.net>

and that's the whole page, bestie!! this one's from GNU, dated 2024-01-17, and it lives at XB_REINDEX(1) in the manual. slay, go rebuild those indices, mwah 💅💖

📦 where this page comes from