Comments (10)
+1
Well, it could be optional, like passing an argument specifying the number of rows to show.
Example showing first 10 rows:
java -jar schemaspy.jar -rows 10
from schemaspy.
@lukeIam have a look at https://dbeaver.io/
from schemaspy.
It looks like someone submitted a patch to add this support to Schema Spy 5:
https://sourceforge.net/p/schemaspy/feature-requests/85/
from schemaspy.
This should be turned off by default and only enabled via a switch, and I'd argue that it shouldn't be added at all.
SchemaSpy is a product for creating entity relationship diagrams, and (possibly live) table contents have no place on an ERD.
If this is enabled, then the end user runs the risk of exposing production data to anyone who is able to view the ERD. For example, I don't want my business analysts to be able to see any live or production data anywhere other than within the database where their access can be controlled and limited.
from schemaspy.
I'm with other ones, it's default off since database might contain sensitive data.
from schemaspy.
This is probably a completely different request, but what if instead there was the ability to do some analysis on the values without revealing the data itself? Ex: how many nulls vs non-nulls are present in a column? What is the longest, shortest, and average length of a varchar, etc?
Something like what MYSQL does with ... PROCEDURE ANALYZE
(or if you have ever used PhpMyAdmin, the Propose table structure
button) https://dev.mysql.com/doc/refman/5.6/en/procedure-analyse.html
from schemaspy.
+1
Well, it could be optional, like passing an argument specifying the number of rows to show.
any update on this?
seems to be a little bit outdated...
I had a short look to your code but it looks to complicated to implement the push of information through all the classes and templates for me (discovered schemaspy today).
from schemaspy.
@lukeIam the model and everything was never intended to include data from the database. I commented that it should be off, but if I'm honest I really don't want to include it. Since data and structures are different things.
from schemaspy.
@npetzall fair enough - I'm currently using schemaspy for exploring an unknown database and the column titles aren't the best, so I have to take a look at the data too.
from schemaspy.
@lukeIam the model and everything was never intended to include data from the database. I commented that it should be off, but if I'm honest I really don't want to include it. Since data and structures are different things.
It can be useful when using development database to generate the data dictionary to display example data.
Use cases are:
- The type is string, but format is an ULID (
01D78XYFJ1PRM1WPBCBT3VHMNV
) - The type is a JSON, with a specific structure.
- The type follows a sequence (incremental versions on a specific element).
from schemaspy.
Related Issues (20)
- Docker: arm image HOT 1
- Moving GUI components
- GUI does not respond to re-sizing HOT 1
- No relationships image created HOT 6
- Too much information in error.
- Sign snapshots
- Cant get line breaks in Table Comments to work. HOT 6
- I am unable to get comments
- Oracle database - null password given HOT 5
- Driver Error HOT 7
- Failed to parse [schema].meta.xml HOT 5
- Terminating null reference error when generating HTML for Constraints MSSQL HOT 1
- SchemaSpy ERD (relationship tab) is not showing lines between tables HOT 4
- Relationship between Unique Keys and Foreign Key HOT 8
- ERROR - Bad config Schema (-s/-schemas) was not provided and unable to deduce schema, ... HOT 2
- Trying to set trustServerCertificate true in schemaspy.connprops Property in config file does not work HOT 2
- Getting an Exception when running against Oracle database in charset ISO-8859-15 HOT 2
- Feature request: "Comment" as title in relationships.html
- Get `AbstractMethodError` when connect to SQL Server by using `mssql17-jtds` driver. HOT 2
- Snowflake connection with private key pair HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from schemaspy.