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