DB Navigator Releases

From ISP_RAS

Contents 1 LSB Navigator 1.9 (2008-06-23) 1.1 New Features 1.2 Bug Fixes 2 LSB Navigator 1.8 (2008-04-03) 2.1 New Features 2.2 Bug Fixes 3 LSB Navigator 1.7 (2008-02-11) 3.1 New Features 3.2 Bug Fixes 4 LSB Navigator 1.6 (2007-12-13) 4.1 New Features 4.2 Bug Fixes 5 LSB Navigator 1.5 (2007-10-30) 5.1 New Features 5.2 Bug Fixes 6 LSB Navigator 1.4 (2007-09-27) 6.1 New Features 6.2 Bug Fixes 7 LSB Navigator 1.3 (2007-08-03) 7.1 New Features 7.1.1 Administration Mode Changes 7.2 Bug Fixes 8 DB Navigator 1.2 (2007-06-05) 8.1 New Features 8.2 Bug Fixes 9 DB Navigator 1.1 (2007-04-28) 9.1 New Features 9.2 Bug Fixes 10 DB Navigator 1.0 (2007-04-13) 10.1 New Features 10.2 Bug Fixes 11 DB Navigator 0.1 (2006-12-12) 11.1 New Features 11.2 Bug Fixes (bugs in the old dbadmin)

LSB Navigator 1.9 (2008-06-23)

New Features

1. New subsection in the 'Linux Applications Analysis Center' - 'Interpreters Usage Frequency'
2. Comments for non-LSB libraries used by applications is now showed on the basis of the LibraryAttribute table.
3. More consistency checks - excluded types used as parameters and return types of included interfaces.
4. Tests and Coverage pages speed up (about 2 times faster now).
5. Interface search speed up (about 2 times faster now).
6. Support for several versions of one included symbol on the same architecture.
7. The concept of manually maintained 'List of Approved Libraries' is introduced, for which we guarantee presence status in distributions (i.e. explicitly search for each library from the list while analyzing distributions).
8. New section in the admin mode - 'Approved Libraries Presence in Distributions'.
9. Notes about data completeness on libraries and interfaces home pages (on the basis of the new ApprovedLibrary table).
10. Architecture filter is now disabled on those pages where it doesn't make any sense
11. 'Class Usage by Applications' statistics is displayed on the class homepage (with possibility of obtaining list of such applications as well as lists of particular symbols used by every app).
12. Added search for headers.

Bug Fixes

1. In the Interface search results sometimes less than 500 entries were displayed while actually there are more than 500 corresponding records in the db.
2. If interpreted language module in a distribution is provided by several components, then only one component was displayed.
3. When requesting applications using the symbol on the 'excluded ints usage' page (clicking on 'list...'), incorrect data was sometimes displayed for symbols provided by more than one library.

LSB Navigator 1.8 (2008-04-03)

New Features

1. New Decision Making Support section gathering different statistics for any given set of symbols in one table (available in the Administration mode only).
2. Filter by library is implemented on 'Included Ints Usage', 'Deprecated Ints Usage' and 'Excluded Ints Usage' pages
3. 'Voting' for interfaces in addition to comments. One can vote for adding symbol to the LSB (for not-included symbols) or for deprecating symbol (for included ones).
4. 'Count Rejected Libs/Ints' filters on pages from the AppStats section.
5. New consistency checks:
   • Checks for function kind (are constructors/destructors marked properly)
   • Inconsistencies between some ClassInfo fields and Vtable records
   • Incorrect Vtable entries
   • Included Headers with incorrect libs
   • Excluded types used as parameters of included interfaces
6. Easy configurable email notification about new interface comments/votes.

Bug Fixes

1. Elimination of filter side effects (tricky cases when one sees '7 (list...)' but after clicking on 'list' gets 2 entries due to filters).
2. 'Exact match' for interface search is now case insensitive. Previously symbols with the same name as search pattern but with case differs went to 'Not Exact Match'.

LSB Navigator 1.7 (2008-02-11)

New Features

