Free tool to visualize a schema?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

Free tool to visualize a schema?

csanyipal
Hi,

I think the visualization of a schema helps to develop a sqlite database.

I am searching for a free software, like SchemaCrawler.
It is good, but can't show CONSTRAINT and FOREIGN KEY names in the diagram.

I just tried out the Sqleton but it can't be start on my system so far.

Do you uses such a free tool?

--
Best, Pali
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Best, Pál
Reply | Threaded
Open this post in threaded view
|

Re: Free tool to visualize a schema?

R Smith-2
On 2018/04/15 11:52 AM, Csányi Pál wrote:

> Hi,
>
> I think the visualization of a schema helps to develop a sqlite database.
>
> I am searching for a free software, like SchemaCrawler.
> It is good, but can't show CONSTRAINT and FOREIGN KEY names in the diagram.
>
> I just tried out the Sqleton but it can't be start on my system so far.
>
> Do you uses such a free tool?

I think most SQLite (or indeed other DB) admin systems have some
function for producing schema visualization - at least, in the standard
sense of the word.

Does this example do what you would like?
http://sqlc.rifin.co.za/SchemaDocExample1.html
or (in other colour scheme):
http://sqlc.rifin.co.za/SchemaDocExample2.html

If so you can find those in the schema documentation HTML export of
sqlitespeed (http://sqlc.rifin.co.za/) but it's unfortunately on Windows
only. The sqlitebrowser project has some nice features and work in the
*nix systems too. (http://sqlitebrowser.org/)

There might even be a command-line tool that does a good job, I think
I've seen someone here talking about it, but am not sure now.

Good luck!
Ryan

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Free tool to visualize a schema?

csanyipal
2018-04-15 14:08 GMT+02:00 R Smith <[hidden email]>:

> On 2018/04/15 11:52 AM, Csányi Pál wrote:
>>
>> Hi,
>>
>> I think the visualization of a schema helps to develop a sqlite database.
>>
>> I am searching for a free software, like SchemaCrawler.
>> It is good, but can't show CONSTRAINT and FOREIGN KEY names in the
>> diagram.
>>
>> I just tried out the Sqleton but it can't be start on my system so far.
>>
>> Do you uses such a free tool?
>
>
> I think most SQLite (or indeed other DB) admin systems have some function
> for producing schema visualization - at least, in the standard sense of the
> word.
>
> Does this example do what you would like?
> http://sqlc.rifin.co.za/SchemaDocExample1.html
> or (in other colour scheme):
> http://sqlc.rifin.co.za/SchemaDocExample2.html
>
> If so you can find those in the schema documentation HTML export of
> sqlitespeed (http://sqlc.rifin.co.za/) but it's unfortunately on Windows
> only. The sqlitebrowser project has some nice features and work in the *nix
> systems too. (http://sqlitebrowser.org/)
>
> There might even be a command-line tool that does a good job, I think I've
> seen someone here talking about it, but am not sure now.
>
> Good luck!
> Ryan

No, I would like a tool such as sqleton
https://github.com/inukshuk/sqleton

--
Best, Paul
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Best, Pál
Reply | Threaded
Open this post in threaded view
|

Re: Free tool to visualize a schema?

R Smith-2
Ahh, sqleton is probably the best then - Why does it not work for you?

Maybe ask the devs there?


On 2018/04/15 2:14 PM, Csányi Pál wrote:

> 2018-04-15 14:08 GMT+02:00 R Smith <[hidden email]>:
>> On 2018/04/15 11:52 AM, Csányi Pál wrote:
>>> Hi,
>>>
>>> I think the visualization of a schema helps to develop a sqlite database.
>>>
>>> I am searching for a free software, like SchemaCrawler.
>>> It is good, but can't show CONSTRAINT and FOREIGN KEY names in the
>>> diagram.
>>>
>>> I just tried out the Sqleton but it can't be start on my system so far.
>>>
>>> Do you uses such a free tool?
>>
>> I think most SQLite (or indeed other DB) admin systems have some function
>> for producing schema visualization - at least, in the standard sense of the
>> word.
>>
>> Does this example do what you would like?
>> http://sqlc.rifin.co.za/SchemaDocExample1.html
>> or (in other colour scheme):
>> http://sqlc.rifin.co.za/SchemaDocExample2.html
>>
>> If so you can find those in the schema documentation HTML export of
>> sqlitespeed (http://sqlc.rifin.co.za/) but it's unfortunately on Windows
>> only. The sqlitebrowser project has some nice features and work in the *nix
>> systems too. (http://sqlitebrowser.org/)
>>
>> There might even be a command-line tool that does a good job, I think I've
>> seen someone here talking about it, but am not sure now.
>>
>> Good luck!
>> Ryan
> No, I would like a tool such as sqleton
> https://github.com/inukshuk/sqleton
>

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Free tool to visualize a schema?

Lifepillar
In reply to this post by csanyipal
On 15/04/2018 14:14, Csányi Pál wrote:

> 2018-04-15 14:08 GMT+02:00 R Smith <[hidden email]>:
>> On 2018/04/15 11:52 AM, Csányi Pál wrote:
>>>
>>> Hi,
>>>
>>> I think the visualization of a schema helps to develop a sqlite database.
>>>
>>> I am searching for a free software, like SchemaCrawler.
>>> It is good, but can't show CONSTRAINT and FOREIGN KEY names in the
>>> diagram.
>>>
>>> I just tried out the Sqleton but it can't be start on my system so far.

DbVisualizer (https://www.dbvis.com) is cross-platform, has free/pro
versions, and has a good visualization tool, which displays foreign key
names and other constraints (but not, AFAICS, arbitrary constraint́…
check… clauses). It supports SQLite, too.

Life.

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Free tool to visualize a schema?

csanyipal
2018-04-15 15:49 GMT+02:00 Lifepillar <[hidden email]>:

> On 15/04/2018 14:14, Csányi Pál wrote:
>>
>> 2018-04-15 14:08 GMT+02:00 R Smith <[hidden email]>:
>>>
>>> On 2018/04/15 11:52 AM, Csányi Pál wrote:
>>>>
>>>>
>>>> Hi,
>>>>
>>>> I think the visualization of a schema helps to develop a sqlite
>>>> database.
>>>>
>>>> I am searching for a free software, like SchemaCrawler.
>>>> It is good, but can't show CONSTRAINT and FOREIGN KEY names in the
>>>> diagram.
>>>>
>>>> I just tried out the Sqleton but it can't be start on my system so far.
>
>
> DbVisualizer (https://www.dbvis.com) is cross-platform, has free/pro
> versions, and has a good visualization tool, which displays foreign key
> names and other constraints (but not, AFAICS, arbitrary constraint́…
> check… clauses). It supports SQLite, too.
>
> Life.

Thanks!

--
Best, Paul
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Best, Pál
dmp
Reply | Threaded
Open this post in threaded view
|

Re: Free tool to visualize a schema?

dmp
In reply to this post by csanyipal
> Hi,
> I think the visualization of a schema helps to develop a sqlite database.
>
> I am searching for a free software, like SchemaCrawler.
> It is good, but can't show CONSTRAINT and FOREIGN KEY names in the
> diagram.
>
> I just tried out the Sqleton but it can't be start on my system so far.
> Do you uses such a free tool?
>
> Best, Pali

Hello Pali,

Ajqvue,
A free open source database access tool.
http://ajqvue.com/

It has a visual QueryBuilder, plugin.
http://ajqvue.com/plugins.html
http://ajqvue.com/images/screenshots/querybuilder/querybuilder_diagram.html

The application is in Java, and uses a JDBC to access a SQLite
database, file. At this time I no longer bundle a JDBC, with the
project for SQLite. One can be found though at:

https://github.com/xerial/sqlite-jdbc

Place its Jar in your jre/lib/ext folder and Ajqvue will have
access to it. I have not tried this current library and usually
build my own.

Dana M. Proctor
Ajquve Project Manager

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Free tool to visualize a schema?

Peter Halasz
In reply to this post by csanyipal
Unfortunately SQLite does not fully support introspection.

On Sun, Apr 15, 2018 at 7:52 PM, Csányi Pál <[hidden email]> wrote:

> Hi,
>
> I think the visualization of a schema helps to develop a sqlite database.
>
> I am searching for a free software, like SchemaCrawler.
> It is good, but can't show CONSTRAINT and FOREIGN KEY names in the diagram.
>
> I just tried out the Sqleton but it can't be start on my system so far.
>
> Do you uses such a free tool?
>
> --
> Best, Pali
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users