Release v6.2.2

Full Changelog: v6.2.1...v6.2.2

Features:

Fixes:

• javadoc: remove errors
• schemaspy.schemas usage throws exception

Release v6.2.1

Full Changelog: v6.2.0...v6.2.1

Fixes:

• pgsql11: update catalog query
• connectionconfig: missing alias for password
• docker: only include -app.jar in image

Release v6.2.0

Release v6.2.0 (2023-03-20)

Long awaited release

Full Changelog: v6.1.0...v6.2.0

Below you will find the basic statistic about the project:

• 3.4M Docker Downloads (+3.4M)
• 378.2k JAR Downloads (+308.2k)
• 2490 Stars (+1466)
• 548 Closed Pull Request (+244) - Thanks for all contributions
• 44 Contributors (+14)

18 - Contributors to SchemaSpy v6.2.0

• npetzall
• jesperolsson-se
• aisbergde
• vbro
• ugultopu
• marcelstoer
• edumucelli
• kamyabnazari
• digitalbot
• DanNYSPD
• scottjmaddox
• unusual-thoughts
• FormerlyChucks
• allella
• pgrimaud
• mapausch
• igor-suhorukov
• rafalkasa

SchemaSpy v6.1.0

This is v6.1.0 release (18-09-2019)

I would like to inform you that the next stable release of SchemeSpy 6.1.0 is available.
Working on SchemaSpy it was for us the great honor and make a lot of fun.
Amazing thing is that our community is growing and we have more and more stars in the project.

Below you will find the basic statistic about the project:

• 70k Downloads SchemeSpy
• 1024 Stars
• 304 Closed Pull Request - Thanks for all Contributors
• 30 Contributors

September 2019

If you would like to know more about the changes in the project and fixed issues please read the full log here:
https://github.com/schemaspy/schemaspy/milestone/6

16 - Contributors to SchemaSpy v6.1.0

• npetzall
• karlkauc (j136ifc)
• rafalkasa
• laurencevanq
• igor-suhorukov
• brianrepko
• vonloxley (Niki Hansche)
• osadi
• GabLeRoux
• ShubhamTatvamasi
• francoiskha
• NaimJamalludin
• abitrolly
• abdelgadir (gateet)
• Kamyabnz
• vdaburon

SchemaSpy v6.0.0

This is v6.0.0 release (05-08-2018)

After two years of development, hard work of all community and contributors we are proud to introduce the version 6.0 finally ready.

Based on our opinion we released a very stable version of SchemeSpy 6.0.
Working on SchemaSpy it was for me great honor and make me a lot of fun. Using the opportunity I would like to thank you very much @npetzall for his contribution, engagement and take ownership of the SchemaSpy project.

Amazing thing is that our community is growing and we have more and more stars in the project.

Below you will find find basic statistic about the project:

• 24k Downloads SchemeSpy
• 484 Stars
• 201 Closed Pull Request - Thanks for all Contributors
• 18 Contributors

August 2018

If you would like to know more about the changes in the project and fixed issues please read the full log here:
https://github.com/schemaspy/schemaspy/milestone/7?closed=1

Licence

The SchemaSpy project like initial sourceforge version is maintained based on the LGPL licence. You can read more detail about in this post / issue #206

Contributions to SchemaSpy v6.0.0

• Rafal Kasa
• Nils Petzäll
• Dan Watt
• Thomas Traude
• Wojciech Kasa
• Ismail Simsek
• Jason Stadler
• mapausch
• RMsiemens
• martenbohlin
• laurencevanq
• ClintEstwood
• James Holland
• jornh
• dhermanns
• Bharath Kumar Uppala
• alpha0010
• Johan Van de Wauw
• 0xBADDCAFE

SchemaSpy v6.0.0-rc2

This is v6.0.0-rc2 release (30-09-2017)

I would like to inform you that next stable release of SchemeSpy 6.0 is available.
Working on SchemaSpy it was for me great honor and make me a lot of fun.
Amazing thing is that our community is growing and we have more and more stars in the project.

Below you will find find basic statistic compare to the previous release:

• 3387 Downloads SchemeSpy v6.0.0-rc1
• 188 Stars
• 73 Closed Pull Request - Thanks for all Contributors
• 9 Contributors

Project statistic also look very promise and interesting:

July 2017

September 2017

This release contains many enhancement and bug fixes compare to previous version. Information about the most important changes you can find below.

Enhancement

#7 Minimize layout size as much as possible, and copy all JavaScript and Html plugins locally

All of the html resources are managed by bower and configured in bower.json. This will improve few things like minimize layout size #7, all CSS and JavaScript are available offline #56, #118
Bower local #130

#39 Backwards Compatibility: Number of things missing

This issue contains added some of missing functionalities:

