ZDBase is a free Datamanagement for Alibre Design and Alibre Atom3D
ZDBase Launcher App
ZDB Launcher with all modules.
ZDBase Alibre Design Viewer mit Voransicht von 3D-Teilen, Baugruppen, Blechteilen und 2D-Zeichnungen
Above, a specific term was searched... With over 40,000 files, all files in which this term appears anywhere are found in less than a second!
The SQLite database is extremely fast and very efficient and compact, even with very large amounts of data!

ZDBase DMS Document Management System

First things first: your existing folder structure will NOT be touched.
Everything remains as it is! The ZDB drawing management for Alibre Design EXP, PRO and Atom3D automatically reads the drawings into a fast SQLite database and also works without an Alibre licence (e.g. in Production planing).

NEW Drawing-Management and Database for Alibre Design and Atom3D, inclusive "Where used".

With ZDB Alibre Drawing Management you import all information from your drawing inventory into a super fast SQLite database. Individual Alibre files or directories with subdirectories can be imported fully automatically. All General Properties, Standard Properties
AND Custom Properties are considered and imported cleanly into the database. This gives you the possibility to search for all contents within all Alibre files. Furthermore, information is displayed where a certain component has been used or where a 2D drawing of it already exists.
Another new feature is the option to sort by files with high activity. This means that the list of all files can be sorted according to the number of save operations. This gives you a good overview of which components and projects are being worked on and how much, especially in a multi-user environment.

News:

v2024.11.14

  • All components like Parts, Shetmetal, BOM and Assemblies are now listed in 2D drawings. You can therefore select individual components and immediately see the linked 3D file in the preview.
  • Search in all Metadatas. In the custom Properties also!Allow any expressions in the second argument of the RAISE function.
  • The aggregate function group_concat() has been corrected so that it returns an empty string and not NULL if it receives a single input value that is an empty string.
  • The generate_series() table-valued function has been improved so that it is able to recognize and use constraints on its output value.
  • Performance optimizations:
  • Improved reuse of subqueries associated with the IN operator, especially when the IN operator has been duplicated due to predicate pushdown.
  • Use of a Bloom filter for subqueries on the right side of the IN operator in cases where this is likely to increase performance.
SEARCH EXAMPLES:
- which parts you have defined with a certain material?
- which parts, assemblies, drawings all belong to project XY?
- what is the change index for part ABC?
- in which project was a certain part used?
- which manufacturer supplies what?
- which supplier delivers what?
- which is the largest file?
- which projects were processed in December 2020?
- Display of the standard properties
- Display of user-defined properties
Where used? Yes!
  -> In which assembly was a certain part used?
  -> Does a 2D drawing of a 3D part or assembly already exist?
  -> In which 2D drawings was a particular part used?

You can search for any term and combination!

"We have been working with the ZDB-Tool Tool for a year now and are very satisfied with it. It speeds up the search considerably and reduces the error rate at the same time. We can only recommend it to everyone. Above all, it is already integrated in Expert, which is surprisingly positive anyway and has to be purchased at a very high price from our competitors. Personally, I can only recommend everyone to take a closer look at this lean and fast search tool  :-)"

DOWNLOAD
All programmes are bilingual in English / German. The language is automatically detected.

New functions Release 2024.11.14 (November 15, 2024)

v2024.11.14

  • All components like Parts, Shetmetal, BOM and Assemblies are now listed in 2D drawings. You can therefore select individual components and immediately see the linked 3D file in the preview.
  • Search in all Metadatas. In the custom Properties also!Allow any expressions in the second argument of the RAISE function.
  • The aggregate function group_concat() has been corrected so that it returns an empty string and not NULL if it receives a single input value that is an empty string.
  • The generate_series() table-valued function has been improved so that it is able to recognize and use constraints on its output value.
  • Performance optimizations:
  • Improved reuse of subqueries associated with the IN operator, especially when the IN operator has been duplicated due to predicate pushdown.
  • Use of a Bloom filter for subqueries on the right side of the IN operator in cases where this is likely to increase performance.

 

New functions Release 2024.9.20 (September 20, 2024)

  • Thumbnail preview now also in the print templates ----->
    The language of the print template is recognized automatically.
    You can create any print templates yourself.

  • Improved robustness when parsing tokenize= arguments in FTS5.

  • Improvements in the prediction of covering indices in the Query Planner. Added early detection of overprediction of covering indexes so that sqlite3_prepare() returns an error instead of just generating bad bytecode.

  • The number of terms in a VALUES clause must not be limited by SQLITE_LIMIT_COMPOUND_SELECT, even if the VALUES clause contains elements that look like ariables due to string literals in double quotes.

  • Fixed the window function version of group_concat() to return an empty string if it has one or more empty string inputs.

  • Fixed false positive integrity check reports on corrupted indexes in FTS5 secure delete mode.

  • Syntax errors in ALTER TABLE should always return SQLITE_ERROR. In some cases they used to return SQLITE_INTERNAL.

  • Other minor fixes.
ZDBase print template including file preview...

New functions in Release 2024.8 (09. August 2024)

  • Thumbnail previews of parts, assemblies, sheet metal parts and 2D drawings
  • Improvement of PRAGMA optimize in several ways to make it easier to use.
  • Improvements to date and time functions.
  • Added support for underscores (“_”) between digits in numeric literals.
  • Added the json_pretty() SQL function.
  • Query planner improvements.
  • Allocate additional memory from the heap to the SQL parser stack when that stack overflows, instead of reporting a “parser stack overflow” error.
  • The PRAGMA integrity_check command has been corrected to work on read-only databases that contain FTS3 and FTS5 tables.
