Re: [sqlite] Unexplained table bloat

[Tom Browder]

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 values (as in one per row)


Thanks, Keith.

I assume that is just for SQLite, or am I wrong again?

-Tom
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Unexplained table bloat

[Tom Browder]

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

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

[Tom Browder]

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.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[Tom Browder]

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, character. I take it
> back.


You folks may be interested in checking out the relatively new programming
language "Raku" (currently in the throes of renaming from "Perl 6").  Its
natural text handling is UTF-8 and there are modules for handling SQLite
and other RDBMS systems.

See the entry point for the language at .

Best regards,

-Tom
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[Tom Browder]

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 try are:
...

Thanks, Ryan, for a good set of references!

Best regards,

-Tom
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[Tom Browder]

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 NOT keeping user
settings in the db file.

However, why shouldn't sqliterc be documented on the SQLite website since
the sqlite3 CLI is part of the whole suite?

Simply adding the contents of the current man page would suffice for that.

-Tom
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[Tom Browder]

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 found .sqliterc on
> an internet search and that allowed the persistent settings I wanted.
>

I forgot that the sqliterc IS mentioned clearly in the sqlite3 man page on
Linux systems.

-Tom
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[Tom Browder]

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 settings I wanted.

However, would it not be more natural to keep those settings persistent
inside the db file?

Thanks,

-Tom
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Missing docs: sqliterc, lint

[Tom Browder]

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
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[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 version is looking that way, too.

You Perl people really should look into Perl 6. I started with Perl 4 back
in 1993, went
to Perl 5 later than I should have (and used it to execute SQLite2 when I
first
heard about it), and ran with that until 2015 when I saw Perl 6
was almost ready for its first stable release.

I quickly realized Perl 6 is the Perl I envisioned, and have rarely gone
back
except to port favorite old scripts to Perl 6.

I invite you to visit  and look around. The community is
as
welcoming as this one has been to me.  The real place to hang out is the
#perl6 IRC channel.

(At the risk of going off topic, File::Slurp has issues. File::Slurper is a
> better alternative.)


By the way, in Perl 6, slurp is built-in and works great.

Best regards, and Happy Perling!

-Tom
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[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 probably encounter will be at the design level

...

Thanks, Rob, good to know.

-Tom
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[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 results.

And I also have the commercial Razor SQL to use.

Thanks again.

-Tom


-To

> 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
>
>
> Thanks for the idea, Alex.
>
> I'm doing all programmatically at the moment (using a Perl 6 module:
> DB::SQLite), but using one of those tools you mentioned would help in
> design for sure!
>
> -Tom
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[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 made out. May it work for you. Peace! Alex


Thanks for the idea, Alex.

I'm doing all programmatically at the moment (using a Perl 6 module:
DB::SQLite), but using one of those tools you mentioned would help in
design for sure!

-Tom
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[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
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[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 work together.
> >
> > Is this list appropriate for presenting my design and requesting advice?
...

> Yes, you can post a schema here (paste it into your message, attachments are 
> stripped)
...
> Do be aware that almost all of us are just users like you.  We are not 
> professional
> designers, we argue with one-another, and you can't sue us if we give you bad 
> advice.

Thanks, Simon, I will try to be a courteous and objective participant!

-Tom
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[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-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite3.dll for Win 64

[Tom Browder]

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

Best regards,

-Tom

Thomas M. Browder, Jr.
Niceville, Florida
USA
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Tom Browder]

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:
>>
>> > sqlite db files and making sure that directory is writable by my web
>> > server.  I make sure that the directory is not used for anything else
>> > in order to help secure my web site.
>> >
>>
>> Another tip for such uses:
>>
>> .htaccess:
>>
>>   (or however your db is named)
>>        Order allow,deny
>>        Deny from all
>> 
>>
>> so that people who know the db is there can't fetch it over http.
>>
>
> You should be able to put the folder for the database file(s) outside of the
> path available to access by url.  'above' or 'beside' the home / root
> folder.  That way there is no way for someone to access it directly through
> a browser.  Only code running on the server can access it.

And that is exactly what I did.

Best regards,

-Tom

P.S.  So far sqlite is performing admirably on my site--so much easier
for certain uses.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Tom Browder]

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 answer seems to be yes.

I have solved my problem by defining an explicit directory for my
sqlite db files and making sure that directory is writable by my web
server.  I make sure that the directory is not used for anything else
in order to help secure my web site.

Best regards,

-Tom
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Tom Browder]

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 directory.
...
> You can also try disabling the temp files (telling it to use memory
> instead).

But I think the journal file is the problem...as I understand it, it
has to be on disk, doesn't it?

-Tom

Thomas M. Browder, Jr.
Niceville, Florida
USA



>
> --
> - stephan beal
> http://wanderinghorse.net/home/stephan/
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Tom Browder]

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 file, but I would like them to
>> be written to a separate directory.
...
> See http://www.sqlite.org/tempfiles.html for a list of the various kinds of
> temporary files used by SQLite.  Some of them (ex: the rollback journal)
> must be in the same directory as the database file in order to ensure
> recovery after a crash.

Thanks, Richard (and Simon), I think I can solve my web access problem
by giving the db file its own directory.

Best regards,

-Tom

P.S.  Sqlite seems to be handling my modest multiple-virtual-host
Apache2 web server just fine--as expected.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Tom Browder]

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 code and recompiling, to control where the temporary
files are created?  From my limited testing on my web server they are
written in the same directory as the db file, but I would like them to
be written to a separate directory.

I have experimented with setting the TMP and TMPDIR variables but
haven't seen that work.

Is there any good solution without code changing for a sys admin?

Thanks and best regards,

-Tom

Thomas M. Browder, Jr.
Niceville, Florida
USA
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users