BiblioteQ Changelog

What's new in BiblioteQ 2023.12.30

Dec 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. This item is missing a period in the embedded release notes except for the PowerPC release.
  • 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.

New in BiblioteQ 2023.07.20 (Jul 20, 2023)

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

New in BiblioteQ 2023.07.15 (Jul 15, 2023)

  • Release Notes:
  • 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.

New in BiblioteQ 2023.06.06 (Jun 5, 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.

New in BiblioteQ 2023.02.20 (Feb 18, 2023)

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

New in BiblioteQ 2022.12.25 (Dec 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.

New in BiblioteQ 2022.11.25 (Nov 22, 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.

New in BiblioteQ 2022.05.30 (Sep 14, 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; Windows.

New in BiblioteQ 2022.03.30 (Mar 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//discussions/191.
  • Create a new SQLite database: File -> New SQLite Database.
  • Open Merge SQLite Databases: Tools -> Merge SQLite Databases.
  • Press Add Row.
  • Select the legacy SQLite database file.
  • Press the Merge button.
  • PostgreSQL 10.20.1; Windows.
  • 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; Windows.

New in BiblioteQ 2022.02.30 (Mar 3, 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.
  • Open Library queries via alternate identifiers.
  • Overdue Fees in Members Browser.
  • Sort basic search (main window) results by titles. Thank you tamascz.

New in BiblioteQ 2022.01.30 (Jan 31, 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 table'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; Windows.
  • Simplify text before displaying it in the main table and associated tool tips. Thank you meteos77.

New in BiblioteQ 2021.12.15 (Dec 16, 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; Windows.
  • SQLite database merge.
  • Speedy reservations. New option in Members Browser.

New in BiblioteQ 2021.10.30 (Nov 1, 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.

New in BiblioteQ 2021.09.10 (Sep 12, 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.

New in BiblioteQ 2021.08.08 (Aug 9, 2021)

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

New in BiblioteQ 2021.06.12 (Jun 13, 2021)

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

New in BiblioteQ 2021.05.15 (May 17, 2021)

  • Grey Literature reservations. Please upgrade your database schemas.
  • PostgreSQL 10.16 for Windows.
  • SQLite 3.35.5 for Windows.
  • YAZ 5.31 for Windows.

New in BiblioteQ 2021.04.10 (Apr 11, 2021)

  • Release Notes:
  • 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.

New in BiblioteQ 2021.02.12 (Feb 13, 2021)

  • Release Notes:
  • 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.

New in BiblioteQ 2021.02.02 (Feb 4, 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.
  • make install; Windows.

New in BiblioteQ 2020.09.09 (Nov 11, 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.

New in BiblioteQ 2020.07.25 (Jul 25, 2020)

  • C++2011.
  • Colorful messages in SQLite upgrade process.
  • Corrected SQLite upgrade statements.

New in BiblioteQ 2019.03.15 (Mar 19, 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.

New in BiblioteQ 2018.12.12 (Dec 13, 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.

New in BiblioteQ 2018.07.04 (Jul 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.

New in BiblioteQ 2018.05.05 (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

New in BiblioteQ 2017.08.19 (Aug 21, 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.

New in BiblioteQ 2017.06.04 (Aug 21, 2017)

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

New in BiblioteQ 2017.05.05 (May 9, 2017)

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

New in BiblioteQ 2017.04.30 (May 2, 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.

New in BiblioteQ 2017.01.20 (Jan 21, 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.

New in BiblioteQ 2016.12.16 (Dec 23, 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 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.

New in BiblioteQ 2016.11.06 (Dec 8, 2016)

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

New in BiblioteQ 2016.11.05 (Nov 7, 2016)

  • 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 ComputerHKEY_CURRENT_USERSoftwareBiblioteQ 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.

New in BiblioteQ 2016.09.04 (Oct 19, 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.

New in BiblioteQ 2016.07.04 (Jul 5, 2016)

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

New in BiblioteQ 2016.03.15 (Mar 16, 2016)

  • More forward-only SQL queries.
  • Portable BiblioteQ. Previous user configuration settings will be lost.

New in BiblioteQ 2016.03.08 (Mar 16, 2016)

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

New in BiblioteQ 2016.03.07 (Mar 16, 2016)

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

New in BiblioteQ 2016.03.03 (Mar 5, 2016)

  • Corrected Language selection.
  • New option under Options
  • Removed duplicate INI directives from the source
  • Upgraded SQLite to version 3.11.1 on Windows

New in BiblioteQ 2016.02.17 (Feb 18, 2016)

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

New in BiblioteQ 2015.10.28 (Feb 18, 2016)

  • Corrected QProgressDialog problem for Qt 5.5.x.
  • Upgraded Qt to version 5.5.1 on Windows.

New in BiblioteQ 2015.10.16 (Oct 19, 2015)

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

New in BiblioteQ 2015.07.04 (Jul 6, 2015)

  • A patron's gender is now optional. PostgreSQL administrators, please update via postgresql_update_schema.sql.

New in BiblioteQ 2015.06.27 (Jun 29, 2015)

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

New in BiblioteQ 2015.06.10 (Jun 11, 2015)

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

New in BiblioteQ 10.01 (Apr 27, 2015)

  • Added proxy authentication support to SRU magazine queries.
  • All database retrieval queries are now forward-only.
  • 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.

New in BiblioteQ 10.00 (Jan 29, 2015)

  • Version 10.00 is now available.
  • 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.

New in BiblioteQ 6.74 (Dec 19, 2014)

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

New in BiblioteQ 6.73 (Dec 10, 2014)

  • A new Hungarian translation.
  • Improved recording of Z39.50 errors.
  • Prohibit case-sensitive PostgreSQL administrator names.
  • Upgraded YAZ products to version 5.7.1 on Windows.

New in BiblioteQ 6.72 (Oct 14, 2014)

  • Prevent cancellation of processes that are not interruptible.
  • Spelling corrections.
  • Upgraded Qt products to version 5.3.2 on Windows.

New in BiblioteQ 6.71 (Aug 11, 2014)

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

New in BiblioteQ 6.70 (Aug 4, 2014)

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

New in BiblioteQ 6.69 (Jun 9, 2014)

  • 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.
  • Inspect indexOf() results and results of similar methods.
  • Upgraded SQLite libraries to version 3.8.5 on Windows.

New in BiblioteQ 6.68 (May 22, 2014)

  • Added support for 64-bit integers to limit and offset SQL clauses.
  • Avoid divisions by zero.
  • 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 leaks 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 YAZ products to version 5.1.1 on Windows platforms.
  • Use parameterized SQL statements so as to avoid injection errors. Please note that this item required significant changes. Please report issues.

New in BiblioteQ 6.67 (Mar 28, 2014)

  • 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 schemas 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

New in BiblioteQ 6.66 (Mar 28, 2014)

  • 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

New in BiblioteQ 6.65 (Mar 28, 2014)

  • 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

New in BiblioteQ 6.64 (Mar 28, 2014)

  • 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

New in BiblioteQ 6.63 (Mar 28, 2014)

  • Added artist and composer fields to the cd_songs table. PostgreSQL administrators are urged to review the postgresql_update_schema.sql file. Please see 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