1. -nopages - will switch off default pagination and all tables / views will be displayed on one page
2. To the main page database statistic section was added
   
3. Views was excluded from Orphan Tables module

#57 Update teradata.properties

#61 Update Maven to 3.5.0 (using Maven wrapper)

#62 Support for Amazon Redshift database

#63 Added -imageformat parameter (png, svg) default format is png

This issue is in reference to the others issues extending SchemaSpy to have possibility of generate svg diagrams #41, #59, #60

#64 Support for Cloudera Impala

Impala JDBC driver is quite specific to use this driver with SchemaSpy to the class path more external jars must be added.
To use impala JDBC driver please set -loadjars=true if enabled SchemaSpy will load to the JAVA classpath additional jars used by JDBC Driver. These jars must be located in the same folder where JDBC Driver is located.

#65 Remove the built in Swing GUI as there is a better alternative

There are plans to separate the SchemaSpy core functionality from a GUI into a dedicated project #54

#66 Introduce AssertJ as test dependency, remove JUnit-addons, Refactoring

#67 Fix sonar issue: Remove declaration of thrown exception SQLException

#68 Remove unused class ImageWriter, clean up ResourceWriter

#69 Update Spring dependency to 4.3.8.RELEASE

Update Spring Framework dependency to 4.3.7.RELEASE #53

#70 Update commons-io to 2.5

#72 Support for Maria DB

#73 Add automatic schemaspy@latest deploy from master build

#74 Introduce Spring Boot, update maven plugins

#75 Schema and catalog comments are fetched and passed to template.

#79 Set scope 'test' for mockito dependency, remove duplicate scope

#80 Fix sonar issues

#81 Remove some dead code, mainly in Html generation classes

#82 Add Docker image for SchemaSpy - https://hub.docker.com/r/schemaspy/schemaspy/

Docker image builds: snapshot and release #96
Docker images v2 #104
Docker image unstable #122

#85 Added spring-boot-starter-test

#86 Include nar when loading dp sibling libraries

#87 Refactoring Config: Introduce JCommander to parse CLI arguments

#91 Don't use @autowire in application classes

Replace field injection with constructor injection for some Spring Beans #101

#92 Simple integration test of DatabaseService

#93 Travis-CI doesn't run integrations tests

#94 Table column comments not appearing

#95 Added Oracle test using a fork of testcontainers

#99 Fix link to SonarQube project in README.md

#100 Clean up Config class by removing unused fields, methods, init values

#102 Replace explicit reading of project version with resource filtering

#103 Support for IBM Netezza

#107 Removed usage of fork and added a helper library

#108 Graphviz version 2.26.0 not supported

Skip patch details for Graphviz version #113

#109 Port definition in dbTypes is inconsistent

Ignored port definition in properties file #111
Issue 109 dbtypes #131

#110 Test generated XML against a saved, using MySql container

#112, #114 Decimal type not showing the number of decimals

#115 Support for MySql socket connection dbType

#123 Pinned jre to 8u111, added branch,revision,driver versions as labels

#126 Support Type4 DB2 Database Driver

Added JDBC Type 4 Driver Access to DB2/zos #127

#136 Page details in HTML title tag

#141 Is it called schemaspy (a after m) or schemespy (e after m)

Resolved typo, it was schemespy instead of schemaspy

#151 Display on main page database description in HTML #151

This change is covering backward compatibility with SchemaSpy 5.0.x after information provided after -desc parameter will be visible on main page fix #149
-desc "<b>Connection details:</b></br><b>Host/Port: </b>127.0.0.1:1433</br><b>DBName: </b>Librrary</br>"

#153 Clean code project

Bug

#26 Unable to find layout/schemaSpy.css

#78 Impala support fixes

#83 -template parameter ignored with jar-binary package

#143 HTML files in directory "tables" are not written

#144 Sortable columns in modules TABLES, COLUMNS and CONSTRAINTS

Rename jquery-2.2.3.min.js to jQuery-2.2.3.min.js #146

#147 No "datatables" directory in subdirectory bower/admin-lte/plugins of SchemaSpy-output

Documentation

#55 Fix some typos and wording in docs for installation

#116 Few lines about docker

Contributions to SchemaSpy v6.0.0

• Rafal Kasa
• Wojciech Kasa
• Thomas Traude
• Nils Petzäll
• Ismail Simsek
• mapausch
• ClintEstwood
• dhermanns
• jornh

SchemaSpy v6.0.0-rc1

This is v6.0.0-rc1 release (01-04-2017)

I would like to inform you that first Release Candidate of SchemeSpy 6.0 is available.
This is big step forward and project has more and more enthusiasm and passionate developers.

The project was reactivated by me on Github six months ago. Below you can find short statistic:

• 786 Downloads SchemeSpy v6.0.0-beta.3
• 42 Stars
• 21 Closed Pull Request - Thanks for all Contributors
• 6 Contributors

