BiblioteQ is an archiving, cataloging, and library management suite. The software is available for many operating systems and should be compatible with any system that supports a modern Qt. BiblioteQ is distributed with a BSD license.
BiblioteQ Summary
ARM architecture support.
Administrator roles.
Alpha architecture support.
Android!
Animated confirmations, here and there. Future fun.
Anti-censorship through digital content.
Apple Silicon.
Archive important documents.
Bar scanners supported indirectly.
Cataloging of books, dvds, grey literature, journals, magazines, music cds, photograph collections, and video games.
Cover images with drag and drop support.
Customized displays.
Customized item data, pricing information, and currencies.
Documentation.
Elaborate options. Many options. Very many.
Embedded hyperlinks for localized searches of similar items.
Exporting of views to CSV files.
External applications.
Files browser.
Free and Open Source technology.
FreeBSD, Linux, MacOS, OS/2, OpenBSD, Windows, etc.
Front cover image retrieval via Amazon and Open Library.
Importing of books from CSV files.
Internationalization (translation) support. BiblioteQ currently supports Arabic, Czech, Dutch, English, French, German, Greek, Hungarian, Polish, Portuguese, Russian, and Spanish.
Item file attachments.
Item reservation.
Listings of overdue items, requested items, and reserved items.
MARC21 and UNIMARC record syntaxes.
MacOS and Windows install targets: make install.
Merging of SQLite databases.
Multiple icon sets.
Natively compiled on ARM, Alpha, PowerPC, Sparc64, X86, X86_64.
Network-less!
Open Library queries for select items.
Optional item reservation histories for patrons.
PDF reader via Poppler, where available.
Parse local MARC tags. Books, journals, magazines.
Patron information.
Portable.
Portable libraries.
PostgreSQL accounts with various privileges.
PostgreSQL and SQLite engines.
PowerPC support.
Print support, including previews.
Qt LTS.
Raspberry Pi!
Retain the privacy of your memories.
Rich search capabilities, including custom SQL queries.
Row-level security policies for PostgreSQL.
SQL syntax highlighting with custom colors.
Sparc64 support.
Support for multiple SRU and Z39.50 sites.
Support for requesting unavailable items.
Threaded data retrieval via the standard Z39.50 protocol for books, journals, and magazines.
Transactional database queries.
True PostgreSQL and SQLite pagination.
Uniform functionality across various platforms.
Windows portable.
Release Notes
June 30, 2024.
260 releases of BiblioteQ!
Archived biblioteq_architecture.h and replaced with
QSysInfo::buildCpuArchitecture().
Cell colors. Please see Other Options -> Main Window ->
Special Value Colors. GitHub ticket #369.
True-equality comparisons are performed. Fast, super fast.
Consider PostgreSQL's libpq location on Apple Silicon.
Corrected item reservation for PostgreSQL. Please drop the
delete_request() function as it is incomplete.
Display a reminder if a requested item has been returned.
PostgreSQL for now. GitHub ticket #350.
Final traditional release. Future releases provided through
Qup.
First LTS of 2024?
Include hh:mm:ss in item-request date.
Non-modal About dialog.
PostgreSQL 15.7.2 Windows.
QSqlQueryModel::setQuery() has a new signature since Qt 6.2.
Item included in MacOS and Windows releases. Available elsewhere in
a future release.
Resize other windows at about 95% of the main window's size.
Select the appropriate member in the Members Browser
when an item is prepared for reservation. For example, an item
is selected in the main window and the Reserve Selected Item
button is clicked.
The file postgresql_update_schema.sql's last entry's date is incorrect. The correct date is 2024.06.30.
April 30, 2024.
259 releases of BiblioteQ; here and there.
A pleasant approximation.
676 Dewey Number and Z39.50 Unimarc. GitHub ticket #344.
Added sslcompression=1 to connection_options in biblioteq.conf.
PostgreSQL only.
Completed C++ enumerator classes. Please discover errors.
Corrected INI recording of availability colors in
Other Options -> Main Window. Do not neglect sorted columns!
GitHub ticket #357.
Corrected INI recording of date formats in Other Options -> Items.
Do not neglect sorted columns! GitHub ticket #357.
Correctly committed Database Enumerations Browser data will cause
automatic population of existing interfaces. Please note that
BiblioteQ will make a best effort at preserving current values of
existing interfaces.
Database Enumerations Browser: replaced combination box widgets
in the Locations table with item delegates. The revision resolves
a peculiar Qt warning "edit: editing failed". The problem
is encountered during tab-key navigation. Please also read the
TO-DO document.
Display all items in Database Enumerations Browser -> Section
combination box widget.
Display an error message if the PostgreSQL library provided
by Homebrew is not available on MacOS.
Display formatted dates for all queries in the main window.
Do not translate Type fields in the Database Enumeration
Browser's Locations and Reservations Minimum Days. The Type field
represents a database value and items are located through it.
GitHub ticket #360.
Introduced loop-unrolling in project files for some
distributions.
Organized source. Please review and submit corrections.
Other Options: do not record colors names as Latin in the INI file.
Instead, record colors names as presented.
Removed all QSettings::sync() instances.
Removed duplicate mnemonics from all interfaces.
Removed inactive Help menu from CSV Import Browser. Seriously!
Renamed some INI keys: otheroptions/book_date_format ->
otheroptions/date_format. Please review Other Options -> Items.
Replaced QString(tr()) with tr().
Restore a normal cursor if qmain is not available in
biblioteq_otheroptions::prepareShortcuts(). Very awful and very
unlikely.
Scroll to the bottom of the list and table widgets whenever new
entries are created in the Database Enumerations Browser.
This is a happy release in a world of calamity.
March 25, 2024.
A style of Breeze is the preferred style of biblioteq.sh.
Animated confirmations:
Copies Browser
Custom Query
Other Options
Block signals in biblioteq_misc_functions::sortCombinationBox()
before modifying the contents of the combination box widget.
Completed system icons for items.
DVDs, photograph collections, video games and global fonts.
Enumerator classes here and there.
Improved text search in documentation class.
Let's consider active confirmations. Many, if not all, of
the interactions with BiblioteQ result in negative or positive
confirmations. A negative confirmation results in an error dialog
and / or a log entry. Now, a negative result will also be in the form
of an animated push button. Similarly, a positive result will be in
the form of an animated push button. An animated widget is a widget
which provides an animated background color such as crimson or red,
or some variation.
New notes database fields.
Notes are now available in copy editors.
PostgreSQL 15.6.1 for Windows.
Replaced BIBLIOTEQ_CONFIGFILE with BIBLIOTEQ_CONFIGURATION_FILE.
Sort item types in Database Enumerations combination boxes.
Sort strings of combination boxes in copy editors.
February 29, 2024.
A source-only release during an elongated February on a lunatic
planet.
Added missing period in release notes.
Animated negative and positive indicators on some panels.
GitHub ticket #348.
Beautified the source. Please discover errors.
Center Member-Create / Member-Modify panel with respect to its
parent.
Corrected embedded searches. Problems caused by favorites.
Enumerator classes here and there.
New --special-executable-icon. GitHub ticket #347.
New Other Options -> Display -> Icon Set. System icons may not
be available everywhere. Incomplete.
PowerPC may require future tweaks because of legacy Qt.
Removed Document Changes section from BiblioteQ.odt.
Removed redundant clear() instances.
Replaced QString(tr()) with tr(). Incomplete.
Replaced SHA1 with SHA3-512. New data only.
Resize photograph panel at about 95% of parent's size.
Sprinkled icons.
This release is dedicated to the linguistic Mr. D. See you.
Uniform widget widths, here and there.
December 30, 2023.
Added BnF Z39.50 target to biblioteq.conf.
Added new labels describing on-top window behavior to relevant
windows.
Bundle French documentation files into the executables.
Completed Database Enumerations defaults: Grey Literature,
Languages, Locations, Monetary Units, Video Games. Favorites are also
prepared for new items and searches. GitHub ticket #308.
Corrected resetting of Monetary Units for the General Search.
The contents of the combination box are purged if the Reset button
is activated. Reviewed all other item searches.
Display Notes in photograph view.
Final LTS release of 2023. See you!
First PiOS 64-bit release!
Improved retrieval of publication dates from Z39.50 queries.
Completed for books and magazines. GitHub ticket #343.
LTS release! Release includes a bunch of bunched bunches covering
numerous operating systems: Android 10, Debian PowerPC, Kubuntu 22.04,
Raspbian 12, MacOS 13, Windows 11.
New Magic Unix scripts. Please inspect the Scripts directory.
New 214 processing for books and Z39.50 queries.
GitHub ticket #343.
PiOS-64 now requires Qt 6 and version 12.
PostgreSQL 15.5.1; Windows.
Qt 6.5.3 LTS on Android.
Qt 6.5.3 LTS on MacOS.
Qt 6.5.3 LTS on Windows.
Query history. Please see Tools. Query strings may be incomplete
and therefore some may not be executable.
GitHub ticket #340.
Added Next (Ctrl + Right) and Previous (Ctrl + Left) shortcuts to
various interfaces.
Added a completer to Member ID in Batch Activities.
GitHub ticket #331.
Adjust a view's scene rectangle according to the scene's
contents.
Allow multiple books to be created.
Clean Discovered Name in Batch Activities Browser on reset.
GitHub ticket #330.
Deprecated Qt 5 LTS for Android, MacOS, and Windows.
ISBN-13 is now the default focus widget for books.
MacOS release will be built with Qt 6.5 LTS.
Reset the main view's rectangle upon a database disconnect.
September 15, 2023.
Added Next (Ctrl + Right) and Previous (Ctrl + Left) shortcuts to
photograph views.
Added shortcut tool tips to Other Options -> Shortcuts.
Administrator Browser: include Batch Activities Browser.
Align graphic views. These are views containing images.
Android and Qt 6.5.2 LTS.
Corrected book import: missing target_audience field in
Template 2.
Corrected page selection in photograph views.
Corrected required field highlights of book item:
alternate_id_1, volume.
Corrected scene sizes in photograph views.
Database Enumerations defaults: DVDs. Favorites are prepared
for new DVDs and searches. GitHub ticket #308.
Display a patron's name in the Batch Activities Browser's Borrow
panel after editing of the Member ID field has finished.
Future Windows releases will feature x86-64. PostgreSQL version
10 is the last supported x86 release. Please read
https://www.postgresql.org/download/windows.
Improved version reporting of obsolete software.
Include image quantities in photograph collections.
New Filter order in Members Browser.
GitHub discussion #316.
New book fields: date_of_reform, origin, purchase_date.
GitHub ticket #260.
Populate target_audiences during an import.
GitHub ticket #317.
Process pending events shortly after show() is issued on the
main window. This will allow child windows, which may be shown
during the preparation process, to be centered correctly.
Scroll to Reservations Minimum Days section via Members
Browser.
Sort table fields in Custom Query.
Sortable Read Status table column. GitHub ticket #321.
July 20, 2023.
Database Enumerations defaults: CDs. Favorites are prepared for new CDs and searches. GitHub ticket #308.
July 15, 2023.
Database Enumerations defaults: books. Favorites are prepared for new books and searches. GitHub ticket #308.
Linux-like distributions: replaced /usr/local with /opt. GitHub ticket #310.
New Tools -> External Applications. GitHub ticket #278.
Remove INI key custom_query_favorite after the relevant favorite is deleted via the interface.
June 6, 2023.
Adapt to incomplete custom queries and reservation processes.
Added SQLite table trigger item_borrower_trigger.
Added volume_number field to book category. GitHub ticket #227.
Allow pasting of images into Back and Front cover image containers. GitHub ticket #284.
Allow resetting of highlight colors: Other Options -> Custom Query.
Android and Qt 6.2 LTS.
Archived release notes.
Avoid creating expensive program objects if they are not necessary: Members Browser -> Print Selected Member's Reserved Items.
Batch returns. GitHub ticket #280.
Book import template 2 was missing alternate_id_1.
Center PDF progress dialogs.
Copy Browser did not contain the correct number of reserved non-book items. The process was incomplete. Completed!
Custom query favorite and shortcut. See also Other Options -> Shortcuts. GitHub ticket #279.
Display a gentle and persistent reminder in the status bar if a new version of BiblioteQ is available.
Display brief summaries in favorite actions.
Enable clear button for many text fields.
Enable sorting for table widgets in Other Options.
Final Windows x86 packaged release. Future Windows releases will include Qt 6 LTS and Windows x86-64.
For new installations, the following options will be enabled: Populate Administrator Browser On Display, Populate Database Enumerations Browser On Display, and Populate Members Browser On Display.
Include target audience in book view. GitHub ticket #294.
Infinite intelligent Custom Query windows.
LTS release! Several accumulated bundles included.
Native dialogs and menus. File dialogs remain non-native.
New Year's End convenience widget in patron information. GitHub ticket #297.
On-top Member's Reservation History window. GitHub discussion #248.
On-top Members Browser window. GitHub discussion #248.
Optional member reservation history for SQLite databases.
PostgreSQL and compression. See SQL/postgresql_update_schema.sql.
Qt 5.15.9 for MacOS. Some releases do not include this item in their release notes but will in the future.
Qt 6.5 LTS compliant.
Removed SQL keywords for highlighting: INSERT INTO, INSERT INTO SELECT, and SELECT INTO.
Replaced error() with errorOccurred() in Qt 5.15 and newer for QNetworkReply.
Reset post-query highlight colors for books, journals, and magazines as necessary.
SQLite upgrade tool: all or recent. Please see Tools menu. Always create a copy of the SQLite file before upgrading!
Set highlights of Custom Query text immediately after colors are configured and saved.
Unlimited queries for PostgreSQL. Please be careful!
YAZ 5.34; W32.
March 15, 2023.
C++17.
Initialize visible Members Browser columns.
Some containers may be intentionally empty. Added label reminders.
March 10, 2023.
Options -> Select Global Font is now available on MacOS.
Visible Members Browser columns: Other Options -> Members -> Visible Columns. GitHub ticket #246.
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!
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; MacOS.
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).
Version information in About is incorrect for Debian and MacOS. Will be corrected in the next release.
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.
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.
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.
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 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; 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.
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 MacOS 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 MacOS. 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 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.
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.
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 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.
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:
Modify your PostgreSQL schema by executing the SQL statements under version 6.55 of the postgresql_schema_update.sql file.
Launch BiblioteQ and connect to your PostgreSQL instance. You must connect with the administrator account that you used to create the BiblioteQ database.
Open the Administrator Browser and issue a save.
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 MacOS.
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.