schemaspy
KeenWrite
schemaspy | KeenWrite | |
---|---|---|
17 | 98 | |
3,014 | 621 | |
1.5% | - | |
9.4 | 0.0 | |
4 days ago | 8 months ago | |
HTML | Java | |
GNU Lesser General Public License v3.0 only | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
schemaspy
- Show HN: Open source database diagram editor
-
SQLite Schema Diagram Generator
You might try https://schemaspy.org/ - it generates a website with ER diagrams that only go one or two relationships out, but they have clickable table names to get to the next diagram
- Document your database simply and easily
-
DE new on the job
I had the same problem when i started my job. I used SchemaSpy to generate an html with all of metadata and ERD diagrams as a reference point. Then i used dbt to connect to the database and used dbt to document the table and column that i have worked on. It takes time to document but it's worth it if you company don't have your database documented yet.
-
Spring, SchemaSpy DB docs, and GitHub Pages
SchemaSpy is a standalone application that connects to the database, scans its tables and schemas, and generated nicely composed HTML documentation. You can check out an example sample by this link but I'm showing you just one screenshot to clarify my point.
-
pgAdmin Generate ERD stuck on load
I like https://schemaspy.org/
- Tips on investigating new databases with minimal documentation?
-
Looking for a database documenting tool to generate docs for analysts
I like the diagrams and reports SchemaSpy generates. If you are using a DBMS that allows setting comments to tables, views, columns (and other objects), those will be included and that makes those reports even more helpful
- What some of your recommended database mappers?
-
Schema to dia/UML/etc/whatever
https://schemaspy.org/ creates nice looking diagrams.
KeenWrite
-
Ask HN: Tell us about your project that's not done yet but you want feedback on
KeenWrite is my free, open-source, cross-platform desktop Markdown editor that can produce beautifully typeset PDFs. I started working on it years ago to help write a novel that has a complex timeline and I couldn't find a text editor that would allow me to integrate a character sheet with the story itself.
https://github.com/DaveJarvis/keenwrite
Tutorials:
* https://www.youtube.com/playlist?list=PLB-WIt1cZYLm1MMx2FBG9...
Here's what I mean by using variables directly:
* https://www.youtube.com/watch?v=CFCqe3A5dFg
CommonMark doesn't propose a standard for bibliographic references. Would anyone find the editor more appealing if it had cross-references and citations?
-
Documentation as Code for Cloud Using PlantUML
My cross-platform desktop text editor, KeenWrite, allows users to define variables in an external YAML file. The editor calls out to Kroki[1] to convert text-based diagrams to SVG. The diagrams can reference variables and are rendered using EchoSVG[2].
KeenWrite[3] can produce PDF documentation from Markdown documents that has PlantUML diagrams with elements stored in an external, machine-readable file. Here are screenshots showing variables on the left, diagram text in the middle, and a real-time render on the right:
* https://raw.githubusercontent.com/DaveJarvis/KeenWrite/main/...
* https://raw.githubusercontent.com/DaveJarvis/KeenWrite/main/...
KeenWrite supports all diagrams offered by Kroki, which includes "diagram-plantuml".
[1]: https://kroki.io/
[2]: https://github.com/css4j/echosvg/
[3]: https://github.com/DaveJarvis/keenwrite
- On why Markdown is not a good, or even a half-decent, markup language
- MdBook – Create book from Markdown files. Like Gitbook but implemented in Rust
- KeenWrite 3.3.2: MermaidJS diagrams (with caveat)
-
Interactive CommonMark Tutorial
Although not interactive, I've created a video series that shows advanced usage of Markdown. Namely R, external variables, diagrams, math, annotations, and a different approach to metadata:
* https://www.youtube.com/playlist?list=PLB-WIt1cZYLm1MMx2FBG9...
Tutorial 4 shows basic Markdown:
* https://www.youtube.com/watch?v=qNbGSiRzx-0
The top-right of each video shows keyboard and mouse clicks to help follow along.[1] My desktop text editor, KeenWrite[2], is used in the tutorials.
[1]: https://github.com/DaveJarvis/kmcaster
[2]: https://github.com/DaveJarvis/keenwrite
-
“Exit Traps” Can Make Your Bash Scripts Way More Robust and Reliable
https://github.com/DaveJarvis/keenwrite/blob/main/scripts/bu...
My template script provides a way to make user-friendly shell scripts. In a script that uses the template, you define the dependencies and their sources:
DEPENDENCIES=(
-
EchoSVG: SVG rasterizer library supporting level 4 selectors (Apache 2)
I didn't create the fork, nor am I affiliated with the project. I use it in my text editor, KeenWrite to rasterize SVG.
-
Millions of dollars in time wasted making papers fit journal guidelines
KeenWrite Themes[1] are instructions that tell ConTeXt how to typeset XHTML documents (content) into PDF files (presentation). I made a tutorial that shows how my FOSS desktop text editor, KeenWrite[3], allows users to write in Markdown to typeset a document against a particular theme.
Before it can be used for scientific papers, it needs cross-references, which, unfortunately, aren't part of the CommonMark specification.
I posit that the vast majority of LaTeX users don't grok how to separate content from presentation. When I asked a question on TeX.SE about how to adjust the line spacing between enumerated items (spanning a couple dozen enumerated lists), the vast majority of people voted for the answer of using `\itemsep0em` to tweak each list ... individually.[4] The correct answer, IMO, is to fix the problem globally, and not waste time tweaking individual lists.
[1]: https://github.com/DaveJarvis/keenwrite-themes
[2]: https://www.youtube.com/watch?v=3QpX70O5S30
[3]: https://github.com/DaveJarvis/keenwrite
[4]: https://tex.stackexchange.com/questions/6081/reduce-space-be...
What are some alternatives?
plantuml - Generate diagrams from textual description
markdown-preview.nvim - markdown preview plugin for (neo)vim
dbml - Database Markup Language (DBML), designed to define and document database structures
marktext - 📝A simple and elegant markdown editor, available for Linux, macOS and Windows.
Postico - Public issue tracking for Postico
typst - A new markup-based typesetting system that is powerful and easy to learn.
graphviz
vim-markdown - Markdown Vim Mode
mermaid - Generation of diagrams like flowcharts or sequence diagrams from text in a similar manner as markdown
Zettlr - Your One-Stop Publication Workbench
sketchviz-docker - Graphviz -> Sketchy PNG in one image, for automation
kroki - Creates diagrams from textual descriptions!