Release Notes

April, 2023.

- Custom query favorite and shortcut. See also Other Options -> Shortcuts. GitHub ticket #279.
- For new installations, the following options will be enabled: Populate Administrator Browser On Display, Populate Database Enumerations Browser On Display, Populate Members Browser On Display.
- Removed SQL keywords for highlighting: INSERT INTO, INSERT INTO SELECT, SELECT INTO.

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 Mac.
- 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.

January 16, 2023.

- Allow renaming of Custom Query favorites. GitHub discussion.
- 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.
- 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 instaces 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.

November 25, 2022.

- Batch Activities categories.
- Batch Activities discovery.
- Maximum reserved books. Limits are now enforced.
- Optional tear-off menus.
- PostgreSQL 10.23; Windows.
- PostgreSQL files require book_target_audiences permissions.
- Qt 5.15.2; Windows.
- Qt 5.15.7; Mac.
- Remove hyphens from multi-volume ISBN in book search.
- Removed vertical headers from many table widgets.
- SQLite 3.40; Windows.

September 15, 2022.

- As requested, display the Alternate Identifier for books category.
- Corrected book import and copy generation.
- Corrected order of widgets in Database Enumerations Browser.
- Import locale-specific prices. Thank you meteos77.
- Per request, Batch Activities Browser.
- PostgreSQL 10.22.1; Windows.
- Qt 5.15.5 LTS; Mac.
- Report failures of biblioteq_misc_functions::getOID().
- SQLite 3.39.3; Android and Windows.
- Scroll-to-section for Database Enumerations Browser.
- Sort some combination box entries.
- Standard optimization (O2).
- YAZ 5.31.1; Windows.

May 30, 2022.

- Added alternate_id_1, description, and multivolume_set_isbn fields to all-fields book import.
- Adding living application links.
- Basic search (main window) is now exact, per request. The wildcard character is %.
- Book imports will now create copies upon discovering duplicate ISBNs.
- Check ISBNs checkbox widget if either ISBN is available; book panel.
- Corrected export-as-PNG function. A scene's render() function must be provided the scene's bounding rectangle. Thank you meteos77 for the report.
- Corrected next and previous actions of photograph collections. Problem caused by type() override.
- Corrected photograph Qt signals.
- Improved detection of book binding types for MARC queries.
- Include multi-volume ISBNs in book prints.
- New book target audience field. Please upgrade your databases.
- Other book image retrieval.
- PostgreSQL 10.20.2; Windows.
- Qt 6.2 LTS is more complete!
- Remove ampersands from color buttons. Ampersands may be added by environments to denote mnemonics.
- Removed UNIQUE constraint from multivolume_set_isbn. See March 30, 2022 release notes for SQLite.
- SQLite 3.38.5; Android and Windows.

March 30, 2022.

- Copy contents of book_sequence and sequence tables during Merge SQLite Databases.
- Display a warning if the current database schema is not current.
- French release notes. Thank you meteos77.
- Limit Files Per Page (Files Browser) and Members Per Page (Members Browser) to 2500.
- Limit copies to 1000.
- New multivolume_set_isbn database field. For SQLite databases, the field cannot be added with a UNIQUE constraint per https://www.sqlite.org/lang_altertable.html. Consider merging the existing database with a newly-created database. See https://github.com/textbrowser/biblioteq/discussions/191.

1. Create a new SQLite database: File -> New SQLite Database.
2. Open Merge SQLite Databases: Tools -> Merge SQLite Databases.
3. Press Add Row.
4. Select the legacy SQLite database file.
5. Press the Merge button.

- PostgreSQL 10.20.1; Windows.
- Qt 6.2.4 LTS for Android.
- Retain SQLite upgrade statements of previous release (2022.02.30) only. All other statements have been archived in the source.
- Revised BiblioteQ.odt: new information, new sections, replaced images, spelling corrections.
- SQLite 3.38.2; Android and Windows.

February 30, 2022.

- Generate e-mail patron reminders.
- New Mokka information. Thank you tamascz.
- New alternate_id_1 and membership_fees database fields. Please upgrade database schemas. For SQLite, open the desired database and proceed to Tools -> Upgrade SQLite Schema.
- Open Library queries via alternate identifiers.
- Overdue Fees in Members Browser.
- Sort basic search (main window) results by titles. Thank you tamascz.

January 30, 2022.

- BiblioteQ @ 20! Happy New Year!
- Configurable YAZ options.
- Corrected case-insensitive searches. Thank you meteos77.
- Corrected revisions of the main view via item details; persistent indices.
- Database Enumerations (binding types, languages, locations, monetary units) are now included in the book import.
- Disable the Reserve Selected Item context menu action if the current item is a photograph.
- Display import preview header strings in the import template table. For example, the preview tabler's column 1 text may be set to "Title" and the item at (0, 1) in the template table will have its text also set to "Title". Thank you meteos77.
- Display optimizations of large content.
- Do not disable database-connection widgets if a connection is already present.
- Enable case-sensitive-like for general SQLite searches.
- Export Icons View as PNG.
- Group returns of selected items via the All Reserved category.
- ISBN display format options. Please see Other Options.
- Initialize empty barcodes in copy editors.
- Members Browser pagination.
- New Other Options for setting the number of Icons Mode columns.
- New import template. Thank you meteos77.
- New open-postgresql-database terminal option.
- Print Icons View.
- Remove hyphens from ISBN fields within conditionals.
- SQLite 3.37.2; Android and Windows.
- Simplify text before displaying it in the main table and associated tool tips. Thank you meteos77.

December 15, 2021.

- Accession Number query; available from the main window.
- Allow for the SQL delete statement to be issued for custom queries.
- Automatically convert ISBN-10 to ISBN-13 during imports.
- Column-configuration option will be disabled for custom queries as the queries describe the desired columns.
- Corrected book read-status and custom queries for SQLite.
- Corrected column-configuration menu. Thank you meteos77.
- Corrected generation of CSV files from custom queries. Thank you meteos77.
- Corrected translations. New translation files.
- Embedded documentation and release notes.
- Inspect the font created from the global_font setting. If the font cannot be recreated, assign a default font.
- Introduced the timeout option for YAZ. The actual timeout varies.
- More complete lists of available database tables in Custom Query.
- New open-sqlite-database terminal option.
- Optional main window images and progress dialogs. Please see Other Options.
- Patron export and import.
- PostgreSQL 10.19; Windows.
- Qt 5.12.12 LTS; Windows.
- Qt 6.2 LTS. One item remaining.
- Restore and retain Members Browser's geometry.
- SQLite 3.37; Android and Windows.
- SQLite database merge.
- Speedy reservations. New option in Members Browser.

October 30, 2021.

- Android release! SQLite only.
- Avoid duplicate signals in Branch Selection.
- Corrected setting of book images with respect to the read-only column.
- Embedded translation files.
- Maximum reserved books. Please upgrade the database schemas. Limits are not enforced.
- New Total Reserved column in Members Browser.
- PostgreSQL 10.18.2, Windows.
- Qt 6.2 LTS. Incomplete.
- Removed e-mail validation. Qt 6.2 LTS.
- Sample SQLite database. Thank you sunyuyangg555.
- Spanish translation. Thank you caalma.
- YAZ is now optional.

September 10, 2021.

- New column added to the CSV Import browser.
- New column added to the main table denoting read status. SQLite only.
- PostgreSQL 10.18, Windows.

August 8, 2021.

- Availability colors. Please see Other Options.
- C++ 2011.
- Read-status for books. SQLite only.
- SQLite 3.36, Windows.

June 12, 2021.

- Corrected copy-editor browser caused by incorrect C++ protected method. Thank you tamascz.
- PostgreSQL 10.17 for Windows.
- Qt 5.12.11 for Windows.

May 15, 2021.

- Details: https://github.com/textbrowser/biblioteq/compare/2021.04/10...master.
- Grey Literature reservations. Please upgrade your database schemas.
- PostgreSQL 10.16 for Windows.
- SQLite 3.35.5 for Windows.
- YAZ 5.31 for Windows.

April 10, 2021.

- Configurable sort algorithm for book accession numbers. See Other Options.
- High DPI support.
- New URL field for book items. Please update your database schemas.
- Optional item images. See Other Options.
- Portuguese translation. Thank you a12554.
- PostgreSQL 9.6.21; Windows.
- SQLite 3.35.04; Windows.

February 12, 2021.

- Copies management enhancements. Please report errors.
- Corrected UTF-8 conversions of Open Library data. Thank you jferby.
- New Polish translation. Thank you jerzyPL.
- Poppler has been removed from the Windows build as it's outdated. Will be replacing the library with QtPDF.

February 2, 2021.

