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
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
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
> 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.
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
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
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
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
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
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
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
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
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
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
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
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
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
17 matches
Mail list logo