1. 'Standards' subsection in the 'Workgroup Services' is redesigned. Main page now contains the number of interfaces, commands and ELF section types documented in each referenced standard (with the availability of getting the full list of such items). Every standard has a home page with more detailed information. Values in the 'Standard' column in interfaces, commands and section types lists are now urls to home pages of the appropriate standards.
2. Return type names in interface lists are now urls to home pages of appropriate types.
3. Filter by functional category added to the AppStats pages. Filter by library added to the 'Excluded Interfaces Used by Apps' page.
4. Advanced filters are available on AppStats pages.
5. New subsection in the 'LSB Elements' - 'Interpreted Languages'. Administrative interface for interpreted languages is also available.
6. Now the number of perl/python modules used is displayed for every application.
7. Information from new Ldeprecatedsince and SMdeprecatedsince fields is displayed.
8. Command recommendations (if any) are displayed on command home page.
9. 'Deep', 'Normal', and 'Shallow' values are used as possible test quality levels in the test coverage statistics (to replace the obsolete Primary, Secondary, Called).
10. New 'Total tested' column on the 'Tested Interfaces' page.
11. Application list is now divided into pages (500 apps per page).

Bug Fixes

1. Links to application home pages were formed incorrectly for Aurl fileds not starting with 'http'.
2. At the 'Statistics' page, when list of included interfaces was displayed, compiler specific c++ things (vtables, typeinfos, etc.) with the same names from different libs were counted as one entry. The main statistics page was not affected and contained correct numbers.
3. For early LSB versions (1.0 - 1.3) 'included' elements were displayed on some pages for architectures that were not actually supproted at that time.

LSB Navigator 1.6 (2007-12-13)

New Features

1. Pages from 'Tests and Coverage' section now contain filters for documented/undocumented and deprecated interfaces.
2. New 'Deprecated Interfaces Usage' subsection in the Application Statistics
3. Tooltips with short explanations added for filters in 'App Stats' section.
4. "Distribution Type" in Application Statistics filters renamed "Licensing". New possible value - 'Mixed' - added. 'Command Line' renamed to 'non-GUI'. 'Application Group' renamed to 'Vendor'.
5. New 'Mandatory since' column in tables with lists of libraries, commands and interfaces + on library and command home pages.
6. For libraries, classes, commands, types and constants on their home pages a short status is displayed now directly in title, as it was already done for interfaces ('Included'/'Never Been in LSB', etc.)
7. For interfaces that were not mandatory for some time (such as Qt4 or new 'Trial Use' modules) additional field is displayed in LSB Status with LSB version where the interface became mandatory. For interfaces from 'trial use' modules 'Trial Use' is also displayed in short status.
8. On 'Interfaces Required by Application' and 'Non-LSB Interfaces Required by Application' pages interface recommendations are now displayed, if any. The latter page will also contain notification in case when interface is included in LSB version which is greater than current 'LSB Version' filter value.
9. In titles like '... used/required, but not included in LSB' LSB version is now added (version is taken from filter, if it has some real value; if 'No filter' is set, then 'any LSB version' will be used).
10. Private interfaces are not taken into account when calculating test coverage statistics. Note, however, that at the moment the database provides such information for Qt3 interfaces only (will be fixed as we re-import other data).
11. Interfaces on Statistics pages are sorted first by Library name, then by Interface name.
12. On 'DB Consistency' page Ireturn=0 is not considered as error for constructors, destructors, thunks, 'vtable for' and 'typeinfo' interfaces, as discussed in Bug 1774 (Note, however, that constructors are detected using 'Ifkind' field, which is set properly for Qt3 only.)
13. Components are now divided on pages (500 components on each page). So 'Components' page is displayed much more faster now.
14. 'Libraries' page speed up.

Bug Fixes

1. On 'Interfaces from ... Library' pages in the 'Distro & Apps' section links to interface pages were set using only interface names. This sometimes led to inconsistency for interfaces which are present both in Qt3 and Qt4 - when clicking on interface from Qt4, one could be redirected to page for the same interface from Qt3, and vise versa.
2. All constant search results, even in case of exact match, were placed in the 'Not Exact Match' section.
3. 'Presence in Distributions' section on class home pages could be empty when the page is requested by mangled class name.

LSB Navigator 1.5 (2007-10-30)

New Features

1. Speed up of pages from 'Application Statistics' section. They now work faster though there is still a lot to do in this area. Some other pages concerning interfaces and classes also work faster.
2. Type members are displayed for complex types on their pages.
3. Number of search results is limited to 500 in order to not overload server.
4. In application statistics, for non-LSB interfaces, additional comments are now displayed:
   • for those interfaces that were withdrawn from the specification, LSB version where they were withdrawn is displayed;
   • for interfaces included in the LSB but assigned to a library that is not in application NEEDED libraries list, the appropriate message is displayed.
