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

Re: [sqlite] kooky thought: a vm-only build (for embedded). feasible?

On 4/15/18, dave wrote: > I had a stray thought, and wanted to ask if it's been thunk before,and if so > what is the thinking? Or just for commentary. > > I have been building a system, part of which uses sqlite and virtual tables. > This is working great in a desktop/mobile

Re: [sqlite] CLI thoughts

On Sun, 15 Apr 2018 14:38:33 +0100, Martin wrote: > > I am a relatively new user of sqlite. My current use is to learn > sqlite sql to solve solitaire battleship puzzles. I am not a programmer, > so use the command line interface on a Mac. > > As a result I

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.

Re: [sqlite] kooky thought: a vm-only build (for embedded).feasible?

That was more-or-less my thinking. Mostly, my inquiry is to solicit any advice or wisdom-of-the-ages, or even advice against it. After having sent that, I suspect that this would more likely wind up being something I'm on my own in doing the hands-on work, but I still welcome any advice on how

Re: [sqlite] kooky thought: a vm-only build (for embedded). feasible?

On 15 Apr 2018, at 7:54pm, dave wrote: > I wonder if I can really strip it down > further by eliminating parsing, query planning, etc, altogether, and only > support the virtual machine. I wonder what you would find if you looked through the data structure of

[sqlite] kooky thought: a vm-only build (for embedded). feasible?

I had a stray thought, and wanted to ask if it's been thunk before,and if so what is the thinking? Or just for commentary. I have been building a system, part of which uses sqlite and virtual tables. This is working great in a desktop/mobile environment. However, eventually one day, I will

Re: [sqlite] sqlite-autoconf-3200100 : Where is the test suite for sqlite ?

On 14/09/17 02:00 PM, Richard Hipp wrote: On 9/14/17, Dennis Clarke wrote: RE : sqlite-autoconf-3200100 The sqlite-autoconf-3200100 tarball strips out all the tests. Maybe grab a copy of the canonical source code (https://sqlite.org/2017/sqlite-src-3200100.zip) and

[sqlite] CLI thoughts

I am a relatively new user of sqlite. My current use is to learn sqlite sql to solve solitaire battleship puzzles. I am not a programmer, so use the command line interface on a Mac. As a result I wonder whether it is worth considering a few amendments to the commands in the CLI tool. My

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

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

Re: [sqlite] In memory only WAL file

ah ok, now I understand. So you would like some setting like "limit writes to x/s", keeping the intermediate writes in memory. Here is a great writeup on how to tune sqlite for writes: https://stackoverflow.com/q/1711631/124416 But depending on your app you might just group a ton of writes in a

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

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

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

Re: [sqlite] SQLite equivalent of SQL Over(Partition)

Simon, I think the Group by might work correctly, but sometimes (as in OP case) would require a lot of rewriting (copy-paste). The key point here is that the Window function doesn't change the set, but only allows wider access to other rows of the set at the current row "time". So we just have to

[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