December 20, 2024.

- Also read Item Pages menu in the main window. This brevity was not mentioned in the 2024.12.01 release notes.
- Android people shall be burdened with ARM32 and ARM64 bundles. So much lovely work.
- BiblioteQ contains at least 127 options.
- CSV Import Browser: new post-import script with a memory.
- Corrected discovery and separation of tabbed search windows. The discovery process did not set the current tab page to that of the discovered item while the separation process did not center the separated window.
- Corrected selection of icon items. Whenever an item is selected in the main table, its icon representation is also selected. The coordinates of the icon item must be translated to its scene's coordinates system.
- Denote interrupted preview in CSV Import Browser.
- Drop-shadow-effects on graphics items.
- Enable tool tips on graphics items. Remember, Other Options -> Main Window -> Show Table Tool Tips must be enabled.
- Final LTS release of 2024. See YOU!
- Final release of Linux packages. Future: Android, MacOS, Windows. See YOU!
- Highlight BiblioteQ Field Name widgets in CSV Import Browser if mismatches occur.
- LTS release.
- LTS version information in About.
- Let's repeat. Paged items!
- Merry something to someone who may be merry.
- New --help terminal option.
- New Edit -> Select All.
- New Options -> Download Version Information After Launch. Off.
- New Other Options -> Scripts. The values will be available in CSV Import Browser and Tools -> External Applications; sorted and unique. Icons available in External Applications actions.
- Paste buttons in book images. GitHub ticket #386.
- Pretty rounded borders on some images.
- Qt 6.8.1 LTS on Android.
- Qt 6.8.1 LTS on MacOS.
- Qt 6.8.1 LTS on Windows.
- Qup releases in the hopeful future.
- Removed the Ctrl + A shortcuts from photographs as the shortcuts will interfere with the wordly shortcut.
- Replaced the dull selection border on a graphics item with a sassy geometric shape.
- Second entry in the 2024.12.01 release notes: Kubuntu -> KDE.
- Super fast selection of large table sets via Ctrl + A.
- The newest version in postgresql_update_schema.sql should be 2024.12.01.
- Wider progress dialogs.
- Will BiblioteQ reach a quarter of a century of awesomeness? Maybe, maybe not. We simply do not know!

December 1, 2024.