- Happy New Year!
- Continued parameterizing SQL search queries.
- Corrected Qt 5.15 warnings.
- New Files Browser.
- New enumerators; internal objects. Please report all errors.
- New status database fields. Please update your databases!
- Purge SQLite database entries upon removal of parent entries.
- Qt 5.12.10 on Windows.
- Qt 5.15.2 on OS X.
- SQLite 3.34.1.

September 9, 2020.

- Allow opening of multiple PDF files.
- Hid the Delete button in Copy Browser. The widget is not necessary and neither is its function. The number of copies is controlled by the parent window.
- New book layout, per request.
- New mechanisms for parsing MARC tags for books, journals, magazines.
- OpenBSD corrections.
- PostgreSQL 9.6.19 for W32.
- Synchronize current page with page index in PDF reader.
- Various text hints.

July 25, 2020.

- C++2011.
- Colorful messages in SQLite upgrade process.
- Corrected SQLite upgrade statements. Thank you tamascz.

July 11, 2020.

- Corrected Database Enumerations furnishing. Thank you jerzyPL.
- Corrected main table tool tips with respect to binary data. Thank you jerzyPL.
- Introduced various shortcuts.

July 4, 2020.

- Access main window items via the Enter key.
- Allow proxies for Open Library image downloads.
- Allow proxies for SRU queries.
- Borrowers forward-only SQL queries.
- Child PDF windows will be bound to the main window.
- Container optimizations: isEmpty() versus size() > 0.
- Corrected removal of selected rows in import mechanism.
- Dates in the main table will be displayed according to formats in Other Options. For general categories, for example All, dates will be displayed using the ISO-8601 format. Thank you jerzyPL.
- Deprecated Qt 4.8.7 support.
- Display conversion error dialog if a 13-digit ISBN is not prefixed by 978 or 979.
- Main window print preview.
- New Library of Congress SRU server. Please update biblioteq.conf!
- New context menus now available on various widgets.
- New reservation history print layout.
- Open Library queries.
- PDF print preview.
- Per request, automatically increment book accession numbers.
- Photographs image rotations.
- Polish translation. Thank you jerzyPL.
- PostgreSQL 9.6.18 on Windows.
- Private member histories for PostgreSQL >= 9.5.
- Qt 5.12.9 on Windows.
- Redesigned several PostgreSQL triggers, linking items with their reservation information.
- Relaxed ISSN validation. Thank you robindegen.
- Removed item_borrower_vw database view. Please update PostgreSQL and SQLite databases.
- Removed std::nothrow.
- Reservation history print preview.
- Row-level item_borrower and item_request security policies for PostgreSQL >= 9.5.
- SQLite 3.32.3 on Windows.
- SSL / TLS for Amazon image retrieval. Ignore SSL / TLS errors on image retrieval.
- Vacuum database tool.
- YAZ 5.30.3 on Windows.

January 1, 2020.

- Container optimization; replaced first().
- Debian ARM Qt 5 package. Native build.
- Fifteen splendid years of BiblioteQ!
- Happy New Year!
- Importing of books from CSV files is now supported. BiblioteQ mapping template included.
- OS/2 Qt 5 support.
- Optional e-mail validation.
- PostgreSQL 9.6.16 on Windows.
- Qt 5.9.9 on Windows.
- SQLite 3.30.1 on Windows.

October 10, 2019.

- Best Fit photograph view option.
- Forward-only database queries, where appropriate.
- New contact information in Members Browser.
- Process interface events. Smooth.
- SQLite 3.30 on W32.
- Trim database string values during processing.

September 9, 2019.

- Allow exporting of Members Browser's visible items as CSV.
- Corrected Viewable Columns. Thank you sidheban.
- Corrected removal of photographs via context menus; abnormal termination.
- Denote SQLite database usernames as SQLITE where applicable.
- Disabled hyperlink searches on SQLite. Editable text-edit fields do not support interactive hyperlinks.
- Display Call Number for All Overdue, All Requested, and All Reserved categories.
- Display database role in main window's title.
- Drop extensions in postgresql_destroy_schema.sql.
- Full screen mode.
- Intuitive radio button appearance.
- Larger image previews in main window's table.
- Patron contact information now available in All Overdue, All Requested, and All Reserved categories.
- PostgreSQL 9.6.15 on W32.
- Qt 5.13.0 on OS X.
- Removed C++ singleton.
- SQLite 3.29 on W32.
- Source format changes.
- Update item image in main table upon image change.

June 6, 2019.

- Grey Literature Publication Date Format correction provided by coldacid.
- Modified expected location of biblioteq.conf on Windows. Thank you coldacid.
- Open Library cover images.
- Parameter-based search queries. SQL injections.
- PostgreSQL 9.6.13 on W32.
- Qt 5.9.8 on W32.
- SQLite 3.28 on W32.

March 15, 2019.

- Elegant Mac menus.
- Happy New Year!
- New Other Options setting. If enabled, pretty tool tips will be displayed on the main table.
- PostgreSQL 9.6.12 on W32.
- Qt 5.12.1 on OS X.
- Removed Qt::WA_MacMetalStyle.
- Retain General Search widget states after a query.
- Russian translation from Viacheslav Ptsarev. Thank you!
- SQLite 3.27.2 on W32.
- The Debian package was created on Kubuntu 18.10. The YAZ5 library is expected.

December 12, 2018.

- Case-insensitive LIKE operations. Thank you ozgurcan.
- Corrected location of the Translations directory on Mac. Thank you Marty.
- Corrected mainwindow_canvas_backgound_color setting. Should be mainwindow_canvas_background_color.
- Corrected parsing of sub-fields within XML. Some fields must be discarded. Thank you sit42.
- Optional unaccent() for PostgreSQL. Thank you ozgurcan.
- Prevent abnormal termination during image download. Thank you sit42.
- Qt 9.6.7 on W32.
- Spelling corrections.
- The automatic-save setting is now enabled for new installations.

October 1, 2018.

- Allow reloading of items in the Custom Query dialog.
- Close SQLite Upgrade Schema results dialog on Close click.
- Control + S and Control + W shortcuts. Thank you wohali.
- Corrected less-than operator implementations in derived table items. Current software assumes that cell values are static.
- PQ at version 9.6.10 on W32.
- SQLite at version 3.25.2 on W32.
- Support ISBN 979 prefix. Thank you Safranil.

July 4, 2018.

- Enable sorting of the main table after grey literature file counts and photograph counts are acquired.
- New Greek Z39.50 target. Please see biblioteq.conf.
- Qt 5.9.6 on W32.
- Qt 5.11.1 on OS X.
- Removed forward-only database queries as some cause problems with PQ and Qt 5.11.
- SQLite 3.24.0 on W32.
- Set the default application icon.
- Unique Qt signal connections.
- YAZ 5.25.0 on W32.

May 5, 2018.

- Allow cancellation of SRU queries.
- Allow searching of PDF files.
- Allow sorting of files by file sizes in books, journals, and magazines.
- Alpha 21264 processor support.
- Avoid logging duplicate and unique errors on INSERT to member_history_dnt.
- Corrected Database Enumerations Browser tool tips.
- Corrected member ALTER statement for SQLite upgrade process.
- Correctly parent progress dialogs.
- Correctly remove photograph item windows upon deletion of corresponding database entries.
- Correctly retain the Category setting during a BiblioteQ session regardless of database connectivity.
- Debian AMD64 package built using Qt 5.5.1.
- Debian PowerPC package with Qt 4.8.x.
- Depict read-only widgets in various item windows. The current implementation is incomplete.
- Destroy phantom objects. These objects are created if item-retrieval methods fail.
- Disable the MIT-SHM extension on X11.
- Do not discard the Custom Query window after a query is executed.
- Embedded item icons in the main table.
- Inspect potential zero pointers.
- Launch PDF viewers via double-click events for books, journals, and magazines. Poppler required.
- Maintain field values after a general search has completed.
- Multiple-word generic searches.
- Native menu bar widgets.
- New SQLite upgrade message dialog.
- New date formats in Other Options. Thanks coldacid.
- New user document.
- OpenBSD support.
- Properly delete photograph scene items after their corresponding database representations are correctly deleted. The incorrect logic causes abnormal termination.
- Purge scene items whenever item images are replaced. Otherwise, phantom memory objects remain.
- Raspbian armhf package with Qt 4.8.7.
- Replaced static SRU and Z39.50 query dialogs with dynamic instances.
- Replaced the PDF reader's View contents with a list of scale factors.
- Report SRU network errors.
- Reset Case-Insensitive state on Reset activation.
- SQLite at version 3.23.0 on Win32.
- Some widgets should be hidden in various item-search windows. For example, Files.
- Sparc64 support.
- Support for grey literature. PostgreSQL administrators, please update your database schema(s) via postgresql_update_schema.sql.
- The OS X release is generated with Qt 5.10.1 on OS X 10.12.6. Support for previous OS X versions is unknown.
- Upgraded Qt products to version 5.9.5 on Win32.
- Upgraded PostgreSQL products to version 9.6.8 on Win32.
- YAZ at version 5.23.1 on Win32.