5. Thunks, guard variables and typeinfo* interfaces are not taken into account when calculating test coverage.

Bug Fixes

1. 'Precense in all distributions' verdict could be shown sometimes even if interface is abcent on Debian 3.1r2.

LSB Navigator 1.4 (2007-09-27)

New Features

1. Users can now leave comments on single interface pages. In order to do it, users should first log in in the linux-foundation wiki. Note: 'lsbuser' should be granted to perform 'INSERT' into the InterfaceComment table.
2. Library usage on all pages is now calculated on the basis of interface usage and interface<->library mapping, in addition to usage calculated on the basis of 'DT_NEEDED' sections.
3. Filters by application category on statistics pages.
4. Thanks to the fact that new distribution data was uploaded, 'Presence in Distributions' pages now do correlate with the real state of affairs. I.e. if an interface is reported to be missed in some distributions, then it is really absent there (at least, without any additinal packages not included in the standard repository).
5. Single pages for every type with short information and usage in interfaces.
6. Parameter types in the interface synopsis are now clickable and lead to the appropriate type pages.
7. Search for constants is now available; search is performed by name and by value. Constants can be also selected by first letters.
8. Search for types is also available, and types can also be selected by first letters.
9. Redesigned LibGroups and Header Sections main pages - lib groups are grouped by libraries, header sections - by headers, short content information is displayed.
10. Interfaces in 'Interfaces used by application' lists are now grouped by libraries for more comfortable analysis.
11. 'Consistency Check' page now contains summary table with all checks results.
12. For interfaces which have been withdrawn and then put back the "Appearance in the LSB" section now shows short information about every period of 'presence'.
13. 'Statistics on LSB Elements' page now contains statistics for libraries and classes. By default, statistics is shown for the last released LSB version and development versions (if any), information for older versions can be obtained by simple click.
14. Interfaces in 'Non-LSB ints used by applications' in 'App Stats' section are now grouped by name & library.
15. On the 'Headers' page number of classes for each header is displayed (with possibility to get a list of these classes).
16. 'Interface Parameters' page in the admin mode now displays current interface synopsis.
17. In 'Non-LSB Ints used by Application' there is a new column showing how many apps use the interface.
18. List of apps that use interfaces from a given library is available on single library pages.
19. Attributes for RawInterfaces can be added and modified in the admin mode now. Just switch to the 'Administrtion' mode from the interface individual page.
20. For each distribution release date is displayed.

Bug Fixes

1. Extra version was assigned to raw library name when the name itself contained version (e.g. 'libgtk-x11-2.0-2.0').
2. When returning to 'browse' mode from the 'admin' on 'Interface Parameters' or 'Interface Attributes' page, user was redirected to main interface page. Now he is redirected to the appropriate interface page.

LSB Navigator 1.3 (2007-08-03)

New Features

1. New 'Linux Applications Analytical Center' (App Stats section of Workgroup Services) with different statistics on interfaces and libraries used by applications in LSB perspective.
2. Search for applications - search is performed both in application names and summaries.
3. Individual application 'home pages' containing summary information about each application (original homepage, versions uploaded to the database, LSB compliancy, etc.).
4. Navigator now uses LSBVersion table to form different version filters.
5. Interface lists are now collapsed and grouped by name; architecture specific information (if any) can be observed on the interface home page.
6. Orphan constants are now displayed in browse mode. Previously only information about constants assigned to any header could be obtained.
7. Unmangled type names are used in the 'Types' section.
8. Statistics about distributions (number of components, libraries, commands and classes) is now displayed on the main 'Distributions' page.
9. "No filter" value is now on the top of all possible values in all filters.
10. Library is displayed for the full lists of LSB and 'raw' interfaces.
11. Links to module for libraries and commands on their individual pages, link to header on interface pages.
12. Interface status is now displayed shortly on home page directly in 'LSB Status' heading.
13. 'Show Full Information' link is available for lists of interfaces from a given library.
14. Library names are now displayed instead of Standards in the interface search results.
15. In the 'Interfaces Used by Application' libraries required by applications is now taken into account, so in case when more than one interface with the same name exists in the database the proper one will be selected with libraries taken into account.
16. 'Coverage Provided by Test Suites' page now has a 'Total' line.
17. On 'Coverage Provided by Test Suite' page records are grouped by test case.
18. 'Select by letter' bar for Classes, RawLibraries, RawClasses, RawCommands, RawInterfaces and Applications pages.
19. Classes are now sorted by unmangled names instead of mangled ones.
20. Improved individual Library pages - 'Presence in Distributions' section is displayed more gracefully (like the same section on interface pages - using javascript and with 'absence' section). Now it is possible to get list of applications that require a library and list of tests for interfaces from library.
21. Library name on home class pages is now a hyperlink to the appropriate library page.
22. New style - the new one from the linux-foundation.org.