- 261 releases of BiblioteQ!
- A style of Breeze is the preferred style of biblioteq.sh for Kubuntu. Otherwise, Fusion is the preferred style.
- Abundant constants. Please report weird events.
- Added DROP statements in postgresql_destroy_schema.sql. Not a single sprite ushered a complaint.
- Allow only unique items in Batch Activities Browser -> Discover. Uniqueness is defined via the Identifier column.
- Awesome button colors. The previous edition featured buttons having full colors.
- Batch Activities is incomplete regarding reservation histories. That is, history entries were not created for borrowed items. GitHub ticket #373.
- CSV Import Browser: guess BiblioteQ Table Field Name values according to the contents of the CSV file. GitHub tickets #376, #385.
- CSV Import Browser: highlight CSV Preview cells in Templates table. Cells are highlighted if values are missing or present. GitHub ticket #376.
- CSV Import Browser: optionally refresh the main window's view after an import event of Template 1 and Template 2. A prompt is displayed if at least one item is imported. Books category.
- CSV Import Browser: replaced Templates signal current-index-changed() with activated().
- CSV Import Browser: writable CSV File widget.
- Corrected biblioteq.win.pro. Deleting debug plugins may delete required plugins files in the install target. Qt 6.5 LTS has separated the debug and release files and the additional logic in biblioteq.win.pro is not necessary. GitHub tickets #374, #375.
- Disable the Go! button in Batch Activities Browser if the current page is Discover.
- Display a reminder if a requested item has been returned on SQLite. Other Options -> SQLite. GitHub ticket #350.
- Display all reserved items in the main table if the Batch Activities Browser -> Return table is empty during a Go! event.
- Include the account's database role in the main window's title for a PostgreSQL connection.
- Include the member's identifier in Member's Reservation History window title.
- Into the never-future with Poppler and Qt.
- List number of lines in CSV; CSV Import Browser.
- Missing Qt TLS libraries / plugins on Windows. Also read item covering biblioteq.win.pro. GitHub tickets #374, #375.
- New --prepare-csv-import-file terminal option.
- New Options -> Center Child Windows. Most windows and some dialogs.
- New Options -> Patron Reservation History.
- New Options -> Tabbed Item Windows. Enabled. New windows only.
- New Other Options -> Main Window -> Only UTF-8 Printable Text. If enabled, cell text in the main window will only contain printable UTF-8 characters.
- New no_image.png image.
- New terminal option --open-sqlite-database-index index, where index is the index of the entry in the Recent SQLite Files menu. First index is one.
- Optional progress dialogs in CSV Import Browser. The process is inactive and may be completed later. GitHub ticket #384.
- Q_OS_WIN -> Q_OS_WINDOWS.
- Poppler and Qt 6. Poppler is an exterior product covering PDF documents.
- Populate entries in the Recent SQLite Files menu with values adjusted with QFileInfo.
- PostgreSQL 15.10.1; Windows.
- PostgreSQL: grant delete on item_borrower to biblioteq_librarian.
- QSqlQueryModel::setQuery() has a new signature since Qt 6.2.
- Record and restore window geometries: Batch Activity Browser, CSV Import Browser, Database Enumerations Browser, Merge SQLite Databases, Other Options, Query History. Geometries are restored before windows are optionally centered.
- Removed GNOME-specific geometry instructions.
- Retrieve the absolute file paths for arguments of --special-executable and --special-executable-icon.
- SRU@France is now HTTPS in biblioteq.conf.
- Set QMAKE_MACOSX_DEPLOYMENT_TARGET to 13.0 in biblioteq.macos.pro.
- Set the height of the member dialog as maximum(-100 + m_members_diag->height(), userinfo_diag->sizeHint().height()).
- Sort Recent SQLite Files entries.
- Spelling corrections in this document.
- Tabbed item windows! Please report glitches.
- The method biblioteq_misc_functions::isbn13to10() will now produce the original string if the string does not begin with 978. GitHub ticket #350.
- The sample CSV file (Data/BiblioteQ.csv) now reflects the sample SQLite database (Data/BiblioteQ.sqlite) with respect to books.
- Trim header strings in CSV Import Browser. The strings are trimmed for both the CSV Preview and Templates tables.
- Utilize either ISBN-10 or ISBN-13 for Copy Browser and Item Reservation Status; first available value.

June 30, 2024.

- 260 releases of BiblioteQ!
- Archived biblioteq_architecture.h and replaced with QSysInfo::buildCpuArchitecture().
- Cell colors. Please see Other Options -> Main Window -> Special Value Colors. GitHub ticket #369. True-equality comparisons are performed. Fast, super fast.
- Consider PostgreSQL's libpq location on Apple Silicon.
- Corrected item reservation for PostgreSQL. Please drop the delete_request() function as it is incomplete.
- Display a reminder if a requested item has been returned. PostgreSQL for now. GitHub ticket #350.
- Final traditional release. Future releases provided through Qup.
- First LTS of 2024?
- Include hh:mm:ss in item-request date.
- Non-modal About dialog.
- PostgreSQL 15.7.2; Windows.
- QSqlQueryModel::setQuery() has a new signature since Qt 6.2.
- Resize other windows at about 95% of the main window's size.
- Select the appropriate member in the Members Browser when an item is prepared for reservation. For example, an item is selected in the main window and the Reserve Selected Item button is clicked.

April 30, 2024.

