An Open Source (CLI) command-line application that helps you output your database schema. #Database schema #Database API #SQL schema #SchemaCrawler #Output #Database
SchemaCrawler is an open source, cross-platform and freely distributed Java API (Application Programming Interface) that has been designed from the ground up to help application developers work easily with database metadata. It is also a database schema documentation utility and database schema comprehension and discovery tool.
The software will help Java developers in finding columns and tables using regex (regular expressions), finding issues with schema design, to use the JavaScript scripting language for scripting against your database, as well as with database diagramming.
Another interesting feature of the SchemaCrawler software is that it supports any JDBC powered database. However, for your convenience, SchemaCrawler includes drivers for some of the most common relational database management systems.
If you want to see a usage example of how the SchemaCrawler software works, please take a look at the example below.
final SchemaCrawlerOptions options = new SchemaCrawlerOptions(); // Set what details are required in the schema - this affects the // time taken to crawl the schema options.setSchemaInfoLevel(SchemaInfoLevel.standard()); final Database database = SchemaCrawlerUtility.getDatabase(connection, options); for (final Schema schema: database.getSchemas()) { System.out.println(schema); for (final Table table: database.getTables(schema)) { System.out.print("o--> " + table); for (final Column column: table.getColumns()) { System.out.println(" o--> " + column); } } }
Taking a look under the hood of the SchemaCrawler project, we can notice that it has been written entirely in the Java programming language. We have successfully tested the software with computers supporting either of the 64 or 32-bit instruction set architectures.
Being written in Java, SchemaCrawler is a cross-platform software that works with any computer operating system where the Java Runtime Environment (JRE) is available, including GNU/Linux, BSD, Microsoft Windows, and Mac OS X.
What's new in SchemaCrawler 12.06.03:
- Fixing links on website.
SchemaCrawler 12.06.03
add to watchlist add to download basket send us an update REPORT- runs on:
- Linux
- main category:
- Database
- developer:
- visit homepage
ShareX 16.0.1
Bitdefender Antivirus Free 27.0.35.146
Context Menu Manager 3.3.3.1
IrfanView 4.67
Microsoft Teams 24060.3102.2733.5911 Home / 1.7.00.7956 Work
Zoom Client 6.0.3.37634
calibre 7.9.0
Windows Sandbox Launcher 1.0.0
7-Zip 23.01 / 24.04 Beta
4k Video Downloader 1.5.3.0080 Plus / 4.30.0.5655
- Windows Sandbox Launcher
- 7-Zip
- 4k Video Downloader
- ShareX
- Bitdefender Antivirus Free
- Context Menu Manager
- IrfanView
- Microsoft Teams
- Zoom Client
- calibre