sql-export
tbls
sql-export | tbls | |
---|---|---|
1 | 6 | |
1 | 3,068 | |
- | - | |
4.1 | 8.8 | |
3 months ago | 12 days ago | |
Go | Go | |
- | MIT License |
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.
sql-export
-
sql-export - create .md / .json files from database content
sql-export export database data into all-in-one JSON file or into many files (one file per SQL result row) in JSON, Markdown with YAML frontmatter or custom format (using text/template, same syntax as you use is HTML layouts in Hugo)
tbls
- FLaNK 25 December 2023
- tbls
- Tools to use to make high level Architecture diagrams
-
Graphviz: Open-source graph visualization software
Autogenerated database documentation is often pretty hit and miss but tbls[1] does a pretty good job in that space. Especially when you comment on your tables, fields, views, functions etc (which is a good habit anyway!) the output is quite useful
[1] https://github.com/k1LoW/tbls
-
Lesser Known PostgreSQL Features
In-database comments combined with something like https://github.com/k1LoW/tbls make for very cheap database documentation.
No affiliation with tbls except that I'm a big fan
-
Recommendations for a CLI-tool to generate DB diagrams?
Check out tbls. You can create a ERD in one command
What are some alternatives?
jet - Type safe SQL builder with code generation and automatic query result data mapping
dbmate - :rocket: A lightweight, framework-agnostic database migration tool.
ZiniGo - Utility to backup magazines from the Zinio service as PDF, bypassing/Removing their DRM.
ksuid - K-Sortable Globally Unique IDs
prisma-client-go - Prisma Client Go is an auto-generated and fully type-safe database client
Hugo - The world’s fastest framework for building websites.
pg-ulid - ULID Functions for PostgreSQL
usql - Universal command-line interface for SQL databases
plantuml-syntax - vim syntax file for plantuml
Next.js - The React Framework
mermaid - Generation of diagrams like flowcharts or sequence diagrams from text in a similar manner as markdown