Sqleton: Visualize Your SQLite Database Schema

sqleton ['skelɪtən]

Visualizes your SQLite database schema.

Installation

$ npm install -g sqleton

You need to install graphviz separately:

$ [pacman -Sy | apt-get install | brew install] graphviz

Example

$ sqleton -o db.svg db.sqlite

The format will be inferred from the name of the output file; you can use any format supported by graphviz (png, pdf, svg, and many more).

Usage

Usage: sqleton [options] <database>

Options:
  -L, --layout      The layout command
      [choices: "neato", "dot", "circo", "fdp", "osage", "sfdp", "twopi"]
                                                         [default: "fdp"]
  -e, --edge-labels Label foreign key edges                     [boolean]
  -t, --title       Optional title string
  -f, --font        The font to use                [default: "Helvetica"]
  -d, --direction   Graph direction [choices: "TB", "LR"] [default: "LR"]
  -o, --out         Output file (determines output format)     [required]

Fine-Tuning

To fine-tune your graph, the best option is to use .dot as your output format and adjust the parameters in the file.

Node.js

const sqleton = require('sqleton')

// Open your database and writable stream
// ....

sqleton(db, stream, options)
  .then(() => { db.close() })
  .then(() => { stream.end() })

What about PostgreSQL or other databases?

sqleton was written to visualize SQLite schemata. Having said that, you can try to dump your schema and create a new SQLite database for visualisation from it.


Download Details:

Author: inukshuk
Source Code: https://github.com/inukshuk/sqleton

License: GPL-3.0 license

#sqlite 

What is GEEK

Buddha Community

Sqleton: Visualize Your SQLite Database Schema
Brain  Crist

Brain Crist

1600347600

SCHEMAS in SQL Server -MS SQL Server – Zero to Hero Query Master

Introduction

This is part 3 of “MS SQL Server- Zero to Hero” and in this article, we will be discussing about the SCHEMAS in SQL SERVER. Before getting into this article, please consider to visit previous articles in this series from below,

A glimpse of previous articles
Part 1

In part one, we learned the basics of data, database, database management system, and types of DBMS and SQL.

Part 2
  • We learned to create a database and maintain it using SQL statements.
  • Best practice methods were also mentioned.

#sql server #benefits of schemas #create schema in sql #database schemas #how to create schema in sql server #schemas #schemas in sql server #sql server schemas #what is schema in sql server

Kaia  Schmitt

Kaia Schmitt

1627002660

How to Use Select Query in SQLite Database Python | Python Built-In Database - V

Querying Data - Python Built-In Database - SQLite.

Github - https://github.com/theindianinnovation/Python-SQLite-Database-Tutorial

#python #database #sqlite database python #query #sqlite #sqlite database

Kaia  Schmitt

Kaia Schmitt

1626988020

What is SQLite Database | SQLite Introduction | Python Built-In Database - I

Introduction - Python Built-In Database - SQLite.

Github - https://github.com/theindianinnovation/Python-SQLite-Database-Tutorial

#sqlite #python #database #sqlite introduction #sqlite database

Kaia  Schmitt

Kaia Schmitt

1626994800

How to Create Table in SQLite Database Python | Python Built-In Database - III

Create Table - Python Built-In Database - SQLite.

Github - https://github.com/theindianinnovation/Python-SQLite-Database-Tutorial

#sqlite #database #python #sqlite database python #database python

Kaia  Schmitt

Kaia Schmitt

1626998400

How to Insert Records in SQLite Database Python | Python Built-In Database - IV

Insert Records - Python Built-In Database - SQLite.

Github - https://github.com/theindianinnovation/Python-SQLite-Database-Tutorial

#database #python #sqlite database python #sqlite #database python