Re: [sqlite] New sqlite version update tool based on pragma

[Sergei G]

I can certainly add a transaction.  I did not know "Android's
SQLiteOpenHelper" exists.

On Sat, Oct 1, 2016 at 1:01 AM, Clemens Ladisch <clem...@ladisch.de> wrote:

> Sergei G wrote:
> > I wrote a tool that I am using to maintain SQLite DB schema.  It is very
> > simple and it is based on user_version pragma, which makes it SQLite
> > specific.  I have no plans to make it more complicated than it is today.
>
> This makes it quite similar to Android's SQLiteOpenHelper.
>
> > https://github.com/Kulak/sqlitemaint
>
> | Known Issues
> |
> | There is no wrapping of script file in a transaction. If script fails
> | it may leave datbase in an inconsistent state.  Workaround: apply
> | transaction in the script file itself.
>
> The checking of the version and the actual update must be done
> atomically, so it is your tool that must create a transaction.
>
>
> Regards,
> Clemens
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] New sqlite version update tool based on pragma

[Sergei G]

Hi,

I am a passive subscriber to this list at best and I use SQLite on small
projects.

I wrote a tool that I am using to maintain SQLite DB schema.  It is very
simple and it is based on user_version pragma, which makes it SQLite
specific.  I have no plans to make it more complicated than it is today.

I used GO language to write the library and application for it.

Reusable library and detailed documentation of algorithm:
https://github.com/Kulak/sqlitemaint

Console executable front end:  https://github.com/Kulak/sqlitemaintainer

It is just my small contribution back to an excellent SQLite library.

I am not sure if there is a good reference repository to get tool listed.


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

Re: [sqlite] FTS Example Fails (matchinfo arguments)

[Sergei G]

Is there a way I can obtain documentation that matches my version?
Online documentation is for the most current version.
I have found that both my hosting provider and debian stable are a bit
behind, so I have to work with what I've got.


Thanks

On Thu, Jun 14, 2012 at 1:16 AM, Dan Kennedy <danielk1...@gmail.com> wrote:

> On 06/14/2012 01:27 PM, Sergei G wrote:
>
>> I am running sqlite3 version 3.7.3 on debian.
>>
>> I run the following commands from fts3.html documentation page:
>>
>> CREATE VIRTUAL TABLE t1 USING fts4(a, b);
>> INSERT INTO t1 VALUES('transaction default models default', 'Non
>> transaction reads');
>> INSERT INTO t1 VALUES('the default transaction', 'these semantics
>> present');
>> INSERT INTO t1 VALUES('single request', 'default data');
>>
>> SELECT matchinfo(t1) FROM t1 WHERE t1 MATCH 'default transaction
>> "these semantics"';
>>
>> SELECT matchinfo(t1, 'ns') FROM t1 WHERE t1 MATCH 'default transaction';
>>
>> The last line with match info(t1, 'ns') fails with the following error
>> message:
>>
>> Error: wrong number of arguments to function matchinfo()
>>
>> I have originally worked on my own table, but found the same error. So, I
>> have tried example above and it failed for me in the same way.
>>
>
> I think the two argument version of matchinfo() is only in 3.7.4 and
> newer. Prior to that it only accepted one argument.
> __**_
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<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

[sqlite] FTS Example Fails (matchinfo arguments)

[Sergei G]

I am running sqlite3 version 3.7.3 on debian.

I run the following commands from fts3.html documentation page:

CREATE VIRTUAL TABLE t1 USING fts4(a, b);
INSERT INTO t1 VALUES('transaction default models default', 'Non
transaction reads');
INSERT INTO t1 VALUES('the default transaction', 'these semantics present');
INSERT INTO t1 VALUES('single request', 'default data');

SELECT matchinfo(t1) FROM t1 WHERE t1 MATCH 'default transaction
"these semantics"';

SELECT matchinfo(t1, 'ns') FROM t1 WHERE t1 MATCH 'default transaction';

The last line with match info(t1, 'ns') fails with the following error
message:

Error: wrong number of arguments to function matchinfo()

I have originally worked on my own table, but found the same error. So, I
have tried example above and it failed for me in the same way.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users