BiblioteQ strives to be a professional archiving, cataloging, and library management suite, utilizing a Qt interface and providing connectivity to PostgreSQL and SQLite. The Open Library, SRU, and Z39.50 protocols are used for retrieving data for books, journals, and magazines. The software is available for all major operating systems and should be compatible with any system that supports Qt. BiblioteQ is distributed under a BSD license.
ARM architecture support.
Alpha architecture support.
Archive important documents.
Cataloging of books, dvds, grey literature, journals, magazines, music cds, photograph collections, and video games.
Cover images with drag and drop support.
Customized item data, pricing information, and currencies.
Embedded hyperlinks for localized searches of similar items.
Exporting of views to CSV files.
Free and Open Source technology.
FreeBSD, Linux, Mac, 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, and Russian.
Item file attachments.
Listings of overdue items, requested items, and reserved items.
MARC21 and UNIMARC record syntaxes.
Natively compiled on Alpha, ARM, PowerPC, Sparc64, X86, X86_64.
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.
PostgreSQL accounts with various privileges.
Print support, including previews.
Qt 5.x support.
Rich search capabilities, including custom SQL queries.
Row-level security policies for PostgreSQL.
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.
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.
PostgreSQL 9.6.19 for W32.
Synchronize current page with page index in PDF reader.
Various text hints.
July 25, 2020.
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.
Reservation history print preview.
Row-level item_borrower and item_request security policies for PostgreSQL >= 9.5.
SQLite 3.32.3 on Windows.
SSL / TLS for Amazon image retrieval. Ignore SSL / TLS errors on image retrieval.
Vacuum database tool.
YAZ 5.30.3 on Windows.
January 1, 2020.
Container optimization; replaced first().
Debian ARM Qt 5 package. Native build.
Fifteen splendid years of BiblioteQ!
Happy New Year!
Importing of books from CSV files is now supported. BiblioteQ mapping template included.
OS/2 Qt 5 support.
Optional e-mail validation.
PostgreSQL 9.6.16 on Windows.
Qt 5.9.9 on Windows.
SQLite 3.30.1 on Windows.
October 10, 2019.
Best Fit photograph view option.
Forward-only database queries, where appropriate.
New contact information in Members Browser.
Process interface events. Smooth.
SQLite 3.30 on W32.
Trim database string values during processing.
September 9, 2019.
Allow exporting of Members Browser's visible items as CSV.
Corrected Viewable Columns. Thank you sidheban.
Corrected removal of photographs via context menus; abnormal termination.
Denote SQLite database usernames as SQLITE where applicable.
Disabled hyperlink searches on SQLite. Editable text-edit fields do not support interactive hyperlinks.
Display Call Number for All Overdue, All Requested, and All Reserved categories.
Display database role in main window's title.
Drop extensions in postgresql_destroy_schema.sql.
Full screen mode.
Intuitive radio button appearance.
Larger image previews in main window's table.
Patron contact information now available in All Overdue, All Requested, and All Reserved categories.
PostgreSQL 9.6.15 on W32.
Qt 5.13.0 on OS X.
Removed C++ singleton.
SQLite 3.29 on W32.
Source format changes.
Update item image in main table upon image change.
June 6, 2019.
Grey Literature Publication Date Format correction provided by coldacid.
Modified expected location of biblioteq.conf on Windows. Thank you coldacid.
Open Library cover images.
Parameter-based search queries. SQL injections.
PostgreSQL 9.6.13 on W32.
Qt 5.9.8 on W32.
SQLite 3.28 on W32.
March 15, 2019.
Elegant Mac menus.
Happy New Year!
New Other Options setting. If enabled, pretty tool tips will be displayed on the main table.
PostgreSQL 9.6.12 on W32.
Qt 5.12.1 on OS X.
Retain General Search widget states after a query.
Russian translation from Viacheslav Ptsarev. Thank you!
SQLite 3.27.2 on W32.
The Debian package was created on Kubuntu 18.10. The YAZ5 library is expected.
December 12, 2018.
Case-insensitive LIKE operations. Thank you ozgurcan.
Corrected location of the Translations directory on Mac. Thank you Marty.
Corrected mainwindow_canvas_backgound_color setting. Should be mainwindow_canvas_background_color.
Corrected parsing of sub-fields within XML. Some fields must be discarded. Thank you sit42.
Optional unaccent() for PostgreSQL. Thank you ozgurcan.
Prevent abnormal termination during image download. Thank you sit42.
Qt 9.6.7 on W32.
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.
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.
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.
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.
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.
Allow usage of QHttp in place of QNetworkAccessManager. Source only.
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.
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 220.127.116.11 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.
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 18.104.22.168 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.
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.
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.
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.
New OS X bundle.
Updated Windows Qt libraries to 4.7.0.
September 5, 2010.
Recreated BiblioteQ-6.41.pkg.zip for Mac OS X.
April 18, 2010.
Version 6.41 is ready for immediate use.
Introduced a mechanism for converting 13-digit ISBNs to 10-digit ISBNs.
Resolved a potential branch-ordering issue if a misconfigured biblioteq.conf is installed.
April 10, 2010.
Released version 6.40.
Displaying connection information.
Resolved an incorrect window title.
February 20, 2010.
Version 6.39 is now available.
Fixed an OS X Font Selection crash.
New feature: File->New SQLite Database.
The main window's title now references the currently-opened SQLite database.
Updated PostgreSQL sections in order to eliminate warnings.
January 10, 2010.
Version 6.38 is available.
Added an icon to the Windows executable, per David Bolton.
In the process of simplifying translation support.
The Windows version has been upgraded to utilize Qt 4.6.
The current category is now retained.
Updated the Administrator Guide document.
October 26, 2009.
In the process of re-releasing the software bundles.
Modified documentation files.
Removed obsolete translation files.
October 23, 2009.
Version 6.37 is being released.
Eliminated the paging mechanism for SQLite databases on Windows due to plugin restrictions.
OS X and Windows versions have been upgraded to use Qt 4.5.3.
Please update your database schemas by executing the statements under version 6.37 of the postgresql_update_schema.sql and sqlite_update_schema.sql files.
Simplified book editions.
Thank you Robert (fmra357) for discovering the SQLite issue on Windows.
October 2, 2009.
Version 6.36 will be available shortly.
Fixed an incorrect error dialog.
Improved the image download mechanism.
Modified the format in which images are stored. This update eliminates some database warnings.
New BiblioteQ icon.
Other miscellaneous improvements.
August 19, 2009.
Version 6.35 is now available.
Support for multiple Z39.50 sites.
Updated biblioteq.conf settings.
Version 6.22.4 is the final release under the 6.22 branch.
July 13, 2009.
Versions 6.34 and 6.22.4 are available.
Additional verification dialogs.
Fixed the 6.22 OS X installer.
Improved the progress dialogs.
Resolved translation issues.
June 12, 2009.
Versions 6.33 and 6.22.3 will be available shortly.
Implemented a paging mechanism. This new addition should simplify the navigation of large databases. By default, pages will contain at most 25 entries.
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.
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.
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.
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.
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.
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.
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.
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.
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.