August 19, 2017.

- Corrected visibility of password dialogs on SQLite databases. Such dialogs should be not be accessible. Thank you Fares Othman.
- Optional dates in various searches.
- Qt products upgraded to version 5.9.1 on Windows.
- Upgraded PostgreSQL products to version 9.6.4 on OS X.
- Upgraded SQLite products to version 3.20.0 on OS X and Windows.
- Upgraded YAZ products to version 5.22.0 on OS X and Windows.

July 4, 2017.

- Context menu for removing photographs.
- New Windows library information. Thank you Leif-W.

May 5, 2017.

- Corrected Arabic language menu item. Thanks to Fares Othman for reporting the problem.
- New Other Option date format: yyyy.
- Purge objects.

April 30, 2017.

- Arabic translation provided by Fares Othman.
- Increased optimization level on all platforms.
- Poppler PDF viewer on W32.
- PostgreSQL products at version 9.6.2 on W32.
- Qt at version 5.8.0 on W32.
- SQLite has been upgraded to version 3.18.0 on W32.
- YAZ products have been upgraded to version 5.20.1 on W32.

January 20, 2017.

- Allow exporting of selected photograph(s).
- Allow pagination after an interrupted query.
- PDF viewer for books, journals, and magazines. Poppler required. Available on FreeBSD and Linux.
- PostgreSQL databases offer query sizes. Modified some progress dialogs.
- Upgraded SQLite to version 3.16.2 on Windows.
- Upgraded YAZ to version 5.20.0 on OS X.

December 16, 2016.

- Version 2016.12.16 is now available.
- Allow sorting of Custom Database Query items.
- Corrected a selection issue with photograph collections. The problem would prevent modifications of selected items in photograph collections.
- Corrected the Music CD search query.
- New accession_number database field. PostgreSQL administrators, please update your database schema(s) via postgresql_update_schema.sql. SQLite users, please see the Upgrade SQLite Schema option off the Tools menu.
- Upgraded Qt to version 5.7.1 on Windows.

December 6, 2016.

- New version is ready! Version 2016.12.06.
- Corrected documentation.
- New Other Options. Please see the Options menu.
- Upgraded SQLite to version 3.15.2 on OS X and Windows.
- Windows XP users, please consider installing the bundled vc_redist.x86.exe file.

November 5, 2016.

- Version 2016.11.05 is ready!
- Allow reloading of biblioteq.conf via Options.
- Corrected a grant statement in postgresql_create_schema.sql with respect to grey_literature_myoid_seq. PostgreSQL administrators, please read postgresql_update_schema.sql.
- Corrected member query. Problem caused by translation-based logic. Thanks to Jeepee for the report.
- Corrected the sole INSERT statement in postgresql_create_schema.sql. Explicitly mention column names. Thanks to Arti for reporting the problem.
- If you're having Z39.50 problems on Windows, please remove the Windows registry My Computer\HKEY_CURRENT_USER\Software\BiblioteQ via regedit.
- Modified postgresql_destroy_schema.sql so that it produces a single notice during an ideal execution.
- Replaced CREATEUSER with CREATEROLE in postgresql_create_schema.sql. PostgreSQL 9.6 has deprecated CREATEUSER. Please see https://www.postgresql.org/docs/9.6/static/release-9-6.html. Thanks to Arti for the report.
- SQLite at version 3.15.1 on OS X and Windows.
- Upgraded YAZ products to version 5.18.0 on OS X and version 5.17.0 on Windows.
- Verify accessibility of SQLite files.

September 4, 2016.

- Version 2016.09.04 is available.
- Disallow cancellation of Z39.50 queries.
- EXISTS() instead of COUNT(), where applicable.
- Upgraded Qt products to version 5.7.0 on Windows.
- Upgraded SQLite products to version 3.14.1 on Windows.

July 4, 2016.

- Version 2016.07.04 is available.
- Corrected overdue fees reminder.
- Decreased biblioteq_guest permissions on item_borrower_vw. Please see postgresql_update_schema.sql.
- Ellipses.
- Introduced connection_options in biblioteq.conf.
- Introduced file attachments for books, journals, and magazines. PostgreSQL administrators should execute the latest statements in postgresql_update_schema.sql.
- New option for unlimited photographs per page.
- Per birch, print book inside-cover labels. Please see https://sourceforge.net/p/biblioteq/feature-requests/48.
- Per paolofrancioso, added a stale-data reminder to Database Enumerations.
- Replaced QHash, QMap [] operator with value(); performance.
- The destructor of biblioteq_magazine must be virtual.
- Upgraded Qt to version 5.6.1 on Windows.
- Upgraded SQLite to version 3.13.0 on Windows.

March 15, 2016.

- A new version is available, 2016.03.15.
- More forward-only SQL queries.
- Portable BiblioteQ. Previous user configuration settings will be lost.

March 8, 2016.

- Uploaded a new W32 installer, adding api-ms-win-crt-runtime-l1-1-0.dll. Thank you Bill Burns for reporting the problem.

March 7, 2016.

- Uploaded a new W32 installer, adding vcruntime140.dll. Thank you Lazaros S. for reporting the problem.

March 3, 2016.

- Version 2016.03.03 is available.
- Corrected Language selection. Thanks to Lazaros S. for reporting the problem.
- New option under Options, per Lazaros S.
- Removed duplicate INI directives from the source.
- Upgraded SQLite to version 3.11.1 on Windows.

February 17, 2016.

- Version 2016.02.17 is available.
- Added a feature for updating legacy SQLite BiblioteQ schemas. Please see the Tools menu.
- Added support for the ARM architecture.
- Allow cancellation of Z39.50 queries.
- BiblioteQ should not create artificial copy identifiers.
- Corrected biblioteq_image_drop_site::clear(). The method did not delete the removed graphics items.
- Corrected discovery of database field names of custom query results.
- Corrected incomplete error message for photographs.
- Corrected photograph thumbnails on Qt 5.
- Corrected the FreeBSD Qt project files; clang.
- Corrected the video game search mechanism.
- Improved border styles of selected images.
- Improved widget mnemonics.
- Photograph import mechanism.
- PostgreSQL connections will now require SSL/TLS by default. Please see biblioteq.conf.
- Qt 5.5.1 progress dialog corrections. Please see https://bugreports.qt.io/browse/QTBUG-47042.
- Prepared SQL files for grey literature. Incomplete.
- Prevent execution of empty SQL queries.
- Renamed project files. As this may have introduced glitches, please report discrepancies.
- SQLite databases must support patron histories.
- Upgraded PostgreSQL products to version 9.5.1.1 on Windows.
- Upgraded SQLite products to version 3.10.2 on Windows.
- Upgraded YAZ products to version 5.15.2 on Windows.

October 28, 2015.

- Version 2015.10.28 is available.
- Corrected QProgressDialog problem for Qt 5.5.x.
- Please report errors at https://github.com/textbrowser/biblioteq/issues.
- Upgraded Qt to version 5.5.1 on Windows.

October 16, 2015.

- Version 2015.10.16 is ready.
- Allow item image zoom via double-click.
- Corrected HTTP dialog title.
- Minor correction on the status bar's stylesheet.
- Upgraded Qt products to version 5.5.0 on Windows.
- Upgraded SQLite products to version 3.9.1 on Windows.
- Upgraded YAZ products to version 5.14.10 on Windows.

July 4, 2015.

- Version 2015.07.04 is now available.
- A patron's gender is now optional. PostgreSQL administrators, please update the database schema(s) via postgresql_update_schema.sql.

June 27, 2015.

- Version 2015.06.27 is available.
- Modified the Z39.50 query for books. Only include the OR operator if both the ISBN-10 and ISBN-13 values are provided.

June 10, 2015.

- Version 2015.06.10 is available.
- Additional pointer guards.
- New version system.
- Reset sensitive fields whenever the login dialog is dismissed.
- Upgraded Qt products to version 4.8.7 on OS X and 5.4.2 on Windows.
- Upgraded SQLite to version 3.8.10.2 on Windows.
- Upgraded YAZ products to version 5.13.0 on Windows.
- Use DROP USER IF EXISTS instead of DROP USER. PostgreSQL only.

April 19, 2015.

