Re: [sqlite] Can I get help with db design for SQLite use?

2019-04-02 Thread Tom Browder
On Tue, Apr 2, 2019 at 18:21 Tom Browder wrote: > On Tue, Apr 2, 2019 at 17:30 am...@juno.com wrote: > >> You might want to import everything into SQLite Studio > > It's SQLite Studio, and i used it a bit many years ago, but it has had a recent update so I will give it a try--and report

Re: [sqlite] Can I get help with db design for SQLite use?

2019-04-02 Thread Tom Browder
On Tue, Apr 2, 2019 at 17:30 am...@juno.com wrote: > You might want to import everything into SQLite Studio or SQLite Suite I > forget the exact name)--a freebie on the internet. I found it worked for > me. In order to help others, I would appreciate it if you tell us on this > usergroup how you

Re: [sqlite] Can I get help with db design for SQLite use?

2019-04-02 Thread am...@juno.com
You might want to import everything into SQLite Studio or SQLite Suite I forget the exact name)--a freebie on the internet. I found it worked for me. In order to help others, I would appreciate it if you tell us on this usergroup how you made out. May it work for you. Peace! Alex --

Re: [sqlite] Can I get help with db design for SQLite use?

2019-04-02 Thread Tom Browder
On Tue, Apr 2, 2019 at 10:40 AM Don V Nielsen wrote: > > > Do be aware that almost all of us are just users like you. > > And be aware these guys are freakin brilliant. No lie. I don't doubt it at all, but thanks for the warning, Don! -Tom ___

Re: [sqlite] Can I get help with db design for SQLite use?

2019-04-02 Thread Tom Browder
On Tue, Apr 2, 2019 at 10:26 Simon Slavin wrote: > On 2 Apr 2019, at 3:48pm, Tom Browder wrote: > > I need help with a db design to be modeled for use with SQLite. The design > > uses foreign keys and I am just now using the foreign pragmas and other > > parts of SQLite to help me make it all

Re: [sqlite] Can I get help with db design for SQLite use?

2019-04-02 Thread Don V Nielsen
> Do be aware that almost all of us are just users like you. And be aware these guys are freakin brilliant. No lie. On Tue, Apr 2, 2019 at 10:26 AM Simon Slavin wrote: > On 2 Apr 2019, at 3:48pm, Tom Browder wrote: > > > I need help with a db design to be modeled for use with SQLite. The >

Re: [sqlite] Can I get help with db design for SQLite use?

2019-04-02 Thread Simon Slavin
On 2 Apr 2019, at 3:48pm, Tom Browder wrote: > I need help with a db design to be modeled for use with SQLite. The design > uses foreign keys and I am just now using the foreign pragmas and other parts > of SQLite to help me make it all work together. > > Is this list appropriate for

[sqlite] Can I get help with db design for SQLite use?

2019-04-02 Thread Tom Browder
I need help with a db design to be modeled for use with SQLite. The design uses foreign keys and I am just now using the foreign pragmas and other parts of SQLite to help me make it all work together. Is this list appropriate for presenting my design and requesting advice? Best regards, -Tom

[sqlite] Reporting two queries with performance regression

2019-04-02 Thread Jinho Jung
Hello, Thanks for the previous advice. We are reporting two interesting cases with different bisecting result using "sql-perf-fuzz". Here are the steps for reproducing our observations. All steps are same except for the link for downloading new test-cases: [Our test environment] * Ubuntu 16.04

Re: [sqlite] importing a large TSV file

2019-04-02 Thread Rowan Worth
On Mon, 1 Apr 2019 at 19:20, Domingo Alvarez Duarte wrote: > Hello Gert ! > > I normally do this (be aware that if there is a power outage the > database is screwed): > > === > > PRAGMA synchronous = OFF; > begin; > > --processing here > > commit; > PRAGMA synchronous = ON; > You can probably