- 259 releases of BiblioteQ; here and there. A pleasant approximation.
- 676 Dewey Number and Z39.50 Unimarc. GitHub ticket #344.
- Added sslcompression=1 to connection_options in biblioteq.conf. PostgreSQL only.
- Completed C++ enumerator classes. Please discover errors.
- Corrected INI recording of availability colors in Other Options -> Main Window. Do not neglect sorted columns! GitHub ticket #357.
- Corrected INI recording of date formats in Other Options -> Items. Do not neglect sorted columns! GitHub ticket #357.
- Correctly committed Database Enumerations Browser data will cause automatic population of existing interfaces. Please note that BiblioteQ will make a best effort at preserving current values of existing interfaces.
- Database Enumerations Browser: replaced combination box widgets in the Locations table with item delegates. The revision resolves a peculiar Qt warning "edit: editing failed". The problem is encountered during tab-key navigation. Please also read the TO-DO document.
- Disabled sorting in Database Enumerations Browser -> Reservations Minimum Days. GitHub ticket #362.
- Display all items in Database Enumerations Browser -> Section combination box widget.
- Display an error message if the PostgreSQL library provided by Homebrew is not available on MacOS.
- Display formatted dates for all queries in the main window.
- Do not translate Type fields in the Database Enumeration Browser's Locations and Reservations Minimum Days. The Type field represents a database value and items are located through it. GitHub ticket #360.
- Introduced loop-unrolling in project files for some distributions.
- Organized source. Please review and submit corrections.
- Other Options: do not record colors names as Latin in the INI file. Instead, record colors names as presented.
- Removed all QSettings::sync() instances.
- Removed duplicate mnemonics from all interfaces.
- Removed inactive Help menu from CSV Import Browser. Seriously!
- Renamed some INI keys: otheroptions/book_date_format -> otheroptions/date_format. Please review Other Options -> Items.
- Replaced QString(tr()) with tr().
- Restore a normal cursor if qmain is not available in biblioteq_otheroptions::prepareShortcuts(). Very awful and very unlikely.
- Scroll to the bottom of the list and table widgets whenever new entries are created in the Database Enumerations Browser.
- This is a happy release in a world of calamity.

March 25, 2024.

- A style of Breeze is the preferred style of biblioteq.sh.
- Animated confirmations:
  - Copies Browser
  - Custom Query
  - Other Options
- Block signals in biblioteq_misc_functions::sortCombinationBox() before modifying the contents of the combination box widget.
- Completed system icons for items.
- DVDs, photograph collections, video games and global fonts.
- Enumerator classes here and there.
- Improved text search in documentation class.
- Let's consider active confirmations. Many, if not all, of the interactions with BiblioteQ result in negative or positive confirmations. A negative confirmation results in an error dialog and / or a log entry. Now, a negative result will also be in the form of an animated push button. Similarly, a positive result will be in the form of an animated push button. An animated widget is a widget which provides an animated background color such as crimson or red, or some variation.
- New notes database fields.
- Notes are now available in copy editors.
- PostgreSQL 15.6.1 for Windows.
- Replaced BIBLIOTEQ_CONFIGFILE with BIBLIOTEQ_CONFIGURATION_FILE.
- Sort item types in Database Enumerations combination boxes.
- Sort strings of combination boxes in copy editors.

February 29, 2024.

- A source-only release during an elongated February on a lunatic planet.
- Added missing period in release notes.
- Animated negative and positive indicators on some panels. GitHub ticket #348.
- Beautified the source. Please discover errors.
- Center Member-Create / Member-Modify panel with respect to its parent.
- Corrected embedded searches. Problems caused by favorites.
- Enumerator classes here and there.
- New --special-executable-icon. GitHub ticket #347.
- New Other Options -> Display -> Icon Set. System icons may not be available everywhere. Incomplete.
- PowerPC may require future tweaks because of legacy Qt.
- Removed Document Changes section from BiblioteQ.odt.
- Removed redundant clear() instances.
- Replaced QString(tr()) with tr(). Incomplete.
- Replaced SHA1 with SHA3-512. New data only.
- Resize photograph panel at about 95% of parent's size.
- Sprinkled icons.
- This release is dedicated to the linguistic Mr. D. See you.
- Uniform widget widths, here and there.

December 30, 2023.

