It?s a mistake ofexpression.
I mean,
1. readconcurrently indifferent threads.
or
2. write in one thread andread inother threads.
noconcurrently writing happened.
Sorry about this. I come from a not-English-speaking country, it's hard for me
to express myself.
???:Simon Slavinslavins at
Hello,
I am using SQLite on iOS developing.
Now I need the better performance of multithread-reading-and-writing and the
robustness ofWAL journal mode without mmap.
As I know,WALjournal mode without mmap requires EXCLUSIVE locking mode, which
may prevent multithread-reading-and-writing. But mmap
On Thu, Oct 8, 2015 at 8:36 AM, Simon Slavin wrote:
>
> On 8 Oct 2015, at 2:38pm, Richard Hipp wrote:
>
> > If accepted, the new policy will cause the next release to be 3.9.0
> > instead of 3.8.12. And the second number in the version will be
> > increased much more aggressively in future
On 10/09/2015 10:18 AM, chromedout64 at yahoo.com wrote:
> I noticed there was talk in the other thread of including FTS5 support in the
> amalgamation. That would be great and it seems like that might solve my
> problem. Is that correct?
>
> Also, I noticed what may be a couple typos in the
Suspect you are running into more VBA<->C issues. The db path, journal path
and wal path are stored sequentially in memory, so if you were to skip the
NUL terminators you'd see all three paths.
But I'm not exactly sure how that might happen without resulting in a
segfault, so I could be missing
Thanks Richard, this is exactly what I was thinking. One question on this:
On Tue, Oct 6, 2015 at 10:22 PM, Richard Hipp wrote:
> (2) For the source database connection of the backup, use the same
> database connection that is used for writing to the database. That
> means that when changes
On 9 Oct 2015, at 1:46pm, sanhua.zh wrote:
> It?s a mistake ofexpression.
> I mean,
> 1. readconcurrently indifferent threads.
> or
> 2. write in one thread andread inother threads.
Okay. That is what WAL mode does very well. There's nothing better you can do
for this than to use WAL mode.
On 9 Oct 2015, at 1:29pm, sanhua.zh wrote:
> 2. multithread-reading-and-writing, not serial
It is not possible for two different operations, whether different threads or
different processes, to write to a database at the same time. No matter what
system you use this just isn't possible.
To
It should be possible with a custom collation sequence.
-Urspr?ngliche Nachricht-
Von: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Cecil
Westerhof
Gesendet: Freitag, 09. Oktober 2015 12:08
An: sqlite-users at
Thanks, will sort this out.
RBS
On Fri, Oct 9, 2015 at 10:16 AM, Graham Holden
wrote:
> From memory of VB6, a string returned from a DLL call doesn't have its
> length set - you ideally need the call to return the length and do x$ =
> left$( x$, xlength ) before continuing. If the length isn't
Thanks for that. Must indeed be a C > VBA problem and will sort this out.
RBS
On Fri, Oct 9, 2015 at 9:52 AM, Rowan Worth wrote:
> Suspect you are running into more VBA<->C issues. The db path, journal path
> and wal path are stored sequentially in memory, so if you were to skip the
> NUL
When I use ORDER BY an ? comes after a z. Is it possible to make an ? come
after a z?
If it is important I am using SQLite 3.8.6 and Python 3.4.1.
--
Cecil Westerhof
On Thu, 08 Oct 2015 21:12:51 +0100,
R.Smith wrote:
>
>
> *** Correction ***
It's not, but you don't want to get me started. 8-)
> On 2015-10-08 10:03 PM, R.Smith wrote:
> >
> > To clarify, when used as an adverb to modify a verb, you may well
> > add the s - such as saying "I'm moving
The next release of SQLite will now be version 3.9.0. The sources has
been updated to use "semantic versioning" and the JSON1 and FTS5
extensions have been incorporated into the amalgamation.
Draft documentation is available at:
https://www.sqlite.org/draft/releaselog/3_9_0.html
2015-10-08 15:38 GMT+02:00 Richard Hipp :
> Several users have proposed that SQLite adopt a new version numbering
> scheme. The proposed change is currently uploaded on the "draft"
> website:
>
> https://www.sqlite.org/draft/versionnumbers.html
>
> On Fri, Oct 9, 2015 at 5:08 AM, Cecil Westerhof
> wrote:
>
> > When I use ORDER BY an ? comes after a z. Is it possible to make an ?
> come
> > after a z?
> >
> > If it is important I am using SQLite 3.8.6 and Python 3.4.1.
>
Perhaps you might garner some insight from looking at other's code?
All working fine now, but noticed that for the attached database I get not
just the file path of the attached database, but also the journal
file path and wal file path:
C:\Test\NewDB2.db3C:\Test\NewDB2.db3-journalC:\Test\NewDB2.db3-wal
There is actually no journal file or wal file that I can
On 10/9/15, David Barrett wrote:
> Thanks Richard, this is exactly what I was thinking. One question on this:
>
> On Tue, Oct 6, 2015 at 10:22 PM, Richard Hipp wrote:
>
>> (2) For the source database connection of the backup, use the same
>> database connection that is used for writing to the
On Fri, Oct 9, 2015 at 5:08 AM, Cecil Westerhof
wrote:
> When I use ORDER BY an ? comes after a z. Is it possible to make an ? come
> after a z?
>
> If it is important I am using SQLite 3.8.6 and Python 3.4.1.
>
> --
> Cecil Westerhof
>
>
?I am unsure of how to do this _exactly_ as you want, but
R.Smith wrote:
> More draft doc errors:
> https://www.sqlite.org/draft/versionnumbers.html
An additional typo near the end of above page:
=== BEGIN QUOTE ===
Again, the *destinction* (-> distinction) between "major" and "minor"
is subjective.
=== END QUOTE ===
Regards
Dominique
I noticed there was talk in the other thread of including FTS5 support in the
amalgamation. That would be great and it seems like that might solve my
problem. Is that correct?
Also, I noticed what may be a couple typos in the FTS5 documentation at
https://www.sqlite.org/fts5.html.
In the
Jan, I see no merit to your proposal and plenty of downsides. SQLite's current
release schedule works quite well, there is no good reason to formally do
feature releases just twice a year, especially with that terrible terrible 9x
kludge. There's also no reason to pander to guesses about what
On 2015-10-09 12:55 AM, K. P. wrote:
> Brilliant - thanks.Though I still do not understand my
> errordistinct(t.LastName || ', ' || t.FirstName),Seems to me that I am
> passing a single argument in parentheses to distinct
You had a separator (DISTINCT .. , '; ') as a second
On 2015-10-09 12:22 AM, K. P. wrote:
> I tried this, of course, before asking, but:
> group_concat(distinct(t.LastName || ', ' || t.FirstName), '; ') As Teachers,
> gives
> [15:19:32] Error while executing SQL query on database 'test': DISTINCT
> aggregates must have exactly one argument
As
On 2015-10-08 11:47 PM, K. P. wrote:
> Am using SQLiteStudio - which I really like - though I have wondered if it
> passes all its knowledge around errors onto the user...
I hope it does. Try some other ones too, just to get a wider idea.
Perhaps http://www.sqlc.rifin.co.za/ or
On 2015-10-08 11:30 PM, K. P. wrote:
> It does indeed work - had to make myself a simpler query than the real life
> one to see this. I probably had some other syntax error that I mistook for
> it...
> Thanks!
Nice.
Are you logging the SQLite errors and error descriptions? It's usually
quite
On 2015-10-08 10:54 PM, K. P. wrote:
> Thanks for that.I'd need something along the lines of
>
> group_concat(c.LastName || ', ' || c.FirstName, ';') as ClientName,
>
>
> which in itself does not seem to be supported.
This would be quite a normal group concatenation and works perfectly well...
28 matches
Mail list logo