Re: [sqlite] Free tool to visualize a schema?

[Peter Halasz]

Unfortunately SQLite does not fully support introspection.

On Sun, Apr 15, 2018 at 7:52 PM, 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?
>
> --
> Best, Pali
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Free tool to visualize a schema?

[dmp]

> 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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Free tool to visualize a schema?

[Csányi Pál]

2018-04-15 15:49 GMT+02:00 Lifepillar :
> On 15/04/2018 14:14, Csányi Pál wrote:
>>
>> 2018-04-15 14:08 GMT+02:00 R Smith :
>>>
>>> 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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Free tool to visualize a schema?

[Lifepillar]

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

2018-04-15 14:08 GMT+02:00 R Smith :

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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Free tool to visualize a schema?

[R Smith]

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 :

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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Free tool to visualize a schema?

[Csányi Pál]

2018-04-15 14:08 GMT+02:00 R Smith :
> 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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Free tool to visualize a schema?

[R Smith]

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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Free tool to visualize a schema?

[Csányi Pál]

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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users