Administration Mode Changes

1. New folder - admin_community. This folder is aimed to store scripts for community tables administration. Note: Access to this folder should be restricted as well as to 'admin' folder.
2. Interface for uploading applications (on the 'Applications' page in the Administration mode).
3. After adding new entity in the administration mode, page reloading doesn't lead to new insertion attempt.
4. 'Select by Letter' is available for Classes and Commands in the Administration mode.
5. Error messages in the administration mode are now displayed using red bold font.

Bug Fixes

1. Links to libraries from "Libraries Used by Application" page could become broken on architecture filter change. Now architecture filter is disabled on such pages, since the page contents always belongs to the particular architecture and cannot be affected by filters.
2. Fixed interface synopsis: for parameters of 'FuncPtr' kind the arguments were not displayed and sometimes MySQL errors appeared.
3. MySQL error arose on some class pages in the "BaseType Entries" section. Corrected.
4. Synopsis of 'Common' and 'Data' interfaces is now displayed correctly.

DB Navigator 1.2 (2007-06-05)

New Features

1. New pages for adding interfaces and types. See http://ispras.freestandards.org/index.php/LSB_DB_Navigator#Add_New_Type and http://ispras.freestandards.org/index.php/LSB_DB_Navigator#Add_New_Interface for details.
2. Browsing of tests provided by test suites is improved - cross-links added, comments (useful for cases of calls from libraries), target LSB versions are now taken into account (and there is a version filter on pages with tests information).
3. Unmangled type names are now displayed in interface synopsis.
4. For a single interface not only presence but also absence in distributions is displayed now.
5. Full information about interface presence in distributions is now shown on demand only. By default a short summary is displayed.
6. Brief information about tests for interface (if any) is displayed on its page.
7. When displaying interface covered by test suite, records are grouped by interface names and ordered first by quality and then by name.
8. References to System V ABI and LSB in Elf Sections and Section Types descriptions are now hyperlinks and lead to the appropriate documents.
9. The 'Search' field value is not erased now after 'Search' button is pushed.
10. Multicolumn lists with no decorations in the LSB Elements section are replaced with decorated tables.
11. Values of interface attributes of 'Recommendation' type (from the new InterfaceAttribute table) are now displayed in the 'Recommendations' section of interface page.
12. Page in the Administration mode for the new InterfaceAttribute table. Recommendations for interfaces as well as 'BinOnly' flag can be set there.
13. Links from search results in the admin mode now lead to the appropriate pages in the administration mode.
14. Icandidatefor information is displayed (if any) for interfaces not included in the LSB on their pages.
15. Class information (base classes and virtual tables) is now displayed in a more structured and clear way.
16. Improved search results look; now some additional information about elements found is displayed.
17. Improved interface search; now class methods are handled in a more intelligent way.
18. When deleting elements in the admin mode, confirmation is asked.
19. In 'Interfaces by Header' and 'Interfaces by LibGroup' lists unmangled names are displayed for c interfaces.
20. All pages are now valid XHTML 1.0 transitionals.

Bug Fixes

1. Empty lines could appear in comboboxes in the administration mode.
2. LibGroup names on the interface page in the admin mode are now displayed without character escaping.
3. Class search - for not exact match found in the RawClass only invalid link was printed.
4. Some more situations leading to php warnings in webserver log are wrapped. However, some situations of this kind still exist.
5. Some problems concerning MySQL 4 usage and its handling of 'join' statements corrected. Sometimes they could lead to MySQL 'ambiguous field' errors.
6. 'tmp_Interface table already exists' error was shown on the Interface page when requesting interface list from a given library on a given architecture.
7. When modifying a single interface information, the same Iurl was set for all entries.
8. If there was no record in the LGInt table for the given interface, then after assigning it to a certain libgroup new record was not added and actually interface was not assigned.
9. Synopsis for interfaces of 'Alias' type was displayed incorrectly (Bugzilla 1649).