Below you can look at project statistic from 19th March to 1st April:

This release contains many enhancement and bug fixes compare to previous version. Information about the most important changes you can find below.

Documentation

#14 Build documentation on Github using Sphinx

Finally project start to has documentation hosted on http://schemaspy.readthedocs.io. Community help here and contribution are as always very welcome.

Enhancement

#24 Improvements on implied constraint

Implied constraint logic was improved by @ismailsimsek and recognize more implied relationship between tables. In addition that logic was also covered by UnitTests.

#27 Refactoring of DBSpecificOption

#28 Polish maven pom

Changes in pom.xml files made by @Riggs333 simplify the logic and everything in the file look better now

#29 Refactoring table class

#30 Maven wrapper was added to the project

#31 Remove build.xml (Ant)

#36 Fix for possible leaks. Moved close to finally block.

#45 Added schemaspy.properties with configuration

This is very interested change in new version allow you to configure all SchemeSpy properties and options in simple properties file. You can read more about this change in documentation. @wkasa thank you for that work it is very appreciated.

#48 Orphan Tables

#49 Update teradata.properties

#50 Deep linking anchors

In Table and View pages you will find extra anchors to the main sections. This feature is in my opinion very useful. Implementation was very easy because of use AnchorJS. Thank @jornh for your help to make SchemeSpy better.

#51 Add some missing <h3> id's on Table and View page.

Bug

#33 Specifying the Graphviz renderer - Mac OS

Thank you @rajadain to invent and share with community how to resolve problem with Graphviz 2.40.1 on Mac OS. The best option is use -renderer :quartz

#35 Cross-Schema Foreign Key not working with MSSQL

This was serious bug in the SchemeSpy. Thank you @kjvalencik for found this issue and describe in details step to reproduce.

#42, #43 -all flag causes schemaspy to always exit non-zero code

#46, #47 WARNING exception in DbAnalyzerTest when schemaspy.properties is missing

Contributions to SchemaSpy v6.0.0-rc1

• Rafal Kasa
• Ismail Simsek
• Wojciech Kasa
• Thomas Traude
• jornh
• ClintEstwood

SchemaSpy v6.0.0-beta.3

This is v6.0.0-beta.3 release (04-01-2017)

This is new release fixed issue #26 very serious bug which made it impossible generate the documentation.

Enhancement

#25 fix maven warning

Bug

#26 Unable to find layout/schemaSpy.css

This is fix for very serious bug reported by @saihegde. schemaspy-6.0.0-beta.2.jar don't work correctly and generate documentation was impossible.

Contributions to SchemaSpy v6.0.0-beta.3

• Ismail Simsek
• Rafal Kasa

SchemaSpy v6.0.0-beta.2

This is v6.0.0-beta.2 release (30-12-2016)

I would like to inform you that new version is available. This release contains some enhancement and bug fixes compare to previous version. Information about the most important changes you can find below.

Enhancement

#8 Improve multiple database schemas

With help @ismailsimsek PR #20 right now MultipleSchemaAnalyzer functionality have been restored as was initially created in base project.

#18 added -template parameter

Right now you can provide after the -template parameter directory with your own HTML layout changed or prepared especially for you purposes

Bug

#23 Use long for row count in meta data

This is fix for old bug initially created on sourceforge project https://sourceforge.net/p/schemaspy/bugs/191/

Contributions to SchemaSpy v6.0.0-beta.2

• Ismail Simsek
• Rafal Kasa

SchemaSpy v6.0.0-beta.1

This is first v6.0.0-beta.1 release (12-12-2016)

This SchemaSpy version has been totally rewrote and switched in core section to simple Spring services instead of mixing model and business logic layer together. This is first step to have more tests and improve in the project code coverage.

Changes:

1. The most important change in this version is new HTML pages engine generator built based Mustache https://github.com/spullara/mustache.java
2. Big change for all previous SchemaSpy users is new layout based on AdminLTE bootstrap template https://almsaeedstudio.com/themes/AdminLTE/pages/examples/blank.html
3. One more important change made in SchemaSpy is new look and feel the generated diagrams to see more go to http://schemaspy.org/sample/tables/Customer.html
4. In database comments you can use Markdown language what should improve user experience from reading your database documentation
5. You can also easily create in database comments links to the tables and columns

You can also find how look sample of new SchemaSpy documentation generated version here http://schemaspy.org/

I have plan add more and more changes to this project to be your the best database document generator ever.

To start using new version schema spy try to write in your java console:

java -jar schemaspy-6.0.0-beta.1.jar -t mssql05 -dp C:/sqljdbc4-3.0.jar -db DATABASE -host SERVER -port 1433 -s dbo -u USER -p PASSWORD -o DIRECTORY