[sqlite] Can a sys admin control temporary file location without changing the source code?

I've seen various threads in the users' list archives about the subject of temporary file location with no definitive answer, and I've seen the use of the pragma temp_store_directory is deprecated so that solution is out. I've not looked at the code yet, but is there any way, without changing the

Re: [sqlite] Can a sys admin control temporary file location without changing the source code?

On Thu, Jun 30, 2011 at 13:42, Richard Hipp <d...@sqlite.org> wrote: > On Thu, Jun 30, 2011 at 2:30 PM, Tom Browder <tom.brow...@gmail.com> wrote: ... >>  From my limited testing on my web server [temporary files] are >> written in the same directory as the db

Re: [sqlite] Can a sys admin control temporary file location without changing the source code?

On Thu, Jun 30, 2011 at 14:44, Stephan Beal <sgb...@googlemail.com> wrote: > On Thu, Jun 30, 2011 at 9:06 PM, Tom Browder <tom.brow...@gmail.com> wrote: ... >> Thanks, Richard (and Simon), I think I can solve my web access problem >> by giving the db file its own direct

Re: [sqlite] Can a sys admin control temporary file location without changing the source code?

On Thu, Jun 30, 2011 at 15:02, Stephan Beal <sgb...@googlemail.com> wrote: > On Thu, Jun 30, 2011 at 9:52 PM, Tom Browder <tom.brow...@gmail.com> wrote: > >> But I think the journal file is the problem...as I understand it, it >> has to be on disk, doesn't it? The a

Re: [sqlite] Can a sys admin control temporary file location without changing the source code?

On Mon, Jul 11, 2011 at 01:18, H. Phil Duby <phild...@phriendly.net> wrote: > On Sat, Jul 9, 2011 at 23:22, Stephan Beal <sgb...@googlemail.com> wrote: > >> On Sun, Jul 10, 2011 at 4:25 AM, Tom Browder <tom.brow...@gmail.com> >> wrote: >> >>

Re: [sqlite] SQLite3.dll for Win 64

On Fri, Jul 22, 2011 at 06:23, Everton Vieira wrote: > Please Help. I need an SQLite3.dll for Win 64? This link has Windows 64-bit binary installation packages--may find it in one of them: http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki HTH

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

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

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

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 t

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

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--

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

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?

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?

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

[sqlite] Why no persistent user settings in a database file?

After coming back to SQLite from a long absence, I was surprised that setting things like .mode and .headers in a database didn't stay that way after exiting the file. Then I remembered something about a resource file and found .sqliterc on an internet search and that allowed the persistent

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

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

[sqlite] Missing docs: sqliterc, lint

I have not been able to find any docs on the site about .sqliterc or lint. There is some information on sqliterc in the mailing list archives, and there is: sqlite3> .help lint But if one is not already aware of either one, how does one find out about them? Best regards, -Tom

Re: [sqlite] Why no persistent user settings in a database file?

On Wed, Apr 3, 2019 at 05:52 Tom Browder wrote: > After coming back to SQLite from a long absence, I was surprised that > setting things like .mode and .headers in a database didn't stay that way > after exiting the file. > > Then I remembered something about a resource file and

Re: [sqlite] Why no persistent user settings in a database file?

On Wed, Apr 3, 2019 at 06:57 R Smith wrote: > Hi Tom, ... > About the CLI - It's a very useful piece of toolkit, but it's intent is ... > For more usability, there are a few good options in the World from CLI's > to GUI's. I see you already know SQLite studio, some of my favourites > you might

Re: [sqlite] Why no persistent user settings in a database file?

On Wed, Apr 3, 2019 at 05:52 Tom Browder wrote: > After coming back to SQLite from a long absence, I was surprised that > setting things like .mode and .headers in a database didn't stay that way > after exiting the file. > ... Okay, I agree with all the excellent arguments about

Re: [sqlite] Things you shouldn't assume when you store names

On Mon, Nov 11, 2019 at 15:28 Tom Browder wrote: > See the entry point for the language at <https://raku.org>. > Oh, and there are Debian packages available, too. -Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sql

Re: [sqlite] Things you shouldn't assume when you store names

On Mon, Nov 11, 2019 at 15:18 Richard Damon wrote: > On 11/11/19 3:49 PM, Jose Isaias Cabrera wrote: > > Richard Damon, on Monday, November 11, 2019 02:37 PM, wrote... > > Aaaah, my apologies. We are talking about different things. You are > talking about a combination of Unicodes vs. full,

Re: [sqlite] Unexplained table bloat

On Sun, Jan 12, 2020 at 14:05 Keith Medcalf wrote: > On Sunday, 12 January, 2020 09:03, Tom Browder > wrote: > >Am I missing something? I thought every column has to have a type? > > Close, but no banana. Every value has a type. A column may contain > multiple valu

Re: [sqlite] Unexplained table bloat

Am I missing something? I thought every column has to have a type? -Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users