DB Navigator 1.1 (2007-04-28)

New Features

1. Browsing of Test Suites and interfaces covered by them using improved specdb tables.
2. Navigator now uses 'lsbtester' instead of 'lsbadmin' in the 'browse' mode. Note that this user should have 'CREATE TEMPORARY TABLES' privilegy. 'DROP' privilegy is not required any more.
3. New 'Provide Feadback' page and link in the upper-right corner.
4. Switching to/from 'Administration' mode is improved. On some pages (About, Help, Provide Feedbach, Search Results) switching to the 'Administration' mode is denied. On all other pages after clicking 'Administration' link user will be redirected to a file from the 'admin' folder, so it is available to protect 'Administration' mode by means of web server by setting special access permissions for the 'admin' folder. In the 'admin' mode user can switch between different sectiones without leaving to the 'browse' mode (even between sectiones where 'admin' mode is not supported).
5. '\' symbols are not displayed in macro values.
6. Names in raw libraries and raw commands lists are now clickable - they link to the appropriate pages for library or command with this name.
7. Admin mode perfomance is greatly improved - in earlier dbadmin there were a lot of places in html generated where one could see large amount of the same huge dropdown boxes. Now such boxes are created on the fly (using javascript) and therefore there is only one copy of the box in the html generated. In many cases this has greatly decreased the generated html size and therefor generation time.
8. On the main Classes list classes are now grouped by their names.
9. '3.2 (devel)' added to possible LSB versions
10. New logo.

Bug Fixes

1. When redirecting from LSB Elements section to a single page for a class, command, library or interface, section was switched to the 'Distribution'. Corrected.
2. A lot of php warnings that were printed to a web server's log eliminated for both 'admin' and 'browse' mode.
3. Back slashes sometimes were not escaped correctly when entered in the 'search' field.
4. When browsing multipage list, filter changes could lead to total number of pages decreasing and if the current page number was greater than the new total number, "no records" warning was shown. Now on filter changes the current page number is always set to 1.

DB Navigator 1.0 (2007-04-13)

New Features

1. Browsing of Distributions and Application contents.
2. Search among interfaces, classes, libraries and commands.
3. Individual pages for interfaces, commands, libraries and classes with the following key features:
   • Links to documentation for interfaces and commands.
   • Presence in distribution for all elements.
   • Full LSB history (in which version appeared/was withdrawn on every supported architecture).
   • Synopsis and usage by applications for interfaces.
   • Base class information for every class.
4. New Workgroup Services section involving information about test suites and their coverage, statistics and list of standards referenced by the LSB Specification.
5. Filtering by architecture and LSB version.

Bug Fixes

1. Bug 1167 (incorrect writes for special symbols in 'admin' mode).
2. Bug 1106 (dbadmin doesn't handle quotes inside strings).

DB Navigator 0.1 (2006-12-12)

New Features

1. New design, the same as used on freestandards.org site, new navigation panel.
2. Regrouping pages describing LSB artifacts. LSB artifacts are now subdivided to LSB ABI, Commands, ELF Artifacts and RPM Artifacts.
3. New 'Tests and Coverage' page that includes some queries from old 'Status' page and two new summary reports ('Covered interfaces' and 'Coverage by test suites').
4. Pages for browsing and adding commands are implemented.
5. New pages to browse module contents.
6. All interfaces for a given library (i.e. from all its libgroups) can be now obtained directly from 'Library' page, by pressing new 'Interfaces' button.
7. On 'Constant' and 'Type' pages when displaying a list of headers the number of constants/types in each header is displayed in the brackets.
8. New 'DB Consistency' page that includes all consistency checks from old 'Status' page. New checks should be added here in future.
9. Speed improvements - with the specdb release 0.2 queries dealing with Constant and Header in DB Navigator work much more faster. With the specdb release 0.3 queries dealing with TypeMember and ArchType also work faster.

Bug Fixes (bugs in the old dbadmin)

1. Corrections in queries for browsing interfaces to make them MySQL5-compatible.
2. Trouble when going to interface from 'Status' page.
3. Trouble when going to header from 'Status' page.
4. Sometimes in the list of interfaces the interfaces without names were displayed (i.e. only "()" string), clicking by such "interface" led to mysql error.