- Added BnF Z39.50 target to biblioteq.conf.
- Added new labels describing on-top window behavior to relevant windows.
- Bundle French documentation files into the executables.
- Completed Database Enumerations defaults: Grey Literature, Languages, Locations, Monetary Units, Video Games. Favorites are also prepared for new items and searches. GitHub ticket #308.
- Corrected resetting of Monetary Units for the General Search. The contents of the combination box are purged if the Reset button is activated. Reviewed all other item searches.
- Display Notes in photograph view.
- Final LTS release of 2023. See you!
- First PiOS 64-bit release!
- Improved retrieval of publication dates from Z39.50 queries. Completed for books and magazines. GitHub ticket #343.
- LTS release! Release includes a bunch of bunched bunches covering numerous operating systems: Android 10, Debian PowerPC, Kubuntu 22.04, Raspbian 12, MacOS 13, Windows 11.
- New Magic Unix scripts. Please inspect the Scripts directory.
- New 214 processing for books and Z39.50 queries. GitHub ticket #343.
- PiOS-64 now requires Qt 6 and version 12.
- PostgreSQL 15.5.1; Windows.
- Qt 6.5.3 LTS on Android.
- Qt 6.5.3 LTS on MacOS.
- Qt 6.5.3 LTS on Windows.
- Query history. Please see Tools. Query strings may be incomplete and therefore some may not be executable. GitHub ticket #340.
- Read-only item-specific photograph fields.
- Release files: Android 10 32-bit, Android 10 64-bit, Debian PowerPC, MacOS 13, Kubuntu 22.04, Raspbian 32-bit, Raspbian 64-bit, Windows 11. Eight bundles!
- Removed obsolete QAction objects.
- Removed organization domain biblioteq.sourceforge.net.
- Set Alternate Identifier and URL to portions of the 003 field after a Z39.50 Unimarc query if Alternate Identifier is empty. GitHub discussion #339.

October 08, 2023.

- Intelligent Batch Activities completer model. Fewer resources. GitHub ticket #331.

October 05, 2023.

- Added Next (Ctrl + Right) and Previous (Ctrl + Left) shortcuts to various interfaces.
- Added a completer to Member ID in Batch Activities. GitHub ticket #331.
- Adjust a view's scene rectangle according to the scene's contents.
- Allow multiple books to be created.
- Clean Discovered Name in Batch Activities Browser on reset. GitHub ticket #330.
- Deprecated Qt 5 LTS for Android, MacOS, and Windows.
- ISBN-13 is now the default focus widget for books.
- MacOS release will be built with Qt 6.5 LTS.
- Reset the main view's rectangle upon a database disconnect.

September 15, 2023.

- Added Next (Ctrl + Right) and Previous (Ctrl + Left) shortcuts to photograph views.
- Added shortcut tool tips to Other Options -> Shortcuts.
- Administrator Browser: document Batch Activities Browser.
- Align graphic views. These are views containing images.
- Android and Qt 6.5.2 LTS.
- Corrected book import: missing target_audience field in Template 2.
- Corrected page selection in photograph views.
- Corrected required field highlights of book item: alternate_id_1, volume.
- Corrected scene sizes in photograph views.
- Database Enumerations defaults: DVDs. Favorites are prepared for new DVDs and searches. GitHub ticket #308.
- Display a patron's name in the Batch Activities Browser's Borrow panel after editing of the Member ID field has finished.
- Future Windows releases will feature x86-64. PostgreSQL version 10 is the last supported x86 release. Please read https://www.postgresql.org/download/windows.
- Improved version reporting of obsolete software.
- Include image quantities in photograph collections.
- New Filter order in Members Browser. GitHub discussion #316.
- New book fields: date_of_reform, origin, purchase_date. GitHub ticket #260.
- Populate target_audiences during an import. GitHub ticket #317.
- Process pending events shortly after show() is issued on the main window. This will allow child windows, which may be shown during the preparation process, to be centered correctly.
- Scroll to Reservations Minimum Days section via Members Browser.
- Sort table fields in Custom Query.
- Sortable Read Status table column. GitHub ticket #321.

July 20, 2023.