- Version 10.01 is available.
- Added proxy authentication support to SRU magazine queries.
- All database retrieval queries are now forward-only. Please see https://doc.qt.io/qt-4.8/qsqlquery.html#setForwardOnly.
- Allow usage of QHttp in place of QNetworkAccessManager. Source only.
- Corrected postgresql_destroy_schema.sql.
- Corrected selections of requested items.
- Corrected variable assignment in marc::parseBookZ3950Marc21() with respect to fields 100 and 700.
- Disable general search widgets after a search is performed. Widgets may be enabled via the interface.
- Introduced a basic search that's integrated into the main window.
- Layout changes.
- Moved the category option into the View menu.
- New PostgreSQL guest account! Please see postgresql_update_schema.sql.
- Patrons may now decline reservation histories. Enabled by default.
- Removed biblioteq_patron permissions from biblioteq_membership. PostgreSQL administrators, please see postgresql_update_schema.sql. The biblioteq_membership role must not have access to patron activity.
- Support OS X 10.6.8 and Qt 4.8.6. Thanks to Ceres for reporting the errors.
- Upgraded Qt products to version 5.4.1 on Windows.

January 27, 2015.

- Version 10.00 is now available.
- BiblioteQ celebrates its tenth year!
- Happy New Year!
- Experimental UNIMARC support for the Z39.50 protocol.
- Introduced a case-insensitive general search.
- MARC data for journals and magazines is abbreviated. Corrected.
- Properly delete QNetworkReply objects.
- Updated SQLite libraries to version 3.8.8.1 on Windows.
- Upgraded Qt products to version 5.4.0 on Windows.

December 18, 2014.

- Version 6.74 is available.
- Corrected use of ZOOM_connection_error().
- QSqlRecord::fieldName() may include an alias. For example, the method may return journal.type instead of type. As a result, some queries will result in misrepresented data. Corrected.

December 9, 2014.

- Version 6.73 is now available.
- A new Hungarian translation. Thank you Csanád Baksay.
- Improved recording of Z39.50 errors.
- Prohibit case-sensitive PostgreSQL administrator names. Thank you Nicola.
- Upgraded YAZ products to version 5.7.1 on Windows.

October 13, 2014.

- Version 6.72 is now available.
- All dogs go to Heaven.
- Prevent cancellation of processes that are not interruptible.
- Spelling corrections.
- Upgraded Qt products to version 5.3.2 on Windows.
- Upgraded YAZ products to version 5.4.3 on OS X and 5.4.1 on Windows.

August 9, 2014.

- Version 6.71 is now available.
- Corrected support of optional ISBNs with respect to missing titles in the Copy Browser.
- ISSNs are now optional. PostgreSQL administrators, please see the postgresql_update_schema.sql file.

August 2, 2014.

- Version 6.70 is available.
- Extended the sex field in the member table. PostgreSQL administrators, please see the postgresql_update_schema.sql file. Thanks to Frans.
- Per Frans, removed input masks for telephone numbers and zip codes.
- Remind the user to save their settings after a locale change.
- Upgraded Qt to version 5.3.1 on Windows.
- Upgraded YAZ products to version 5.3.0 on OS X and Windows platforms.

June 6, 2014.

- Version 6.69 has been uploaded.
- After adding a photograph collection, items in the collection should be editable without requiring the collection to be reloaded. Corrected.
- Avoid accessing invalid array items.
- Corrected C++ constructors.
- Created an icons resource file and updated all relevant source. Thanks to Nick for reporting the OS X issue.
- Inspect indexOf() results and results of similar methods.
- Upgraded SQLite libraries to version 3.8.5 on Windows.

May 21, 2014.

- Version 6.68 is available.
- Added support for 64-bit integers to limit and offset SQL clauses.
- Avoid divisions by zero.
- Corrected the OS X Qt 5 project file with respect to a missing Cocoa library.
- Corrected the PostgreSQL loader paths in the OS X bundle.
- Corrected the SRU and Z39.50 mechanisms with respect to books. BiblioteQ should not replace ISBN fields if the fields were completed by the user. Ten-character or thirteen-character ISBNs are considered as user-provided.
- Corrected the scene's parent in qtbook_photographcollection::slotViewPhotograph().
- Corrected use of qgetenv(). The function returns a byte array.
- Corrected widget highlighting with respect to SRU and Z39.50 query results.
- Do not access members of invalid pointers.
- Do not store database credentials information in database objects and display widgets.
- Increased the maximum issue and volume values for journals and magazines.
- Prevent memory mismanagement of qtbook_item objects during the reservation process.
- Properly set parents of action widgets.
- Remind the user of resource limits.
- Respect array boundaries.
- Update photograph objects in qtbook::updateItemWindows().
- Upgraded Qt to version 4.8.6 on OS X.
- Upgraded YAZ products to version 5.1.1 on OS X and Windows platforms.
- Use parameterized SQL statements so as to avoid injection errors. Please note that this item required significant changes. Please report issues.

March 27, 2014.

- Version 6.67 is now available.
- Notify the user if an SQLite database cannot be created.
- Properly bind NULL SQL values in QSqlQuery.
- Removed obsolete variables.
- Resolved two SRU issues. Thanks to SigmaX for reporting the errors.
- Review QDataStream read and write results.
- Review indexOf() results.
- The type field in the locations table should not be null. PostgreSQL users, please update your schema(s) via the postgresql_update_schema.sql file.
- Upgraded Qt products to version 5.2.1 on Windows.
- Upgraded SQLite products to version 3.8.3.1 on Windows.
- Upgraded YAZ products to version 5.0.18 on OS X and Windows.

September 17, 2013.

- Version 6.66 is ready!
- Added condition and originality fields to the book and book_copy_info database tables. UI elements reflect new additions.
- Am in need of a Windows 7 license. Please donate!
- As always, PostgreSQL administrators are urged to update their database schemas. Please see postgresql_update_schema.sql.
- Custom book binding types. Please see the Database Enumerations Browser. Please note that you ought to populate the book_binding_types table so that Book Binding Type combination boxes contain the new data. PostgreSQL: INSERT INTO book_binding_types (binding_type) (SELECT DISTINCT binding_type FROM book).
- Updated Qt products to version 4.8.5 on OS X and version 5.1.1 on Windows.
- Updated YAZ products to version 4.2.66 on OS X and version 4.2.65 on Windows.

June 3, 2013.

- Version 6.65 has been released.
- Added documentation to doc.d/contributors.d. Document provided by Ana Monteiro and Fátima Dias.
- Added foreign key constraints to various SQLite database tables. Unfortunately, the changes will only be seen in new databases.
- Corrected SQLite foreign key flaw. Thanks to Ana Monteiro for reporting the issue. The problem was introduced in version 6.56.
- Updated the SQLite library on Windows to version 3.7.17.

May 27, 2013.

- Version 6.64 is now available.
- Added missing privileges to the biblioteq_librarian role. PostgreSQL administrators, please see postgresql_update_schema.sql.
- Corrected a problem that occurs when a new administrator is defined. The administrator's roles are not properly recorded. Thanks to numibesi for discovering the issue.
- Corrected some deep privileges problems. Again, thanks numibesi.
- Fixed an incorrect comparison related to minimum patron id lengths.
- Updated postgresql_destroy_schema.sql.

April 29, 2013.

- Version 6.63 is now available.
- Added artist and composer fields to the cd_songs table. PostgreSQL administrators are urged to review the postgresql_update_schema.sql file. Please see SourceForge ticket 3598802 for more information.
- Purged SQLite sql files. The file include.d/sqlite_create_schema.h is sufficient.
- Updated YAZ products to version 4.2.54 for OS X and Windows.

April 15, 2013.

- New site!

March 7, 2013.

- Version 6.62 is now available.
- Guard array boundaries.

February 28, 2013.

- Version 6.61 will be released today.
- Because photograph collections may not be reserved by patrons, the reservation process of such items should not raise database exceptions.
- Center a photograph detail view with respect to its parent.
- The database field MYOID is guaranteed to be unique per table. Corrected routines (qtbook::slotDisplaySummary(), qtbook::slotSceneSelectionChanged(), qtbook::updateSceneItem()) that failed to recognize item types in addition to the MYOID values.

February 27, 2013.

- Version 6.60 is now available.
- Added context menus to photograph collection views. Activating the menus will allow users to view individual photographs in greater detail.
- Updated Qt products to version 4.8.4 on OS X.
- Updated YAZ products to version 4.2.50 on OS X and Windows platforms.

January 4, 2013.

- Happy New Year! Version 6.59 is now available. Please report issues at https://sourceforge.net/tracker?group_id=129976.
- Added documents contributed by Olivia Novak. Please see doc.d/contributors.d.
- Added issue and volume numbers to the main window's summary for journals and magazines.
- Corrected C++ object casts.
- Display formats of dates have been changed to ISO 8601.
- Eliminated QGraphicsView warnings regarding drag leave events.
- Fixed the state of the ISBNs checkbox for books.
- Modified much of BiblioteQ in order to avoid problems created by inconsistent translations. Feedback?
- Per Myshkin, the Tab key should change focus for textedit fields.
- Photograph collections!
- PostgreSQL administrators are required to update their schemas. Please see the postgresql_update_schema.sql file.
- Removed ISBN input validators in support of hyphens.
- Replaced the OS X application installer with a simple disk image file.
- SRU support for books, journals, and magazines.
- The Copy Browser did not display the correct item's ID in the title.
- Updated biblioteq.conf in support of QSettings. Please update your configuration files accordingly.

