Re: [sqlite] Need suggestion for database scheama

2013-11-09 Thread dd
Hi James K. Lowden, Sorry. My backup application pulls tracks from albums and upload to server. Here, I need to store these Albums and Tracks information into database. From my application point of view, Every Track is a file.File may be track. When same track avail with different albums, then

[sqlite] UNICODE_STRING_MAX_CHARS

2013-11-09 Thread Keith Medcalf
This constant is not available on all compilers -- for example the MinGW GCC compiler seems to be missing this define in WinNT.h Can you make sure it is defined before using it, and define it if it is not? ___ sqlite-users mailing list

Re: [sqlite] Handling move/rename of an SQLite database file

2013-11-09 Thread Dan Kennedy
On 11/09/2013 06:47 PM, Simon Slavin wrote: On 9 Nov 2013, at 10:07am, Dan Kennedy wrote: On 11/09/2013 04:58 PM, L. Wood wrote: Richard Hipp wrote: Rollback journal files might be closed and reopened. [snip] [snip]* But what about the next open()

Re: [sqlite] Handling move/rename of an SQLite database file

2013-11-09 Thread Simon Slavin
On 9 Nov 2013, at 10:07am, Dan Kennedy wrote: > On 11/09/2013 04:58 PM, L. Wood wrote: >>> Richard Hipp wrote: >>> Rollback journal files might be closed and reopened. [snip] >> >> [snip]* But what about the next open() of a new journal file? Will it

Re: [sqlite] Row Level Locking as in InnoDB

2013-11-09 Thread Ryan Johnson
On 08/11/2013 5:07 AM, Raheel Gupta wrote: No. It's not even feature-frozen yet, as far as we know. And whenever it is, it's incredibly unlikely to have row level locking. Please add row-level locking if possible. I can't think of any other single feature that would remove the "lite" from

Re: [sqlite] Handling move/rename of an SQLite database file

2013-11-09 Thread Dan Kennedy
On 11/09/2013 04:58 PM, L. Wood wrote: Richard Hipp wrote: Rollback journal files might be closed and reopened. But the main database file is opened once and held open until sqlite3_close() (or DETACH if the file was originally opened using ATTACH). Thanks for this

Re: [sqlite] Handling move/rename of an SQLite database file

2013-11-09 Thread L. Wood
> Richard Hipp wrote: > Rollback journal files might be closed and reopened.  But the main database > file is opened once and held open until sqlite3_close() (or DETACH if the > file was originally opened using ATTACH). Thanks for this information. But suppose, while a journal

Re: [sqlite] Unicode support in SQLite

2013-11-09 Thread Aleksey Tulinov
On 11/04/2013 11:50 AM, Aleksey Tulinov wrote: Hey, As you can see, this is truly full Unicode collation and case mapping with untailored special casing. Extension provides the following functions, statements and collations: I've updated extension, examples and documentation, now it's