- Database Enumerations defaults: CDs. Favorites are prepared for new CDs and searches. GitHub ticket #308.

July 15, 2023.

- Database Enumerations defaults: books. Favorites are prepared for new books and searches. GitHub ticket #308.
- Linux-like distributions: replaced /usr/local with /opt. GitHub ticket #310.
- New Tools -> External Applications. GitHub ticket #278.
- Remove INI key custom_query_favorite after the relevant favorite is deleted via the interface.

June 6, 2023.

- Adapt to incomplete custom queries and reservation processes.
- Added SQLite table trigger item_borrower_trigger.
- Added volume_number field to book category. GitHub ticket #227.
- Allow pasting of images into Back and Front cover image containers. GitHub ticket #284.
- Allow resetting of highlight colors: Other Options -> Custom Query.
- Android and Qt 6.2 LTS.
- Archived release notes.
- Avoid creating expensive program objects if they are not necessary: Members Browser -> Print Selected Member's Reserved Items.
- Batch returns. GitHub ticket #280.
- Book import template 2 was missing alternate_id_1.
- Center PDF progress dialogs.
- Copy Browser did not contain the correct number of reserved non-book items. The process was incomplete. Completed!
- Corrected Custom Query syntax colors table sorting.
- Corrected printing of books.
- Custom query favorite and shortcut. See also Other Options -> Shortcuts. GitHub ticket #279.
- Display a gentle and persistent reminder in the status bar if a new version of BiblioteQ is available.
- Display brief summaries in favorite actions.
- Enable clear button for many text fields.
- Enable sorting for table widgets in Other Options.
- Final Windows x86 packaged release. Future Windows releases will include Qt 6 LTS and Windows x86-64.
- For new installations, the following options will be enabled: Populate Administrator Browser On Display, Populate Database Enumerations Browser On Display, and Populate Members Browser On Display.
- Include target audience in book view. GitHub ticket #294.
- Infinite intelligent Custom Query windows.
- LTS release! Several accumulated bundles included.
- Native dialogs and menus. File dialogs remain non-native.
- New Year's End convenience widget in patron information. GitHub ticket #297.
- On-top Member's Reservation History window. GitHub discussion #248.
- On-top Members Browser window. GitHub discussion #248.
- Optional member reservation history for SQLite databases.
- PostgreSQL and compression. See SQL/postgresql_update_schema.sql.
- Qt 5.15.9 for MacOS. Some releases do not include this item in their release notes but will in the future.
- Qt 6.5 LTS compliant.
- Removed SQL keywords for highlighting: INSERT INTO, INSERT INTO SELECT, and SELECT INTO.
- Replaced error() with errorOccurred() in Qt 5.15 and newer for QNetworkReply.
- Reset post-query highlight colors for books, journals, and magazines as necessary.
- SQLite upgrade tool: all or recent. Please see Tools menu. Always create a copy of the SQLite file before upgrading!
- Set highlights of Custom Query text immediately after colors are configured and saved.
- Unlimited queries for PostgreSQL. Please be careful!
- YAZ 5.34; W32.

March 15, 2023.

- C++17.
- Initialize visible Members Browser columns.
- Some containers may be intentionally empty. Added label reminders.

March 10, 2023.

- Options -> Select Global Font is now available on MacOS.
- Visible Members Browser columns: Other Options -> Members -> Visible Columns. GitHub ticket #246.

March 3, 2023.

- Initialize Other Options -> Items -> Item Fields. GitHub ticket #276.
- New biblioteq-darkmode.bat Windows file.

February 25, 2023.

- Improved processing of duplicate cover images. Decreased memory consumption.
- Improved recording of SQL syntax colors. Example INI value: keyword=color. Existing values will not be ported. Apologies!
- Intelligent woody trees.
- Preserve boldness of fonts, if possible.
- Remove trailing semicolons from custom-query search strings. The semicolons produce errors in SQLite.
- Reviewed all UNION statements. Replaced UNION with UNION ALL. Separate sets do not require pruning.
- Show query completion time in the main window's status bar. Not all queries are measured.
- Validate Reservations Minimum Days integer input in Database Enumerations Browser.