Thumbnail Zeichnungsvoransicht in ZDBase DMS PDM Document Management System

New functions release 2024 (January 17, 2024)

  • Improvements in the optimization of subquery columns.
  • Correction of errors when reading over the end of memory buffers and other specific situations as well as improvements in the query optimizer.
  • Improvements to the query planner, new functions and security improvements.
  • Improvements in handling SQL functions that could break and other bug fixes.
  • Fixed a performance regression in the Query Planner and applied fixes for various security issues.
  • Fixes for incorrect results for certain queries and other issues.
  • Bug fixes other obscure bug fixes.
  • Fixes for UAF errors, memory leaks.

New functions release 2024 (January 05, 2024)

  • Evaluation of files with high activity added by general request. Can be found in the DB Viewer in the last column labeled Count.
  • Already runs with Alibre Design V27 SP Buid 27039
  • Some internal optimizations made.

New functions (July 21, 2023)

  • The setup program now has a valid certificate.
  • Already runs with Alibre Design V27

New functions release 2.21 (January 26, 2023)

  • ZDBViewer.exe can now be started with a search term as a parameter. We will soon provide an Alibre script that searches for a loaded Alibre file in the drawing database. This will show you whether a 2D drawing of this file already exists or where it has been used.
  • Update to the latest sqlite3.dll (3.40.1.)
  • Also available as a ZIP file for portable installations or simple updates

New functions (January 12, 2023)

  • The drop-down list with the file types had a malfunction, which is now fixed.
  • An additional sorting function for the DataGrid has also been implemented.
  • A few optimizations. Among other things, a field type in the DB has been optimized from DATETIME to VARCHAR.

New functions (January 05, 2023)

  • Works with the latest version 26 of Alibre Design Expert, Professional and Atom3D.
  • Some internal functions have been optimized.

New functions (February 22, 2022)

  • Empty files with 0 bytes are automatically sorted out.
  • Some internal functions have been optimized.

New functions (November 24, 2021)

  • Now also works with Alibre Design and Atom3D V23 and V24.
  • Some internal functions have been optimized.

New functions (March 15, 2021)

  • All ZDB modules are now bilingual (English and German), the language is automatically recognized and the modules start in the set Windows language.
  • A separate, additional data field for private data has been implemented in the viewer. You can save an additional note there when browsing the data records and search for it later.
  • ZDBImport.exe and ZDBConstituents.exe can now run simultaneously in the background without causing a write conflict in the database.
  • A new limit field has been added to the display of data records, especially in the live search. This means that the data records found are displayed more quickly, which is particularly advantageous with a large database.
  • Other small bugs have been fixed.

New function (February 24, 2021)

  • As of this version, you can add additional files to the file currently selected in the ZDB viewer. These can be added via drag & drop or directory by directory. This gives you an overview of all files that are related to a specific project and a specific file.
  • We have also created a launcher that combines all ZDB apps in one interface. Among other things, you can enter ZDB imports and ZDB components into the task planner with a single click.
  • The BOM Viewer is now also part of the ZDB apps.
  • Some bugs have been fixed. (e.g. incorrect file names for Constituents.exe)
  • Alternatively, the ZDB apps can also be installed with an installer.
  • The best thing is that all apps are free and portable :).

New function (January 22, 2021)

  • All assemblies in which a specific component has been installed are listed.
  • In addition, all 2D drawings of a specific component or assembly are listed if there is a 2D derivation of it.
  • The print function has been released (even without sponsoring).
  • Sponsoring is now optional.
  • Various bug fixes.
Operation instructions
After you install ZDB Setup and start it for the first time, you can proceed as follows:
(FYI: Your file structure will not be touched! All your files remain in place).
Start the Launcher.exe
The Launcher App starts all existing programme modules in one interface.
We recommend that some regularly running applications can be entered into the Windows Task Scheduler.
The scheduler can do this for you and also delete the task again.
ZDBase Launcher App for Alibre Design

Now start the programme ZDBImport.exe

This reads in all Alibre files from a freely definable directory.
We recommend that you run this module regularly so that changes to the database are adopted and the database is always up to date. (In the scheduler, the programme runs in the background.)
(This can be conveniently entered into the Windows task scheduling with the launcher above.)
ZDBase Import Alibre Design Data

 The first import of all Alibre file information may take a little longer depending on the amount of data. This concerns the  Launcher-Button:

 

Start ZDB Importer...

 

After that, these programm only took a few seconds per run!


Then start the programme ZDBConstituents.exe
This programme searches for all components of an assembly or a drawing.
We recommend that you run this module regularly so that changes to your parts, assemblies and drawings are adopted and the database is always up to date. (In the scheduler, the programme runs in the background.)
(This can be conveniently entered into the Windows task planning with the launcher above.)
ZDBase Import Alibre Design Constituents

 The first import of all constituents take longer depending on the amount of data.

This concerns the  Launcher-Button:

 

Start ZDB Constituents...

 

After that, these programm only took a few seconds per run!


Now you can only work with the ZDBViewer.exe
From now on, you can search in the viewer for everything in the properties, parts lists or file names. Furthermore, a print function is available to print out the corresponding data sheets.
ZDBase Alibre Design Viewer with preview of 3D parts, assemblies, sheet metal parts and 2D drawings
ZDBase drawing management and file management for Alibre Design and Atom3D...
Buy or sponsor it so that ZDBase can be further developed.
Thanks to your purchase or at least a fair donation, ZDBase for Alibre Design and Atom3D can be continuously developed and maintained since February 2020.
The hint box will no longer be displayed when purchasing or sponsoring.
Our thanks therefore go to all fair Alibre users who help with this small but fine project!