doteur

Tool to automate the visualisation of SQL schemas from a SQL file

MIT License

Downloads
8.8K
Stars
102
Committers
3

Bot releases are visible (Hide)

doteur - 0.5.6 Latest Release

Published by nag763 4 months ago

Upgrades

  • Optimization of release package size
  • Managing schema name

Downloads

All the downloads can be found here : https://nag763.github.io/doteur/downloads

Road to v0.6.0

  • Fixes and better parsing
  • Postgres support

Full Changelog: https://github.com/nag763/doteur/compare/0.5.5..0.5.6

doteur -

Published by nag763 10 months ago

Upgrades

  • This release upgrades the dependencies of the crate.
  • It also upgrades the rust version.
  • Temporary file for rendering is now created in temporary dir
  • Partial postgres support

Downloads

All the downloads can be found here : https://nag763.github.io/doteur/downloads

Road to v0.6.0

  • Fixes and better parsing
  • Postgres support

Full Changelog: https://github.com/nag763/doteur/compare/0.5.2...0.5.3

doteur -

Published by nag763 about 2 years ago

Global upgrade of dependencies

This release upgrades the dependencies of the crate.

Downloads

All the downloads can be found here : https://nag763.github.io/doteur/downloads

Road to v0.6.0

  • Fixes and better parsing
  • Postgres support

Full Changelog: https://github.com/nag763/doteur/compare/0.5.2...0.5.3

doteur - Fix dependalerts

Published by nag763 over 2 years ago

Mitigate dependabot alerts

This release mitigate dependabot alerts on GitHub.

Downloads

All the downloads can be found here : https://nag763.github.io/doteur/downloads

About this version

  • Regex crate upgraded to 1.5.5 (CVE-2022-24713)
  • Mysql crate upgraded to 22.1.0

Road to v0.6.0

  • Fixes and better parsing
  • Postgres support

Full Changelog: https://github.com/nag763/doteur/compare/0.5.1...0.5.2

doteur - Minor fixes

Published by nag763 over 2 years ago

Minor fixes

This release only contains minor fixes regarding the previous one.

Downloads

All the downloads can be found here : https://nag763.github.io/doteur/downloads

About this version

Road to v0.5.0

  • Add support for ALTER COLUMN and DELETE COLUMN lines
  • Ensure that most SQL inputs are supported and well rendered
  • Connect to an existing database
    - [ ] Possibly, add a possibility to run it as a webservice in order to integrate it to the doteur website.

Road to v0.6.0

  • Fixes and better parsing
  • Postgres support

Full Changelog: https://github.com/nag763/doteur/compare/0.5.0...0.5.1

doteur - Large refactoring, improving the code quality, new projects in coming

Published by nag763 almost 3 years ago

Large refactoring, improving the code quality, new projects in coming

This release contains a large refactoring in the project structure, now the libraries and the cli tools are separated, allowing further enhancements.

A direct consequence of this refactoring is that the tool is now downloadable in several packages instead of a "very large" one. For more information, check this page of the new site : https://nag763.github.io/doteur/features

Besides, the old site hosted at www.doteur.net is now replaced by the github pages at https://nag763.github.io/doteur

Downloads

All the downloads can be found here : https://nag763.github.io/doteur/downloads

About this version

  • A brand new website 😄
  • A better packaging 🚚
  • A better code, for a better tool ! 🔨

Road to v0.5.0

  • Add support for ALTER COLUMN and DELETE COLUMN lines
  • Ensure that most SQL inputs are supported and well rendered
  • Connect to an existing database
    - [ ] Possibly, add a possibility to run it as a webservice in order to integrate it to the doteur website.

Additional improvements on this release :

  • Better packaging
  • Brand new site

Road to v0.5.1

  • Add postgres support

Full Changelog: https://github.com/nag763/doteur/compare/0.4.1...0.5.0

doteur - Connection to running MySQL instance

Published by nag763 almost 3 years ago

Live connection to a running mysql instance !

This release adds a more than interesting feature through the addition of the --it (interactive) and --url (raw url connection), you can by now connect to a running database instance and print the graph of its relations !