November 19, 2012.

- Version 6.59 will feature support for photograph collections and the SRU protocol.
- The new version is expected to be delivered before 2013.

October 15, 2012.

- A user reported a missing iconv.dll file. Uploaded a new Windows installer to correct the issue. Version remains at 6.58.

October 3, 2012.

- An online version of BiblioteQ has been made available by Clint Bush. The software resides at https://code.google.com/p/biblioteqonline.

August 18, 2012.

- Version 6.58 has been released.
- Added the All Available category option.
- Added the Language sub-menu off of the Options menu.
- Initialize class members.
- Prevent BiblioteQ from scaling null images.
- Updated YAZ products to version 4.2.34 on OS X and Windows platforms.

July 3, 2012.

- Version 6.57 is available for download.
- Added several new PostgreSQL roles in support of various configurations.
- Administrators were unable to modify their passwords.
- Improved book searches. The ISBN fields are considered in queries only if provided.
- The Z39.50 query may return an edition that is not in the expected format. Adjusted the software to support varying formats.
- The biblioteq_patron role was not properly applied to patron accounts.
- Version 6.57 includes changes to the PostgreSQL schema. Please update your schemas.

June 17, 2012.

- Version 6.56 is now available.
- Added Amazon and Z39.50 proxy support.
- Added French documentation and translation files. Please thank J. Cornavin.
- Added grids to various reports.
- Added patron database fields: comments, general_registration_number, and memberclass.
- Applied patches provided by Jason Perry. The Unix install target did not function properly. Sorting by the Call Number was also improved.
- BiblioteQ shall now attempt to use both ISBNs (10, 13) when querying the Z39.50 site. The first discovery concludes the query process.
- Changed the minimum member ID length from seven to five characters.
- Corrected Z39.50 authentication options.
- Corrected empty images in the Icons view.
- Explicitly enable foreign key support for SQLite databases. Please refer to https://sqlite.org/foreignkeys.html#fk_enable.
- Increased Z39.50 msleep() intervals from 10 milliseconds to 100.
- Must remember to purge obsolete objects.
- Thanks to everyone for their support.

May 13, 2012.

- Version 6.55 is now available.
- Happy Mother's Day!
- A critical flaw was discovered by a user. Because of the current PostgreSQL database design, the number of users that may exist is limited. The new approach introduces the roles biblioteq_administrator, biblioteq_circulation, biblioteq_librarian, biblioteq_membership, and biblioteq_patron. Accounts will now be assigned roles. To update your PostgreSQL schema, please execute the following suggestions:

1. Modify your PostgreSQL schema by executing the SQL statements under version 6.55 of the postgresql_schema_update.sql file.
2. Launch BiblioteQ and connect to your PostgreSQL instance. You must connect with the administrator account that you used to create the BiblioteQ database.
3. Open the Administrator Browser and issue a save.
4. Open the Members Browser and perform a batch update of the privileges.

- Corrected uses of QProgressBars. BiblioteQ must avoid assigning values outside of defined ranges.
- Fixed while-loops responsible for parsing Z39.50 data.
- Modified the biblioteq.pro file, changing the location of the biblioteq.conf file to /usr/local/biblioteq.
- Per cbush06, the member_history table's item_id field has been removed. The field was incorrectly populated. It was also redundant. Please update your PostgreSQL schemas.
- Received a donation from an anonymous user. Thank you.
- Received a donation from luismontilla. Thank you.
- Updated Qt products to version 4.8.1 for Windows systems.
- Updated YAZ (Z39.50) products to version 4.2.31 on OS X and Windows systems.
- Whenever an item is updated, its Icons Mode image must also be updated.

March 9, 2012.

- Version 6.54 is now available.
- A Greek user guide has been provided by Dimitris Kanas.
- Added the Add Item sub-menu to the Edit menu.
- Added the Format specifier to biblioteq.conf. This new field will allow users to specify Z39.50 character conversions.
- Added the Total Reserved column to various table views.
- After many years, BiblioteQ will showcase a new icon set.
- BiblioteQ will now use the system's fonts on the OS X platform. Allowing the user to set the fonts may result in distorted widgets.
- Corrected issues with SQLite files. Thanks to yasbean for reporting the problems.
- Fixed some state issues with respect to item duplication. Some buttons (Copies, Reservation Status, Show Tracks) must be initially disabled.
- Generic searches now support item availability.
- Received the first monetary donation. Thank you yasbean.
- The Members Browser will now allow administrators to update privileges for all listed patrons.

January 7, 2012.

- Happy New Year!
- Version 6.53 is now available. Enjoy!
- Added basic support for overdue fees. PostgreSQL users are urged to execute the appropriate section from the postgresql_update_schema.sql file.
- Improved representation of numeric data.
- Introduced the Icons Mode under the View menu. If you notice that the retrieval process is slow, please lower the Entries per Page value. Decreasing image sizes will also help.
- Modified biblioteq.conf so that medium-sized images are retrieved from Amazon.
- Qt products have been upgraded to version 4.8.0 on Windows platforms.
- Replaced turbine with localhost in biblioteq.conf.
- SQLite database files will now have the sqlite extension automatically added.
- The first elementary school in Nea Erythraia, Attica, Greece has selected BiblioteQ.

November 20, 2011.

- Version 6.52 is now available.
- Added support for duplicating entries.
- Allow multiple create windows.
- Improved window sizing.
- Modified queries so that special characters are properly escaped.
- Removed redundant containers.
- Resolved several segmentation faults.
- Ubuntu's Unity interface overrides menu settings. Modified BiblioteQ so that it prevents certain actions.

November 3, 2011.

- Released version 6.51.1.
- Because of international characters, the database searches have been made case-sensitive.

September 29, 2011.

- Version 6.51 is available for download.
- A new keyword field has been added to the various item types. PostgreSQL users are urged to execute the appropriate section from the postgresql_update_schema.sql file.
- Added a Dutch translation per editor3d7.
- BiblioteQ will retain the previously-opened database branch.
- Dates will now be displayed in their native formats. Date data will retain the usual MM/dd/yyyy format.
- Due to corruption, the main table's column widths will not be retained. The feature will return in a future release.
- Faulty search queries have been fixed.
- Fixed incorrect background colors of non-essential fields.
- Fixed issues related to Qt's table-sorting behavior. Problems may only be apparent with Qt 4.6.x. Qt versions 4.6.x are discouraged.
- Improved Z39.50 parsing.
- Multiple Z39.50 results will be enumerated by ISSNs for journals and magazines.
- Qt products have been upgraded to version 4.7.4 on OS X and Windows platforms.
- Removed the Automatically Resize Table to Contents option.
- Some UNION queries lacked ALL keywords.
- Some containers were not cleared after a database disconnect. Fixed.
- Thanks for everyone's participation.
- The ISBN fields are now optional. PostgreSQL users are required to update their schemas.
- The Windows installer will now install a Desktop icon.
- When reserving items, the Copy Browser will now automatically select the next available copy.
- Z39.50 records will now be retrieved in MARC21 format.

August 18, 2011.

- Version 6.50 is now available.
- Added a call to QMainWindow::closeEvent() in qtbook_journal::closeEvent().
- Added various protections against NULL objects.
- Force selection of a Z39.50 site if one is not selected (books, journals, magazines).
- Protect misc_functions::updateSQLiteDatabase() against BiblioteQ version changes.
- Retain the main window's toolbar states.

May 23, 2011.

- Version 6.46 is in the process of being released.
- This version is dedicated to Mr. R.'s father.

May 15, 2011.

- Version 6.46 will be available soon.
- Ability to save the current view as a CSV file.
- Added an install target to biblioteq.pro.
- Added the Unlimited Entries per Page for SQLite databases.
- Patrons will now have expiration dates. Expired members will not be allowed to reserve items. Please note that for SQLite databases, the software should automatically adjust the member table in order to support the new expiration_date field. Please submit a trouble report if you experience problems.
- Qt products have been upgraded to version 4.7.3 on OS X and Windows platforms.
- The main table's states will now be restored and retained.
- Updated the Administrator Guide documents.
- Was incorrectly retrieving the userid from the UI instead of the database object.

March 20, 2011.

- Version 6.45 has been released.
- A Spanish translation has been postponed until a translation becomes available.

March 18, 2011.

- Version 6.45 will be released soon. New features and fixes are listed below.
- All search input will be trimmed.
- Column headers are now retained and restored.
- Greek translation.
- Patrons were unable to connect to PostgreSQL instances due to incorrect error handling.
- Printing from the main window will generate tabular reports.
- Removed the Unlimited Entries per Page option.
- True PostgreSQL and SQLite pagination.