February 20, 2023.

- Added find function for and to the main table.
- Custom Query SQL language highlights. GitHub ticket #246.
- New Custom Query Other Options panel. GitHub ticket #246.

January 25, 2023.

- Ability to export member history as a CSV file. GitHub discussion #274.

January 16, 2023.

- Allow renaming of Custom Query favorites. GitHub discussion #255.
- Batch Activities Browser: do not display a file dialog if an export would be empty.
- Book SRU query results: set Alternate Identifier to control field 003's ark value if Alternate Identifier is empty. GitHub discussion #268.
- CSV Import Browser: empty ISBN-10 and ISBN-13 substitutions. Values may be prepared manually.
- Completed GitHub ticket #228. Allow UPDATE queries on selected items.
- Custom queries executed via the Custom Query menu will be executed through the same logic as the Custom Query browser.
- Do not convert ISBN-13 to ISBN-10 unless the prefix is 978 (biblioteq_misc_functions::isbn13to10()). GitHub ticket #269.
- Do not disconnect the current database if a future database does not have a database driver.
- Happy New Year!
- Item field colors. New options in Other Options. GitHub ticket #272.
- Publication Date Formats are now open. Correct formats are expected. See Other Options. GitHub ticket #270.
- Replaced all instances of MM/dd/yyyy with biblioteq::s_databaseDateFormat. GitHub ticket #270.
- Show a warning label if the selected database's driver does not exist in Branch Selection.
- Some operators believe that BiblioteQ should correct their malformed data regardless of the effort, interest, and time. Modified the import mechanism such that it attempts to correct publication dates. GitHub ticket #270.
- Source-only release! Preparing release files requires a significant effort and an interest. Requests for release files will be ignored! Apologies. The tar bundle for Linux is created in Ubuntu 20.04.

December 25, 2022.

- Added book_target_audiences to Custom Query tree widget.
- Added book_target_audiences to Merge SQLite Databases.
- Added member_history_dnt to Custom Query tree widget.
- Allow null ISBN book searches.
- Audio and Batch Activities Browser. Multimedia system required.
- Avoid searching of duplicate items in Batch Activities Browser.
- Bottom-scroll-on-add added to Batch Activities Browser. Setting is ephemeral.
- Close and reset the Merge SQLite Databases window upon a database disconnect.
- Completed Qt 6.2 LTS regular expressions. Some glitches may remain.
- Corrected discovery of grey literature items in the Batch Activities Browser. Problem caused by referencing incorrect database field.
- Corrected grey literature searches. The query was missing fields.
- Corrected magazine searches. The query was missing a space character.
- Corrected queries which include single quotes for SQLite and PostgreSQL.
- Corrected section scrolling order in Database Enumerations Browser.
- Custom queries and favorites. Please see Custom Query and View menu.
- Do not include empty myoid information in the Merge SQLite Databases utility during error reporting.
- Export missing items function in Batch Activities Browser's Discover panel.
- Hyperlinks for SQLite. Please activate a link by pressing and holding the Alt key while clicking on the link. Also functional on editable PostgreSQL entries.
- Ignore empty scanned input in Batch Activities Browser.
- Improved error reporting of biblioteq_misc_functions::getNextCopy().
- Include item title in the Discover portion of the Batch Activities Browser.
- New database tables book_conditions, book_originality. Please upgrade the databases. Static values have been removed from relevant widgets.
- Removed Poppler (PDF), PostgreSQL, and YAZ from MacOS.
- Removed SQLite libraries and source. Qt provides sufficient SQLite services.
- Removed duplicate tool tips from Other Options.
- Reset numerous panels after a database is closed.
- Revised text on numerous menu items.
- Save tear-off menus setting only if Automatically Save Settings On Exit is active or the settings are explicitly saved.
- This will be the final package release. Future releases will include source only. Good luck!
- Woody tree widgets. Collapse / expand trees.

January 1, 2002.

- BiblioteQ is born!