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

2019-04-03 Thread Tom Browder
On Wed, Apr 3, 2019 at 02:50 Shawn Wagner wrote: > Yay Perl! My favorite language. DBD::SQLite is definitely one of the > better, fuller featured sqlite bindings out there. Though Tom is using > perl6, not perl5. I have no idea how its version compares. ... Glad to hear, Shawn, and the Perl 6

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

2019-04-03 Thread Tom Browder
On Wed, Apr 3, 2019 at 02:08 Rob Willett wrote: > Tom, > > We use the Perl DB::SQLite module. It works very well and I cannot > recall a single issue with it in the last four years. There's not as > much support for Perl on this mailing list as it's not as popular, but > most issues you will

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

2019-04-03 Thread Rob Willett
Shawn, I will investigate File::Slurper. Rather than pollute this list, send me a mail on rob.sql...@robertwillett.com about the issues you had. Thanks Rob On 3 Apr 2019, at 8:50, Shawn Wagner wrote: Yay Perl! My favorite language. DBD::SQLite is definitely one of the better, fuller

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

2019-04-03 Thread Shawn Wagner
Yay Perl! My favorite language. DBD::SQLite is definitely one of the better, fuller featured sqlite bindings out there. Though Tom is using perl6, not perl5. I have no idea how its version compares. (At the risk of going off topic, File::Slurp has issues. File::Slurper is a better alternative.)

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

2019-04-03 Thread Rob Willett
Tom, We use the Perl DB::SQLite module. It works very well and I cannot recall a single issue with it in the last four years. There's not as much support for Perl on this mailing list as it's not as popular, but most issues you will probably encounter will be at the design level rather than

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
-- Original Message -- From: Tom Browder To: SQLite mailing list Subject: Re: [sqlite] Can I get help with db design for SQLite use? Date: Tue, 2 Apr 2019 15:07:58 -0500 On Tue, Apr 2, 2019 at 10:26 Simon Slavin wrote: > On 2 Apr 2019, at 3:48pm, Tom Browder wrote: > > I need help

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