BiblioteQ is a professional archiving, cataloging, and library management suite. The software is available for all major operating systems and should be compatible with any system that supports Qt. BiblioteQ is distributed with a BSD license.
ARM architecture support.
Alpha architecture support.
Anti-censorship through digital content.
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 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, 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.
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.
Natively compiled on ARM, Alpha, 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.
PostgreSQL and SQLite engines.
Print support, including previews.
Qt 5 LTS and Qt 6 LTS support.
Rich search capabilities, including custom SQL queries.
Row-level security policies for PostgreSQL.
SQL syntax highlighting with custom colors.
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.
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.
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 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 184.108.40.206 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 220.127.116.11 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 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.
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.