Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

[BohwaZ]

Kia ora,

Like with the Fossil list I did subscribe and switch to the forum, but
wouldn't it be possible to add the ability in Fossil to handle incoming
email replies to forum posts?

So that people wishing to use emails could still do it by subscribing
to alerts and then replying to notifications.

It would be a perfect solution for my use of Fossil as well.

Would that feature would be accepted in Fossil if someone (probably not
me, I lack the time right now sorry) would submit a patch?

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

Re: [sqlite] Backing up a SQLite database without the CLI

[Bohwaz/Fossil]

If you're trying to copy a file while connections still have it open
then you should use SQLite API calls to do it.  The obvious ones are
in the SQLite Online Backup API, which is the set of calls underlying
the '.backup' command you mentioned.  You can find documentation for
this here:



Unfortunately I don't think the PHP sqlite3 tools give access to this 
API.


Not yet, but I did a patch and there is a pending pull request for that: 
https://github.com/php/php-src/pull/3617


It does work, I'm using it, and you could too if you are willing to 
compile your own PHP extension.


Hopefully it will land in PHP 7.4 :)

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

Re: [sqlite] LiteCLI

[BohwaZ]

On Tue, 8 Jan 2019 05:51:36 -0800 / Amjith Ramanujam
 said :

> You can explicitly request an in memory database at the time of
> launch like this:
> 
> litecli :memory:

A temporary database is not an in memory database, it can be partially
flushed to disk when it grows too much :)
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] LiteCLI

[BohwaZ]

Looks great!

I was expecting it to behave like the default sqlite CLI tool though,
that is if you fire it with no arguments it would automatically start
a temporary database (see https://www.sqlite.org/inmemorydb.html ), but
it doesn't seem like it's possible?

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