February 25, 2011.

- Released version 6.44.3.
- Fixed book, journal, and magazine search errors.

January 7, 2011.

- Happy New Year!
- Version 6.44.2 is available for download.
- Fixed a fatal flaw with SQLite databases by introducing an artificial sequence. Users must execute the statement under version 6.44.2 of the sqlite_update_schema.sql file from within sqlite3 in order to create the required sequence. Thanks to ResetFlag for reporting the problem.
- Improved the look-and-feel on OS X systems.
- Introduced some thread-safety mechanisms with respect to the Z39.50 query.
- Modified the Database Enumerations Browser by introducing separate transactions. Again, thanks to ResetFlag for reporting the issue.
- Replaced QHttp with QNetworkReply and QNetworkAccessManager.

December 31, 2010.

- Recreated the Windows installer. The new bundle includes a potentially-important manifest file.

December 27, 2010.

- Version 6.44.1 has been released.
- This release fixes an issue regarding QApplication::processEvents() on OS X (10.6.5) and Qt 4.7.1.

December 19, 2010.

- Version 6.44 is now available! Modifications are summarized below.
- A basic Spanish translation will be available in version 6.45.
- Added MARC Tags fields to books, journals, and magazines.
- Amazon information is now defined at runtime if the biblioteq.conf is damaged or missing.
- Compact Disc runtimes are now computed whenever track information is saved.
- Fixed an OID issue regarding journals and magazines on SQLite databases. ISSNs ending with X were impacted.
- Fixed incorrect combination box defaults in various places.
- Improved the parsing of Z39.50 data for books.
- Improved user interface elements.
- Moved most of the configuration lists from biblioteq.conf to database tables. Please update PostgreSQL and SQLite instances via postgresql_update_schema.sql and sqlite_update_schema.sql.
- Qt has been upgraded to version 4.7.1 for OS X and Windows platforms.
- The Custom Query dialog now contains additional data objects.
- The Entries per Page menu has been expanded.

November 14, 2010.

- Version 6.43 has been released.
- Added constness to various methods.
- Combination box values are now in alphabetical order.
- The minimum due days are now configurable via the biblioteq.conf file.

October 29, 2010.

- Version 6.42 is now available.
- Minor fixes.
- New OS X bundle.
- Updated Windows Qt libraries to 4.7.0.

September 5, 2010.

- Recreated BiblioteQ-6.41.pkg.zip for Mac OS X.

April 18, 2010.

- Version 6.41 is ready for immediate use.
- Introduced a mechanism for converting 13-digit ISBNs to 10-digit ISBNs.
- Resolved a potential branch-ordering issue if a misconfigured biblioteq.conf is installed.

April 10, 2010.

- Released version 6.40.
- Displaying connection information.
- Resolved an incorrect window title.

February 20, 2010.

- Version 6.39 is now available.
- Fixed an OS X Font Selection crash.
- New feature: File->New SQLite Database.
- The main window's title now references the currently-opened SQLite database.
- Updated PostgreSQL sections in order to eliminate warnings.

January 10, 2010.

- Version 6.38 is available.
- Added an icon to the Windows executable, per David Bolton.
- In the process of simplifying translation support.
- The Windows version has been upgraded to utilize Qt 4.6.
- The current category is now retained.
- Updated the Administrator Guide document.

October 26, 2009.

- In the process of re-releasing the software bundles.
- Modified documentation files.
- Removed obsolete translation files.

October 23, 2009.

- Version 6.37 is being released.
- Eliminated the paging mechanism for SQLite databases on Windows due to plugin restrictions.
- OS X and Windows versions have been upgraded to use Qt 4.5.3.
- Please update your database schemas by executing the statements under version 6.37 of the postgresql_update_schema.sql and sqlite_update_schema.sql files.
- Simplified book editions.
- Thank you Robert (fmra357) for discovering the SQLite issue on Windows.

October 2, 2009.

- Version 6.36 will be available shortly.
- Fixed an incorrect error dialog.
- Improved the image download mechanism.
- Modified the format in which images are stored. This update eliminates some database warnings.
- New BiblioteQ icon.
- Other miscellaneous improvements.

August 19, 2009.

- Version 6.35 is now available.
- Support for multiple Z39.50 sites.
- Updated biblioteq.conf settings.
- Version 6.22.4 is the final release under the 6.22 branch.

July 13, 2009.

- Versions 6.34 and 6.22.4 are available.
- Additional verification dialogs.
- Fixed the 6.22 OS X installer.
- Improved the progress dialogs.
- Resolved translation issues.

June 12, 2009.

- Versions 6.33 and 6.22.3 will be available shortly.
- Implemented a paging mechanism. This new addition should simplify the navigation of large databases. By default, pages will contain at most 25 entries.
- Miscellaneous improvements.
- New menu. (Options->Entries per Page)

May 2, 2009.

- Versions 6.32 and 6.22.2 are now available.
- New menu. (File->Recent SQLite Files)

April 16, 2009.

- Versions 6.31 and 6.22.1 will be released shortly.
- Fixed an order issue in the postgresql_create_schema.sql file.
- Updated biblioteq.conf. Please modify the [Amazon Front Cover Images] section accordingly and insert the [Amazon Back Cover Images] section.

April 10, 2009.

- Version 6.30 is in the process of being released.
- Discontinued support of OFFSYSTEM.
- Future fixes will also be applied to the 6.22 branch.

April 5, 2009.

- Version 6.22 has been released.
- Minor changes.
- Updated the qt.conf file.

March 21, 2009.

- Version 6.21.1 is now available.
- Updated the documentation.
- Updated the translations.d directory.

March 3, 2009.

- Version 6.21 has been released!
- Added support for Czech and German translations. I'm thankful to those who provided the translation files.
- Additional changes in support of internationalization, including bug fixes.
- Fixed an issue with the Administrator Browser. Also implemented a feature that prevents the creation of administrators without privileges.
- Fixed an issue with the Reservation Browser. Non-privileged accounts were unable to view an item's reservations.

February 23, 2009.

- Version 6.20.2 will be available today.
- Solved several issues regarding the drag-and-drop feature.

February 22, 2009.

- Version 6.20.1 has been released.
- Improved the image drag-and-drop feature.
- Resolved some issues related to translation support.
- The Windows XP release will be available on February 23, 2009.

February 22, 2009.

- Version 6.20 is now available.
- Added icons to various widgets.
- Search date formats have been changed to MM/yyyy.

February 7, 2009.

- Version 6.19 has been released.
- Added the Place of Publication field to Books, Journals, Magazines, and Video Games.
- Fixed several issues regarding embedded hyperlinks.
- Implemented default values for several mandatory fields.
- Please update your database schemas by executing the statements under version 6.19 of the postgresql_update_schema.sql and sqlite_update_schema.sql files.

January 16, 2009.

- Version 6.18 is now available.
- Fixed a size issue with the Book dialog's ISBN-13 textfield.
- Introduced some comments in the various SQL scripts.
- Modified the initial size of the Branch Selection dialog.

January 4, 2009.

- Happy New Year!
- Version 6.17 is available.
- Added an additional uniqueness key to the item_request table. PostgreSQL users are urged to execute the statements under version 6.17 of the postgresql_update_schema.sql file. The new constraint allows patrons to request similar items.
- General improvements.
- Minor redesign of the Branch Selection dialog.
- Resolved a SQLite issue in regards to empty databases and custom queries.
- The software is being prepared for internationalization.

December 7, 2008.

- Released version 6.16.
- Enable certain options only if applicable.
- Improved the Branch Selection dialog.

November 27, 2008.

- Version 6.15 is now available.
- Improved error messages.
- Member IDs may be modified during patron account creation.
- Users must resave preferences data.

November 18, 2008.

- Version 6.14.1 will be released today.
- Added the BiblioteQ icon to the various windows.
- All users are urged to upgrade!
- Existing SQLite databases must be updated. Please execute the commands under version 6.14.1 of the sqlite_update_schema.sql file.
- Fixed a segmentation fault that was introduced by the previous release.
- Fixed an incorrect query in the Item Reservation Status dialog.
- Fixed an incorrect query in the Members Browser.
- Resolved a well-disguised issue regarding the removal of administrator and patron accounts.
- Resolved several critical issues regarding administrator privileges.

November 15, 2008.

- Version 6.14 is available.
- General improvements.
- New options under the Options menu.
- The Administrator Browser now includes details regarding administrator capabilities.

November 13, 2008.

- Version 6.13 is available.
- Resolved an incorrect question dialog associated with unsaved data.
- Standard members do not require access to the admin table. Please "Save" each member's data through the Members Browser.
- The Windows XP installer requires redistribution as it lacks certain PostgreSQL libraries.

October 3, 2008.

- Released version 6.12.2.
- Fixed an issue with the filter pulldown menu.
- The main table is now populated whenever the type filter changes.

