Re: [sqlite] Free tool to visualize a schema?
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?
> 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?
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?
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?
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?
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?
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