Further usage and examples here.

Downloads :

Please read this : It is highly recommended to download graphviz and having it in your path before downloading the binary.

cargo install doteur

For further informations about how to download and use the tool please refer to the README

About this version

  • Adds a connection to a running database with the usage of --it and --url args
  • Better end of program handling with calls to exit() rather than panic!

Road to v0.4.0

  • Detect primary keys
  • Draw primary keys on table renderer
  • Improve code on :
    • The table content parsing
    • The coma separator handling on tables
    • Possibly, ignore the comments in file
    • Create a restriction to not render a key defined twice in a table

Additional improvements on this release :

  • Rendering different on the relations depending on the ON DELETE types
  • Enhanced logging

Road to v0.5.0

  • Add support for ALTER COLUMN and DELETE COLUMN lines
  • Ensure that most SQL inputs are supported and well rendered
  • Connect to an existing database
  • Possibly, add a possibility to run it as a webservice in order to integrate it to the doteur website.

Additionnal :

  • Better exit of programs

Full Changelog: https://github.com/nag763/doteur/compare/0.4.0...0.4.1

doteur - Primary Key and Relation types support

Published by nag763 almost 3 years ago

Update release to refresh crates.io

This release should be way more stable than the last one, as well as including a lot of new key features that will enhance the user experience with the tool. Besides, since the version 0.3.3, the project has been made available on crates.io, making it easier to download for cargo users.

Downloads :

Please read this : It is highly recommended to download graphviz and having it in your path before downloading the binary.

cargo install doteur

For further informations about how to download and use the tool please refer to the README

About this version

  • See prior release to see version notes

Road to v0.4.0

  • Detect primary keys
  • Draw primary keys on table renderer
  • Improve code on :
    • The table content parsing
    • The coma separator handling on tables
    • Possibly, ignore the comments in file
    • Create a restriction to not render a key defined twice in a table

Additional improvements on this release :

  • Rendering different on the relations depending on the ON DELETE types
  • Enhanced logging

Road to v0.5.0

  • Add support for ALTER COLUMN and DELETE COLUMN lines
  • Ensure that most SQL inputs are supported and well rendered
  • Connect to an existing database
  • Possibly, add a possibility to run it as a webservice in order to integrate it to the doteur website.

Full Changelog: https://github.com/nag763/doteur/compare/0.3.3...0.4.0

doteur - Update release to refresh crates.io

Published by nag763 almost 3 years ago

Update release to refresh crates.io

  • See prior release for release notes
  • Improved comments on crates

Downloads :

Please read this : It is highly recommended to download graphviz and having it in your path before downloading the binary.

About this version

  • See prior release to see version notes

Road to v0.3.0

  • Multifile support
  • Support folder
  • Detect primary keys
  • Draw keys on table renderer

Road to v0.4.0

  • Detect primary keys
  • Draw primary keys on table renderer
  • Improve code on :
    • The table content parsing
    • The coma separator handling on tables
    • Possibly, ignore the comments in file
    • Create a restriction to not render a key defined twice in a table
doteur - Fix double attribute rendering when FK

Published by nag763 almost 3 years ago

Fix double attribute rendering when FK

Prior to this version, any attribute would be rendered twice if it was also declared as a FK

Downloads :

Please read this : It is highly recommended to download graphviz and having it in your path before downloading the binary.

About this version

  • Fix double attribute rendering when FK
  • PK detecting and rendering delayed to v0.4.0 at best

Road to v0.3.0

  • Multifile support
  • Support folder
  • Detect primary keys
  • Draw keys on table renderer

Road to v0.4.0

  • Detect primary keys
  • Draw primary keys on table renderer
  • Improve code on :
    • The table content parsing
    • The coma separator handling on tables
    • Possibly, ignore the comments in file
    • Create a restriction to not render a key defined twice in a table
doteur - Fix issue with unicode chars on Windows

Published by nag763 over 3 years ago

Fix issue with unicode chars on Windows

Fix an issue with unicode characters not being recognized on windows

Downloads :

Please read this : It is highly recommended to download graphviz and having it in your path before downloading the binary.