October 2, 2008.

- Version 6.12.1 will be released today.
- Fixed menu shortcut discrepancies.
- Updated several icons.

September 30, 2008.

- Version 6.12 is available!
- Added e-mail address information to patron accounts.
- Improved the interfaces for the Z39.50 query and image download.
- Patrons may now cancel their requested items.
- Prices of 0.00 are now supported.
- Resolved minor issues.
- UPC fields now allow 13 digits.
- Updated the icon set.

September 19, 2008.

- Version 6.11 has been released.
- Improved the functionality of the Members Browser.
- The summary panel on the main window now displays the availability of the selected item.

August 29, 2008.

- Released version 6.10.
- Corrected a widget visibility state issue.
- Included with this release is the ROLES document. The document details administrator privileges.

August 27, 2008.

- Version 6.09 is now available.
- Set widget focus when appropriate.
- Updated some informational text.
- Verified that BiblioteQ is functional on Debian Sparc64 and CentOS 5.2.

August 24, 2008.

- Version 6.08 will be available today.
- Potential crashes due to inapropriate use of threads and event handlers have been resolved.
- Prepared the application for downloading back cover images from Amazon. The biblioteq.conf file needs to be properly configured.

August 15, 2008.

- Released version 6.07.
- Downloading of front cover images for books is now supported. Please update biblioteq.conf accordingly. (Images are downloaded from Amazon.)
- Fixed a bug with the misc_functions::grantPrivs() method. This issue was introduced after the journal database table was added. The bug impacts PostgreSQL databases and administrator functions (creation, modification).

June 27, 2008.

- Recreated the OS X Intel package as some users were having connectivity issues with SQLite databases.

June 20, 2008.

- Version 6.06 has been released.
- Improved display of cover images. Images are now scaled to fit their containers.
- Items now possess multiple categories (genres for Video Games). Please update your database schemas.
- Users are now reminded of unsaved changes.

June 15, 2008.

- Version 6.05 is now available.
- Other minor improvements.
- Removing of the "N/A" after a successful Z39.50 query for books.

June 8, 2008.

- Released version 6.04 for OS X Intel, yet again.
- Included additional dependencies in the bundle.

June 4, 2008.

- Version 6.04 has been released once again.
- Please report any issues as there have been many updates recently!
- Solidified the parsing algorithms for Z39.50 queries. The algorithms also attempt to set the categories.

June 2, 2008.

- Released version 6.04 for OS X Intel.
- Improved the parsing routine for the Library of Congress query results for book items. Will most likely re-release this version as it's still too primitive.

May 30, 2008.

- Version 6.03 will be released today.
- All users are urged to upgrade!
- Created a journal table.
- Removed image format information from the item tables.
- Resolved critical issues with the journal and magazine table implementation.

May 26, 2008.

- Version 6.02 has been released!
- Allow members to view their overdue items, requested items, and reserved items.
- ISBNs may now be generated for PostgreSQL databases.
- Members are now allowed to place items on request.
- Other general improvements.

May 21, 2008.

- Version 6.01 is now available for Windows XP.

May 20, 2008.

- Released version 6.01.
- Must remember to update some internal variables after copy information is saved.
- The Copy Browser now displays the title of the respective item.

May 11, 2008.

- Versions 5.03.3 and 6.00 have been released.
- Version 5.03.3 addresses several widget sensitivity issues. (These issues have also been addressed by version 6.00.)

May 10, 2008.

- Version 6.00 may be released today!
- Pricing information is now only presented to certain administrator roles.
- Resolved several widget sensitivity state issues.
- Slimmer database design. Tables containing reservation information have been condensed.

May 7, 2008.

- Version 5.03.2 is now available.
- This release resolves a dysfunctional drag-and-drop implementation on OS X.

May 6, 2008.

- Version 5.03.1 has been released.
- This version addresses an incorrect reference to the ISBN column in the main table. The column is actually ISBN-10.

May 5, 2008.

- Released version 5.03.
- Default values for required fields. This only applies to the Book category.
- Implemented a mechanism for generating unique ISBNs for SQLite databases.
- Resolved an issue with myqstring::escape().

May 3, 2008.

- Version 5.02 is now available.
- Completed items from the TO-DO document.
- Devised a widget-centering algorithm.
- Miscellaneous fixes.
- Resolved several issues with the Journal and Magazine categories.
- Resolved some SQLite issues.

May 2, 2008.

- Released version 5.01.
- Completed the Administrator Browser. This browser is only available for PostgreSQL databases.
- Improved the INSTALL document.
- Minor, yet lovely, improvements.
- Required fields are now highlighted.
- Resolved items from the TO-DO list.

April 23, 2008.

- Version 5.00 is now available for download.
- Improved SQLite support.
- Miscellaneous improvements.
- Removed MySQL support.
- Resolved some CASCADE DELETE issues.

April 21, 2008.

- Version 4.05 is available.
- Fixed several SQL queries related to NULL fields in WHERE clauses.
- Notify the administrator to remind a new member of their default password upon member creation.
- Updated the MySQL scripts. There are some outstanding issues in regards to member creation.

April 20, 2008.

- Released version 4.04.
- Implemented the OFFSYSTEM URL feature.

April 19, 2008.

- Uploaded a new Windows XP bundle to resolve several dependency issues.

April 19, 2008.

- Version 4.03 is available for download.
- Ability to drag images (BMP, JPG, PNG) onto the Cover Image canvases.
- First official release for Windows XP.
- Key fields (such as Author(s), Director(s), etc.) are now represented as hyperlinks. This will simplify the searching of similar items.
- Minor bug fixes.

April 14, 2008.

- Version 4.02.2 is now available.
- Modified the sqlite_create_tables.sql script in support of delete cascades.
- Removed some user interface titles.
- Successfully tested the application in Windows XP via a SQLite connection.
- Updated several INSERT statements in support of SQLite limitations on unique constraints.

April 13, 2008.

- Released version 4.02.1.
- Created a superficial wrapper around QSqlQuery::size() in support of SQLite.
- Fixed a SQL query with the Reservation History panel.
- General enhancements.
- New options under the Options menu.

April 12, 2008.

- Released version 4.02.
- SQLite 3.x is now supported.

April 11, 2008.

- Version 4.01 is now available.
- Beautified many aspects of the user interface.
- Cover images support.
- Fixed some of the SQL scripts.
- General enhancements.

March 31, 2008.

- Version 4.00.1 is available.
- Corrected the MySQL scripts.
- Updated several error messages.
- Updated the INSTALL.freebsd document.

March 30, 2008.

- Version 4.00 has been released.
- Allow members to view their reserved items.
- Enhanced the user interface.
- Implemented user authentication based on MySQL and PostgreSQL.
- Removed account information from the biblioteq.conf file.

March 22, 2008.

- Version 3.23.1 is now available.
- Completed the Member's Reservation History panel.
- Fixed the various SQL scripts.
- Improved the appearance of the main form.
- Minor bug fixes.

March 19, 2008.

- Released version 3.23.
- If upgrading, please execute the 3.23 SQL statements from either the mysql_update.sql or postgresql_update.sql scripts at the appropriate database prompt.
- Initial release in support of reservation history.
- Miscellaneous improvements.
- Updated several icons.
- Updated the SQL files that are responsible for creating the various database tables.

March 15, 2008.

- Released version 3.22.
- If you are upgrading, please execute the 3.22 SQL statements from either the mysql_update.sql or postgresql_update.sql scripts at the appropriate database prompt.
- Implemented a mechanism for printing information from the main window.
- Modified the database item tables to include type information.
- Replaced several hide() calls with raise().

March 12, 2008.

- Version 3.21 is now available.
- Preserve the visibility of the main table's columns after a Type Filter change.

March 9, 2008.

- Released version 3.20.
- Implemented a means to copy the contents of the Error Dialog to the clipboard buffer.
- Modified the backup.csh script in support of FreeBSD's Qt4 port.

March 7, 2008.

- Released version 3.19.
- Fixed a focus issue.
- Modified scrolling attributes for several of the table widgets.
- Verified that the application functions properly on FreeBSD 7.0 systems.

February 28, 2008.

- Version 3.18 is now available.
- Corrected the constructor's signature in numeric_table_item.cc.
- Program is fully functional on Solaris 10 systems.

February 14, 2008.

- Released version 3.17.
- Improved several user interface elements.
- Modified the SQL files, removing ALL privileges.
- Removed redundant QApplication::restoreOverrideCursor() calls.

February 9, 2008.

- Released version 3.16.
- Implemented stronger data massaging algorithms on Library of Congress query results.
- Minor user interface improvements.

January 18, 2008.

- Version 3.15 is now available.
- Fixed some minor display issues.

January 15, 2008.

