Hello,
I searched the bug tracker and the only thing I saw that looked relevant was
ticket UUID 6c266900a22574d4d6474503da5bfe849c8b244f.
http://www.sqlite.org/src/tktview?name=6c266900a2
However, that seems to deal with special Unicode characters and I'm not dealing
with that here.
I'm using
So I've used CTE to solve a simple problem... I'm tempted to use it to
fix more problems... but I'm wondering how to select different values
at different levels. I know there's like 'select * from table where
column in ( set,of,things) ' but can I index into the set? is there
some sort of way I
insert into combinedTable
select * from table1
union
select * from table2
union
select * from table 3;
{set} union {set} returns the distinct result
{set} union all {set} returns a results that may have duplicate rows
> -Original Message-
> From: sqlite-users-bounces at
> Mensaje original
> De: Richard Hipp
>Fecha: 4/11/2015 23:23 (GMT+01:00)
>Para: SQLite mailing list
>Asunto: Re: [sqlite] Problem when upgrading from FTS3/4 to FTS5 modules
>Here is a hack.
>Let the name of your FTS3 table be "xyzzy"
>(1) Invoke "PRAGMA writable_schema=ON". (Read
On 11/11/15, Richard Hipp wrote:
> On 11/10/15, Ousherovitch Alex wrote:
>>
>> setting PRAGMA cache_size to zero is a no-op and the default (2000 pages)
>> will be used if it's done right after opening a database.
>
> I'm unable to reproduce this problem. Do you have a test case?
>
I see now.
On Nov 10, 2015, at 6:38 PM, Richard Hipp wrote:
> On 11/10/15, Jay Kreibich wrote:
>>
>> I want to be a Certified SQLite Professional.
>>
>
> The inventors and developers of the SQLite database engine to all to
> whom these presents may come, Greetings: Whereas Mr. Jay Kreibich has
>
On Nov 11, 2015, at 3:25 AM, Simon Slavin wrote:
> There's a story behind this.
>
> During the review leading to HTML5 the web consortium (the one which decides
> which features should be introduced to HTML/CSS/JavaScript) listed a
> 'webdatabase' specification so that browsers could
>
> Mensaje original
> De: Simon Slavin
> Para: SQLite mailing list
> Fecha: Wed, 11 Nov 2015 09:25:47 +
> Asunto: Re: [sqlite] "Shipping a New Mindset" - SQLite in Windows 10
>
>There's a story behind this.
>
>During the review leading to HTML5 the web consortium (the one
On 11/10/15, Ousherovitch Alex wrote:
>
> setting PRAGMA cache_size to zero is a no-op and the default (2000 pages)
> will be used if it's done right after opening a database.
I'm unable to reproduce this problem. Do you have a test case?
--
D. Richard Hipp
drh at sqlite.org
Hi ,
I am rather unknown to sqlite and I have the following problem.
I have several tables (3) with exactly the same schema. I have to
combine them to one table but there are overlapping data in each.
So e.g. table one ends (in column one) on 2015-07-21 11:55
and the next starts on
On 11 Nov 2015, at 8:56am, J.L. Blom wrote:
> I have several tables (3) with exactly the same schema. I have to combine
> them to one table but there are overlapping data in each.
Are you doing this just once -- now -- to prepare some data, or do you have to
write software which will do this
> Mensaje original
> De: Richard Hipp
> Para: General Discussion of SQLite Database mailinglists.sqlite.org>
> Fecha: Tue, 10 Nov 2015 14:41:28 -0500
> Asunto: [sqlite] "Shipping a New Mindset" - SQLite in Windows 10
>
>
On 11/11/2015 3:56 AM, J.L. Blom wrote:
> So e.g. table one ends (in column one) on 2015-07-21 11:55
> and the next starts on 2015-07-19
> 17:50
> There is an overlap op 2 days approx. 380 rows (each row contains 53
> items).
> Is there a script - or commando
On 11 Nov 2015, at 8:33am, ajm at zator.com wrote:
> A great notice to all us who write Windows. And a final prayer to MS: add an
> extension to use it from JavaScript.
There's a story behind this.
During the review leading to HTML5 the web consortium (the one which decides
which features
Thanks Richard a nice simple answer to pass on.
Paul
www.sandersonforensics.com
skype: r3scue193
twitter: @sandersonforens
Tel +44 (0)1326 572786
http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit
-Forensic Toolkit for SQLite
email from a work address for a fully
On 11/11/2015 01:19 AM, Florian Weimer wrote:
> * Dan Kennedy:
>
>> On 10/18/2015 10:27 PM, Florian Weimer wrote:
>>> My first surprise was SQLITE_BUSY_SNAPSHOT from BEGIN IMMEDIATE (see
>>> ?SQLITE_BUSY_SNAPSHOT from BEGIN IMMEDIATE?). I have found another
>>> source of such snapshot failures
On 10 Nov 2015, at 11:53pm, Tim Uy wrote:
> On Tue, Nov 10, 2015 at 3:31 PM, Jay Kreibich wrote:
>
>> I want to be a Certified SQLite Professional.
>
> Exactly. How does this happen?
If you'd each like to send me a check for five thousand dollars and take a
short online test I will be
17 matches
Mail list logo