About this version

  • Fix issue with unicode chars on Windows

Road to v0.3.0

  • Multifile support
  • Support folder
  • Detect primary keys
  • Draw keys on table renderer

Road to v0.4.0

  • Detect primary keys
  • Draw primary keys on table renderer
  • Improve code on :
    • The table content parsing
    • The coma separator handling on tables
    • Possibly, ignore the comments in file
    • Create a restriction to not render a key defined twice in a table
doteur - Improve application style, add multi file support

Published by nag763 over 3 years ago

Improve application styles, enable multifiles support

The application keeps improving the right way, with an additional dark mode being added to the application.

Downloads :

Please read this : It is highly recommended to download graphviz and having it in your path before downloading the binary.

About this version

  • Change the argument for inputs : now both files and directories can be passed to the tool, they will be aggregated as one.
  • Draw foreign keys in table.
  • Change some styles for the light mode.
  • Adds a dark mode.

Road to v0.3.0

  • Multifile support
  • Support folder
  • Detect primary keys
  • Draw keys on table renderer

Road to v0.4.0

  • Detect primary keys
  • Draw primary keys on table renderer
  • Improve code on :
    • The table content parsing
    • The coma separator handling on tables
    • Possibly, ignore the comments in file
    • Create a restriction to not render a key defined twice in a table
doteur - Inclusions and exclusions

Published by nag763 over 3 years ago

Pre release for inclusive and exclusive research args

This first release will suit the simplest needs. Consider it as an alpha and don't hesitate to report any bug you might encounter.

Downloads :

Please read this : It is highly recommended to download graphviz and having it in your path before downloading the binary.

About this version

  • Stabilise the new arguments support
  • Change background color of tables, change header color
  • More models, better code quality (can still be improved)
  • Add docker support

Road to v0.2.0

  • Include exclude tables and relations from file
  • Assert it is stable

Road to v0.3.0

  • Multifile support
  • Support folder
  • Detect primary keys
  • Draw keys on table renderer
doteur - Pre release for Inclusive and Exclusive

Published by nag763 over 3 years ago

Pre release for inclusive and exclusive research args

This first release will suit the simplest needs. Consider it as an alpha and don't hesitate to report any bug you might encounter.

Downloads :

Please read this : It is highly recommended to download graphviz and having it in your path before downloading the binary.

About this version

  • Add include ( -i ) and exclude ( -x ) args to the tool
    • i.e. passing -x hell* will exclude hello from the render, and will world
    • i.e passing -i wor* will include world, and exclude hello table

Road to v0.2.0

  • Include exclude tables and relations from file
  • Assert it is stable

Roadmap

  • Add cli arg to include exclude tables
  • Add possibility to pass multiple .sql files
  • Add possibility to connect directly to mysql db by passing logs
  • Add support for other sql engines (psql and sqlite mainly)
doteur - Fix issue on Windows

Published by nag763 over 3 years ago

Fix issue on Windows

This first release will suit the simplest needs. Consider it as an alpha and don't hesitate to report any bug you might encounter.

Downloads :

Please read this : It is highly recommended to download graphviz and having it in your path before downloading the binary.

About this version

  • Fix unrecognized dot exe in Windows path

Road to v0.2.0

  • Include exclude tables and relations from file

Roadmap

  • Add cli arg to include exclude tables
  • Add possibility to pass multiple .sql files
  • Add possibility to connect directly to mysql db by passing logs
  • Add support for other sql engines (psql and sqlite mainly)
doteur - First release, will suit basic usages

Published by nag763 over 3 years ago

First release

This first release will suit the simplest needs. Consider it as an alpha and don't hesitate to report any bug you might encounter.

Downloads :

Please read this : It is highly recommended to download graphviz and having it in your path before downloading the binary.

About this version

  • Takes a .sql file as input and render the relations and table.
  • Use the dot library to render the files.

Road to v0.1.1

  • Include exclude tables and relations from file

Roadmap

  • Add cli arg to include exclude tables
  • Add possibility to pass multiple .sql files
  • Add possibility to connect directly to mysql db by passing logs
  • Add support for other sql engines (psql and sqlite mainly)