- Released version 3.14.
- Improved the appearance of the Members Browser.
- Resolved an incorrect SELECT statement in misc_functions::getReservedItems().
- Standard users can now view the due date of reserved items.

January 13, 2008.

- Version 3.13 is now available.
- Created a mechanism for printing a member's reserved items.
- Fixed an incorrect query statement in the Members Browser.

January 8, 2008.

- Released version 3.12.
- Resolved an issue with the resetting of the Error Log upon a database disconnect.

December 28, 2007.

- Version 3.11 is now available.
- Fixed a minor issue with item quantities.
- Updated the icon set.

December 25, 2007.

- Released version 3.10.
- Several user interface modifications.
- The database searches are now case-insensitive.
- The main window's geometry is now stored in the user's configuration file whenever the file is saved.

December 23, 2007.

- Uploaded the TAR bundle to SourceForge.net.

December 22, 2007.

- Version 3.09 is now available.
- Added a capability for custom queries.
- Miscellaneous improvements.
- Resolved a privilege issue.

November 30, 2007.

- Created biblioteq.sh.
- Updated backup.csh, biblioteq.conf, and biblioteq.win.pro.

November 29, 2007.

- Released version 3.08.
- Allow for anonymous connections. The information required to establish such connections is available in the biblioteq.conf file.

November 22, 2007.

- Version 3.07 is now available.
- Introduced the Journal category.
- Resolved a database issue with item copies.
- The YAZ++ package is no longer required.

November 14, 2007.

- Released version 3.06.
- Updated the Library of Congress query for journals (magazines).

November 12, 2007.

- Version 3.05 is available.
- Added an application icon for the OS X platform.

November 2, 2007.

- Version 3.04 is now available.
- Modified some minimum-size properties for several panels.
- Resolved an incorrect database table join.

October 27, 2007.

- Version 3.03 has been released.
- Allow administrator to modify copy information during item creation.
- Small enhancements.

October 20, 2007.

- Released version 3.02.
- Removed some unnecessary code.
- Simplified the Branch Selection dialog.

October 12, 2007.

- Released version 3.01.
- Resolved an issue caused by an unescaped single quote.

October 11, 2007.

- Version 3.00 is now available!
- Many little, but wonderful, improvements.

October 5, 2007.

- Version 3.00 will be released shortly.
- Additional errors have been resolved.
- The item table has been separated into several tables so as to better represent the data.

September 26, 2007.

- Released version 2.09.
- Fixed postgresql_create_tables.sql.
- Fixed some major flaws with PostgreSQL-related sections.
- Fixed some problems caused by incorrect usage of hide().
- Introduced a new option under the Options menu.

September 24, 2007.

- Version 2.08 is now available.
- Updated several tool tips.
- Updated the postgresql_create_tables.sql script.

September 21, 2007.

- Version 2.07 is available.
- Code detoxification.
- Updated the contents of the biblioteq.conf file.

September 19, 2007.

- Released version 2.06.
- Fixed an error with the DVD class.
- Resolved a critical issue with indices.

September 17, 2007.

- Version 2.05 is now available.
- Implemented additional error logging.
- Several administrator issues resolved.

September 12, 2007.

- Version 2.04 is available.
- Created an "admin" table.
- Fixed some issues with administrator authentication.

September 10, 2007.

- Version 2.03 is available.
- Updated the parsing routine for the Library of Congress query for books.

September 9, 2007.

- Version 2.02 is available.
- Resolved an issue with the ISSN field for magazines. The check digit may be an X.

September 6, 2007.

- Version 2.01 is available.
- Addressed some minor Z39.50 issues with books.

September 5, 2007.

- Version 2.00 has finally been released!
- This release includes full support for books, cds, dvds, magazines, and video games.

July 22, 2007.

- Fixed two incorrect labels with the CD panel.
- Miscellaneous updates.
- Resolved an indexing issue with the Library of Congress query for books.

July 14, 2007.

- Added an option to allow the user to set the global font.
- Completed several items from the TO-DO list.
- Resolved various issues.

July 9, 2007.

- Changed the default font to Times.
- Miscellaneous changes.
- Redesigned item information layouts to accommodate smaller display resolutions.
- Updated the Library of Congress query for books.

July 1, 2007.

- Completed items from the TO-DO list.

June 24, 2007.

- Added a Category field to the generic search panel.
- Fixed a uniqueness issue with ISSN numbers.
- Resolved several potential issues with incomplete transactions.

June 21, 2007.

- Finished the Library of Congress Z39.50 query for magazines.
- Inserted a missing comma in the postgresql_create_tables.sql file.

June 17, 2007.

- Creating an initial copy as part of the item creation process.
- Implemented tasks from the TO-DO list.
- Library of Congress connection information is now retrieved from the biblioteq.conf file.
- Processing Library of Congress queries from threads.
- Renamed .qtbook.dat to .biblioteq.dat.
- Renamed qtbook.conf to biblioteq.conf.

June 15, 2007.

- Initial usage of the Z39.50 protocol for books. You must install the YAZ toolkit.
- Redesigned the Members Browser.
- Resolved some potential problems.

June 10, 2007.

- Completed items from the TO-DO list.
- Resolved several nameless issues.

June 3, 2007.

- Completed several items from the TO-DO list.
- Eliminated some potential issues with row indices.
- Enhanced the user interface.

June 1, 2007.

- Resolved a PostgreSQL-related problem with the Members Browser.

May 31, 2007.

- Added some new fields to the Magazine category.
- Completed several items from the TO-DO list.

May 24, 2007.

- Resolved some issues with window titles.
- The create and search dialogs are now non-modal.

May 16, 2007.

- Added a mechanism to convert ISBN-10 to ISBN-13.
- Other wonderful improvements.

May 13, 2007.

- Added several new fields to the Book category.
- General improvements.
- Resolved an error caused by switching from one category to another.

May 12, 2007.

- General improvements.

May 11, 2007.

- Bug fixes.
- Completed the Video Game category.

May 5, 2007.

- Resolved an issue with the Track Browser.

May 4, 2007.

- Implemented the CD category.

May 2, 2007.

- Added some text validators to the various ID fields.
- Replaced one or two icons.

April 16, 2007.

- Completed several items from the TO-DO list.
- Improved the user interface's functionality.

April 2, 2007.

- Fixed some modality issues.
- Introduced the VHS type. Yes, VHS.
- More wonderful changes.

April 1, 2007.

- Lots of issues resolved.
- Massive code overhaul. Users are now able to browse multiple items simultaneously.

March 27, 2007.

- Another small release. Allow normal users to view an item's details.
- Bug fixes and code cleanup.

March 21, 2007.

- As usual, bug fixes. Completed several items from the TO-DO list.

March 18, 2007.

- Completed several items from the TO-DO list.
- Renamed the project to BiblioteQ.

March 11, 2007.

- Some minor improvements.

March 9, 2007.

- Several bug fixes. Close to completing the CD category.

March 7, 2007.

- Bug fixes. Additional enhancements to the Tracks Browser.

March 5, 2007.

- Released INSTALL.freebsd.
- Some minor work on the Tracks Browser.

March 4, 2007.

- Bug fixes.
- Resolved some issues with file paths.
- Successfully compiled and executed the program on Windows XP!

March 3, 2007.

- Completed the CD search mechanism.
- Miscellaneous bug fixes. The application's release status remains Pre-Alpha.
- The installation document for PostgreSQL on FreeBSD will be included as soon as I find it.

March 2, 2007.

- Bug fixes.
- The menus are operational.
- User interface redesign.

February 28, 2007.

- Introduced an installation document for PostgreSQL on FreeBSD.
- Resolved some issues that were introduced in previous releases.
- Some of the new menus are not yet operational.

February 27, 2007.

- Several bug fixes.

February 24, 2007.

- Additional code cleanup and bug fixes.
- Implemented item reservation.

February 21, 2007.

- Bug fixes.
- Code cleanup.
- Miscellaneous enhancements.

February 18, 2007.

- Close to completing CD support.
- Separated the large qtbook.cc file into smaller pieces.

February 9, 2007.

- More improvements to the user interface.

February 5, 2007.

- User interface improvements.

February 4, 2007.

- Additional items from the TO-DO list have been completed.
- Code cleaning.

February 3, 2007.

- Preliminary release in support of PostgreSQL.

February 2, 2007.

- Implemented a sleep mechanism via QMutex and QWaitCondition.
- Must not reference objects after they've been deleted.
- Other general goodies included with this release.

January 29, 2007.

- Yet another pre-alpha release.

January 28, 2007.

- A new release! Please read the TO-DO file for remaining items.

January 15, 2007.

- Version 2.00 (Pre-Alpha) has been released. Please read the included documentation for release information.

November 4, 2006.

- Version 2.00 is in the works! Many wonderful features will be included. The previous version has been removed.

January 1, 2002.

- BiblioteQ, or XBook, is introduced.